Re: TEXT columns should indentify as java.sql.Types.CLOB

Thomas Kellerer wrote:
> Toni Helenius wrote on 16.08.2010 11:01:
>> I'm using Postgres 8.3.11 database and the latest JDBC driver 8.4
>> Build 701 (JDBC 4) + Java 6. In our databases there are TEXT type
>> columns. However if I make a query to identify these fields in Java,
>> the field DATA TYPE is VARCHAR and the length is 2147483647. Type
>> name is correct; "TEXT". But as we need database independent code, we
>> are using DATA TYPE as I presume is correct. And I think these TEXT
>> fields should return java.sql.Types.CLOB as DATA TYPE instead of
>> VARCHAR.
>
> I agree, this would make the driver more JDBC compatible and it would
> behave more like other drivers.

Returning Types.CLOB would imply that the preferred way to deal with
those columns is via getClob() / setClob(), which surely isn't correct
for TEXT columns in most cases?

-O