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-19 06:32

i am getting this ettor what changes should i do in my report javafile or xmlfile

 

please let me know in detail

 

Thanks in advance

 

 

 

 

By: Martin Phee - mphee

RE: maximum open cursors exceeded

2002-12-19 07:18

JRQueryExecuter:

Change the constructor to public.

Change executeQuery( Connection conn) to public.

Add a private PreparedStatement variable and change executeQuery to use it.

Add a finialize method and close the PreparedStatement in it.

 

JRBaseFiller:

Around line 350 remove the lines that get the ResultsSet.

Add a line that creates a new JRQueryExecuter passing it the paramaters from the line you commented out except for the Connection.

Add a line which calls executeQuery(Connection conn).

 

I also added a line after the rs.close() setting the JRQueryExecuter to null.

 

This seems to have solved the problem for me. We have run hundreds of reports now with no problems.

 

Marty

 

 

By: Pinkal Shukla - pinkal

RE: maximum open cursors exceeded

2002-12-19 07:26

i am changing the original source file and tell me in detail about the finalize method should i add new finalize method and is there any otherway so the source is not changed

 

please let me know

 

thanks a lot

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...