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


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)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to