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"
> />
>
>
>
>
