POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!On 20 Apr 2006 08:10, bworwood wrote:

>POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
>PAGE!On 30 Dec 2003 17:06, dominikroblek wrote:

>>We are successfully using Hibernate with Oracle JDBC driver with
>>prepared statement cache enabled. We had to raise open cursor limit in
>>Oracle database as each cached prepared statement keeps one open
>cursor
>>on the database. Ask you DBA for assistance.

>I am having a similar problem - open cursors are not being cleared.
>Did you get over your issue?

I ran into the same problem when using DBCP connection provider in
Hibernate 2.1.2.  Traced into
net.sf.hibernate.connection.DBCPConnectionProvider, I found the
construction of statementPool didn't pass in maxTotal parameter, which
is used by GenericKeyedObjectPoolFactory to determine when to clear the
pool content. So the solutions can be either to pass in this parameter
or to disable statement pool by simply setting statemPool to null.  Both
work!