]
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: