SCROLLABLE RESULTSET PROBLEM

[Terence Doyle]

HI,
I've got a problem getting my resultset to be scrollable.
I'm using Tomcat 4.0, MySQL, on W98.
All other stuff seems to work( up to my poor sql level anyway).
This is the line that causes runtime (not compiler) error:
Statement s = DBConx.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_UPDATABLE ) ;
The code is fine - I copied it from the Resultset documentation!
Any ideas? Perhaps MySQL doesn't support scrollable results? If not what free db can I use?
Thanks,
Terry

[Jamie Robertson]

just to clarify an issue, it is not the database that dictates whether a resultset can be scrollable or not, it is the jdbc driver which determines that. If you are using the type 4 driver to access the mySQL db, then you shouldn't have any problems. If you are using the jdbc dbc bridge, then you will have problems no matter which database you use.
So my question is which driver are you using? Is it throwing a SQLException? If so, which one?
Jamie

[Terence Doyle]

HI,
This is the driver code:

Class.forName( "org.gjt.mm.mysql.Driver" ) ; 
DBConx = DriverManager.getConnection("jdbc:mysql://:3306/knowledgebase" , "" , "" )

I'm sure the documentation for the driver says its a class 4 driver.
The error message in the errorPage is this

java.lang.AbstractMethodError
at terry.ConxBean.doQuery(ConxBean.java:29)
at org.apache.jsp.query2$jsp._jspService(query2$jsp.java:121)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:215)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1005)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098)
at java.lang.Thread.run(Unknown Source)

Hope that will help you help me.
Thanks,
Terry

[Jamie Robertson]

I guess you may be right. Check to make sure you have the latest release of the jdbc driver at http://mmmysql.sourceforge.net/ . If the error still persists
I guess your out of luck. Unfortunately I don't use mySQL so I can't recommend a driver for you that supports scrollable resultsets for mySQL databases.
Jamie