Thanks...I'm going to try... Marco On Jan 11, 2008 9:39 AM, Andrus Adamchik <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > >> sorry about that... :-) > >> Thanks > >> Marco > >> > >> > >> On Jan 10, 2008 12:47 PM, Andrus Adamchik <[EMAIL PROTECTED]> > >> 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 < [EMAIL PROTECTED]> > >>> 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 < > >>>>> [EMAIL PROTECTED]> > >>>>> 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 > >>>>>> > >>>>>> > >>>>> > >>> > >>> > >> > >
