From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Adrian Frick <mbch67(at)yahoo(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Boolean: DatabaseMetaData.getColumns |
Date: | 2003-11-29 08:27:13 |
Message-ID: | 20031129082713.GB2449@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Wed, Nov 26, 2003 at 01:01:12AM -0800, Adrian Frick wrote:
> Configuration:
> - PostgreSQL 7.4
> - JDBC 7.4 beta3 build 209
>
> Test case:
> 1. Created a table column of type BOOLEAN
> 2. Retrieved column metadata using
> - Class: DatabaseMetaData
> - Method: getColumns
> 3. Got the following values
> - DATA_TYPE: -7 (java.sql.Types.BIT)
> - TYPE_NAME: bool
>
> Error description:
> DATA_TYPE should be 16 (java.sql.Types.BOOLEAN)
> instead of -7, wenn TYPE_NAME is 'bool'
Types.BOOLEAN is an alias for Types.BIT according to the JDBC spec. Seems
valid to return BIT for a boolean column to me, especially as BOOLEAN isn't
present in earlier JDBC versions.
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2003-11-29 18:18:54 | Re: insert into Views. |
Previous Message | Jim Wright | 2003-11-29 01:34:12 | Re: UNICODE and JDBC Driver |