You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by marco turchi <ma...@gmail.com> on 2008/01/08 19:02:22 UTC
Commit Exception Error
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
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
As far as Cayenne is concerned, javax.sql.DataSource is pluggable.
Cayenne provides one to you by default, but with the help of
DataSourceFactory in the Modeler (or even directly via API) you can
set your own DataSource with custom behavior. The simplest thing would
be to use a non-pooling DataSource (e.g.
org.apache.cayenne.conn.DriverDataSource) that would close all
returned connections for real, that is if you are comfortable with
disabling pooling globally for the entire app.
Andrus
On Jan 13, 2008, at 9:23 PM, marco turchi wrote:
> Hi Andrus,
> I was wandering about my project and I can try to change the
> structure of
> the code....
> but is it possible to close the connection and reopen it when I need
> it
> inside the same java project? It means that I can get the data from
> mysql,
> close the connection, compute what I need and reopen the connection
> when I'm
> ready to write back the results... everything into the same java
> project...
> In this way, I manage the connections... maybe this structure is
> obvious,
> but I get it just right now :-)
> the difference will be that at the moment i do not close anything
> after that
> I have got the data... and i leave everything into the java/mysql
> hands...
>
> Thanks
> Marco
>
> On Jan 13, 2008 10:47 AM, marco turchi <ma...@gmail.com> wrote:
>
>> I understand, but which are the option in my.cnf that I should
>> change? are
>> there any specific entries that I need to enable or disable?
>> thanks
>> Marco
>>
>>
>> On Jan 13, 2008 10:32 AM, Andrus Adamchik < andrus@objectstyle.org>
>> wrote:
>>
>>> At this point it is hard to recommend anything specific with no
>>> access
>>> to your environment... Now that the client side is setup to handle
>>> connection timeouts, you may have to start digging on the server
>>> side,
>>> tweaking appropriate MySQL options (e.g. those in my.cnf).
>>>
>>> Andrus
>>>
>>>
>>> On Jan 12, 2008, at 10:08 PM, marco turchi wrote:
>>>
>>>> Hi Andrus,
>>>> I have created the new url adding what u have suggested me...
>>>> <url
>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>>> connectTimeout=0&autoReconnect=true"/>
>>>> but I get again the same 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: Communication link failure:
>>>> java.net.SocketException, underlying cause: Broken pipe
>>>>
>>>> ** BEGIN NESTED EXCEPTION **
>>>>
>>>> java.net.SocketException
>>>> MESSAGE: Broken pipe
>>>>
>>>> STACKTRACE:
>>>>
>>>> java.net.SocketException: Broken pipe
>>>> at java.net.SocketOutputStream.socketWrite0 (Native Method)
>>>> at
>>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
>>>> :92)
>>>> at java.net.SocketOutputStream.write(SocketOutputStream.java:
>>>> 136)
>>>> at java.io.BufferedOutputStream.flushBuffer(
>>>> BufferedOutputStream.java:65)
>>>> at
>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1765)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>> 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)
>>>> 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)
>>>>
>>>>
>>>> ** END NESTED EXCEPTION **
>>>>
>>>>
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>> 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
>>>> 12 Jan 2008 19:40:25,088 - INFO main
>>>> com.translation.alg.TranslationNews - [
>>>> Ljava.lang.StackTraceElement;@1551f60
>>>>
>>>>
>>>> I'm quite desperate!!! :-)
>>>> thanks
>>>> Marco
>>>>
>>>> On Jan 11, 2008 10:06 AM, Andrus Adamchik < andrus@objectstyle.org>
>>>> wrote:
>>>>
>>>>> To make it valid XML you will need to replace "&" with "&" (or
>>>>> use
>>>>> CayenneModeler that will do it for you).
>>>>>
>>>>> Andrus
>>>>>
>>>>>
>>>>> On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
>>>>>
>>>>>> I have added the string that u send me,
>>>>>>
>>>>>> <url
>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>>>>> connectTimeout=0&autoReconnect=true"/>
>>>>>>
>>>>>>
>>>>>> but I get:
>>>>>> java.lang.ExceptionInInitializerError
>>>>>> at
>>>>>> com.translation.alg.TranslationNews.run(TranslationNews.java:33)
>>>>>> at
>>>>>> com.translation.alg.TranslationNews.main(TranslationNews.java:21)
>>>>>> Caused by: org.objectstyle.cayenne.ConfigurationException: [v.
>>>>>> 1.2.3
>>>>>> May 6
>>>>>> 2007] Error during Configuration initialization. [v.1.2.3 May 6
>>>>>> 2007] Load
>>>>>> failures. Main configuration class:
>>>>>> org.objectstyle.cayenne.conf.DefaultConfiguration, details:
>>>>>> domain.node.name=TranslationNode,
>>>>>> domain.node.datasource=TranslationNode.driver.xml, reason:
>>>>>> DataSource load
>>>>>> failed - The reference to entity "autoReconnect" must end with
>>>>>> the
>>>>>> ';'
>>>>>> delimiter.
>>>>>> at
>>>>>> org
>>>>>> .objectstyle
>>>>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>>>>> Configuration.java:321)
>>>>>> at
>>>>>> org
>>>>>> .objectstyle
>>>>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>>>>> Configuration.java:294)
>>>>>> at
>>>>>> org
>>>>>> .objectstyle
>>>>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>>>>> Configuration.java :275)
>>>>>> at
>>>>>> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
>>>>>> (Configuration.java:212)
>>>>>> at
>>>>>> org.objectstyle.cayenne.access.DataContext.createDataContext (
>>>>>> DataContext.java:242)
>>>>>> at com.translation.alg.News.<clinit>(News.java:17)
>>>>>> ... 2 more
>>>>>>
>>>>>> I have added ";" at the end of the string, but nothing changes
>>>>>> <url
>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>>>>> connectTimeout=0&autoReconnect=true;"/>
>>>>>>
>>>>>> Thanks
>>>>>> Marco
>>>>>> On Jan 11, 2008 9:51 AM, marco turchi < marco.turchi@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Thanks...I'm going to try...
>>>>>>> Marco
>>>>>>>
>>>>>>>
>>>>>>> On Jan 11, 2008 9:39 AM, Andrus Adamchik
>>>>>>> <an...@objectstyle.org>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> This is still a connection timeout issue. I dug up some of my
>>>>>>>> own
>>>>>>>> production configurations developed to address a similar issue.
>>>>>>>> Here
>>>>>>>> is another URL parameter you may try - "connectTimeout". E.g.:
>>>>>>>>
>>>>>>>> jdbc:mysql://server/database?
>>>>>>>> connectTimeout=0&autoReconnect=true
>>>>>>>>
>>>>>>>> Andrus
>>>>>>>>
>>>>>>>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
>>>>>>>>
>>>>>>>>> Hi Andrus,
>>>>>>>>> no good news...
>>>>>>>>> I have run the software using the changes that u have
>>>>>>>>> suggested
>>>>>>>>> me,
>>>>>>>>> but I
>>>>>>>>> get:
>>>>>>>>> 10 Jan 2008 23:19:30,036 - ERROR main
>>>>>>>>> com.translation.alg.TranslationNews -
>>>>>>>>> Fatal 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 : Communication link failure:
>>>>>>>>> java.net.SocketException, underlying cause: Broken pipe
>>>>>>>>>
>>>>>>>>> ** BEGIN NESTED EXCEPTION **
>>>>>>>>>
>>>>>>>>> java.net.SocketException
>>>>>>>>> MESSAGE: Broken pipe
>>>>>>>>>
>>>>>>>>> STACKTRACE:
>>>>>>>>>
>>>>>>>>> java.net.SocketException : Broken pipe
>>>>>>>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
>>>>>>>>> at
>>>>>>>>> java
>>>>>>>>> .net.SocketOutputStream.socketWrite(SocketOutputStream.java
>>>>>>>>> :92)
>>>>>>>>> at
>>>>>>>>> java.net.SocketOutputStream.write(SocketOutputStream.java:
>>>>>>>>> 136)
>>>>>>>>> at java.io.BufferedOutputStream.flushBuffer(
>>>>>>>>> BufferedOutputStream.java:65)
>>>>>>>>> at
>>>>>>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:
>>>>>>>>> 123)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:
>>>>>>>>> 1279)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :
>>>>>>>>> 2278)
>>>>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>>>>>>> at com.mysql.jdbc.Statement.execute(Statement.java :906)
>>>>>>>>> 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)
>>>>>>>>> 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)
>>>>>>>>> ** END NESTED EXCEPTION **
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:
>>>>>>>>> 1279)
>>>>>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
>>>>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>>>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>>>>>>> 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
>>>>>>>>> 10 Jan 2008 23:19:30,103 - INFO main
>>>>>>>>> com.translation.alg.TranslationNews - [
>>>>>>>>> Ljava.lang.StackTraceElement;@1551f60
>>>>>>>>>
>>>>>>>>> I do not know what it is...
>>>>>>>>> sorry aout that
>>>>>>>>> thanks
>>>>>>>>> Marco
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com
>>>>>>>>> >
>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> sorry about that... :-)
>>>>>>>>>> Thanks
>>>>>>>>>> Marco
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
>>>>>>>>>> andrus@objectstyle.org>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Ah cool. I thought I was going crazy :-)
>>>>>>>>>>>
>>>>>>>>>>> Andrus
>>>>>>>>>>>
>>>>>>>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi Andrus,
>>>>>>>>>>>> sorry you are right I have added the autoReconnect to the
>>>>>>>>>>>> wrong
>>>>>>>>>>>> place...
>>>>>>>>>>>> now the software is started, I'll see what happens at the
>>>>>>>>>>>> end...
>>>>>>>>>>>> thanks
>>>>>>>>>>>> Marco
>>>>>>>>>>>>
>>>>>>>>>>>> On Jan 10, 2008 11:01 AM, marco turchi <
>>> marco.turchi@gmail.com
>>>>>>>>>>>>>
>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> <?xml version="1.0" encoding="utf-8"?>
>>>>>>>>>>>>> <driver project-version=" 1.1"
>>>>>>>>>>>>> class="com.mysql.jdbc.Driver">
>>>>>>>>>>>>> <url
>>>>>>>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>>>>>>>>>>>> autoReconnect=true"/>
>>>>>>>>>>>>> <connectionPool min="1" max="1" />
>>>>>>>>>>>>> <login userName="####" password="#####"/>
>>>>>>>>>>>>> </driver>
>>>>>>>>>>>>> thanks
>>>>>>>>>>>>> Marco
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
>>>>>>>>>>>>> andrus@objectstyle.org>
>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> DataSource load failed - Can not load JDBC driver
>>>>>>>>>>>>>>>>> named
>>>>>>>>>>>>>>>>> 'com.mysql.jdbc.Driver
>>>>>>>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
>>>>>>>>>>>>>>>>> autoReconnect=true
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> But this is what generates an error... so somehow the
>>>>>>>>>>>>>> driver
>>>
>>>>>>>>>>>>>> name
>>>>>>>>
>>>>>>>>>>>>>> seems messed up. Could you post the entire file (just
>>>>>>>>>>>>>> remove
>>>>>>>>>>>>>> the
>>>>>>>>>>>>>> password)?
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Andrus
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Hi Andrus,
I was wandering about my project and I can try to change the structure of
the code....
but is it possible to close the connection and reopen it when I need it
inside the same java project? It means that I can get the data from mysql,
close the connection, compute what I need and reopen the connection when I'm
ready to write back the results... everything into the same java project...
In this way, I manage the connections... maybe this structure is obvious,
but I get it just right now :-)
the difference will be that at the moment i do not close anything after that
I have got the data... and i leave everything into the java/mysql hands...
Thanks
Marco
On Jan 13, 2008 10:47 AM, marco turchi <ma...@gmail.com> wrote:
> I understand, but which are the option in my.cnf that I should change? are
> there any specific entries that I need to enable or disable?
> thanks
> Marco
>
>
> On Jan 13, 2008 10:32 AM, Andrus Adamchik < andrus@objectstyle.org> wrote:
>
> > At this point it is hard to recommend anything specific with no access
> > to your environment... Now that the client side is setup to handle
> > connection timeouts, you may have to start digging on the server side,
> > tweaking appropriate MySQL options (e.g. those in my.cnf).
> >
> > Andrus
> >
> >
> > On Jan 12, 2008, at 10:08 PM, marco turchi wrote:
> >
> > > Hi Andrus,
> > > I have created the new url adding what u have suggested me...
> > > <url
> > > value="jdbc:mysql://enm-nc-srv1/subsumer?
> > > connectTimeout=0&autoReconnect=true"/>
> > > but I get again the same 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: Communication link failure:
> > > java.net.SocketException, underlying cause: Broken pipe
> > >
> > > ** BEGIN NESTED EXCEPTION **
> > >
> > > java.net.SocketException
> > > MESSAGE: Broken pipe
> > >
> > > STACKTRACE:
> > >
> > > java.net.SocketException: Broken pipe
> > > at java.net.SocketOutputStream.socketWrite0 (Native Method)
> > > at
> > > java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> > > :92)
> > > at java.net.SocketOutputStream.write(SocketOutputStream.java:
> > > 136)
> > > at java.io.BufferedOutputStream.flushBuffer(
> > > BufferedOutputStream.java:65)
> > > at
> > > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1765)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > > 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)
> > > 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)
> > >
> > >
> > > ** END NESTED EXCEPTION **
> > >
> > >
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > > 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
> > > 12 Jan 2008 19:40:25,088 - INFO main
> > > com.translation.alg.TranslationNews - [
> > > Ljava.lang.StackTraceElement;@1551f60
> > >
> > >
> > > I'm quite desperate!!! :-)
> > > thanks
> > > Marco
> > >
> > > On Jan 11, 2008 10:06 AM, Andrus Adamchik < andrus@objectstyle.org>
> > > wrote:
> > >
> > >> To make it valid XML you will need to replace "&" with "&" (or
> > >> use
> > >> CayenneModeler that will do it for you).
> > >>
> > >> Andrus
> > >>
> > >>
> > >> On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
> > >>
> > >>> I have added the string that u send me,
> > >>>
> > >>> <url
> > >>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> > >>> connectTimeout=0&autoReconnect=true"/>
> > >>>
> > >>>
> > >>> but I get:
> > >>> java.lang.ExceptionInInitializerError
> > >>> at
> > >>> com.translation.alg.TranslationNews.run(TranslationNews.java:33)
> > >>> at
> > >>> com.translation.alg.TranslationNews.main(TranslationNews.java:21)
> > >>> Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3
> > >>> May 6
> > >>> 2007] Error during Configuration initialization. [v.1.2.3 May 6
> > >>> 2007] Load
> > >>> failures. Main configuration class:
> > >>> org.objectstyle.cayenne.conf.DefaultConfiguration, details:
> > >>> domain.node.name=TranslationNode,
> > >>> domain.node.datasource=TranslationNode.driver.xml, reason:
> > >>> DataSource load
> > >>> failed - The reference to entity "autoReconnect" must end with the
> > >>> ';'
> > >>> delimiter.
> > >>> at
> > >>> org
> > >>> .objectstyle
> > >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> > >>> Configuration.java:321)
> > >>> at
> > >>> org
> > >>> .objectstyle
> > >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> > >>> Configuration.java:294)
> > >>> at
> > >>> org
> > >>> .objectstyle
> > >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> > >>> Configuration.java :275)
> > >>> at
> > >>> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> > >>> (Configuration.java:212)
> > >>> at
> > >>> org.objectstyle.cayenne.access.DataContext.createDataContext (
> > >>> DataContext.java:242)
> > >>> at com.translation.alg.News.<clinit>(News.java:17)
> > >>> ... 2 more
> > >>>
> > >>> I have added ";" at the end of the string, but nothing changes
> > >>> <url
> > >>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> > >>> connectTimeout=0&autoReconnect=true;"/>
> > >>>
> > >>> Thanks
> > >>> Marco
> > >>> On Jan 11, 2008 9:51 AM, marco turchi < marco.turchi@gmail.com>
> > >>> wrote:
> > >>>
> > >>>> Thanks...I'm going to try...
> > >>>> Marco
> > >>>>
> > >>>>
> > >>>> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org>
> > >>>> wrote:
> > >>>>
> > >>>>> This is still a connection timeout issue. I dug up some of my own
> > >>>>> production configurations developed to address a similar issue.
> > >>>>> Here
> > >>>>> is another URL parameter you may try - "connectTimeout". E.g.:
> > >>>>>
> > >>>>> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
> > >>>>>
> > >>>>> Andrus
> > >>>>>
> > >>>>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
> > >>>>>
> > >>>>>> Hi Andrus,
> > >>>>>> no good news...
> > >>>>>> I have run the software using the changes that u have suggested
> > >>>>>> me,
> > >>>>>> but I
> > >>>>>> get:
> > >>>>>> 10 Jan 2008 23:19:30,036 - ERROR main
> > >>>>>> com.translation.alg.TranslationNews -
> > >>>>>> Fatal 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 : Communication link failure:
> > >>>>>> java.net.SocketException, underlying cause: Broken pipe
> > >>>>>>
> > >>>>>> ** BEGIN NESTED EXCEPTION **
> > >>>>>>
> > >>>>>> java.net.SocketException
> > >>>>>> MESSAGE: Broken pipe
> > >>>>>>
> > >>>>>> STACKTRACE:
> > >>>>>>
> > >>>>>> java.net.SocketException : Broken pipe
> > >>>>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
> > >>>>>> at
> > >>>>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> > >>>>>> :92)
> > >>>>>> at
> > >>>>>> java.net.SocketOutputStream.write(SocketOutputStream.java:
> > >>>>>> 136)
> > >>>>>> at java.io.BufferedOutputStream.flushBuffer(
> > >>>>>> BufferedOutputStream.java:65)
> > >>>>>> at
> > >>>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> > >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> > >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
> > >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > >>>>>> at com.mysql.jdbc.Statement.execute(Statement.java :906)
> > >>>>>> 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)
> > >>>>>> 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)
> > >>>>>> ** END NESTED EXCEPTION **
> > >>>>>>
> > >>>>>>
> > >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
> > >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:1279)
> > >>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > >>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > >>>>>> 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
> > >>>>>> 10 Jan 2008 23:19:30,103 - INFO main
> > >>>>>> com.translation.alg.TranslationNews - [
> > >>>>>> Ljava.lang.StackTraceElement;@1551f60
> > >>>>>>
> > >>>>>> I do not know what it is...
> > >>>>>> sorry aout that
> > >>>>>> thanks
> > >>>>>> Marco
> > >>>>>>
> > >>>>>>
> > >>>>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
> > >>>>> wrote:
> > >>>>>>
> > >>>>>>> sorry about that... :-)
> > >>>>>>> Thanks
> > >>>>>>> Marco
> > >>>>>>>
> > >>>>>>>
> > >>>>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
> > >>>>>>> andrus@objectstyle.org>
> > >>>>>>> wrote:
> > >>>>>>>
> > >>>>>>>> Ah cool. I thought I was going crazy :-)
> > >>>>>>>>
> > >>>>>>>> Andrus
> > >>>>>>>>
> > >>>>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> > >>>>>>>>
> > >>>>>>>>> Hi Andrus,
> > >>>>>>>>> sorry you are right I have added the autoReconnect to the
> > >>>>>>>>> wrong
> > >>>>>>>>> place...
> > >>>>>>>>> now the software is started, I'll see what happens at the
> > >>>>>>>>> end...
> > >>>>>>>>> thanks
> > >>>>>>>>> Marco
> > >>>>>>>>>
> > >>>>>>>>> On Jan 10, 2008 11:01 AM, marco turchi <
> > marco.turchi@gmail.com
> > >>>>>>>>> >
> > >>>>>>>> wrote:
> > >>>>>>>>>
> > >>>>>>>>>> <?xml version="1.0" encoding="utf-8"?>
> > >>>>>>>>>> <driver project-version=" 1.1" class="com.mysql.jdbc.Driver">
> > >>>>>>>>>> <url
> > >>>>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> > >>>>>>>>>> autoReconnect=true"/>
> > >>>>>>>>>> <connectionPool min="1" max="1" />
> > >>>>>>>>>> <login userName="####" password="#####"/>
> > >>>>>>>>>> </driver>
> > >>>>>>>>>> thanks
> > >>>>>>>>>> Marco
> > >>>>>>>>>>
> > >>>>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
> > >>>>>>>>>> andrus@objectstyle.org>
> > >>>>>>>>>> wrote:
> > >>>>>>>>>>
> > >>>>>>>>>>>
> > >>>>>>>>>>>
> > >>>>>>>>>>>
> > >>>>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> > >>>>>>>>>>>
> > >>>>>>>>>>>>>> DataSource load failed - Can not load JDBC driver named
> > >>>>>>>>>>>>>> 'com.mysql.jdbc.Driver
> > >>>>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
> > >>>>>>>>>>>>>> autoReconnect=true
> > >>>>>>>>>>>
> > >>>>>>>>>>> But this is what generates an error... so somehow the driver
> >
> > >>>>>>>>>>> name
> > >>>>>
> > >>>>>>>>>>> seems messed up. Could you post the entire file (just remove
> > >>>>>>>>>>> the
> > >>>>>>>>>>> password)?
> > >>>>>>>>>>>
> > >>>>>>>>>>> Andrus
> > >>>>>>>>>>>
> > >>>>>>>>>>>
> > >>>>>>>>>>
> > >>>>>>>>
> > >>>>>>>>
> > >>>>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>
> > >>
> >
> >
>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
I understand, but which are the option in my.cnf that I should change? are
there any specific entries that I need to enable or disable?
thanks
Marco
On Jan 13, 2008 10:32 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> At this point it is hard to recommend anything specific with no access
> to your environment... Now that the client side is setup to handle
> connection timeouts, you may have to start digging on the server side,
> tweaking appropriate MySQL options (e.g. those in my.cnf).
>
> Andrus
>
>
> On Jan 12, 2008, at 10:08 PM, marco turchi wrote:
>
> > Hi Andrus,
> > I have created the new url adding what u have suggested me...
> > <url
> > value="jdbc:mysql://enm-nc-srv1/subsumer?
> > connectTimeout=0&autoReconnect=true"/>
> > but I get again the same 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: Communication link failure:
> > java.net.SocketException, underlying cause: Broken pipe
> >
> > ** BEGIN NESTED EXCEPTION **
> >
> > java.net.SocketException
> > MESSAGE: Broken pipe
> >
> > STACKTRACE:
> >
> > java.net.SocketException: Broken pipe
> > at java.net.SocketOutputStream.socketWrite0(Native Method)
> > at
> > java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> > :92)
> > at java.net.SocketOutputStream.write(SocketOutputStream.java:
> > 136)
> > at java.io.BufferedOutputStream.flushBuffer(
> > BufferedOutputStream.java:65)
> > at
> > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > 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)
> > 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)
> >
> >
> > ** END NESTED EXCEPTION **
> >
> >
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > 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
> > 12 Jan 2008 19:40:25,088 - INFO main
> > com.translation.alg.TranslationNews - [
> > Ljava.lang.StackTraceElement;@1551f60
> >
> >
> > I'm quite desperate!!! :-)
> > thanks
> > Marco
> >
> > On Jan 11, 2008 10:06 AM, Andrus Adamchik <an...@objectstyle.org>
> > wrote:
> >
> >> To make it valid XML you will need to replace "&" with "&" (or
> >> use
> >> CayenneModeler that will do it for you).
> >>
> >> Andrus
> >>
> >>
> >> On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
> >>
> >>> I have added the string that u send me,
> >>>
> >>> <url
> >>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> >>> connectTimeout=0&autoReconnect=true"/>
> >>>
> >>>
> >>> but I get:
> >>> java.lang.ExceptionInInitializerError
> >>> at
> >>> com.translation.alg.TranslationNews.run(TranslationNews.java:33)
> >>> at
> >>> com.translation.alg.TranslationNews.main(TranslationNews.java:21)
> >>> Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3
> >>> May 6
> >>> 2007] Error during Configuration initialization. [v.1.2.3 May 6
> >>> 2007] Load
> >>> failures. Main configuration class:
> >>> org.objectstyle.cayenne.conf.DefaultConfiguration, details:
> >>> domain.node.name=TranslationNode,
> >>> domain.node.datasource=TranslationNode.driver.xml, reason:
> >>> DataSource load
> >>> failed - The reference to entity "autoReconnect" must end with the
> >>> ';'
> >>> delimiter.
> >>> at
> >>> org
> >>> .objectstyle
> >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> >>> Configuration.java:321)
> >>> at
> >>> org
> >>> .objectstyle
> >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> >>> Configuration.java:294)
> >>> at
> >>> org
> >>> .objectstyle
> >>> .cayenne.conf.Configuration.initializeSharedConfiguration(
> >>> Configuration.java:275)
> >>> at
> >>> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> >>> (Configuration.java:212)
> >>> at
> >>> org.objectstyle.cayenne.access.DataContext.createDataContext(
> >>> DataContext.java:242)
> >>> at com.translation.alg.News.<clinit>(News.java:17)
> >>> ... 2 more
> >>>
> >>> I have added ";" at the end of the string, but nothing changes
> >>> <url
> >>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> >>> connectTimeout=0&autoReconnect=true;"/>
> >>>
> >>> Thanks
> >>> Marco
> >>> On Jan 11, 2008 9:51 AM, marco turchi <ma...@gmail.com>
> >>> wrote:
> >>>
> >>>> Thanks...I'm going to try...
> >>>> Marco
> >>>>
> >>>>
> >>>> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org>
> >>>> wrote:
> >>>>
> >>>>> This is still a connection timeout issue. I dug up some of my own
> >>>>> production configurations developed to address a similar issue.
> >>>>> Here
> >>>>> is another URL parameter you may try - "connectTimeout". E.g.:
> >>>>>
> >>>>> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
> >>>>>
> >>>>> Andrus
> >>>>>
> >>>>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
> >>>>>
> >>>>>> Hi Andrus,
> >>>>>> no good news...
> >>>>>> I have run the software using the changes that u have suggested
> >>>>>> me,
> >>>>>> but I
> >>>>>> get:
> >>>>>> 10 Jan 2008 23:19:30,036 - ERROR main
> >>>>>> com.translation.alg.TranslationNews -
> >>>>>> Fatal 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 : Communication link failure:
> >>>>>> java.net.SocketException, underlying cause: Broken pipe
> >>>>>>
> >>>>>> ** BEGIN NESTED EXCEPTION **
> >>>>>>
> >>>>>> java.net.SocketException
> >>>>>> MESSAGE: Broken pipe
> >>>>>>
> >>>>>> STACKTRACE:
> >>>>>>
> >>>>>> java.net.SocketException: Broken pipe
> >>>>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
> >>>>>> at
> >>>>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> >>>>>> :92)
> >>>>>> at
> >>>>>> java.net.SocketOutputStream.write(SocketOutputStream.java:
> >>>>>> 136)
> >>>>>> at java.io.BufferedOutputStream.flushBuffer(
> >>>>>> BufferedOutputStream.java:65)
> >>>>>> at
> >>>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> >>>>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
> >>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> >>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
> >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> >>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> >>>>>> 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)
> >>>>>> 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)
> >>>>>> ** END NESTED EXCEPTION **
> >>>>>>
> >>>>>>
> >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
> >>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> >>>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> >>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> >>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> >>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> >>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> >>>>>> 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
> >>>>>> 10 Jan 2008 23:19:30,103 - INFO main
> >>>>>> com.translation.alg.TranslationNews - [
> >>>>>> Ljava.lang.StackTraceElement;@1551f60
> >>>>>>
> >>>>>> I do not know what it is...
> >>>>>> sorry aout that
> >>>>>> thanks
> >>>>>> Marco
> >>>>>>
> >>>>>>
> >>>>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
> >>>>> wrote:
> >>>>>>
> >>>>>>> sorry about that... :-)
> >>>>>>> Thanks
> >>>>>>> Marco
> >>>>>>>
> >>>>>>>
> >>>>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
> >>>>>>> andrus@objectstyle.org>
> >>>>>>> wrote:
> >>>>>>>
> >>>>>>>> Ah cool. I thought I was going crazy :-)
> >>>>>>>>
> >>>>>>>> Andrus
> >>>>>>>>
> >>>>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> >>>>>>>>
> >>>>>>>>> Hi Andrus,
> >>>>>>>>> sorry you are right I have added the autoReconnect to the
> >>>>>>>>> wrong
> >>>>>>>>> place...
> >>>>>>>>> now the software is started, I'll see what happens at the
> >>>>>>>>> end...
> >>>>>>>>> thanks
> >>>>>>>>> Marco
> >>>>>>>>>
> >>>>>>>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com
> >>>>>>>>> >
> >>>>>>>> wrote:
> >>>>>>>>>
> >>>>>>>>>> <?xml version="1.0" encoding="utf-8"?>
> >>>>>>>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> >>>>>>>>>> <url
> >>>>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
> >>>>>>>>>> autoReconnect=true"/>
> >>>>>>>>>> <connectionPool min="1" max="1" />
> >>>>>>>>>> <login userName="####" password="#####"/>
> >>>>>>>>>> </driver>
> >>>>>>>>>> thanks
> >>>>>>>>>> Marco
> >>>>>>>>>>
> >>>>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
> >>>>>>>>>> andrus@objectstyle.org>
> >>>>>>>>>> wrote:
> >>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> >>>>>>>>>>>
> >>>>>>>>>>>>>> DataSource load failed - Can not load JDBC driver named
> >>>>>>>>>>>>>> 'com.mysql.jdbc.Driver
> >>>>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
> >>>>>>>>>>>>>> autoReconnect=true
> >>>>>>>>>>>
> >>>>>>>>>>> But this is what generates an error... so somehow the driver
> >>>>>>>>>>> name
> >>>>>
> >>>>>>>>>>> seems messed up. Could you post the entire file (just remove
> >>>>>>>>>>> the
> >>>>>>>>>>> password)?
> >>>>>>>>>>>
> >>>>>>>>>>> Andrus
> >>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>>
> >>
> >>
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
At this point it is hard to recommend anything specific with no access
to your environment... Now that the client side is setup to handle
connection timeouts, you may have to start digging on the server side,
tweaking appropriate MySQL options (e.g. those in my.cnf).
Andrus
On Jan 12, 2008, at 10:08 PM, marco turchi wrote:
> Hi Andrus,
> I have created the new url adding what u have suggested me...
> <url
> value="jdbc:mysql://enm-nc-srv1/subsumer?
> connectTimeout=0&autoReconnect=true"/>
> but I get again the same 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: Communication link failure:
> java.net.SocketException, underlying cause: Broken pipe
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Broken pipe
>
> STACKTRACE:
>
> java.net.SocketException: Broken pipe
> at java.net.SocketOutputStream.socketWrite0(Native Method)
> at
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> :92)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:
> 136)
> at java.io.BufferedOutputStream.flushBuffer(
> BufferedOutputStream.java:65)
> at
> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> 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)
> 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)
>
>
> ** END NESTED EXCEPTION **
>
>
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> 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
> 12 Jan 2008 19:40:25,088 - INFO main
> com.translation.alg.TranslationNews - [
> Ljava.lang.StackTraceElement;@1551f60
>
>
> I'm quite desperate!!! :-)
> thanks
> Marco
>
> On Jan 11, 2008 10:06 AM, Andrus Adamchik <an...@objectstyle.org>
> wrote:
>
>> To make it valid XML you will need to replace "&" with "&" (or
>> use
>> CayenneModeler that will do it for you).
>>
>> Andrus
>>
>>
>> On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
>>
>>> I have added the string that u send me,
>>>
>>> <url
>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>> connectTimeout=0&autoReconnect=true"/>
>>>
>>>
>>> but I get:
>>> java.lang.ExceptionInInitializerError
>>> at
>>> com.translation.alg.TranslationNews.run(TranslationNews.java:33)
>>> at
>>> com.translation.alg.TranslationNews.main(TranslationNews.java:21)
>>> Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3
>>> May 6
>>> 2007] Error during Configuration initialization. [v.1.2.3 May 6
>>> 2007] Load
>>> failures. Main configuration class:
>>> org.objectstyle.cayenne.conf.DefaultConfiguration, details:
>>> domain.node.name=TranslationNode,
>>> domain.node.datasource=TranslationNode.driver.xml, reason:
>>> DataSource load
>>> failed - The reference to entity "autoReconnect" must end with the
>>> ';'
>>> delimiter.
>>> at
>>> org
>>> .objectstyle
>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>> Configuration.java:321)
>>> at
>>> org
>>> .objectstyle
>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>> Configuration.java:294)
>>> at
>>> org
>>> .objectstyle
>>> .cayenne.conf.Configuration.initializeSharedConfiguration(
>>> Configuration.java:275)
>>> at
>>> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
>>> (Configuration.java:212)
>>> at
>>> org.objectstyle.cayenne.access.DataContext.createDataContext(
>>> DataContext.java:242)
>>> at com.translation.alg.News.<clinit>(News.java:17)
>>> ... 2 more
>>>
>>> I have added ";" at the end of the string, but nothing changes
>>> <url
>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>> connectTimeout=0&autoReconnect=true;"/>
>>>
>>> Thanks
>>> Marco
>>> On Jan 11, 2008 9:51 AM, marco turchi <ma...@gmail.com>
>>> wrote:
>>>
>>>> Thanks...I'm going to try...
>>>> Marco
>>>>
>>>>
>>>> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org>
>>>> wrote:
>>>>
>>>>> This is still a connection timeout issue. I dug up some of my own
>>>>> production configurations developed to address a similar issue.
>>>>> Here
>>>>> is another URL parameter you may try - "connectTimeout". E.g.:
>>>>>
>>>>> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
>>>>>
>>>>> Andrus
>>>>>
>>>>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
>>>>>
>>>>>> Hi Andrus,
>>>>>> no good news...
>>>>>> I have run the software using the changes that u have suggested
>>>>>> me,
>>>>>> but I
>>>>>> get:
>>>>>> 10 Jan 2008 23:19:30,036 - ERROR main
>>>>>> com.translation.alg.TranslationNews -
>>>>>> Fatal 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 : Communication link failure:
>>>>>> java.net.SocketException, underlying cause: Broken pipe
>>>>>>
>>>>>> ** BEGIN NESTED EXCEPTION **
>>>>>>
>>>>>> java.net.SocketException
>>>>>> MESSAGE: Broken pipe
>>>>>>
>>>>>> STACKTRACE:
>>>>>>
>>>>>> java.net.SocketException: Broken pipe
>>>>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
>>>>>> at
>>>>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
>>>>>> :92)
>>>>>> at
>>>>>> java.net.SocketOutputStream.write(SocketOutputStream.java:
>>>>>> 136)
>>>>>> at java.io.BufferedOutputStream.flushBuffer(
>>>>>> BufferedOutputStream.java:65)
>>>>>> at
>>>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
>>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>>>> 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)
>>>>>> 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)
>>>>>> ** END NESTED EXCEPTION **
>>>>>>
>>>>>>
>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
>>>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
>>>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
>>>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>>>> 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
>>>>>> 10 Jan 2008 23:19:30,103 - INFO main
>>>>>> com.translation.alg.TranslationNews - [
>>>>>> Ljava.lang.StackTraceElement;@1551f60
>>>>>>
>>>>>> I do not know what it is...
>>>>>> sorry aout that
>>>>>> thanks
>>>>>> Marco
>>>>>>
>>>>>>
>>>>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
>>>>> wrote:
>>>>>>
>>>>>>> sorry about that... :-)
>>>>>>> Thanks
>>>>>>> Marco
>>>>>>>
>>>>>>>
>>>>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
>>>>>>> andrus@objectstyle.org>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Ah cool. I thought I was going crazy :-)
>>>>>>>>
>>>>>>>> Andrus
>>>>>>>>
>>>>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
>>>>>>>>
>>>>>>>>> Hi Andrus,
>>>>>>>>> sorry you are right I have added the autoReconnect to the
>>>>>>>>> wrong
>>>>>>>>> place...
>>>>>>>>> now the software is started, I'll see what happens at the
>>>>>>>>> end...
>>>>>>>>> thanks
>>>>>>>>> Marco
>>>>>>>>>
>>>>>>>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com
>>>>>>>>> >
>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> <?xml version="1.0" encoding="utf-8"?>
>>>>>>>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
>>>>>>>>>> <url
>>>>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?
>>>>>>>>>> autoReconnect=true"/>
>>>>>>>>>> <connectionPool min="1" max="1" />
>>>>>>>>>> <login userName="####" password="#####"/>
>>>>>>>>>> </driver>
>>>>>>>>>> thanks
>>>>>>>>>> Marco
>>>>>>>>>>
>>>>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
>>>>>>>>>> andrus@objectstyle.org>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>>>>>>>>>>
>>>>>>>>>>>>>> DataSource load failed - Can not load JDBC driver named
>>>>>>>>>>>>>> 'com.mysql.jdbc.Driver
>>>>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
>>>>>>>>>>>>>> autoReconnect=true
>>>>>>>>>>>
>>>>>>>>>>> But this is what generates an error... so somehow the driver
>>>>>>>>>>> name
>>>>>
>>>>>>>>>>> seems messed up. Could you post the entire file (just remove
>>>>>>>>>>> the
>>>>>>>>>>> password)?
>>>>>>>>>>>
>>>>>>>>>>> Andrus
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>
>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Hi Andrus,
I have created the new url adding what u have suggested me...
<url
value="jdbc:mysql://enm-nc-srv1/subsumer?connectTimeout=0&autoReconnect=true"/>
but I get again the same 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: Communication link failure:
java.net.SocketException, underlying cause: Broken pipe
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(
BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
at com.mysql.jdbc.Statement.execute(Statement.java:906)
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)
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)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
at com.mysql.jdbc.Statement.execute(Statement.java:906)
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
12 Jan 2008 19:40:25,088 - INFO main com.translation.alg.TranslationNews - [
Ljava.lang.StackTraceElement;@1551f60
I'm quite desperate!!! :-)
thanks
Marco
On Jan 11, 2008 10:06 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> To make it valid XML you will need to replace "&" with "&" (or use
> CayenneModeler that will do it for you).
>
> Andrus
>
>
> On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
>
> > I have added the string that u send me,
> >
> > <url
> > value="jdbc:mysql://enm-nc-srv1/subsumer?
> > connectTimeout=0&autoReconnect=true"/>
> >
> >
> > but I get:
> > java.lang.ExceptionInInitializerError
> > at
> > com.translation.alg.TranslationNews.run(TranslationNews.java:33)
> > at
> > com.translation.alg.TranslationNews.main(TranslationNews.java:21)
> > Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3
> > May 6
> > 2007] Error during Configuration initialization. [v.1.2.3 May 6
> > 2007] Load
> > failures. Main configuration class:
> > org.objectstyle.cayenne.conf.DefaultConfiguration, details:
> > domain.node.name=TranslationNode,
> > domain.node.datasource=TranslationNode.driver.xml, reason:
> > DataSource load
> > failed - The reference to entity "autoReconnect" must end with the ';'
> > delimiter.
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:321)
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:294)
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:275)
> > at
> > org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> > (Configuration.java:212)
> > at
> > org.objectstyle.cayenne.access.DataContext.createDataContext(
> > DataContext.java:242)
> > at com.translation.alg.News.<clinit>(News.java:17)
> > ... 2 more
> >
> > I have added ";" at the end of the string, but nothing changes
> > <url
> > value="jdbc:mysql://enm-nc-srv1/subsumer?
> > connectTimeout=0&autoReconnect=true;"/>
> >
> > Thanks
> > Marco
> > On Jan 11, 2008 9:51 AM, marco turchi <ma...@gmail.com> wrote:
> >
> >> Thanks...I'm going to try...
> >> Marco
> >>
> >>
> >> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org>
> >> wrote:
> >>
> >>> This is still a connection timeout issue. I dug up some of my own
> >>> production configurations developed to address a similar issue. Here
> >>> is another URL parameter you may try - "connectTimeout". E.g.:
> >>>
> >>> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
> >>>
> >>> Andrus
> >>>
> >>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
> >>>
> >>>> Hi Andrus,
> >>>> no good news...
> >>>> I have run the software using the changes that u have suggested me,
> >>>> but I
> >>>> get:
> >>>> 10 Jan 2008 23:19:30,036 - ERROR main
> >>>> com.translation.alg.TranslationNews -
> >>>> Fatal 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 : Communication link failure:
> >>>> java.net.SocketException, underlying cause: Broken pipe
> >>>>
> >>>> ** BEGIN NESTED EXCEPTION **
> >>>>
> >>>> java.net.SocketException
> >>>> MESSAGE: Broken pipe
> >>>>
> >>>> STACKTRACE:
> >>>>
> >>>> java.net.SocketException: Broken pipe
> >>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
> >>>> at
> >>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> >>>> :92)
> >>>> at java.net.SocketOutputStream.write(SocketOutputStream.java:
> >>>> 136)
> >>>> at java.io.BufferedOutputStream.flushBuffer(
> >>>> BufferedOutputStream.java:65)
> >>>> at
> >>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> >>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> >>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> >>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
> >>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> >>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> >>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
> >>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> >>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> >>>> 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)
> >>>> 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)
> >>>> ** END NESTED EXCEPTION **
> >>>>
> >>>>
> >>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
> >>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> >>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> >>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> >>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> >>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> >>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> >>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> >>>> 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
> >>>> 10 Jan 2008 23:19:30,103 - INFO main
> >>>> com.translation.alg.TranslationNews - [
> >>>> Ljava.lang.StackTraceElement;@1551f60
> >>>>
> >>>> I do not know what it is...
> >>>> sorry aout that
> >>>> thanks
> >>>> Marco
> >>>>
> >>>>
> >>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
> >>> wrote:
> >>>>
> >>>>> sorry about that... :-)
> >>>>> Thanks
> >>>>> Marco
> >>>>>
> >>>>>
> >>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
> >>>>> andrus@objectstyle.org>
> >>>>> wrote:
> >>>>>
> >>>>>> Ah cool. I thought I was going crazy :-)
> >>>>>>
> >>>>>> Andrus
> >>>>>>
> >>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> >>>>>>
> >>>>>>> Hi Andrus,
> >>>>>>> sorry you are right I have added the autoReconnect to the wrong
> >>>>>>> place...
> >>>>>>> now the software is started, I'll see what happens at the end...
> >>>>>>> thanks
> >>>>>>> Marco
> >>>>>>>
> >>>>>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
> >>>>>> wrote:
> >>>>>>>
> >>>>>>>> <?xml version="1.0" encoding="utf-8"?>
> >>>>>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> >>>>>>>> <url
> >>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> >>>>>>>> <connectionPool min="1" max="1" />
> >>>>>>>> <login userName="####" password="#####"/>
> >>>>>>>> </driver>
> >>>>>>>> thanks
> >>>>>>>> Marco
> >>>>>>>>
> >>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
> >>>>>>>> andrus@objectstyle.org>
> >>>>>>>> wrote:
> >>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> >>>>>>>>>
> >>>>>>>>>>>> DataSource load failed - Can not load JDBC driver named
> >>>>>>>>>>>> 'com.mysql.jdbc.Driver
> >>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
> >>>>>>>>>>>> autoReconnect=true
> >>>>>>>>>
> >>>>>>>>> But this is what generates an error... so somehow the driver
> >>>>>>>>> name
> >>>
> >>>>>>>>> seems messed up. Could you post the entire file (just remove
> >>>>>>>>> the
> >>>>>>>>> password)?
> >>>>>>>>>
> >>>>>>>>> Andrus
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>
> >>>
> >>
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
To make it valid XML you will need to replace "&" with "&" (or use
CayenneModeler that will do it for you).
Andrus
On Jan 11, 2008, at 12:02 PM, marco turchi wrote:
> I have added the string that u send me,
>
> <url
> value="jdbc:mysql://enm-nc-srv1/subsumer?
> connectTimeout=0&autoReconnect=true"/>
>
>
> but I get:
> java.lang.ExceptionInInitializerError
> at
> com.translation.alg.TranslationNews.run(TranslationNews.java:33)
> at
> com.translation.alg.TranslationNews.main(TranslationNews.java:21)
> Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3
> May 6
> 2007] Error during Configuration initialization. [v.1.2.3 May 6
> 2007] Load
> failures. Main configuration class:
> org.objectstyle.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=TranslationNode,
> domain.node.datasource=TranslationNode.driver.xml, reason:
> DataSource load
> failed - The reference to entity "autoReconnect" must end with the ';'
> delimiter.
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:321)
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:294)
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:275)
> at
> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> (Configuration.java:212)
> at
> org.objectstyle.cayenne.access.DataContext.createDataContext(
> DataContext.java:242)
> at com.translation.alg.News.<clinit>(News.java:17)
> ... 2 more
>
> I have added ";" at the end of the string, but nothing changes
> <url
> value="jdbc:mysql://enm-nc-srv1/subsumer?
> connectTimeout=0&autoReconnect=true;"/>
>
> Thanks
> Marco
> On Jan 11, 2008 9:51 AM, marco turchi <ma...@gmail.com> wrote:
>
>> Thanks...I'm going to try...
>> Marco
>>
>>
>> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org>
>> wrote:
>>
>>> This is still a connection timeout issue. I dug up some of my own
>>> production configurations developed to address a similar issue. Here
>>> is another URL parameter you may try - "connectTimeout". E.g.:
>>>
>>> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
>>>
>>> Andrus
>>>
>>> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
>>>
>>>> Hi Andrus,
>>>> no good news...
>>>> I have run the software using the changes that u have suggested me,
>>>> but I
>>>> get:
>>>> 10 Jan 2008 23:19:30,036 - ERROR main
>>>> com.translation.alg.TranslationNews -
>>>> Fatal 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 : Communication link failure:
>>>> java.net.SocketException, underlying cause: Broken pipe
>>>>
>>>> ** BEGIN NESTED EXCEPTION **
>>>>
>>>> java.net.SocketException
>>>> MESSAGE: Broken pipe
>>>>
>>>> STACKTRACE:
>>>>
>>>> java.net.SocketException: Broken pipe
>>>> at java.net.SocketOutputStream.socketWrite0(Native Method)
>>>> at
>>>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
>>>> :92)
>>>> at java.net.SocketOutputStream.write(SocketOutputStream.java:
>>>> 136)
>>>> at java.io.BufferedOutputStream.flushBuffer(
>>>> BufferedOutputStream.java:65)
>>>> at
>>>> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>> at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>> 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)
>>>> 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)
>>>> ** END NESTED EXCEPTION **
>>>>
>>>>
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
>>>> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
>>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
>>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
>>>> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
>>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
>>>> at com.mysql.jdbc.Statement.execute(Statement.java:906)
>>>> 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
>>>> 10 Jan 2008 23:19:30,103 - INFO main
>>>> com.translation.alg.TranslationNews - [
>>>> Ljava.lang.StackTraceElement;@1551f60
>>>>
>>>> I do not know what it is...
>>>> sorry aout that
>>>> thanks
>>>> Marco
>>>>
>>>>
>>>> On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
>>> wrote:
>>>>
>>>>> sorry about that... :-)
>>>>> Thanks
>>>>> Marco
>>>>>
>>>>>
>>>>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <
>>>>> andrus@objectstyle.org>
>>>>> wrote:
>>>>>
>>>>>> Ah cool. I thought I was going crazy :-)
>>>>>>
>>>>>> Andrus
>>>>>>
>>>>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
>>>>>>
>>>>>>> Hi Andrus,
>>>>>>> sorry you are right I have added the autoReconnect to the wrong
>>>>>>> place...
>>>>>>> now the software is started, I'll see what happens at the end...
>>>>>>> thanks
>>>>>>> Marco
>>>>>>>
>>>>>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
>>>>>> wrote:
>>>>>>>
>>>>>>>> <?xml version="1.0" encoding="utf-8"?>
>>>>>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
>>>>>>>> <url
>>>>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
>>>>>>>> <connectionPool min="1" max="1" />
>>>>>>>> <login userName="####" password="#####"/>
>>>>>>>> </driver>
>>>>>>>> thanks
>>>>>>>> Marco
>>>>>>>>
>>>>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
>>>>>>>> andrus@objectstyle.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>>>>>>>>
>>>>>>>>>>>> DataSource load failed - Can not load JDBC driver named
>>>>>>>>>>>> 'com.mysql.jdbc.Driver
>>>>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?
>>>>>>>>>>>> autoReconnect=true
>>>>>>>>>
>>>>>>>>> But this is what generates an error... so somehow the driver
>>>>>>>>> name
>>>
>>>>>>>>> seems messed up. Could you post the entire file (just remove
>>>>>>>>> the
>>>>>>>>> password)?
>>>>>>>>>
>>>>>>>>> Andrus
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>
>>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
I have added the string that u send me,
<url
value="jdbc:mysql://enm-nc-srv1/subsumer?connectTimeout=0&autoReconnect=true"/>
but I get:
java.lang.ExceptionInInitializerError
at com.translation.alg.TranslationNews.run(TranslationNews.java:33)
at com.translation.alg.TranslationNews.main(TranslationNews.java:21)
Caused by: org.objectstyle.cayenne.ConfigurationException: [v.1.2.3 May 6
2007] Error during Configuration initialization. [v.1.2.3 May 6 2007] Load
failures. Main configuration class:
org.objectstyle.cayenne.conf.DefaultConfiguration, details:
domain.node.name=TranslationNode,
domain.node.datasource=TranslationNode.driver.xml, reason: DataSource load
failed - The reference to entity "autoReconnect" must end with the ';'
delimiter.
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:321)
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:294)
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:275)
at org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
(Configuration.java:212)
at org.objectstyle.cayenne.access.DataContext.createDataContext(
DataContext.java:242)
at com.translation.alg.News.<clinit>(News.java:17)
... 2 more
I have added ";" at the end of the string, but nothing changes
<url
value="jdbc:mysql://enm-nc-srv1/subsumer?connectTimeout=0&autoReconnect=true;"/>
Thanks
Marco
On Jan 11, 2008 9:51 AM, marco turchi <ma...@gmail.com> wrote:
> Thanks...I'm going to try...
> Marco
>
>
> On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>
> > This is still a connection timeout issue. I dug up some of my own
> > production configurations developed to address a similar issue. Here
> > is another URL parameter you may try - "connectTimeout". E.g.:
> >
> > jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
> >
> > Andrus
> >
> > On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
> >
> > > Hi Andrus,
> > > no good news...
> > > I have run the software using the changes that u have suggested me,
> > > but I
> > > get:
> > > 10 Jan 2008 23:19:30,036 - ERROR main
> > > com.translation.alg.TranslationNews -
> > > Fatal 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 : Communication link failure:
> > > java.net.SocketException, underlying cause: Broken pipe
> > >
> > > ** BEGIN NESTED EXCEPTION **
> > >
> > > java.net.SocketException
> > > MESSAGE: Broken pipe
> > >
> > > STACKTRACE:
> > >
> > > java.net.SocketException: Broken pipe
> > > at java.net.SocketOutputStream.socketWrite0(Native Method)
> > > at
> > > java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> > > :92)
> > > at java.net.SocketOutputStream.write(SocketOutputStream.java:
> > > 136)
> > > at java.io.BufferedOutputStream.flushBuffer(
> > > BufferedOutputStream.java:65)
> > > at
> > > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > > at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1149)
> > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java :2278)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > > 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)
> > > 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)
> > > ** END NESTED EXCEPTION **
> > >
> > >
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java :1786)
> > > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > > 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
> > > 10 Jan 2008 23:19:30,103 - INFO main
> > > com.translation.alg.TranslationNews - [
> > > Ljava.lang.StackTraceElement;@1551f60
> > >
> > > I do not know what it is...
> > > sorry aout that
> > > thanks
> > > Marco
> > >
> > >
> > > On Jan 10, 2008 12:50 PM, marco turchi < marco.turchi@gmail.com>
> > wrote:
> > >
> > >> sorry about that... :-)
> > >> Thanks
> > >> Marco
> > >>
> > >>
> > >> On Jan 10, 2008 12:47 PM, Andrus Adamchik < andrus@objectstyle.org>
> > >> wrote:
> > >>
> > >>> Ah cool. I thought I was going crazy :-)
> > >>>
> > >>> Andrus
> > >>>
> > >>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> > >>>
> > >>>> Hi Andrus,
> > >>>> sorry you are right I have added the autoReconnect to the wrong
> > >>>> place...
> > >>>> now the software is started, I'll see what happens at the end...
> > >>>> thanks
> > >>>> Marco
> > >>>>
> > >>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
> > >>> wrote:
> > >>>>
> > >>>>> <?xml version="1.0" encoding="utf-8"?>
> > >>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> > >>>>> <url
> > >>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> > >>>>> <connectionPool min="1" max="1" />
> > >>>>> <login userName="####" password="#####"/>
> > >>>>> </driver>
> > >>>>> thanks
> > >>>>> Marco
> > >>>>>
> > >>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
> > >>>>> andrus@objectstyle.org>
> > >>>>> wrote:
> > >>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>>
> > >>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> > >>>>>>
> > >>>>>>>>> DataSource load failed - Can not load JDBC driver named
> > >>>>>>>>> 'com.mysql.jdbc.Driver
> > >>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
> > >>>>>>
> > >>>>>> But this is what generates an error... so somehow the driver name
> >
> > >>>>>> seems messed up. Could you post the entire file (just remove the
> > >>>>>> password)?
> > >>>>>>
> > >>>>>> Andrus
> > >>>>>>
> > >>>>>>
> > >>>>>
> > >>>
> > >>>
> > >>
> >
> >
>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Thanks...I'm going to try...
Marco
On Jan 11, 2008 9:39 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> This is still a connection timeout issue. I dug up some of my own
> production configurations developed to address a similar issue. Here
> is another URL parameter you may try - "connectTimeout". E.g.:
>
> jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
>
> Andrus
>
> On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
>
> > Hi Andrus,
> > no good news...
> > I have run the software using the changes that u have suggested me,
> > but I
> > get:
> > 10 Jan 2008 23:19:30,036 - ERROR main
> > com.translation.alg.TranslationNews -
> > Fatal 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: Communication link failure:
> > java.net.SocketException, underlying cause: Broken pipe
> >
> > ** BEGIN NESTED EXCEPTION **
> >
> > java.net.SocketException
> > MESSAGE: Broken pipe
> >
> > STACKTRACE:
> >
> > java.net.SocketException: Broken pipe
> > at java.net.SocketOutputStream.socketWrite0(Native Method)
> > at
> > java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> > :92)
> > at java.net.SocketOutputStream.write(SocketOutputStream.java:
> > 136)
> > at java.io.BufferedOutputStream.flushBuffer(
> > BufferedOutputStream.java:65)
> > at
> > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > 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)
> > 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)
> > ** END NESTED EXCEPTION **
> >
> >
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
> > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> > at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> > at com.mysql.jdbc.Statement.execute(Statement.java:906)
> > 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
> > 10 Jan 2008 23:19:30,103 - INFO main
> > com.translation.alg.TranslationNews - [
> > Ljava.lang.StackTraceElement;@1551f60
> >
> > I do not know what it is...
> > sorry aout that
> > thanks
> > Marco
> >
> >
> > On Jan 10, 2008 12:50 PM, marco turchi <ma...@gmail.com> wrote:
> >
> >> sorry about that... :-)
> >> Thanks
> >> Marco
> >>
> >>
> >> On Jan 10, 2008 12:47 PM, Andrus Adamchik <an...@objectstyle.org>
> >> wrote:
> >>
> >>> Ah cool. I thought I was going crazy :-)
> >>>
> >>> Andrus
> >>>
> >>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> >>>
> >>>> Hi Andrus,
> >>>> sorry you are right I have added the autoReconnect to the wrong
> >>>> place...
> >>>> now the software is started, I'll see what happens at the end...
> >>>> thanks
> >>>> Marco
> >>>>
> >>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
> >>> wrote:
> >>>>
> >>>>> <?xml version="1.0" encoding="utf-8"?>
> >>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> >>>>> <url
> >>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> >>>>> <connectionPool min="1" max="1" />
> >>>>> <login userName="####" password="#####"/>
> >>>>> </driver>
> >>>>> thanks
> >>>>> Marco
> >>>>>
> >>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
> >>>>> andrus@objectstyle.org>
> >>>>> wrote:
> >>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> >>>>>>
> >>>>>>>>> DataSource load failed - Can not load JDBC driver named
> >>>>>>>>> 'com.mysql.jdbc.Driver
> >>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
> >>>>>>
> >>>>>> But this is what generates an error... so somehow the driver name
> >>>>>> seems messed up. Could you post the entire file (just remove the
> >>>>>> password)?
> >>>>>>
> >>>>>> Andrus
> >>>>>>
> >>>>>>
> >>>>>
> >>>
> >>>
> >>
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
This is still a connection timeout issue. I dug up some of my own
production configurations developed to address a similar issue. Here
is another URL parameter you may try - "connectTimeout". E.g.:
jdbc:mysql://server/database?connectTimeout=0&autoReconnect=true
Andrus
On Jan 11, 2008, at 1:36 AM, marco turchi wrote:
> Hi Andrus,
> no good news...
> I have run the software using the changes that u have suggested me,
> but I
> get:
> 10 Jan 2008 23:19:30,036 - ERROR main
> com.translation.alg.TranslationNews -
> Fatal 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: Communication link failure:
> java.net.SocketException, underlying cause: Broken pipe
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Broken pipe
>
> STACKTRACE:
>
> java.net.SocketException: Broken pipe
> at java.net.SocketOutputStream.socketWrite0(Native Method)
> at
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
> :92)
> at java.net.SocketOutputStream.write(SocketOutputStream.java:
> 136)
> at java.io.BufferedOutputStream.flushBuffer(
> BufferedOutputStream.java:65)
> at
> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> 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)
> 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)
> ** END NESTED EXCEPTION **
>
>
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
> at com.mysql.jdbc.Statement.execute(Statement.java:906)
> 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
> 10 Jan 2008 23:19:30,103 - INFO main
> com.translation.alg.TranslationNews - [
> Ljava.lang.StackTraceElement;@1551f60
>
> I do not know what it is...
> sorry aout that
> thanks
> Marco
>
>
> On Jan 10, 2008 12:50 PM, marco turchi <ma...@gmail.com> wrote:
>
>> sorry about that... :-)
>> Thanks
>> Marco
>>
>>
>> On Jan 10, 2008 12:47 PM, Andrus Adamchik <an...@objectstyle.org>
>> wrote:
>>
>>> Ah cool. I thought I was going crazy :-)
>>>
>>> Andrus
>>>
>>> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
>>>
>>>> Hi Andrus,
>>>> sorry you are right I have added the autoReconnect to the wrong
>>>> place...
>>>> now the software is started, I'll see what happens at the end...
>>>> thanks
>>>> Marco
>>>>
>>>> On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
>>> wrote:
>>>>
>>>>> <?xml version="1.0" encoding="utf-8"?>
>>>>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
>>>>> <url
>>>>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
>>>>> <connectionPool min="1" max="1" />
>>>>> <login userName="####" password="#####"/>
>>>>> </driver>
>>>>> thanks
>>>>> Marco
>>>>>
>>>>> On Jan 10, 2008 10:51 AM, Andrus Adamchik <
>>>>> andrus@objectstyle.org>
>>>>> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>>>>>
>>>>>>>>> DataSource load failed - Can not load JDBC driver named
>>>>>>>>> 'com.mysql.jdbc.Driver
>>>>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
>>>>>>
>>>>>> But this is what generates an error... so somehow the driver name
>>>>>> seems messed up. Could you post the entire file (just remove the
>>>>>> password)?
>>>>>>
>>>>>> Andrus
>>>>>>
>>>>>>
>>>>>
>>>
>>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Hi Andrus,
no good news...
I have run the software using the changes that u have suggested me, but I
get:
10 Jan 2008 23:19:30,036 - ERROR main com.translation.alg.TranslationNews -
Fatal 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: Communication link failure:
java.net.SocketException, underlying cause: Broken pipe
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java
:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(
BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1765)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
at com.mysql.jdbc.Statement.execute(Statement.java:906)
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)
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)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1786)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:1728)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1149)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
at com.mysql.jdbc.Statement.execute(Statement.java:906)
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
10 Jan 2008 23:19:30,103 - INFO main com.translation.alg.TranslationNews - [
Ljava.lang.StackTraceElement;@1551f60
I do not know what it is...
sorry aout that
thanks
Marco
On Jan 10, 2008 12:50 PM, marco turchi <ma...@gmail.com> wrote:
> sorry about that... :-)
> Thanks
> Marco
>
>
> On Jan 10, 2008 12:47 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>
> > Ah cool. I thought I was going crazy :-)
> >
> > Andrus
> >
> > On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> >
> > > Hi Andrus,
> > > sorry you are right I have added the autoReconnect to the wrong
> > > place...
> > > now the software is started, I'll see what happens at the end...
> > > thanks
> > > Marco
> > >
> > > On Jan 10, 2008 11:01 AM, marco turchi < marco.turchi@gmail.com>
> > wrote:
> > >
> > >> <?xml version="1.0" encoding="utf-8"?>
> > >> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> > >> <url
> > >> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> > >> <connectionPool min="1" max="1" />
> > >> <login userName="####" password="#####"/>
> > >> </driver>
> > >> thanks
> > >> Marco
> > >>
> > >> On Jan 10, 2008 10:51 AM, Andrus Adamchik < andrus@objectstyle.org>
> > >> wrote:
> > >>
> > >>>
> > >>>
> > >>>
> > >>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> > >>>
> > >>>>>> DataSource load failed - Can not load JDBC driver named
> > >>>>>> 'com.mysql.jdbc.Driver
> > >>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
> > >>>
> > >>> But this is what generates an error... so somehow the driver name
> > >>> seems messed up. Could you post the entire file (just remove the
> > >>> password)?
> > >>>
> > >>> Andrus
> > >>>
> > >>>
> > >>
> >
> >
>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
sorry about that... :-)
Thanks
Marco
On Jan 10, 2008 12:47 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Ah cool. I thought I was going crazy :-)
>
> Andrus
>
> On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
>
> > Hi Andrus,
> > sorry you are right I have added the autoReconnect to the wrong
> > place...
> > now the software is started, I'll see what happens at the end...
> > thanks
> > Marco
> >
> > On Jan 10, 2008 11:01 AM, marco turchi <ma...@gmail.com> wrote:
> >
> >> <?xml version="1.0" encoding="utf-8"?>
> >> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> >> <url
> >> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> >> <connectionPool min="1" max="1" />
> >> <login userName="####" password="#####"/>
> >> </driver>
> >> thanks
> >> Marco
> >>
> >> On Jan 10, 2008 10:51 AM, Andrus Adamchik < andrus@objectstyle.org>
> >> wrote:
> >>
> >>>
> >>>
> >>>
> >>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> >>>
> >>>>>> DataSource load failed - Can not load JDBC driver named
> >>>>>> 'com.mysql.jdbc.Driver
> >>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
> >>>
> >>> But this is what generates an error... so somehow the driver name
> >>> seems messed up. Could you post the entire file (just remove the
> >>> password)?
> >>>
> >>> Andrus
> >>>
> >>>
> >>
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
Ah cool. I thought I was going crazy :-)
Andrus
On Jan 10, 2008, at 2:37 PM, marco turchi wrote:
> Hi Andrus,
> sorry you are right I have added the autoReconnect to the wrong
> place...
> now the software is started, I'll see what happens at the end...
> thanks
> Marco
>
> On Jan 10, 2008 11:01 AM, marco turchi <ma...@gmail.com> wrote:
>
>> <?xml version="1.0" encoding="utf-8"?>
>> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
>> <url
>> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
>> <connectionPool min="1" max="1" />
>> <login userName="####" password="#####"/>
>> </driver>
>> thanks
>> Marco
>>
>> On Jan 10, 2008 10:51 AM, Andrus Adamchik < andrus@objectstyle.org>
>> wrote:
>>
>>>
>>>
>>>
>>> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>>
>>>>>> DataSource load failed - Can not load JDBC driver named
>>>>>> 'com.mysql.jdbc.Driver
>>>>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
>>>
>>> But this is what generates an error... so somehow the driver name
>>> seems messed up. Could you post the entire file (just remove the
>>> password)?
>>>
>>> Andrus
>>>
>>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Hi Andrus,
sorry you are right I have added the autoReconnect to the wrong place...
now the software is started, I'll see what happens at the end...
thanks
Marco
On Jan 10, 2008 11:01 AM, marco turchi <ma...@gmail.com> wrote:
> <?xml version="1.0" encoding="utf-8"?>
> <driver project-version="1.1" class="com.mysql.jdbc.Driver">
> <url
> value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
> <connectionPool min="1" max="1" />
> <login userName="####" password="#####"/>
> </driver>
> thanks
> Marco
>
> On Jan 10, 2008 10:51 AM, Andrus Adamchik < andrus@objectstyle.org> wrote:
>
> >
> >
> >
> > On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
> >
> > >>> DataSource load failed - Can not load JDBC driver named
> > >>> 'com.mysql.jdbc.Driver
> > >>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
> >
> > But this is what generates an error... so somehow the driver name
> > seems messed up. Could you post the entire file (just remove the
> > password)?
> >
> > Andrus
> >
> >
>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
<?xml version="1.0" encoding="utf-8"?>
<driver project-version="1.1" class="com.mysql.jdbc.Driver">
<url value="jdbc:mysql://enm-nc-srv1/subsumer?autoReconnect=true"/>
<connectionPool min="1" max="1" />
<login userName="####" password="#####"/>
</driver>
thanks
Marco
On Jan 10, 2008 10:51 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>
>
>
> On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>
> >>> DataSource load failed - Can not load JDBC driver named
> >>> 'com.mysql.jdbc.Driver
> >>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
>
> But this is what generates an error... so somehow the driver name
> seems messed up. Could you post the entire file (just remove the
> password)?
>
> Andrus
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Jan 10, 2008, at 12:33 PM, marco turchi wrote:
>>> DataSource load failed - Can not load JDBC driver named
>>> 'com.mysql.jdbc.Driver
>>> ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true
But this is what generates an error... so somehow the driver name
seems messed up. Could you post the entire file (just remove the
password)?
Andrus
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Sorry Andrus....
I have this line:
<url value="jdbc:mysql://localhost/subsumer?autoReconnect=true"/>
inside the drive file.... but this does not work...
Thanks
Marco
On Jan 10, 2008 8:39 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> > maybe I have added it to the wrong place...
>
>
> Most likely... "autoReconnect=true" should be appended to the URL, not
> the driver name.
>
> Andrus
>
>
> On Jan 10, 2008, at 4:38 AM, marco turchi wrote:
>
> > Hi Andrus,
> > I have added the jdbc:mysql://localhost/test?autoReconnect=true
> > string to
> > file.driver.xml file into my cayenne model, but I get this error:
> > org.objectstyle.cayenne.ConfigurationException: [v.1.2.3 May 6 2007]
> > Error
> > during Configuration initialization. [v.1.2.3 May 6 2007] Load
> > failures.
> > Main configuration class: org.object
> > style.cayenne.conf.DefaultConfiguration, details:
> > domain.node.name=TranslationNode,
> > domain.node.datasource=TranslationNode.driver.xml, reason:
> > DataSource load
> > failed - Can not load JDBC driver named 'com.mysql.jdbc.Driver
> > ?autoReconnect=t
> > rue': com.mysql.jdbc.Driver?autoReconnect=true
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:321)
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:294)
> > at
> > org
> > .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> > Configuration.java:275)
> > at
> > org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> > (Configuration.java:212)
> > at
> > org.objectstyle.cayenne.access.DataContext.createDataContext(
> > DataContext.java:242)
> > at com.translation.alg.News.<clinit>(News.java:17)
> > maybe I have added it to the wrong place...
> > Thanks
> > Marco
> >
> >
> > On Jan 9, 2008 3:17 PM, Andrus Adamchik <an...@objectstyle.org>
> > wrote:
> >
> >> Hi Marco,
> >>
> >> I think what you need is a reconnect parameter in your MySQL URL.
> >> E.g.:
> >>
> >> jdbc:mysql://localhost/test?autoReconnect=true
> >>
> >> Andrus
> >>
> >>
> >> On Jan 8, 2008, at 8:02 PM, marco turchi wrote:
> >>
> >>> 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
> >>
> >>
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
> maybe I have added it to the wrong place...
Most likely... "autoReconnect=true" should be appended to the URL, not
the driver name.
Andrus
On Jan 10, 2008, at 4:38 AM, marco turchi wrote:
> Hi Andrus,
> I have added the jdbc:mysql://localhost/test?autoReconnect=true
> string to
> file.driver.xml file into my cayenne model, but I get this error:
> org.objectstyle.cayenne.ConfigurationException: [v.1.2.3 May 6 2007]
> Error
> during Configuration initialization. [v.1.2.3 May 6 2007] Load
> failures.
> Main configuration class: org.object
> style.cayenne.conf.DefaultConfiguration, details:
> domain.node.name=TranslationNode,
> domain.node.datasource=TranslationNode.driver.xml, reason:
> DataSource load
> failed - Can not load JDBC driver named 'com.mysql.jdbc.Driver
> ?autoReconnect=t
> rue': com.mysql.jdbc.Driver?autoReconnect=true
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:321)
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:294)
> at
> org
> .objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
> Configuration.java:275)
> at
> org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
> (Configuration.java:212)
> at
> org.objectstyle.cayenne.access.DataContext.createDataContext(
> DataContext.java:242)
> at com.translation.alg.News.<clinit>(News.java:17)
> maybe I have added it to the wrong place...
> Thanks
> Marco
>
>
> On Jan 9, 2008 3:17 PM, Andrus Adamchik <an...@objectstyle.org>
> wrote:
>
>> Hi Marco,
>>
>> I think what you need is a reconnect parameter in your MySQL URL.
>> E.g.:
>>
>> jdbc:mysql://localhost/test?autoReconnect=true
>>
>> Andrus
>>
>>
>> On Jan 8, 2008, at 8:02 PM, marco turchi wrote:
>>
>>> 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
>>
>>
Re: Commit Exception Error
Posted by marco turchi <ma...@gmail.com>.
Hi Andrus,
I have added the jdbc:mysql://localhost/test?autoReconnect=true string to
file.driver.xml file into my cayenne model, but I get this error:
org.objectstyle.cayenne.ConfigurationException: [v.1.2.3 May 6 2007] Error
during Configuration initialization. [v.1.2.3 May 6 2007] Load failures.
Main configuration class: org.object
style.cayenne.conf.DefaultConfiguration, details:
domain.node.name=TranslationNode,
domain.node.datasource=TranslationNode.driver.xml, reason: DataSource load
failed - Can not load JDBC driver named 'com.mysql.jdbc.Driver
?autoReconnect=t
rue': com.mysql.jdbc.Driver?autoReconnect=true
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:321)
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:294)
at
org.objectstyle.cayenne.conf.Configuration.initializeSharedConfiguration(
Configuration.java:275)
at org.objectstyle.cayenne.conf.Configuration.getSharedConfiguration
(Configuration.java:212)
at org.objectstyle.cayenne.access.DataContext.createDataContext(
DataContext.java:242)
at com.translation.alg.News.<clinit>(News.java:17)
maybe I have added it to the wrong place...
Thanks
Marco
On Jan 9, 2008 3:17 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Hi Marco,
>
> I think what you need is a reconnect parameter in your MySQL URL. E.g.:
>
> jdbc:mysql://localhost/test?autoReconnect=true
>
> Andrus
>
>
> On Jan 8, 2008, at 8:02 PM, marco turchi wrote:
>
> > 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
>
>
Re: Commit Exception Error
Posted by Andrus Adamchik <an...@objectstyle.org>.
Hi Marco,
I think what you need is a reconnect parameter in your MySQL URL. E.g.:
jdbc:mysql://localhost/test?autoReconnect=true
Andrus
On Jan 8, 2008, at 8:02 PM, marco turchi wrote:
> 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