maximum open cursors exceeded

[2006 IR Open Discussion]

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

 

Thanks

 

 

 

 

By: Teodor Danciu - teodord

RE: maximum open cursors exceeded

2002-12-26 04:28

 

Hi,

 

There is now a patch available for this here:

 

http://sourceforge.net/tracker/index.php?func=detail&aid=658652&group_id=36382&atid=416705

 

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

 

Thank you,

Teodor

 

 

 

 

 

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,

Ivan