Hi Lance, I was saying Derby's implementation of JDBC support is not complete for Boolean... For example, it may not be possible to prepare a statement like 'Select * from t where ?' and pass Boolean type parameter. So, I was just saying enabling boolean types is more involved.
Satheesh On 8/9/05, Lance J. Andersen <[EMAIL PROTECTED]> wrote: > Satheesh, can you provide an example WRT JDBC metadata as I do not see an > issue there. > > more DB info: > > Sybase ASE and IAnywhere do not support boolean, you can use bit. > Pointbase supports BOOLEAN > Daffodil supports BOOLEAN > MySQL 4.1 and beyond supports BOOLEAN as a TINYINT(1), that is it s a > synonym > > > Derby should have the support externally visible. > > Regards > Lance > > > Satheesh Bandaram wrote: > I don't think all the support is there... Like using them in expressions or > JDBC metadata to name some. Dan has a good point in the second link > provided by Kathey. Here is the current status of BOOLEAN support in other > DBs, from that message: IBM DB2 UDB 7/8 - not supported Informix - > BOOLEAN supported MySQL 4.0 - not supported Oracle 9/10 - not supported > Postgres 7.4 - BOOLEAN supported SQL Server 2000 - not > supported Satheesh Francois Orsini wrote: > Boolean column type is ANSI SQL-99 - if support is already there > and assuming there is no known issues (none in JIRA at least), then it would > be good to see it back from the grave. Just IMHO. On 8/8/05, Kathey Marsden > <[EMAIL PROTECTED]> wrote: > Rick Hillegas wrote: > Hi Slavic, Thanks for bringing up this issue. Derby internally supports > boolean types but does not let users declare boolean typed columns. I > have logged an enhancment request (499) to track this issue. For the moment, > you can kludge around this problem by creating columns of type CHAR(1). > Maybe SMALLINT would be a good option for use with getBoolean(). A value of > 1 will return true. Here are two relevant mails on this > issue: http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/[EMAIL PROTECTED] http://mail-archives.apache.org/mod_mbox/db-derby-user/200412.mbox/[EMAIL PROTECTED] > > > >
