wood burning stoves 2.0*
The moose likes JDBC and the fly likes Snaq DBPool, Mysql Communication Link Failure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Snaq DBPool, Mysql Communication Link Failure" Watch "Snaq DBPool, Mysql Communication Link Failure" New topic
Author

Snaq DBPool, Mysql Communication Link Failure

Vikas Aggarwal
Ranch Hand

Joined: Jun 22, 2001
Posts: 140
I'm using the DBPool package with a MySQL db under Struts and Tomcat 4.1
with the following settings in the properties file:
drivers=org.gjt.mm.mysql.Driver
logfile=dblog.txt
local.url=jdbc:mysql:/localhost/billblac_recovery
local.user=billblac_bill
local.password=wgb
local.maxpool=20
local.maxconn=20
local.expiry=0
local.name=recovery
local.debug=true
I'm getting the following error message intermittently on the host's linux
server. I don't get the error on my Win2000 desktop under
development:
UserFactory.searchReturn() - EXECUTING STATEMENT
UserBeanCommandFactory.searchReturn() sqlException: Communication link
failure: java.net.SocketException
java.sql.SQLException: Communication link failure: java.net.SocketException
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:882)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1809)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1458)
at
snaq.db.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:55
)
at com.recovery.factories.UserFactory.searchReturn(Unknown Source)
at com.recovery.actions.LogInAction.execute(Unknown Source)
The error always occurs after about 10 minutes has gone by since the last
connection to the DB has been made. I have to restart
Tomcat on the server to clear it all up. I'm at a loss here and any ideas
would be greatly appreciated!
Also, where does the dblog.txt file go? In the same directory as the
properties file? I am not getting any debug info into the file.
Thanks,
Vikas Aggarwal


Vikas Aggarwal

Founder @
Leads and Deals Limited

www.LeadsAndDeals.com
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Snaq DBPool, Mysql Communication Link Failure
 
Similar Threads
Problem connecting eclipse to mysql database with hibernate
Communication link failure: java.net.SocketException
java.net.SocketException MESSAGE: Broken pipe
Communications link failure in JBOSS
JDBC Timeout issue with MySQL