Bernd, Thanks for the test. I'm using hsqldb 1.7.3 (so maybe it's a cursor bug that was fixed in 8). I'm currently struggling with the upgrade to 1.8 because it won't read a 1.7.3 database, without hacking.
John -----Original Message----- From: Bernd Bohmann [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:23 PM To: MyFaces Discussion Subject: Re: Response to Volker - RE: Scrollable ResultSet being passed to Tobago Sheet - errors as 'Forward Only' This works for me with 1.8.0.1: Class.forName("org.hsqldb.jdbcDriver" ).newInstance(); Connection conn = DriverManager.getConnection("jdbc:hsqldb:mem:aname", "sa", ""); .... Statement query = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); resultSet = query.executeQuery("select * from solarObject"); Regards Bernd John schrieb: > Hi Volker, > > Thanks for the update. > In the meantime I'll try to put together a simpler test app without > the Tobago stuff, to test the datatable with an hsqldb cursor. > > Regards, > > John > > -----Original Message----- > From: Volker Weber [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 21, 2006 9:38 AM > To: MyFaces Discussion > Subject: Re: Response to Volker - RE: Scrollable ResultSet being > passed to Tobago Sheet - errors as 'Forward Only' > > Hi John, > > i don't forgot you :-), i just can't say mutch so far, but this: > > You can't use a h:datatable in a tobago application, to test with > h:datatable you must setup a non tobago app. > > I don't understand the stacktrace, i don't think this is related to > using non tobago tags in tobago app, but this is also nothing with > 'Forward Only cursor'. > > Bernd is currently testing with differend databases, he will also test > with HSQLdb, hopefully he will find your problem. > > Regards, > Volker > > John wrote: > >>Volker, >> >>I put the h:dataTable tag right above the tobago sheet tag and this >>was the error >> >> >> >> An error occurred in the bean. Error Message is: Exception in JSP: >>/pageparts/quarantinelist.jsp:17 14: 15: 16: 17: 18: 19: 20: > > Stacktrace: > >>Stack Trace is : >>javax.faces.FacesException: Exception in JSP: >>/pageparts/quarantinelist.jsp:17 >> >>14: >>15: >>16: >>17: >>18: >>19: >>20: >> >> >>Stacktrace: >> at >>org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch >>(S >>ervletExternalContextImpl.java:421) >> at >>org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspVi >>ew >>HandlerImpl.java:228) >> at >>org.apache.myfaces.tobago.application.ViewHandlerImpl.renderView(ViewH >>an >>dlerImpl.java:322) >> at >>org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:2 >>99 >>) >> at >>javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli >>ca >>tionFilterChain.java:252) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi >>lt >>erChain.java:173) >> at >>org.apache.myfaces.tobago.webapp.TobagoMultipartFormdataFilter.doFilte >>r( >>TobagoMultipartFormdataFilter.java:81) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli >>ca >>tionFilterChain.java:202) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi >>lt >>erChain.java:173) >> at >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa >>lv >>e.java:213) >> at >>org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa >>lv >>e.java:178) >> at >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja >>va >>:126) >> at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja >>va >>:105) >> at >> > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > >>java:107) >> at >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java >>:1 >>48) >> at >>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: >>86 >>9) >> at >>org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.pr >>oc >>essConnection(Http11BaseProtocol.java:667) >> at >>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoi >>nt >>.java:527) >> at >>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFoll >>ow >>erWorkerThread.java:80) >> at >>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo >>ol >>.java:684) >> at java.lang.Thread.run(Unknown Source) Caused by: >>org.apache.jasper.JasperException: Exception in JSP: >>/pageparts/quarantinelist.jsp:17 >> >>14: >>15: >>16: >>17: >>18: >>19: >>20: >> >> >>Stacktrace: >> at >>org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServ >>le >>tWrapper.java:504) >> at >>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper. >>ja >>va:375) >> at >> > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:31 > 4) > >> at >>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli >>ca >>tionFilterChain.java:252) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi >>lt >>erChain.java:173) >> at >>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispa >>tc >>her.java:672) >> at >>org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicat >>io >>nDispatcher.java:463) >> at >>org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDi >>sp >>atcher.java:398) >> at >>org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDisp >>at >>cher.java:301) >> at >>org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch >>(S >>ervletExternalContextImpl.java:415) >> ... 21 more >> >> >> >> >>-----Original Message----- >>From: Volker Weber [mailto:[EMAIL PROTECTED] >>Sent: Monday, February 13, 2006 9:50 AM >>To: MyFaces Discussion >>Subject: Re: Scrollable ResultSet being passed to Tobago Sheet - >>errors as 'Forward Only' >> >>Hi, >> >>tobago did not access the resultSet directly, so the problem must be >>somewhere deeper. Did you use myfaces or RI impl? >>Can you check it the ResultSet works with plain jsf h:dataTable tag? >>Please post the stackTrace. >> >>Regards, >> Volker >> >>John wrote: >> >> >>>Using HSQLdb >>>Verified with HsqlDb team that my syntax is correct for creating a >>>scrollable ResultSet When I pass this Result Set to a Tobago sheet, I >>>get an exception from Tobago saying that it is a Forward Only cursor >>> >>>John >> >> >>-- >>Don't answer to From: address! >>Mail to this account are droped if not recieved via mailinglist. >>To contact me direct create the mail address by concatenating my >>forename to my senders domain. >> > > > -- > Don't answer to From: address! > Mail to this account are droped if not recieved via mailinglist. > To contact me direct create the mail address by concatenating my > forename to my senders domain. > > -- Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
