Re: OID-problem: metadata: use of TableGen O/R-mapper - Mailing list pgsql-jdbc

I'm using an O/R-Mapper called TableGen.  I had, just recently, a problem with
it having to do with OID's.  I solved that problem by starting to use the 7.3
beta 3 JDBC-driver.

I didn't realize until just today that the latest stable version of the driver
seems to have a problem with TIMESTAMP (or do I have a
configuration-problem?).

As indicated below, my Test doesn't work with the latest stable driver, but it
does work with 7.3 beta 3.

I'm reluctant to use third-party beta-code on the current project; it handles
"other people's money" and financial accounts.

Do I have a config-problem?  Is there an option to postmaster for setting the
default TIMESTAMP format?  I have yet to search for such, but I wanted to get
this email out ASAP.  I'm under a (as always, tight) deadline.

Any assistance with this matter would be much appreciated.

BTW, if this project could count on really speedy bug-fix responses from
postgres-developers (or specifically from postgres JDBC-driver developers),
perhaps use of 7.3 beta 3 in our production version would be worth the risk --
though that would ultimately not be for me to say.

Thank you,

Larry LeFever




(NOTE: "<proprietary-omitted>", below, is the result of a search/replace i
did, to conceal the name of a project not yet to be revealed to the public;
i.e., there's no problem with the paths that expression appears in below)


[lefever@dataman_local dbtables]$ javac Test.java
[lefever@dataman_local dbtables]$ java Test
INSERTing one Client
Showing all Clients
Exception in thread "main" Bad Timestamp Format at 23 in 2002-11-14
14:11:14.163727-05
 at org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:517)
 at org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:675)
 at com.<proprietary-omitted>.db.dao.Client.getFromResultSet(Client.java:422)
 at com.<proprietary-omitted>.db.dao.Client.retrieveAll(Client.java:699)
 at Test.showAllClients(Test.java:68)
 at Test.main(Test.java:17)
[lefever@dataman_local dbtables]$ echo $CLASSPATH

/usr/java/j2sdk1.4.1/lib/postgresql.jar:/usr/java/j2sdk1.4.1/lib/DDConnectionBroker.jar:/home/users/lefever/tablegen-1.8:/home/users/lefever/tablegen-1.8/classes:/home/users/lefever/tablegen-1.8/dbtables:/home/server/pSrvr/<proprietary-omitted>1.0/classes

[lefever@dataman_local dbtables]$ ls $JAVA_HOME/lib
DDConnectionBroker.jar htmlconverter.jar  log4j-1.2.6.jar  pg73b3jdbc2.jar
tools.jar
dt.jar   ir.idl     orb.idl     postgresql.jar
[lefever@dataman_local dbtables]$ export
CLASSPATH=$JAVA_HOME/lib/pg73b3jdbc2.jar:$CLASSPATH
[lefever@dataman_local dbtables]$ echo $CLASSPATH

/usr/java/j2sdk1.4.1/lib/pg73b3jdbc2.jar:/usr/java/j2sdk1.4.1/lib/postgresql.jar:/usr/java/j2sdk1.4.1/lib/DDConnectionBroker.jar:/home/users/lefever/tablegen-1.8:/home/users/lefever/tablegen-1.8/classes:/home/users/lefever/tablegen-1.8/dbtables:/home/server/pSrvr/<proprietary-omitted>1.0/classes

[lefever@dataman_local dbtables]$ java Test
INSERTing one Client
Showing all Clients
0        | llefever0 | myPassword | Larry | LeFever |
INSERTing a second Client
Showing all Clients
0        | llefever0 | myPassword | Larry | LeFever |
1        | llefever1 | myPassword | Larry | LeFever |
[lefever@dataman_local dbtables]$