Re: Jdbc4ResultSet getClob and getBlob are calling getLong internally

On Mon, 1 Feb 2010, Nedim Cholich wrote:

> After getting 'org.postgresql.util.PSQLException: Bad value for type
> long' I found these two methods in Jdbc4ResultSet:
>
>    public java.sql.Clob getClob(int i) throws SQLException
>    {
>        return new Jdbc4Clob(connection, getLong(i));
>    }
>
> Calling getLong here has to be wrong?
>

No.  Large Objects are not stored directly inline, but as a pointer to 
other storage.  The getLong is retrieving the external storage which 
Jdbc4Clob will then stream from the server on demand.  You are probably 
trying to call getClob on a text or varchar column and that's not going to 
work.  It might be nice to provide that interface, but there's no benefit 
(other than compatibility) to the user.  If you have text data stored 
inline, then it's already been transferred over to the client side in the 
ResultSet, so there's no point in using a streaming interface.

Kris Jurka