From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: TEXT columns should indentify as java.sql.Types.CLOB |
Date: | 2010-08-16 11:18:25 |
Message-ID: | 4C691E81.903@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2010-08-16 13:47:49 | Re: TEXT columns should indentify as java.sql.Types.CLOB |
Previous Message | Thomas Kellerer | 2010-08-16 09:30:07 | Re: TEXT columns should indentify as java.sql.Types.CLOB |