Hi,

Below is the exception:
2002-10-21 10:16:55,266 INFO  [STDOUT] PSNewsSessionBean -
findNewsHeadlineBySectionCode() Exception Found :javax.ejb.FinderException:
Find failed: org.jboss.util.NestedSQLException: Could not create
connection; - nested throwable: (java.sql.SQLException: ORA-00020: maximum
number of processes (125) exceeded
); - nested throwable: (org.jboss.resource.ResourceException: Could not
create connection; - nested throwable: (java.sql.SQLException: ORA-00020:
maximum number of processes (125) exceeded
))

 -----Original Message-----
From:   Camus Chan [mailto:[EMAIL PROTECTED]]
Sent:   Monday, October 21, 2002 10:11 AM
To:     '[EMAIL PROTECTED]'
Subject:        Running out of connections

Hi,

I am using JBoss 3.0.3, Tomcat 4.1.12, Oracle8i and all running on Solaris.

Here is the problem:
I have set up successfully a connection pool for using in my applications.
Everytime I call an CMP/BMP bean, a *NEW* db connection gets from the pool,
and seems not being moved back to the pool nor reused. From v$session, I can
see that the connection keeps increased but not shrinked. Eventually the
max. no of processes allowed (set in init.ora) is reached and jboss raises
exception. It is an headache problem since I have to restart jboss
*FREQUENTLY* to clean up all these *INACTIVE* connections (marked in the
status field of v$session).

This question is asked so many times in jboss forum for myself as well as I
can see such problem from others as well but seems without any idea /
solutions. This is a buring issue. Please help !

Thanks,
Camus




-------------------------------------------------------
This sf.net email is sponsored by:
Access Your PC Securely with GoToMyPC. Try Free Now
https://www.gotomypc.com/s/OSND/DD
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to