| From: | Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Problems with infinity |
| Date: | 2005-01-13 13:19:00 |
| Message-ID: | 200501131419.00993.o.siegmar@vitrado.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2005-01-13 13:42:07 | Re: Problems with infinity |
| Previous Message | Oliver Jowett | 2005-01-12 23:54:08 | Re: Ampersands in the output... |