Hi,
I'm using PostgreSQL 7.4.6 with pg74.215.jdbc3.jar and have trouble with
infinite timestamp values.
org.postgres relevant Trace:
Caused by: org.postgresql.util.PSQLException: Bad Timestamp Format at 0 in
9999-01-01
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toTimestamp(AbstractJdbc1ResultSet.java:1188)
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1ResultSet.java:381)
at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1ResultSet.java:541)
Furthermore, in your TODO list I read "The conversion to/from datatypes
supporting infinity is silly because Java doesn't have a similar concept.
Throw an exception instead.".
That's really bad. I can't change the database content because several stored
procedures are based on infinite timestamp values.
Of course I understand that conversion infinite from/to 9999-01-01 or
0001-01-01 is silly...but its better than being forced to use another
language to talk to the database, isn't it?
Cheers,
Oliver