Getting a connection from the weblogic jdbc connection pool - and call
connection.prepareStatement(..) - Works fine for a while, after certain
amount of calls starts failing. Note - connection is being released back to
the pool as well as prepared statements are being closed.
Start server side stack trace:
java.sql.SQLException: Cannot obtain connection after 0 seconds. , Exception
= None available
at
weblogic.jdbc.jts.Connection.wrapAndThrowSQLException(Connection.java:639)
at weblogic.jdbc.jts.Connection.getOrCreateConnection(Connection.java:565)
at weblogic.jdbc.jts.Connection.prepareStatement(Connection.java:115)
at
weblogic.jdbc.rmi.internal.ConnectionImpl.prepareStatement(ConnectionImpl.ja
va:135)
at
weblogic.jdbc.rmi.SerialConnection.prepareStatement(SerialConnection.java:76
)
at RoleEJBBean.ejbFindAllRoles(RoleEJBBean.java:478) - this is where I call
conn.prepareStatement(..)
hth
/
sree
"Angela" <angela...@stercomm.com> wrote in message
news:3bf9579c$1...@newsgroups.bea.com...
Use the console to verify that the connections are going back in the pool. Releasing
resources in a 'finally' block is the best approach.
Mike