[ 
https://issues.apache.org/jira/browse/OPENJPA-351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ben Short updated OPENJPA-351:
------------------------------

    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.


  was:
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)


> 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)
> I dont see this error with OpenJPA 1.0.1-SNAPSHOT.

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