This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pool for high throughput application issue

 
Mohamamd Javad Mahmoudi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used C3P0 connection pool(and Oracle 11) to now but get not stable behavor. I test in very kinde of environment and improvment data base options. I found today Tomcate 7 jdbc connection pool released and get it. Do anyone use it and get better performance than C3p0? (I also test boncp connection pool)
My application is very high load. My problems are:

  • 1. after pass a hour connection pool throws "Can't Open Connection" exception.
    2. sometimes I get this exception "Attempted to use a closed or broken resource" pool and when restart my connection pool(by its mbean) problem fixed
    My C3P0 parameters are:




  • I also test this parameters with serveral value but dont' perceptible changes.
     
    Matthew Brown
    Bartender
    Posts: 4565
    8
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Hi Mohamamd. Welcome to the Ranch!

    I don't think you're going to get much help on database connections in a Developer Certification forum, so I'm going to move this to somewhere more appropriate.
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic