aspose file tools*
The moose likes JDBC and the fly likes SCROLLABLE RESULTSET PROBLEM Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SCROLLABLE RESULTSET PROBLEM" Watch "SCROLLABLE RESULTSET PROBLEM" New topic
Author

SCROLLABLE RESULTSET PROBLEM

Terence Doyle
Ranch Hand

Joined: May 30, 2001
Posts: 328
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

Raising Flares debut album 'Ignition' out now

http://www.raisingflares.com

Terry Doyle <br />SCPJ 1.4 , SCWCD , SCMAD(Beta)
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
Ranch Hand

Joined: May 30, 2001
Posts: 328
HI,
This is the driver code:

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

Hope that will help you help me.
Thanks,
Terry
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
 
jQuery in Action, 2nd edition
 
subject: SCROLLABLE RESULTSET PROBLEM