Re: Jdbc4ResultSet getClob and getBlob are calling getLong internally - Mailing list pgsql-jdbc

Nedim Cholich <nedim@cholich.com> wrote:

> Yes, it's a TEXT column and yes I'm calling
> rs.getClob(columnName);
>
> What am I suppose to call instead?

In PostgreSQL a text column is not a BLOB or CLOB.
Try rs.getString(columnName);

For BLOB behavior, see large objects:

http://www.postgresql.org/docs/8.4/interactive/largeobjects.html

-Kevin