DB Pooling and Processes

[Bob Swerdlow <rs...@transpose.com>]

Hi, y'all -

Is there documentation somewhere about how to set up Oracle with Turbine DB
Pooling?

We ran into a problem recently where we were getting "cannot get connection"
errors.  I found that our TurbineProperties.Resources had:

    # The number of database connections to cache per ConnectionPool
    # instance (specified per database).
    database.default.maxConnections=3

Since the failure happend when our code was setting up 4 connections, I knew
I had to change this.  After a bit of web-snooping, I changed it to 100.

Now we are getting this error:
    ORA-00020: maximum number of processes (50) exceeded

This actually happened after reloading the project a few times.

So my questions are:
  1. What is an appropriate value for database.default.maxConnections?  This
will be a public web site with many concurrent users retrieving pages that
will access the database
  2. Do I need to coordinate the number of connections with the number of
Oracle processes?  How do I control this in Oracle?
  3. Should reloading the project release all of the connections?  It does
not seem to have done so, however, when I restarted Tomcat, those processes
seemed to go away.
  4. What else should I worry about?

Thanks for your help!

Bob Swerdlow
Chief Operating Officer
Transpose, LLC
rswerdlow@transpose.com






--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>