hostdjango Posted January 22, 2016 Share Posted January 22, 2016 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: nextat 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=truenet.sf.jasperreports.governor.timeout.enabled=truenet.sf.jasperreports.jdbc.concurrency=readOnlynet.sf.jasperreports.jdbc.fetch.size=-2147483648net.sf.jasperreports.jdbc.holdability=holdnet.sf.jasperreports.jdbc.result.set.type=forwardOnlybut I think there is a problem in another Help me please. Link to comment Share on other sites More sharing options...
hostdjango Posted January 22, 2016 Author Share Posted January 22, 2016 I solved problem, when i began use DrimveManager.getConnection() instead DadaSource.getConnection().I am suprised. Why it is? Link to comment Share on other sites More sharing options...
hostdjango Posted January 22, 2016 Author Share Posted January 22, 2016 I understood. I found in tomcat this property "removeAbandonedTimeout="60" and jasperreports did not had time work with ResultSet. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now