| 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 |