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







Reply via email to