Connection Exception in JasperReport

2006 IR Open Discussion · August 18, 2006

By: ryanwu - ryanwu

2003-04-15 01:42

Hi Teodor..

I find a problem like japserreport bug...

When I use JDBC direct connect to DB2...

the Japserreport reder PDF is so smooth..

but I deploy to Webphere and use JNDI to look a

Datasource to get a Connection...

and pass the Connection to JasperRunManager

I got Exception...

COM.ibm.db2.jdbc.DB2Exception: [iBM][CLI Driver] CLI0125E Function sequence error.SQLSTATE=HY010

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:260)

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:197)

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:448)

at COM.ibm.db2.jdbc.app.DB2ResultSet.next(DB2ResultSet.java:487)

at com.ibm.ejs.cm.proxy.ResultSetProxy.next(ResultSetProxy.java:511)

at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:112)

at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:700)

at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:162)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:464)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:157)

at dori.jasper.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:164)

at servlets.MainPDFServlet.doGet(MainPDFServlet.java:247)

at servlets.MainPDFServlet.doPost(MainPDFServlet.java:101)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:159)

at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:286)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:106)

at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)

at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)

at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:499)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:278)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:105)

at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:67)

at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:123)

at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)

at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)

at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)

at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)

at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:313)

at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:242)

at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

NESTED BY :

dori.jasper.engine.JRException: Unable to get next record.

at dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:116)