RE: [JBoss-user] Running out of connections

2002-10-20 Thread Camus Chan
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:/

Re: [JBoss-user] Running out of connections

2002-10-20 Thread Dmitri Colebatch
> 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 "netst

RE: [JBoss-user] Running out of connections

2002-10-20 Thread Camus Chan
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 Messag

[JBoss-user] RE: Running out of connections

2002-10-20 Thread Camus Chan
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: max

Re: [JBoss-user] Running out of connections

2002-10-20 Thread David Jencks
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, Oracle

[JBoss-user] Running out of connections

2002-10-20 Thread Camus Chan
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 no

Re: [JBoss-user] Deployment Exception on Branch_3_2 From Today

2002-10-20 Thread Scott M Stark
Resynch and try again. Scott Stark Chief Technology Officer JBoss Group, LLC - Original Message - From: "Hunter Hillegas" <[EMAIL PROTECTED]> To: "JBoss User" <[EMAIL PROTECTED]> Sent: Sunday, October 20, 2002 4:41 PM Subject: [JBoss-user