Definite bug in JDBC
If you define a database field like this with the "without time zone"
clause.....
created timestamp(6) without time zone DEFAULT 'now' NOT NULL,
Then the current postgresql jdbc driver falls over in a heap when trying
to select and retrieve this field.
Chris,
This should have been posted to pgsql-jdbc instead of hackers.
Can you define what you mean by 'current postgresql jdbc driver'? There
are some bugs in the 7.2 driver that are fixed in current sources. Have
you tried the latest development driver from the jdbc.postgresql.org web
site?
Can you define what you mean by 'falls over in a heap'? The actual
error message would really be useful.
I can't seem to be able to reproduce your problem running the latest
development driver against a 7.2.1 database.
thanks,
--Barry
Chris Bitmead wrote:
Show quoted text
If you define a database field like this with the "without time zone"
clause.....created timestamp(6) without time zone DEFAULT 'now' NOT NULL,
Then the current postgresql jdbc driver falls over in a heap when
trying to select and retrieve this field.---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?