Skip site navigation (1) Skip section navigation (2)

CallableStatement.setTimestamp bug

From: Reuben Pasquini <pasquinir(at)bellsouth(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: CallableStatement.setTimestamp bug
Date: 2006-11-15 04:05:22
Message-ID: EBBC2960-BEE4-4AB9-8567-2B68E8E50197@bellsouth.net (view raw or flat)
Thread:
Lists: 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 );
         }
     }
}


Responses

pgsql-jdbc by date

Next:From: Do, Leon (Leon)Date: 2006-11-15 04:36:30
Subject: Re: help with front/backend datatype converting
Previous:From: Oliver JowettDate: 2006-11-14 23:05:53
Subject: Re: help with front/backend datatype converting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group