[OPENJPA-351] OpenJPA attempts to create a DEFERRABLE index with HSQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Environment: OpenJPA 1.1.0-SNAPSHOT; HSQL 1.8.0.7
• Assignee: Unassigned
• Reporter: Ben Short
• Created: 06/Sep/07 12:26
• Updated: 15/Jan/08 12:33

Description

The exception...

<openjpa-1.1.0-SNAPSHOT-r420667:570593 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Unexpected token: DEFERRABLE in statement [CREATE TABLE AttributedProductAttribute (id BIGINT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY (id), UNIQUE (name) DEFERRABLE]

{stmnt 121226 CREATE TABLE AttributedProductAttribute (id BIGINT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY (id), UNIQUE (name) DEFERRABLE)}

[code=-11, state=37000]
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:549)
at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:449)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:170)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:130)
at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:186)
at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:145)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:375)
at $Proxy1.createEntityManager(Unknown Source)
at com.daisytechnologies.eshop.domain2.EntityManagerTests.testIt(EntityManagerTests.java:30)

I dont see this error with OpenJPA 1.0.1-SNAPSHOT.

Issue Links

• is related to: OPENJPA-483 config for openjpa.jdbc.Schemas not applied to SQL (HSQL)