cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "marco turchi" <marco.tur...@gmail.com>
Subject Commit Exception Error
Date Tue, 08 Jan 2008 18:02:22 GMT
Dear experts,
I'm running a java software that gets some data from the DB, computes them
and the writes the result to the DB... Unfortunately, the computation of the
data gets 10 hs...
I'm able to get the data, compute them, but when I try to write to the DB, I
get this error:
org.objectstyle.cayenne.CayenneRuntimeException: [v.1.2.3 May 6 2007] Commit
Exception
        at org.objectstyle.cayenne.access.DataContext.flushToParent(
DataContext.java:1290)
        at org.objectstyle.cayenne.access.DataContext.commitChanges (
DataContext.java:1166)
        at com.translation.alg.WriterData.insert(WriterData.java:57)
        at com.translation.alg.News.write(News.java:85)
        at com.translation.alg.TranslationNews.run(TranslationNews.java :66)
        at com.translation.alg.TranslationNews.main(TranslationNews.java:21)
Caused by: java.sql.SQLException: Connection.close() has already been
called. Invalid operation in this state.
        at com.mysql.jdbc.Connection.getMutex (Connection.java:2130)
        at com.mysql.jdbc.Statement.execute(Statement.java:866)
        at org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.pkFromDatabase
(MySQLPkGenerator.java:123)
        at org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity(
JdbcPkGenerator.java:326)
        at
org.objectstyle.cayenne.access.DataDomainInsertBucket.createPermIdsForObjEntity
(DataDomainInsertBucket.java:194)
        at
org.objectstyle.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(
DataDomainInsertBucket.java:122)
        at org.objectstyle.cayenne.access.DataDomainSyncBucket.appendQueries
(DataDomainSyncBucket.java:108)
        at org.objectstyle.cayenne.access.DataDomainFlushAction.preprocess (
DataDomainFlushAction.java:211)
        at org.objectstyle.cayenne.access.DataDomainFlushAction.flush(
DataDomainFlushAction.java:167)
        at org.objectstyle.cayenne.access.DataDomain.onSyncFlush(
DataDomain.java :846)
        at org.objectstyle.cayenne.access.DataDomain$2.transform(
DataDomain.java:817)
        at org.objectstyle.cayenne.access.DataDomain.runInTransaction(
DataDomain.java:862)
        at org.objectstyle.cayenne.access.DataDomain.onSync (DataDomain.java
:814)
        at org.objectstyle.cayenne.access.DataContext.flushToParent(
DataContext.java:1262)
        ... 5 more

I have tried to delete and recreate the DataContext using
createDataContext() before to write to the table, but I get the same error.
(I have created the DataContext the first time when I start the program...)
Can u help me?
Thanks a lot
Marco

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message