JRResultSetDataSource problem

2006 IR Open Discussion · August 18, 2006

By: Charles McClain - cmcclain1

2003-04-19 07:24

I'm having difficulty passing a JRResultSetDataSource to my report and getting it to fill.

I create the JRResultSetDataSource in a bean, and store it as a session attribute, as follows:

String sql = new String("select CUST__T, CUST_NAME from CUSTOMER");

stmt = conn.prepareStatement(sql);

rs = stmt.executeQuery();

ds = new JRResultSetDataSource(rs);

session.setAttribute("QueryTestDataSource",ds);

.....and then try to use it in my JSP as follows:

JRResultSetDataSource ds = (JRResultSetDataSource) session.getAttribute("QueryTestDataSource");

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,ds);

I should note that I have a similar report which contains a SQL query, and a similar bean-JSP pair, which works flawlessly.

I have checked and double-checked my report definition file vs. my PreparedStatement, and both contain the same columns.

I also have debug writes to logs, and I can definitely see that the ResultSet from which Icreate the JRResultSetDataSource has about 30 rows. Also, I've written "ds" out to the log both in the bean and after I retrieve it from the HTTP session, and the signature is the same.

However, whatever I do, I get a "Unable to get next record" error when I run. What am I doing wrong?

By: Teodor Danciu - teodord

RE: JRResultSetDataSource problem

2003-04-21 01:58

Hi,

Can we see the entire exception stack trace,

not just the exception message?

Thank you,

Teodor

By: Charles McClain - cmcclain1

RE: JRResultSetDataSource problem

2003-04-21 04:46

Teodor:

Sure, although I'm not sure how helpful it will be -- not much info on the base exception, which was unhandled.

Since there doesn't seem to be a way to attach a file here, I guess I'll have to just copy it into this message; hope that is okay. Here goes:

Stack trace:

javax.servlet.ServletException: Unhandled exception caught in JSP service method: Unable to get next record.

at javax.servlet.ServletException.<init>(ServletException.java:107)

at pagecompile._RTS__HTML__Pages._customPages._QueryTest._en__US._html._pgQueryTestResponse_xjsp.performService(_pgQueryTestResponse_xjsp.java:190)

at com.rts.servlets.RTSBaseHttpServlet._jspService(RTSBaseHttpServlet.java:82)

at com.rts.servlets.RTSBaseHttpServlet.service(RTSBaseHttpServlet.java:1100)

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

at com.ibm.servlet.jsp.http.pagecompile.JSPState.service(JSPState.java:352)

at com.ibm.servlet.jsp.http.pagecompile.PageCompileServlet.doService(PageCompileServlet.java(Compiled Code))

at com.ibm.servlet.jsp.http.pagecompile.PageCompileServlet.doGet(PageCompileServlet.java:893)

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

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

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

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

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

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

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

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

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

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))

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

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

at com.rts.portal.servlets.JspRedirector.redirectLocalJsp(JspRedirector.java:1093)

at com.rts.portal.servlets.JspRedirector.redirectURL(JspRedirector.java:1251)

at com.rts.portal.servlets.JspRedirector.redirect(JspRedirector.java:982)

at com.rts.portal.servlets.JspRedirector.redirect(JspRedirector.java:944)

at com.rts.portal.servlets.JspRedirector.redirect(JspRedirector.java:891)

at com.rts.eAccess.framework.RequestHandler.sendPage(RequestHandler.java:3262)

at com.rts.eAccess.framework.RequestHandler.handleRequest(RequestHandler.java(Compiled Code))

at com.rts.eAccess.framework.RequestHandler.performService(RequestHandler.java:3019)

at com.rts.servlets.RTSBaseHttpServlet._jspService(RTSBaseHttpServlet.java:82)

at com.rts.servlets.RTSBaseHttpServlet.service(RTSBaseHttpServlet.java:1100)

at com.rts.eAccess.framework.RequestHandler.service(RequestHandler.java:3314)