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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: TEXT columns should indentify as java.sql.Types.CLOB
Date: 2010-08-16 09:30:07
Message-ID: i4b0ep$a39$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2010-08-16 11:18:25 Re: TEXT columns should indentify as java.sql.Types.CLOB
Previous Message Toni Helenius 2010-08-16 09:01:56 TEXT columns should indentify as java.sql.Types.CLOB