ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Qian" <daqiqi...@aol.com>
Subject autoReconnect=true doesn't solve closed connection problem
Date Thu, 11 May 2006 16:21:45 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
<font size="2"><font face="Arial,sans-serif">All,<br>
<br>
I set following in SglMapConfig.xml file:<br>
<br>
&nbsp;&lt;property name="JDBC.ConnectionURL"
value="jdbc:mysql://hostName:3306/dbName?autoReconnect=true"/&gt;<br>
<br>
It doesn't solve Communication Failure problem due to closed
connection. </font></font><font size="2" face="Arial,sans-serif"><font
 face="Arial,sans-serif">Setting autoReconnection=true works when
connection pool is managed by Tomcat (DBCP). (btw, PingQuery solves the
problem)</font></font><br>
<font size="2"><font face="Arial,sans-serif"><br>
database is MySql 5.019, JDBC diver is mysql-connector-java-3.1.11.<br>
<br>
Did I do something wrong? any suggestion?<br>
<br>
thanks,<br>
Tony<br>
<br>
<br>
</font></font>
</body>
</html>


Mime
View raw message