Re: Question on BOOLEAN data type,

[Tobias Downer <toby@xxxxxxxxx>]

I would suggest forwarding this question to the developers of 
DbVisualizer.  I don't know which part of the JDBC meta data that DbVis 
queries so it's difficult for me to tell you if this is a bug in the 
JDBC driver or not.

Toby.

Vinodh Srinivasasainagendra wrote:

> My question is related to Mckoi BOOLEAN data type. I have a column in my
> table whose SQL data type is BOOLEAN. 
> 
> stat.executeUpdate("CREATE TABLE Test_table ("Name VARCHAR(16) , status
> BOOLEAN NOT NULL)");
> 
> When i query the columnType (getColumnType(2)) it reports is as
> "java.sql.Types.BOOLEAN" which is correct.
> 
> 
> But when i view my table in DbVisualizer the JDBC Mapping for the SQL type
> says "UNKNOWN".
> 
> ******************************************************************
> Column Name     Type(Database)	Type (JDBC)	Type (Java)
>     Name           VARCHAR	 VARCHAR     java.lang.String
>    Status          BOOLEAN	 UNKNOWN     java.lang.Boolean
> ******************************************************************
> 
> Can i get some pointers on this.
> thanks
> vinodh