CallableStatement.setTimestamp bug
От | Reuben Pasquini |
---|---|
Тема | CallableStatement.setTimestamp bug |
Дата | |
Msg-id | EBBC2960-BEE4-4AB9-8567-2B68E8E50197@bellsouth.net обсуждение исходный текст |
Ответы |
Re: CallableStatement.setTimestamp bug
Re: CallableStatement.setTimestamp bug |
Список | pgsql-jdbc |
Hello! It appears that CallableStatement.setTimestamp() does not work correctly with the latest 8.1 jdbc driver - I've listed a test case below - sorry if this bug is already known. Let me know if you have any questions. Thanks for all the great work. Reuben -------------------- p-nut:/tmp pasquini$ javac Frick.java p-nut:/tmp pasquini$ java -cp postgresql-8.1-407.jdbc3.jar:. Frick Nov 14, 2006 9:59:54 PM Frick main INFO: Caught: org.postgresql.util.PSQLException: ERROR: function donothing("unknown") does not exist p-nut:/tmp pasquini$ cat Frick.java import java.util.*; import java.util.logging.Logger; import java.util.logging.Level; import java.lang.reflect.*; import java.sql.*; /* ............. CREATE OR REPLACE FUNCTION doNothing ( TIMESTAMP ) RETURNS INTEGER AS $FUNC$ BEGIN RETURN 0; END; $FUNC$ LANGUAGE plpgsql; */ /** * Test postgres JDBC setTimestamp functionality against doNothing() */ public class Frick { public static void main ( String[] v_argv ) { Logger log_generic = Logger.getLogger ( "littleware" ); try { Class.forName ( "org.postgresql.Driver" ); Connection sql_conn = DriverManager.getConnection ( "jdbc:postgresql:littleware://localhost:5432", "littleware_user", "" ); CallableStatement sql_call = sql_conn.prepareCall ( "{ ? = call doNothing ( ? ) }" ); java.util.Date t_now = new java.util.Date (); sql_call.registerOutParameter ( 1, Types.INTEGER ); sql_call.setTimestamp ( 2, new Timestamp ( t_now.getTime () ) ); sql_call.execute (); } catch ( Exception e ) { log_generic.log ( Level.INFO, "Caught: " + e ); } } }
В списке pgsql-jdbc по дате отправления: