Connection Pooling: Communication link failure: java.io.IOException

[Garrett Smith <ja...@yahoo.com>]

----- 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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>