• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Snaq DBPool, Mysql Communication Link Failure

 
Vikas Aggarwal
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic