aspose file tools*
The moose likes JDBC and the fly likes Connection pool for high throughput application issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pool for high throughput application issue " Watch "Connection pool for high throughput application issue " New topic
Author

Connection pool for high throughput application issue

Mohamamd Javad Mahmoudi
Greenhorn

Joined: Jun 13, 2011
Posts: 1
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

    Joined: Apr 06, 2010
    Posts: 4240
        
        7

    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.
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: Connection pool for high throughput application issue
     
    Similar Threads
    c3p0 configuration need help!
    my tomcat almost kill me
    Hibernate C3P0 connection pool provider
    How to detect wrong login earlier
    c3p0 configuration