It could be that the open_cursors parameter is set to a very low number in init
It could be that even if you are closing the result set you are not closing the SQL statements in your JAVA code.
3. Please ensure that your Enable Connection Pooling if set to yes (for performance reason), is set to no.
Please have your DBA monitor the database and ask to see entries using V$OPEN_CURSORS and V$SYSSTAT data dictionary views.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.