Boolean: DatabaseMetaData.getColumns - Mailing list pgsql-jdbc

From Adrian Frick
Subject Boolean: DatabaseMetaData.getColumns
Date
Msg-id 20031126090112.50099.qmail@web14207.mail.yahoo.com
Whole thread Raw
Responses Re: Boolean: DatabaseMetaData.getColumns
List pgsql-jdbc
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'



__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

pgsql-jdbc by date:

Previous
From: "Sverre H. Huseby"
Date:
Subject: Forcing use of cursor result sets
Next
From: "Veaceslav Chicu"
Date:
Subject: SQLSTATE