Re: Commit Exception Error

From: marco turchi (marco.turch..mail.com)
Date: Thu Jan 10 2008 - 18:36:36 EST

  • Next message: Andrus Adamchik: "Re: Commit Exception Error"

    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..551f60

    I do not know what it is...
    sorry aout that
    thanks
    Marco

    On Jan 10, 2008 12:50 PM, marco turchi <marco.turch..mail.com> wrote:

    > sorry about that... :-)
    > Thanks
    > Marco
    >
    >
    > On Jan 10, 2008 12:47 PM, Andrus Adamchik <andru..bjectstyle.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.turch..mail.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 < andru..bjectstyle.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
    > > >>>
    > > >>>
    > > >>
    > >
    > >
    >



    This archive was generated by hypermail 2.0.0 : Thu Jan 10 2008 - 18:37:13 EST