> 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 ?
not 100% sure what you're observing. But I'm guessing the connection is still in the connection pool, and after a few minutes the connection pool closes the connection because it is not required. I'm sure if you have a look at the connection pool configuration you will be able to tune this area of it. cheers dim > > 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;7576298;k?http://www.sun.com/javavote _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
