You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Ben Short (JIRA)" <ji...@apache.org> on 2007/09/06 14:28:33 UTC
[jira] Updated: (OPENJPA-351) OpenJPA attempts to create a
DEFERRABLE index with HSQL
[ 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.