]
Steve Ebersole closed HHH-3968.
-------------------------------
Assignee: Steve Ebersole
Resolution: Duplicate
Please try this out and report any issues back against HHH-4905.
Error in SchemaUpdate using HSQLDialect with BigInteger or BigDecimal
primary keys [similar to HHH.3323]
--------------------------------------------------------------------------------------------------------
Key: HHH-3968
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3968
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.3.0.SP1
Environment: HSQLDB: 1.8.0.9
Reporter: Jonathan Mastin
Assignee: Steve Ebersole
Problem
---------------
When using HSQLDialect, the following code fails during schema creation:
@Entity
public class Test {
@Id @GeneratedValue(strategy = GenerationType.AUTO)
private BigInteger id;
}
Log output:
----------------
ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table Test (id
numeric generated by default as identity (start with 1), primary key (id))
ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Wrong data type: id in statement [create
table Test (id numeric generated by default as identity (start with 1)]
Expected
---------------------------------
The column type is being set as "numeric", but it needs to be set as
"integer" or "bigint" for HSQL to be able to parse.
From the HSQL manual:
"The supported form is(<colname> INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH n, [INCREMENT BY m])PRIMARY KEY, ...). Support has also been added for
BIGINT identity columns. As a result, an IDENTITY column is simply an INTEGER or BIGINT
column ..."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: