> 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