Re: JDBC ResultSet.getObject() fails for type INTERVAL

At 00:01 02/02/01 -0500, pgsql-bugs(at)postgresql(dot)org wrote:
>John Lemcke (jlemcke(at)netspace(dot)net(dot)au) reports a bug with a severity of 2
>The lower the number the more severe it is.
>
>Short Description
>JDBC ResultSet.getObject() fails for type INTERVAL
>
>Long Description
>Trying to retrieve an INTERVAL from a ResultSet causes an exception. The
>following output is from the attached example code.
>
>~/src/java/rules > java TestInterval
>1
>string1
>TestInterval.executeQuery() : No class found for interval.
>TestInterval.main : No class found for interval.
>No class found for interval.

This is caused because getObject() can't find the class handling Interval.
Probably because there currently isn't one.

When I last checked there was 45 types in 7.1 and I think the JDBC driver
has about 1/2 of them mapped to either SQL or a custom class. Shouldn't
take too long to implement.

Peter