Ciao,ho installato Tomcat alla versione 5.5.20 su server unix, eh ho realizzato una webapp che utilizza come database, mysql alla versione 4.
Funziona tutto egregiamente, solo che tutte le mattine che rientro nella mia applicazione ricevo il seguente errore... Soluzione: rilanciare la webapp dal pannello manager.



Dec 18, 2006 9:38:45 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: 08S01
Dec 18, 2006 9:38:45 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Communications link failure due to underlying exception:

** 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(SocketOutp utStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:66)
at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:124)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 81)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1231)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:92 )
at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:66 2)
at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:214 5)
at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoa der.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(Que ryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performLis t(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:7 9)
at hd.regia.security.user.UserManager.login(UserManag er.java:209)
at hd.regia.tw.struts.LoginDispatchAction.execute(Log inDispatchAction.java:34)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyo teHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(Handler Request.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelS ocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnecti on(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnectio n.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.

di seguito la configurazione del mio file context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context
reloadable="true"
workDir="/opt/tomcat5/work/Catalina/localhost/ssticketweb">
<Resource
name="jdbc/ticketweb"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
factory="org.apache.commons.dbcp.BasicDataSourceFa ctory"
password="password"
maxIdle="10"
minIdle="2"
maxWait="300"
maxActive="1000"
username="utente"
url="jdbc:mysql://localhost:3306/ticketweb?autoReconnect=true"
removeAbandoned="true"
removeAbandonedTimeout="120"
/>
</Context>


Non posso tutte le mattine dover rilanciare la web app!!!!!
Aiuto!""!!! Grazie