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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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