I just saw that you are not using Tomcat's connection pool,
the reason still stands, the socket connection is closed when you try to
execute the query.
if you are using a cached connection, then implement a fail safe or use
Tomcat's connection pool, that already has this functionality
Filip
F
yes, either MySQL or something else on the network closed the connection
Caused by: java.net.SocketException: Socket closed
if you are using the connection pool, make sure you have set
testOnBorrow="true"
validationQuery="SELECT 1"
so that it validates each connection for you
Filip
Jean-Pier
