jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases 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


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
Have you checked out Aspose?
 
subject: Snaq DBPool, Mysql Communication Link Failure
 
jQuery in Action, 3rd edition