Hi Patrick, et al,
This problem is probably explained by the info here:
http://www.sqlite.org/cvstrac/wiki?p=LibraryRoutineCalledOutOfSequence
According to results from other project mailing lists found via Google
search, use of sqlite data structures from a thread pool can trigger
situations that cause this error.
Is OpenJpa by default using its JDBC connections from a thread pool?
Is this configurable via DBDictionary properties or methods?
Thanks,
-Marc
On Jan 2, 2008 2:41 PM, Marc Siegel <[EMAIL PROTECTED]> wrote:
> What does this exception mean, and how can I stop receiving it at
> random intervals?
>
> -Marc
>
> <openjpa-1.0.1-r420667:592145 fatal store error>
> org.apache.openjpa.persistence.RollbackException: The transaction has
> been rolled back. See the nested exceptions for details on the errors
> that occurred.
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:419)
> at com.leadgenllc.lib.Joe.endTransaction(Joe.java:327)
> at com.leadgenllc.lib.GaPull.endTransaction(GaPull.java:515)
> at
> com.leadgenllc.lib.GaSynch.processExplorerSubject(GaSynch.java:1329)
> at
> com.leadgenllc.lib.GaSynch.processExplorerDumpLine(GaSynch.java:1230)
> at com.leadgenllc.lib.GaSynch.receiveExplorerDump(GaSynch.java:130)
> at com.leadgenllc.lib.GaSynch.receiveExplorerDump(GaSynch.java:100)
> at com.leadgenllc.lib.GaSynchApp.main(GaSynchApp.java:61)
> Caused by: <openjpa-1.0.1-r420667:592145 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: The transaction
> has been rolled back. See the nested exceptions for details on the
> errors that occurred.
> at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2107)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1954)
> at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852)
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770)
> at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1292)
> at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:861)
> at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:408)
> ... 7 more
> Caused by: <openjpa-1.0.1-r420667:592145 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: library routine
> called out of sequence {prepstmnt 10862362 UPDATE ExSubject SET
> exSynchronizedAt = ? WHERE id = ? [params=(Timestamp) 2008-01-02
> 14:39:16.935, (long) 3]} [code=0, state=null]
> FailedObject: com.leadgenllc.lib.ExSubject-com.leadgenllc.lib.ExSubject-3
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3938)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:108)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 14 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: library
> routine called out of sequence {prepstmnt 10862362 UPDATE ExSubject
> SET exSynchronizedAt = ? WHERE id = ? [params=(Timestamp) 2008-01-02
> 14:39:16.935, (long) 3]} [code=0, state=null]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)
> ... 21 more
>
