Boolean data type for Java DB

I'm working on a project that involves changing the database engine for an application.

I downloaded an open source application that was implemented using HSQLDB, and I want to change it to Java DB.

The challenge now is that Java DB seems to not have provision for storing and retrieving Boolean data from tables, and I've not been able to find a way to implement it.

I wonder if anyone has encountered a similar thing, and a possible solution.

[471 byte] By [uchwoody186a] at [2007-11-27 9:33:20]
# 1
If a database doesn't support the boolean type, then generally a smallint will be used: 0 = false and 1 = true.
BalusCa at 2007-7-12 22:54:35 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Thanks for the suggestion, I'll try that.But then, is there any particular reason why some databases have Boolean and others don't?
uchwoody186a at 2007-7-12 22:54:35 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...