-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
It is not connections but processes that you are running out of (they are
different).
For Oracle 50 is a way low number. I hope you are not using the defaults as
shipped by Oracle. They were almost reasonable settings 10 years ago.
Thor HW
----- Original Message -----
From: James Cooper <[EMAIL PROTECTED]>
To: Java Apache Users <[EMAIL PROTECTED]>
Sent: Thursday, August 12, 1999 10:29 AM
Subject: Re: keeping a handle on JDBC connections
> -----------------------------
> 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]
>
>
--
--------------------------------------------------------------
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]
