[ http://issues.apache.org/jira/browse/BEEHIVE-435?page=history ] Nathan Jantz closed BEEHIVE-435: --------------------------------
I've verified this fix by iterating through ResultSets from Pointbase using Data Grids and is now working. > ResultSetIterator isLast method throws exception on Derby > --------------------------------------------------------- > > Key: BEEHIVE-435 > URL: http://issues.apache.org/jira/browse/BEEHIVE-435 > Project: Beehive > Type: Bug > Components: NetUI > Versions: V1Beta > Reporter: Scott Semyan > Assignee: Nathan Jantz > Fix For: V1Beta > Attachments: controls.zip > > I have two DB controls executing code that is exactly the same on Derby and > PostgreSQL. The PostgreSQL DB control connects to the data source via JINI: > @JdbcControl.ConnectionDataSource(jndiName="java:comp/env/jdbc/TestDB") > The resource is listed in my Tomcat config file. > My Derby control has this connection string: > @JdbcControl.ConnectionDriver(databaseDriverClass="org.apache.derby.jdbc.EmbeddedDriver", > databaseURL="jdbc:derby:d:/Proj/Beehive_projects/Westside/data/testdb") > This code runs fine with the PostgreSQL control but fails here with the Derby > control: > [/Westside] Unhandled exception caught in shared flow shared.SharedFlow: > java.lang.RuntimeException: An exception occurred reading from the Iterator. > Cause: SQL Exception: The 'isLast' method is only allowed on scroll cursors. > at > org.apache.beehive.netui.util.iterator.ResultSetIterator.hasNext(ResultSetIterator.java:79) > at > org.apache.beehive.netui.databinding.datagrid.runtime.util.PagedDataSet.<init>(PagedDataSet.java:58) > at > org.apache.beehive.netui.tags.databinding.datagrid.DataGrid.doTag(DataGrid.java:155) > at > org.apache.jsp.list_jsp._jspx_meth_netui$1data_dataGrid_0(list_jsp.java:191) > at > org.apache.jsp.list_jsp._jspx_meth_netui$1template_section_0(list_jsp.java:161) > at > org.apache.jsp.list_jsp._jspx_meth_netui$1template_template_0(list_jsp.java:105) > at org.apache.jsp.list_jsp._jspService(list_jsp.java:65) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) > at > org.apache.beehive.netui.pageflow.PageFlowPageFilter.runPage(PageFlowPageFilter.java:283) > at > org.apache.beehive.netui.pageflow.PageFlowPageFilter.doFilter(PageFlowPageFilter.java:208) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) > at > org.apache.beehive.netui.pageflow.internal.DefaultForwardRedirectHandler.forward(DefaultForwardRedirectHandler.java:125) > at > org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.doForward(PageFlowRequestProcessor.java:1749) > at > org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processForwardConfig(PageFlowRequestProcessor.java:1623) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:231) > at > org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:593) > at > org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:854) > at > org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:602) > at > org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:155) > at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) > at java.lang.Thread.run(Unknown Source) > Caused by: SQL Exception: The 'isLast' method is only allowed on scroll > cursors. > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java) > at > org.apache.derby.impl.jdbc.EmbedResultSet20.checkScrollCursor(EmbedResultSet20.java) > at > org.apache.derby.impl.jdbc.EmbedResultSet20.checkRowPosition(EmbedResultSet20.java) > at > org.apache.derby.impl.jdbc.EmbedResultSet20.isLast(EmbedResultSet20.java) > at > org.apache.beehive.netui.util.iterator.ResultSetIterator.hasNext(ResultSetIterator.java:75) > ... 57 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
