Re: "Conversion of interval failed" on PGInterval with - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: "Conversion of interval failed" on PGInterval with
Date
Msg-id Pine.BSO.4.61.0509291610170.29679@leary.csoft.net
Whole thread Raw
In response to "Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar  ("Jean-Pierre Pelletier" <pelletier_32@sympatico.ca>)
Responses Re: "Conversion of interval failed" on PGInterval with  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Thu, 29 Sep 2005, Jean-Pierre Pelletier wrote:

> 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.
>

OK, this is because 8.1 has separated hours and days in an interval
definition, previously 100 hours turned into '4 days 4 hours', but in 8.1
it remains 100 hours.  I'll look at a fix...

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Jean-Pierre Pelletier"
Date:
Subject: "Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar
Next
From: Kris Jurka
Date:
Subject: Re: setObject(col, blob) throws PSQLException