Hi, 1. For BMP, we do have conn.close() in the finally block so that we are sure it is executed. But I think it is a wrapped method. 2. For CMP, please kindly advise how to do that.
For both cases, the connection is marked *INACTIVE* after completing the call. Thanks, Camus -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Burke Sent: Monday, October 21, 2002 11:08 AM To: [EMAIL PROTECTED] Subject: RE: [JBoss-user] Running out of connections u must close the connections. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Camus Chan > Sent: Sunday, October 20, 2002 10:11 PM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] 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 ------------------------------------------------------- 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 ------------------------------------------------------- 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
