[
https://issues.apache.org/jira/browse/OPENJPA-351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Zowalla resolved OPENJPA-351.
-------------------------------------
Resolution: Fixed
Already fixed on master: On master DEFERRABLE is added only when
supportsDeferredUniqueConstraints() is true (DBDictionary.java:4737-4738), and
HSQLDictionary.java:90 sets it to false, so HSQL never gets it. HSQLDictionary
has set this to false since 7d1c8fcca (2006), so the reporter probably was not
using HSQLDictionary, and 'not reproducible' is the more accurate label.
Closing.
> OpenJPA attempts to create a DEFERRABLE index with HSQL
> -------------------------------------------------------
>
> Key: OPENJPA-351
> URL: https://issues.apache.org/jira/browse/OPENJPA-351
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.1.0
> Environment: OpenJPA 1.1.0-SNAPSHOT
> HSQL 1.8.0.7
> Reporter: Ben Short
> Priority: Major
>
> 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.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
