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

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

From: Toni Helenius <Toni(dot)Helenius(at)syncrontech(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: TEXT columns should indentify as java.sql.Types.CLOB
Date: 2010-08-18 09:01:59
Message-ID: E6A9CAA76548CB4EB02D2E3B174DD3B155381F0ED0@ink.sad.syncrontech.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

Yes, good sir, you're right. It got mapped as a BIT. My hastiness and original if-else was a bit off on this. Sorry.

Still how do you feel about TEXT columns mapping as VARCHAR?

-----Original Message-----
From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com] 
Sent: 18. elokuuta 2010 11:19
To: Toni Helenius
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] TEXT columns should indentify as java.sql.Types.CLOB

Toni Helenius wrote:
> Hi,
> 
> Here is the best I can do, I'm sure you'll manage to fill in the holes:

Well, I was more interested in how you were ending up with VARCHAR.
It's normal for booleans to be mapped to Types.BIT (see previous list
discussion)

> 	if (java.sql.Types.BOOLEAN == type) {
> 		println("A boolean");
> 	}

-O

In response to

pgsql-jdbc by date

Next:From: vtkstefDate: 2010-08-19 16:10:01
Subject: uuid values as parameters
Previous:From: Oliver JowettDate: 2010-08-18 08:19:14
Subject: Re: TEXT columns should indentify as java.sql.Types.CLOB

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