Hi, I got issues with schema for the init of the base when having mutiple schemas. Is it your case?
Ps: maybe openjpa list is more adapted Le 16 juil. 2013 18:46, "Leonardo K. Shikida" <[email protected]> a écrit : > 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 >
