Re: bit datatype and getObject() - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: bit datatype and getObject()
Date
Msg-id icigo3$fs0$1@dough.gmane.org
Whole thread Raw
In response to Re: bit datatype and getObject()  (dmp <danap@ttc-cmc.net>)
List 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


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: getTables() doesn't handle umlauts correctly
Next
From: Radosław Smogura
Date:
Subject: Re: Experimental JDBC driver