Jump to content
We've recently updated our Privacy Statement, available here ×

SQLRecoverableException when fill big report


hostdjango

Recommended Posts

Hallo!
I use jasperreports-6.2.0.jar; oracle 11, tomcat 8, jdbc.

It is works for small report.

But i try fill big report (about 1200 rows) i get SQLRecoverableException.

for example: 

 java.sql.SQLRecoverableException: closed connection: next
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:247)
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:118)
 
java.sql.SQLRecoverableException: closed statement: getMetaData
!!! controller encountered error:
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:168)

 

I try set net.sf.jasperreports.jdbc.holdability=hold and close, set fetch.size = 10000, now my properties:

net.sf.jasperreports.governor.max.pages.enabled=true
net.sf.jasperreports.governor.timeout.enabled=true
net.sf.jasperreports.jdbc.concurrency=readOnly
net.sf.jasperreports.jdbc.fetch.size=-2147483648
net.sf.jasperreports.jdbc.holdability=hold
net.sf.jasperreports.jdbc.result.set.type=forwardOnly

but I think there is a problem in another
 
Help me please.
Link to comment
Share on other sites

  • Replies 2
  • 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...