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:314)
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
