Postgres Pro
Downloads
Home   >   mailing lists

Re: TEXT columns should indentify as java.sql.Types.CLOB - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: TEXT columns should indentify as java.sql.Types.CLOB
Date
Msg-id i4b0ep$a39$1@dough.gmane.org
Whole thread Raw
In response to TEXT columns should indentify as java.sql.Types.CLOB  (Toni Helenius <Toni.Helenius@syncrontech.com>)
Responses Re: TEXT columns should indentify as java.sql.Types.CLOB
List pgsql-jdbc
Tree view 
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.

Regards
Thomas

pgsql-jdbc by date:

Previous
From: Toni Helenius
Date:
Subject: TEXT columns should indentify as java.sql.Types.CLOB
Next
From: Oliver Jowett
Date:
Subject: Re: TEXT columns should indentify as java.sql.Types.CLOB