Re: web application crashes

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Jun 13 2003 - 10:12:43 EDT

  • Next message: David Benoff: "Problem with noMatchExp"

    > Do you have any idea about why the server cannot be awaken correctly ?

    Yes, please read this FAQ, it has a MySQL solution:

       http://objectstyle.org/cayenne/faq/deploy.html#reconnect

    Andrus

    >
    > Every night my Tomcat server falls asleep since it does not
    > receive any request for my web app. This application is based
    > on Cayenne and MySQL.
    > In the morning at my first attempt to get a connection
    > the application crashes. The stack trace shows :
    >
    > 2003-06-13 10:11:14 login: Exception when processing request login
    > org.objectstyle.cayenne.CayenneRuntimeException: [v.1.0b3 May 25 2003]
    > Global ex ception.
    > at
    > org.objectstyle.cayenne.access.util.SelectObserver.nextGlobalExceptio
    > n(SelectObserver.java:155)
    >
    > ..............
    >
    > at
    > org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:
    > at
    > hep.xmm.l3sdb.server.L3sdbServlet.selectUser(L3sdbServlet.java:321)
    > at
    > hep.xmm.l3sdb.server.LoginServlet.handleLogin(LoginServlet.java:119)
    > at
    > hep.xmm.l3sdb.server.LoginServlet.handleRequest(LoginServlet.java:49)
    > at
    > hep.xmm.l3sdb.server.L3sdbServlet.doPost(L3sdbServlet.java:87)
    > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    >
    > .................
    >
    > Caused by: java.sql.SQLException: Communication link failure:
    > java.io.IOExceptio n
    > at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
    > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
    > at com.mysql.jdbc.Connection.execSQL(Unknown Source)
    > at com.mysql.jdbc.PreparedStatement.executeQuery(Unknown Source)
    > at
    > org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:375)
    >
    > Do you have any idea about why the server cannot be awaken correctly ?
    >
    >
    > --
    > ______________________________________________
    >
    > Jean-Paul Le Fèvre - Jean-Paul.LeFevr..ea.fr



    This archive was generated by hypermail 2.0.0 : Fri Jun 13 2003 - 10:12:44 EDT