[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6540) Can't make tables in Derby, Boolean problem

[Shane Hughes (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=43250#comment-43250 ] 

Shane Hughes commented on HHH-6540:
-----------------------------------

You are correct. The Hibernate Derby Dialect (at least in 3.5.6.Final) doesn't support the boolean data type.

The first steps in adding support is to extend the current DerbyDialect and implement a new constructor:

{code}
public DerbyDialect() {
    super();
    registerColumnType( Types.BIT, "boolean" );
}
{code}

I haven't tested any further than this though. You can then use: {{true}} and {{false}} in your insert scripts.

> Can't make tables in Derby, Boolean problem
> -------------------------------------------
>
>                 Key: HHH-6540
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6540
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.6.1
>         Environment: Derby 10.8.1.2
> Hibernate 3.6.2
>            Reporter: Łukasz Libront
>              Labels: boolean, derby, hibernate
>
> Link to our problem on Jira http://issues.qcadoo.org/browse/QCADOO-94
> According to https://issues.apache.org/jira/browse/DERBY-499 issue with boolean was closed and fixed but we have still problems with making tables:
> 2011-08-03 11:52:36 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
> SEVERE: Unsuccessful: create table basic_company (id bigint not null, companyFullName varchar(255) default 'Company', tax varchar(255), street varchar(255), house varchar(255), flat varchar(255), zipCode varchar
> (255), city varchar(255), state varchar(255), country varchar(255), email varchar(255), addressWww varchar(255), active smallint default true, primary key (id))
> 2011-08-03 11:52:36 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
> SEVERE: Columns of type 'SMALLINT' cannot hold values of type 'BOOLEAN'.
> 2011-08-03 11:52:36 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
> SEVERE: Unsuccessful: create table materialRequirements_materialRequirement (id bigint not null, name varchar(255), date timestamp, worker varchar(255), onlyComponents smallint default '1', generated smallint, fileName varchar(255), primary key (id))
> 2011-08-03 11:52:36 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
> SEVERE: Columns of type 'SMALLINT' cannot hold values of type 'CHAR'.
> Maybe this is the issue with hibernate.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira