I'm glad you fixed the problems.

IdleTimeoutMinutes in the pool config is probably what you need to look at.

david jencks

On 2002.10.21 21:47:11 -0400 Camus Chan wrote:
> Ok, guys, I have a good news. After modifications, the problem goes away.
> Thanks very much for dm and david for pointing out and giving me
> directions
> to solve the long-lasted problem and my bug-ful programs.
> 
> For CMP, we observed that the connection is lasted for some minutes after
> completing the request and then auto-closed. Is there parameter to
> configure
> this auto-close time ?
> 
> Camus
> 
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:jboss-user-admin@;lists.sourceforge.net]On Behalf Of Camus Chan
> Sent: Monday, October 21, 2002 1:28 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [JBoss-user] Running out of connections
> 
> 
> OK, so let me try to lookup the datasource within setentitycontext while
> getting and closing method within each method. FYI, right now, I don't
> have
> the "connection is closed" style exception ? It seems no problem
> accessing
> the database. Let me try and come back to you.
> 
> How about CMP ?
> 
> 
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:jboss-user-admin@;lists.sourceforge.net]On Behalf Of Dmitri
> Colebatch
> Sent: Monday, October 21, 2002 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Running out of connections
> 
> 
> So, in setEntityContext you obtain a connection, and you close it in
> every
> find method?  Ordinarily this would lead to "connection is closed" style
> exceptions because setEntiyContext is called once, and the find***
> methods
> are obviously called many times.  However, in EJB, calling conn.close
> simply
> disassociates the conn with the current thread.
> 
> Ok, basically, dont call getDBConnection in setEntityContext, call it in
> the
> ejbFind*** methods.  And dont have it as a class member, just have a var
> in
> the method - although you could have a class member, this is my
> preference.
> 
> hth
> dim
> 
> ----- Original Message -----
> From: "Camus Chan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, October 21, 2002 2:29 PM
> Subject: RE: [JBoss-user] Running out of connections
> 
> 
> > For BMP:
> >
> > I set the connection through:
> >
> >   private Connection getDBConnection() throws SQLException,
> RemoteException
> > {
> >       Connection con = null;
> >       try{
> >                         InitialContext iCtx = new InitialContext();
> >                         DataSource ds = (DataSource)iCtx.lookup
> > ("java:/OracleDS");
> >                         con = ds.getConnection();
> >                 } catch(Exception e) {
> >                         System.out.println("getDBConnection : " +
> > e.toString());
> >                 }
> >
> >                 return con;
> >         }
> >
> >    public void setEntityContext(EntityContext ctx) {
> >         //System.out.println ("====== start setEntityContext ");
> >         context = ctx;
> >                 try {
> >                 conn = getDBConnection();
> >                 } catch(SQLException se) {
> >                         System.out.print("SQLException Found : " +
> > se.toString());
> >                 } catch(RemoteException re) {
> >                         System.out.print("RemoteException Found : " +
> > re.toString());
> >                 }
> >     }
> >
> >     public void unsetEntityContext() {
> >         System.out.println ("====== start unsetEntityContext ");
> >         context = null;
> >     }
> >
> > In every ejbFindxxx method, I have, e.g.:
> > public ArrayList ejbFindByDate(String d) {
> >     try {
> >       .....
> >    }
> >    catch(Exception e) {...}
> >    finally {
> >       if(conn!=null)
> >         conn.close() ;
> >    }
> >
> > }
> >
> >
> >
> > Is that the proper way to do open / close connection getting from the
> > connection pool for a BMP ?
> >
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:jboss-user-admin@;lists.sourceforge.net]On Behalf Of Dmitri
> Colebatch
> > Sent: Monday, October 21, 2002 11:44 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [JBoss-user] Running out of connections
> >
> >
> > > Could you kindly tell me which configuration files and parameters
> which
> > are
> > > related to the pool as I am afraid that if I am missing some of them
> ?
> One
> > > more is that the status is marked *INACTIVE* and logon_time was
> lasted
> for
> > > over 24-hour (in v$session),  and *ESTABLISHED* when using "netstat
> -an
> |
> > > grep 1521".
> >
> > do you open connections yourself?  This suggests to me that there are
> > connections not being closed.  Make sure that you always close your
> > connections inside a finally block.
> >
> > hth
> > dim
> >
> > >
> > > Sorry, I don't know anything about the testsuite. Where could I have
> it
> ?
> > >
> > > Thanks,
> > > Camus
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:jboss-user-admin@;lists.sourceforge.net]On Behalf Of David
> Jencks
> > > Sent: Monday, October 21, 2002 10:18 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: [JBoss-user] Running out of connections
> > >
> > >
> > > Sorry, I am highly sceptical of these problems.  I think if there
> were a
> > > problem in jboss the testsuite wouldn't run.
> > >
> > > What is different between your setup and the testsuite setup?
> > >
> > > david jencks
> > >
> > > On 2002.10.20 22:10:53 -0400 Camus Chan wrote:
> > > > 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
> >
> >
> >
> > -------------------------------------------------------
> > 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:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 
> 
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future 
> of  Java(TM) technology. Join the Java Community 
> Process(SM) (JCP(SM)) program now. 
> http://ad.doubleclick.net/clk;4699841;7576298;k?http://www.sun.com/javavote
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 


-------------------------------------------------------
This sf.net emial is sponsored by: Influence the future of 
Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) 
program now. http://ad.doubleclick.net/clk;4699841;7576301;v?
http://www.sun.com/javavote
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to