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/