-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
On Thu, 12 Aug 1999, Joshua Slack wrote:
> It works fine most of the time, but occassionally I get an error where a
> pool cannot be created and it says:
> ORA-00020: maximum number of processes (50) exceeded
>
> 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 max # of connections to oracle is configurable, but that's really not
the problem I don't think.
is your servlet creating the connections in its init() method? does it
ever allocate additional connections if all connections are in use? how
are connections returned back to the pool?
you might consider using one of the many free JDBC connection pools out
there. check out: http://www.bitmechanic.com/
or for an article on the topic:
http://nctweb.com/columns/connection_pool.html
-- James
--
--------------------------------------------------------------
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]
