PostgreSQL JDBC - "Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

"Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar

Jean-Pierre Pelletier

2005-09-29, 8:24 pm

Hi,

I've got PSQLException "Conversion of interval failed"
throwned when trying to read an interval larger than
100 hours (101:12:00) into a PGInterval object.
It was running fine with the build 312 jdbc3 driver.

Here is the line of code which cause the error:

PGInterval interval = (PGInterval) resultset.getObject(1);

I am running PostgreSQL 8.1 beta2 on Windows 2000.

Thanks
Jean-Pierre Pelletier
e-djuster

Sponsored Links