Re: Orion hangs when connections exhausted.
just to get the obvious things out of the way first, are you calling connection.close() prior to the EJB method returning? doing this in a finally block is a good idea. - Original Message - From: Milton S [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 5:36 AM Subject: Orion hangs when connections exhausted. Has anyone experienced Orion hanging when all of the available connections from the pool are exhausted? I noticed a similar question posted by Joel Shellman back in August of 2000 but there was no response to his question. I can re-issue the same URL from a browser multiple times and once the application has taken the last pooled connection it hangs and never returns. Orion never lets go of the connection even after waiting for over an hour. Only way to get Orion working again is to boot. Connections are not being made in an EJB but in regular java classes that are called from a stateless session bean. My application is to be deployed on an Intranet and I expect the traffic to be minimal so a work around is to set up the connection pool with a large enough number of connections so that they are never used up, but Orion shouldn't be hanging. Is this an Orion problem or am I missing something in the data-sources.xml file? Thanks for any help. Milton S. I am running Orion 1.5.2 on NT 2000 Professional against an Oracle 8i database on NT 4.0 server using the Oracle Thin JDBC driver. Here is the data-source I am using: data-source class=com.evermind.sql.DriverManagerDataSource name=jdbc/PWOW_OracleCoreDS location=jdbc/PWOW_OracleCoreDS pooled-location=jdbc/PWOW_OraclePooledDS xa-location=jdbc/xa/PWOW_OracleXaDS ejb-location=jdbc/PWOW_OracleEjbDS connection-driver=oracle.jdbc.driver.OracleDriver min-connections=5 max-connections=10 username=uid password=pwd url=jdbc:oracle:thin:@server:1521:sid inactivity-timeout=10 connection-retry-interval=10 wait-timeout=300 /
Re: Orion hangs when connections exhausted.
And the obvious answer is yes. Greg Matthews wrote: just to get the obvious things out of the way first, are you calling connection.close() prior to the EJB method returning? doing this in a finally block is a good idea. - Original Message - From: Milton S [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 5:36 AM Subject: Orion hangs when connections exhausted. Has anyone experienced Orion hanging when all of the available connections from the pool are exhausted? I noticed a similar question posted by Joel Shellman back in August of 2000 but there was no response to his question. I can re-issue the same URL from a browser multiple times and once the application has taken the last pooled connection it hangs and never returns. Orion never lets go of the connection even after waiting for over an hour. Only way to get Orion working again is to boot. Connections are not being made in an EJB but in regular java classes that are called from a stateless session bean. My application is to be deployed on an Intranet and I expect the traffic to be minimal so a work around is to set up the connection pool with a large enough number of connections so that they are never used up, but Orion shouldn't be hanging. Is this an Orion problem or am I missing something in the data-sources.xml file? Thanks for any help. Milton S. I am running Orion 1.5.2 on NT 2000 Professional against an Oracle 8i database on NT 4.0 server using the Oracle Thin JDBC driver. Here is the data-source I am using: data-source class=com.evermind.sql.DriverManagerDataSource name=jdbc/PWOW_OracleCoreDS location=jdbc/PWOW_OracleCoreDS pooled-location=jdbc/PWOW_OraclePooledDS xa-location=jdbc/xa/PWOW_OracleXaDS ejb-location=jdbc/PWOW_OracleEjbDS connection-driver=oracle.jdbc.driver.OracleDriver min-connections=5 max-connections=10 username=uid password=pwd url=jdbc:oracle:thin:@server:1521:sid inactivity-timeout=10 connection-retry-interval=10 wait-timeout=300 /
