Hi
My user is on windows xp. Apache Derby - 10.2.2.0
Any help on fixing this database would be appreciated.
When we apply data updates, we basically wipe out the data from a subset of
tables and re-insert new data e.g. with product prices etc. We are getting
this exception with this one user, when trying to reload the data.
Here is my exception :
!MESSAGE java.lang.RuntimeException: java.sql.SQLException: Cannot create
new object with key Page(1,Container(0, 2097)) in PageCache cache. The
object already exists in the cache.
com.tpc.ipartner.util.derby.DerbyDataUpdateScriptRunner.updateData(DerbyDataUpdateScriptRunner.java:107)
com.tpc.ipartner.util.derby.DerbyDatabase.runDataUpdateScript(DerbyDatabase.java:355)
com.tpc.ipartner.util.derby.DerbyDatabase$3.performWork(DerbyDatabase.java:383)
com.tpc.ipartner.AbstractTpcRunnableWithProgress.run(AbstractTpcRunnableWithProgress.java:12)
com.tpc.ipartner.util.derby.DerbyDatabase.updateData(DerbyDatabase.java:407)
com.tpc.ipartner.application.actions.ApplyAppAndDataUpdatesProgressableAction$1$1.run(ApplyAppAndDataUpdatesProgressableAction.java:154)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: java.sql.SQLException: Cannot create new object with key
Page(1,Container(0, 2097)) in PageCache cache. The object already exists in
the cache.
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source)
com.tpc.ipartner.util.derby.DerbyDataUpdateScriptRunner.updateData(DerbyDataUpdateScriptRunner.java:87)
com.tpc.ipartner.util.derby.DerbyDatabase.runDataUpdateScript(DerbyDatabase.java:355)
com.tpc.ipartner.util.derby.DerbyDatabase$3.performWork(DerbyDatabase.java:383)
com.tpc.ipartner.AbstractTpcRunnableWithProgress.run(AbstractTpcRunnableWithProgress.java:12)
com.tpc.ipartner.util.derby.DerbyDatabase.updateData(DerbyDatabase.java:407)
com.tpc.ipartner.application.actions.ApplyAppAndDataUpdatesProgressableAction$1$1.run(ApplyAppAndDataUpdatesProgressableAction.java:154)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
--
View this message in context:
http://www.nabble.com/Page-Cache---The-object-already-exists-in-the-cache.-tp18342903p18342903.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
