Hi,

I am using Hibernate 2.0.3. I am fetching some records from oracle9i database. And after some time i get an error as maximum open cursors exceeded.
Here is the code :
Query q =
session.createQuery("from UserRoles as userRoles where userRoles._userId = ?");
q.setString(0, userName);
Iterator userRolesIter = q.iterate();
while (userRolesIter.hasNext()) {
userRoles = (UserRoles) userRolesIter.next();
role = getRole(userRoles.get_roleId(), session);
}
session.close();
In all the methods i close session in the end. Is there anything else to be done. In Session API it states that close() method closes JDBC connection and cleans up.
Please help.

Rajan

This is actually in the FAQ, but I admit that the FAQ isn't very clear.

http://www.hibernate.org/117.html#A11

The Oracle JDBC driver doesn't like prepared statement caching very much. Disable the prepared statement cache in whatever connection pool you are using.

How to disable the statement caching in oracle pleeaasse ?? I can't do it...

Is this by code, or in the hibernate config file ?

Thank you ! =)

I think you have to disable the caching in the hibernate.cfg.xml. I'm having the same problem here. Add this property to disable preparedStatement caching : hibernate.statement_cache.size=0

This is only for the builtin pool which should not be used anyways. Look at the javadoc for net.sf.hibernate.cfg.Environment all config parameters are listed and explained there.

Really Thank you all...

=)