wood burning stoves 2.0*
The moose likes JDBC and the fly likes Use next,Previous, last and first in the resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Use next,Previous, last and first in the resultset" Watch "Use next,Previous, last and first in the resultset" New topic
Author

Use next,Previous, last and first in the resultset

Jaya Cheruvu
Greenhorn

Joined: Jul 06, 2000
Posts: 2
I created an applet in IBM Visual Age. I could get connected to Access database and retrieve the results. But I am not able to use the previous,last etc.. methods to browse through the recordset. I did go through all the answers in this site and understand that it could be because of the version incompatibility of Access driver and jdbc-odbc driver that I am using.
I do not know which driver to update?
Could anyone help me ?
Milind Kulkarni
Ranch Hand

Joined: Jun 01, 2000
Posts: 146
Hi,
The existing driver documentation would have all the information about the driver and the functions it can perform. Check if the vendor has come out with any updates or install a new driver. You can get all the driver information here -
http://industry.java.sun.com/products/jdbc/drivers
Regards,
Milind
Jaya Cheruvu
Greenhorn

Joined: Jul 06, 2000
Posts: 2
Thank you very much for your info.
But to my understanding jdbc-odbc driver is compatible to all database drivers except it is a little slow.
Do I need to update the jdbc-odbc driver?
I did not specifically downloaded any jdbc-odbc driver as it comes with default with the installation of jdk. My Visual Age 3.0 uses JDK 1.1.7A.
Milind Kulkarni
Ranch Hand

Joined: Jun 01, 2000
Posts: 146
Hi,
Sun does not recommend the use of ODBC-JDBC bridge for real applications. It says that you should use the JDBC-ODBC Bridge only for experimental prototyping or when you have no other driver available. Desktop databases such as MS Access still require the use of JDBC-ODBC bridge. This is because the vendors of these database products haven't implemented all-Java JDBC drivers.
Check out the URL for more information -
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
Regards,
Milind

Amit Zzz Kulkarni
Ranch Hand

Joined: Jul 05, 2000
Posts: 30
AFAIK for Oracle and Sybase, the scrollability of the ResultSet is not provided at the actual database level,it is implemented by the JDBC driver itself ,it caches that in a Statement
For Oracle specific enhancement look at this page at the last http://oradoc.photo.net/ora816/java.816/a81354/resltse1.htm
So if your Driver doesn't support it you can't use it.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Use next,Previous, last and first in the resultset