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 <[EMAIL PROTECTED]> wrote:
> 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
> > >>>>>>
> > >>>>>>
> > >>>>>
> > >>>
> > >>>
> > >>
> >
> >
>
