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 */"

7 comments:

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

    ReplyDelete
  2. I have read your blog its very attractive and impressive. I like it your blog.

    Java Training in Chennai Java Training in Chennai | Core Java Training in Chennai

    Online Java Training Java Online Training | Java J2EE Online Training | JavaEE Training Institute in Chennai

    ReplyDelete
  3. 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


  4. ان الرائد تقدم افضل الخدمات النزلية في المدينة المنورة بارخص الاسعار يمكنك زيارة التالي للمزيد من المعلومات :
    شركة تنظيف بمكة
    شركة نقل عفش من جدة الى الاردن شركة شحن عفش من جدة الى الاردن
    شركة تنظيف منازل بالخبر

    افضل شركة تنظيف منازل بالمدينة المنورة شركة تنظيف منازل بالمدينة المنورة
    شركة مكافحة حشرات بالمدينة المنورة شركة رش حشرات بالمدينة المنورة

    ReplyDelete
  5. 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