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
