java.sql.SQLException: Communication link failure: java.net.Socke tException

[Hamelmann Stefan <st...@pdb.sbs.de>]

Hi

After a while I get this exception when I attempt to read from the mySQL
database.
The error disappears after restarting the tomcat server.

- java.sql.SQLException: Communication link failure:
java.net.SocketException
	at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:459)
	at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
	at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
	at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
	at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
	at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
	at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
... a.s.o.

Is it a problem with the struts connection pool ?
In the java.sun.com discussion forum I found also a hint to have only
synchronized methods accessing the db.

Configuration:
Windows NT 4.0

Struts 1.0 
Tomcat 3.2.3
mm.mysql-2.0.4-bin.jar
jdk 1.3.0

server:
3.23.40-nt
client:
3.23.36
( taken from mysqladmin console)

Any help is appreciated.

Stefan Hamelmann