-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
James Cooper wrote:
> >
> > Is this a limitation in Oracle itself, or in JDBC? How do I make sure my
> > servlets that use a database pool are scalable to heavy traffic loads?
>
> how many connections are in the pool that you're creating? it sounds like
> you're leaking open connections somewhere.
The servlet that creates the pool also takes in a minimum # for initial
connections in pool and another number for how many to grow the pool by. When
connections are > than the number given for initial and a connection is
released by the servlet using the pool, the connection is destroyed and removed
from the given pool.
Actually, I monitor the number of open connections (via oracle processes
running on the machine) to be sure all of this is happening correctly.
>
> the max # of connections to oracle is configurable, but that's really not
> the problem I don't think.
Actually, I think it may be the problem. I am doing this in my development
environment with a 8user developers license for Oracle. I don't know how to
raise the 50 connections limit so I will check out this route next. It would
be quite a life saver. =)
Since a number of servlets can create pools using the pool servlet, the limit
is reached quickly. For example, if 6 servlets create a pool each containing a
minimum of 10 connections, you'd need space for 60 connections.
> you might consider using one of the many free JDBC connection pools out
> there. check out: http://www.bitmechanic.com/
Actually the starting point for my pool code is the code given in Oreilly's
servlet book. I have modified it to handle releasing connections and killing
pools better though.
Thanks!
-- Joshua Slack
-- Obj-X, Inc.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
