We help IT Professionals succeed at work.

Open Cursors in Websphere

selvarajb
selvarajb asked
on
654 Views
Last Modified: 2013-12-10
Hi,

The issue is that the application sometimes barfs out an exception Saying "Maximum Open Cursors exceeded". I am using WAS4.0.3 with Oracle 9.0.1 and the Oracle Thin Driver.

Oracle documents and other web forums advise to close all Statements, Connections and Resultsets. I have checked my code thoroughly and am very sure that I have closed all the database resources.
Is there something else I need to do?

Thanks,
Raj

Comment
Watch Question

Commented:
Are you using Datasources? if you are make sure that the maximum connection pool size is less than than the maximum number of open cursors allowed by the db.
And just make sure that you have finally blocks where you close your db resources because it might be you only close them if everything goes well rather than if there's an exception?

Author

Commented:
I am in fact, closing all resources in the finally block. and the maximum connection pool size is less than the maximum number of open cursors. In fact, we bumped up the max_open_cursors variable to 700 and still this exception gets thrown after a week or so of running the app. Is there any way to actually remove and destroy a connection from the pool after say, 4 days or so.? I heard Weblogic does that...

Thanks,
Raj
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Try this link for more information...

http://www.javaworld.com/javaworld/jw-04-2002/jw-0412-aspect3_p.html


Regards,
Muruga

Try this link for more information...

http://www.javaworld.com/javaworld/jw-04-2002/jw-0412-aspect3_p.html


Regards,
Muruga

Commented:
what about your statement cache size in the datasource?  I believe each cached statement uses a cursor.  Also, I believe that the connections do get removed from the pool after the interval specified in "idle timeout", as long as you don't have "minimum pool size" > 0.  The pool will never go below that number.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.