----- Root Cause ----- java.sql.SQLException: Communication link failure: java.io.IOException at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.PreparedStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179) at com.dhtmlkitchen.reg.db.Database.login(Database.java:172) at com.dhtmlkitchen.reg.Login.doPost(Login.java:76)
To fix this, I was told to put a query in my server.xml. <parameter> <name>validationQuery</name> <value>SELECT 0</value> </parameter> The idea is that a select statement will keep connections from timing out. Should I use a ";" as in "SELECT 0;" or just "SELECT 0" ? I thought my host had put this into the server.xml file; it should already be there. Maybe something else is causing this problem. ===== http://dhtmlkitchen.com/ JSP | Servlets | DHTML Garrett Needs A Job __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>