Re: ConnectionProxy is closed

[Jason Mihalick]

I have seen this message from WAS 5.0 when attempting to use a broker 
whose database connection has been closed via a prior call to 
PersistenceBroker.serviceConnectionManager().releaseConnection() 
(assuming you first called getConnection() ).  I learned that it's best 
not to call releaseConnection() AT ALL since it really DOES release the 
connection back to the connection pool and if the connection pool has 
actually closed the connection, you can get the message you describe. 
Does this sound possible for your problem?

--
Jason
Matthias Roth wrote:

Hi,
I trie to use datasources on websphere 5.0.
I get every time the following error message if ojb try to
Get some data:
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: class
com.ibm.ejs.cm.proxy.ConnectionProxy is closed
[06.09.03 16:30:04:378 GMT+01:00]  4bfa5f2 SystemErr     R
com.ibm.websphere.ce.cm.StaleConnectionException: class
com.ibm.ejs.cm.proxy.ConnectionProxy is closed
[06.09.03 16:30:04:378 GMT+01:00]  4bfa5f2 SystemErr     R at
com.ibm.ejs.cm.proxy.ConnectionProxy.prepareStatement(ConnectionProxy.java:3
81)
[06.09.03 16:30:04:378 GMT+01:00]  4bfa5f2 SystemErr     R at
org.apache.ojb.broker.util.WrappedConnection.prepareStatement(WrappedConnect
ion.java:205)
my repository.xml settings:
<jdbc-connection-descriptor
     jcd-alias="MyDB"
     default-connection="true"
     jndi-datasource-name="jdbc/ds2"
     platform="Db2"
     jdbc-level="2.0"
     driver="COM.ibm.db2.jdbc.app.DB2Driver"
     protocol="jdbc"
     subprotocol="db2"
     dbalias="AVAMPROT"
     username="db2admin"
     password="db2admin"
     batch-mode="false"
   useAutoCommit="0"
   ignoreAutoCommitExceptions="false"
 

Thanks for your help

Regards
Matthias Roth
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]