problem in reverse-engineering a boolean type

hsalameh · **Joined:** Sun Jul 25, 2004 11:15 pm **Posts:** 24

Hi
I am using hsqldb and hibernate tools 3.1.0 alpha 5

I have a table which has a column of type BOOLEAN, and when I try to reverse-engineer it, I get the following error:

org.hibernate.cfg.JDBCBinderException:The type java.lang.Object spans multiple columns. Only single column types allowed for single columns.

I changed the type to BIT, and I still got the same error.
The only thing that is close to BOOLEAN that works is NUMERIC(1)

is this a known bug? or am I missing something?

thanks

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Do you try set reveng.xml - mapping boolean to what you want ?

hsalameh · **Joined:** Sun Jul 25, 2004 11:15 pm **Posts:** 24

snpesnpe wrote:

Do you try set reveng.xml - mapping boolean to what you want ?

I don't quite understand what you mean.
The reveng.xml file contains table names. it does not contain any boolean mapping as far as i can tell.

thanks

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

you can map database type to hibernate type , too
for example

Code:

<sql-type jdbc-type="BOOLEAN" hibernate-type="YourType" />

max · **Posted:** Sun Oct 02, 2005 2:51 am

btw. boolean is now mapped by default in the cvs so this will not be necessary in the upcoming release.