Re: bit datatype and getObject()

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