Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group