Hi
I have an app that was creating entities fine in mysql and it does not
when I try on oracle.
The error message does not help much
INFO: Starting OpenJPA 2.2.0
Jul 16, 2013 3:58:27 PM null
INFO: Using dictionary class "org.apache.openjpa.jdbc.sql.OracleDictionary".
javax.ejb.EJBException: The bean encountered a non-application
exception; nested exception is:
<openjpa-2.2.0-r422266:1244990 fatal store error>
org.apache.openjpa.persistence.OptimisticLockException: Unable to
obtain an object lock on "null".
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283)
(...)
Caused by: <openjpa-2.2.0-r422266:1244990 fatal store error>
org.apache.openjpa.persistence.OptimisticLockException: Unable to
obtain an object lock on "null".
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4900)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
(...)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
ORA-00942: table or view does not exist
{prepstmnt 219199633 SELECT t0.id, t0.name FROM SiteType t0}
[code=942, state=42000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:231)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1146)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:265)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1750)
(..)
... 111 more
my persistence.xml has
<properties>
<property name="openjpa.jdbc.DBDictionary"
value="org.apache.openjpa.jdbc.sql.OracleDictionary"/>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(ForeignKeys=true)"/>
</properties>
any ideas?
TIA
Leo
