Hi,
it's guaranteed that at the latest method call
PersistenceBroker#close()
release the used connection back to connection pool or close the used
connection - dependent on the used ConnectionFactory.
Are you sure that you never lookup connections directly from OJB and
close these connections by yourself or that you don't close used PB
instances?
More information about connection handling can be found here
http://db.apache.org/ojb/docu/guides/connection.html#Can+I+directly+obtain+a%0A++++++++++++++++
regards,
Armin
Jakob Braeuchi wrote:
------------------------------------------------------------------------
Subject:
Problem in Releasing Connection
From:
Sudhir Kumar <[EMAIL PROTECTED]>
Date:
Wed, 14 Sep 2005 14:56:27 -0600
To:
[EMAIL PROTECTED]
To:
[EMAIL PROTECTED]
Hi,
I am using OJB in our project. We are using oracle 10g as a
database.
I am using the following steps to retrieve/insert records
the data from the tables
PersistenceBroker broker =
PersistenceBrokerFactory.defaultPersistenceBroker();
broker.beginTransaction();
broker.insert(Object obj);
broker.commitTransaction();
broker.close();
We have a utility which runs on every 10 sec. and after few
minutes we are getting an error that “Unable to get object from
connection pool”
I suspect that by using this way the connection is not
released and it is not returning to pool.
Can u suggest me how to close the connection and return the
connection to pool.
Any help will be highly appreciated. Thanks for helping.
Thanks and regards,
Sudhir Kumar
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
