Data AccessCore JavaApp FrameworksViewTestingBuildingDeploymentDev ToolsSecurityOpinions

Sunday, October 18, 2009

Tomcat DBCP DataSource falls idle overnight

If you have a low activity web server using Tomcat DBCP to retrieve connections to your database, the database server might time out connections in the pool.

Adding the following to your <Resource> configuration can address the problem.
  • testOnBorrow="true"
  • validationQuery="SELECT 1 /* ping */"

4 comments:

  1. be carefull, "SELECT 1" doesn't work everywhere, for example mysql do, but postresql don't ^^

    ReplyDelete
  2. Installments are ascertained as a level of Visa deals, and if the deals are developing, the re-installment could be snappier. check cashing near me open now san diego

    ReplyDelete
  3. A wired network has some disadvantages when compared to a wireless network, but wireless network is more convenient, especially laptop users, just sign in with password (what can be configured with 192.168.l.l)

    ReplyDelete