Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Failure to aquire connection during prepareStatement() call in bean managed entity bean

0 views
Skip to first unread message

Angela

unread,
Nov 19, 2001, 2:05:02 PM11/19/01
to
This is happening on Weblogic 6.1 SP1 wiht Oracle or Sybase.

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(..)

Sree Bodapati

unread,
Nov 19, 2001, 2:30:23 PM11/19/01
to
Try to setup a Testable, RefreshMinutes and TestConnsOnReserve, if these are
already done then, try increasing the number connections in the pool.

hth
/
sree

"Angela" <angela...@stercomm.com> wrote in message
news:3bf9579c$1...@newsgroups.bea.com...

Mike Reiche

unread,
Nov 19, 2001, 6:47:09 PM11/19/01
to

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

0 new messages