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

Reply via email to