Jump to content
Changes to the Jaspersoft community edition download ×

maximum open cursors exceeded

Recommended Posts

By: Pinkal Shukla - pinkal

maximum open cursors exceeded

2002-12-20 10:36

i changed the JRQueryExecuter and JRBaseFiller ibut still i am not able to get the data from the subreport

pls. help







By: Teodor Danciu - teodord

RE: maximum open cursors exceeded

2002-12-26 04:28




There is now a patch available for this here:




Please try it and let me know if it worked in your case.


Thank you,







By: Ivan Biddles - ibiddles

RE: maximum open cursors exceeded

2003-08-13 12:15

Hi Teodor,


I am still seeing this problem on the 0.5.0 release (and the latest CVS is still the same), so I looked into it and found that there is still the potential for the problem, because there is no "finally" block in your code fix.


The scenario is that if an exception occurs at the JRQueryExecuter level, then the closing code will be completely bypassed, and connections will continue to be leaked.


The JRBaseFiller.fill method should have a try block around the JRQueryExecuter.executeQuery line down to the JasperPrint creation. Then the result set close try/catch should be inside a finally block that comes after that first try.


This will close all the holes.


Best wishes,


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...