Hi,
This is because on your Oracle server while installing it has been
specified that the maximum number of processes that can be run as 60, i.e,
from 0 to 59. If you go to instance manager you will find there are 60
instances..
Try to increase this .......
Sateesh
-----Original Message-----
From: ananthakrishnan [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 5:36 AM
To: [EMAIL PROTECTED]
Subject: Revisiting Connection Pooling
Hi,
Revisiting my earlier post regarding connection pooling I would like to
depict the following
scenario...
I have a servlet and a connection pool class and am connecting to oracle
db using the thin
driver(for now no db operations iam performing but only trying to obtain
as many
connection objects as possible). I got the following results while
trying the same and pl
correct me if iam wrong and help me to infer the results of the same
1)In the servlet i have the following code
-
try{
pool = new
ConnectionPool(DSN,User,Password,driver,initialconnections,incrementvalue);
/* initialconnections - depict the number of connections requested
initially
incrementvalue - depict the scaling value in case the pool is
exhausted*/
}
catch(Exception e)
{
throw new UnvailableException(this,"could not create connection pool");
}
2) this is the second part of the working code
for(i=0;i<43;i++)
{
try
{
v.addElement(pool.getConnection()); /* this is thecode that
gets the free connections
and adds it to the vector array v*/
}
catch(Exception e)
{}
3) Now the results i got are
3a) In my first run for the for loop I tried giving 100 as the
index variables limit and an
exception was thrown
3b) In the second run I gave 40 as the index variables limit and
the connections were
opened.
3d) In the third run I gave 20 as the index variables limit and
the connections failed to
open.
Iam unable to understand this situation and basically how can we compute
the number of
connections that could be opened to the database simultaneously. Is this
dependent on the
system resource availability also. Pl explain the same and if possible
the technique used to
compute the number of connections that could be opened for a db.
The exception thrown was
Connection pool failed java.sql.SQLException: ORA-00020: maximum number
of processes (59) exceeded
thanks and regards
Anantha Krishnan
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
