Re: bit datatype and getObject()

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: bit datatype and getObject()
Date: 2010-11-24 08:00:58
Message-ID: icigo3$fs0$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

dmp, 24.11.2010 04:06:

> It is true that the mapping is java.lang.Boolean for the bit(x), but
> there is another type in PostgreSQL to define a multi-bit type. Have
> you tried: bit varying(5) retrieval by getObject()? Because that type
> does map to java.lang.Object.

Correct.

The only thing I noticed is that it returns Types.OTHER as the datatype, not Types.BIT
But as I don't know if Types.BIT is meant to include "multi-bit" types I don't know if
that is correct or not.

> Either way isn't this a server issue on the mapping, not the JDBC?

I don't think so. psql displays this correctly.

Regards
Thomas

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Radosław Smogura 2010-11-24 13:24:29 Re: Experimental JDBC driver
Previous Message Kris Jurka 2010-11-24 07:43:17 Re: getTables() doesn't handle umlauts correctly