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 > > >>> > > >>> > > >> > > > > >