On 8/4/16, 7:32 AM, Donald McLean wrote:
I am running Derby 10.12.1.1 under Java 1.8.0u102.
I am getting an exception trying to delete a record that I added not
long before (as part of a unit test) (see stack trace below).
Any thoughts, hints, or ideas as to what I'm doing wrong would really
be appreciated.
Thank you,
Donald
Caused by: java.sql.SQLException: Exception during creation of file
/Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp
for container
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
~[derby.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source) ~[derby.jar:na]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
~[hibernate-core-5.0.5.Final.jar:5.0.5.Final]
... 36 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: Exception during
creation of file
/Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp
for container
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source) ~[derby.jar:na]
... 48 common frames omitted
Caused by: java.io.FileNotFoundException:
/Users/dmclean/IdeaProjects/aoiIteration16/testPersStore/tmp/T1470320730508.tmp
(No such file or directory)
at java.io.RandomAccessFile.open0(Native Method) ~[na:1.8.0_102]
at java.io.RandomAccessFile.open(RandomAccessFile.java:316) ~[na:1.8.0_102]
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:243)
~[na:1.8.0_102]
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(Unknown Source)
~[derby.jar:na]
at org.apache.derby.impl.io.DirFile.getRandomAccessFile(Unknown Source)
~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
~[derby.jar:na]
at java.security.AccessController.doPrivileged(Native Method)
~[na:1.8.0_102]
at
org.apache.derby.impl.store.raw.data.RAFContainer.createContainer(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.data.FileContainer.createIdent(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.store.raw.data.FileContainer.createIdentity(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.services.cache.ConcurrentCache.create(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.addContainer(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown Source)
~[derby.jar:na]
at org.apache.derby.impl.store.access.heap.Heap.create(Unknown Source)
~[derby.jar:na]
at
org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.createConglomerate(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.store.access.RAMTransaction.createConglomerate(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.execute.TemporaryRowHolderImpl.insert(Unknown
Source) ~[derby.jar:na]
at
org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
~[derby.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source) ~[derby.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby.jar:na]
... 41 common frames omitted
Hi Donald,
Can you supply the schema and the offending statement? The stack trace
indicates an UPDATE statement, not a DELETE statement.
Thanks,
-Rick