Re[2]: pooled connection

From: Andrus (andru..bjectstyle.org)
Date: Sat Jan 04 2003 - 19:42:36 EST

  • Next message: Andrus: "Connection Autorestart [Was: pooled connection]"

    Tim,

    Though we have no proof that this is the case with your application, I
    confirmed that Cayenne would fail in the case I described in the quoted
    message. I will file this as a bug and we will work on handling such cases.
    Here is the stack trace I got from our Tapestry tutorial after I restarted
    MySQL:

    java.sql.SQLException: Communication link failure: java.net.SocketException
             at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
             at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
             at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
             at org.gjt.mm.mysql.PreparedStatement.executeQuery(Unknown Source)
             at
    org.objectstyle.cayenne.access.DefaultResultIterator.<init>(DefaultResultIterat
    or.java:117)
             at
    org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:358)
             at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:278)
             at
    org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:427)
             at
    org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:757)

             at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:846)
             at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:694)
             at
    cayenne.tutorial.tapestry.pages.BrowseArtistsPage.prepareForRender(BrowseArtist
    sPage.java:77)

    Andrus

    At 06:50 PM 1/4/2003 -0500, Andrus wrote:
    >Another question - is it possible that while Tomcat is running, MySQL is
    >restarted independently from Tomcat?
    >
    >This seems a likely cause of this problem. Of course this may need a
    >better handling in Cayenne internal connection pool and I really need to
    >do some testing of this scenario.
    >
    >Cheers,
    >Andrus
    >

    This archive was generated by hypermail 2.0.0 : Sat Jan 04 2003 - 19:41:28 EST