Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

db connection timeout

 
Peter Straw
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having a problem with a connection object timing out in a servlet. The connection is created in a servlets init() method and is used indefinitely in synchonized methods throughout the servlet while the web application runs. This worked ok with microsoft sql, but now using mySql the connection times out and then creates SQLExceptions.
Does anyone know how best to fix this? Should I catch each sql exception and test for the connection being null and if it is create a new one? (Seems a bit long-winded). Or is there a Better Way?
Many thanks
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use a connection pool. The simplest approach is to persuade your application server to make a DataSource available that you look up using JNDI. Otherwise, look into the Apache Jakarta Commons DBCP (DataBase Connection Pool).
- Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic