We have a legacy JSP + Hibernate based application which is running on WAS 7 & Oracle 10g.

At present the application is using Hibrenate 3.1 and ojdbc4.jar

Our task is to make this application work with Oracle 11.

The moment we switch the connection string in hibernate_cfg.xml to Oracle 11 the application runs fine for few minutes and the we get the ORA-01000: maximum open cursors exceeded error.

After some search we upgraded the Hibernate to 3.2.0 & ojdbc6.jar (Oracle 11g jdbc dirvers)

End result is the same. We still get this error. So next steps we did was to disable the prepared statements as described here https://community.jboss.org/wiki/HibernateFAQ-PlatformSpecificIssues?_sscc=t#After_a_while_Oracle_throws_this_exception_too_many_open_cursors

End result is still the same within few minutes after restart of the WAS, the ORA-1000 error appears.

We don't use any connection pooling. We have checked with the DB admin and he said the max allowed cursors are 3200. DBAdmin mentioned that he will not increase the cursor size beyond 3200

I agree there are some bad db logic code in JSP but that cannot be corrected since we don't have any expert nor the money to do that

Also most of the queries in the JSP are select statements called via session.createSQLQuery()

Do you guys know any other ways to stop this? I am not expert in these technologies but I have to help the team to move forward with this