UDB 5.2 JDBC timestamp format different from java.sql.timestamp

UDB 5.2 JDBC timestamp format different from java.sql.timestamp

Post by Darin Shintan » Wed, 23 Dec 1998 04:00:00



The JDBC timestamp format in UDB is not compatible with the java.sql
format.

UDB format:       yyyy-mm-yy-hh.mm.ss.ffffff
java.sql format:  yyyy-mm-dd hh:mm:ss.fffffffff

Using java.sql.ResultSet.getTimestamp( String ) results in the following
exception:

   COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver] CLI0102E Invalid
conversion. SQLSTATE=07006

Is there a fix for this???

Thanks,
Darin