File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate + Derby + boolean + SchemaExport Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate + Derby + boolean + SchemaExport" Watch "Hibernate + Derby + boolean + SchemaExport" New topic

Hibernate + Derby + boolean + SchemaExport

Carey Brown
Ranch Hand

Joined: Nov 19, 2001
Posts: 885

I'm trying to use Hibernate with Derby I can pre-create the tables by running a hand built script and Derby lets me define a column as type 'boolean' and when I 'describe' the table it shows the column as 'boolean'. I'm attempting to use Hibernate's SchemaExport to create a sql script to avoid building it by hand as my project evolves. The problem that I get is that SchemaExport outputs a 'boolean' as a 'smallint' even when I define the type in the xml file to be 'boolean'. I've also looked at the source for the DerbyDialect and there's a line that says:

The export output looks like:

The '_ind' columns are the booleans.

Any ideas where I should be looking?

Thanks in advance.

Understanding the scope of the problem is the first step on the path to true panic
I agree. Here's the link:
subject: Hibernate + Derby + boolean + SchemaExport
It's not a secret anymore!