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 ?
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
Joined: Jul 06, 2000
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.
Joined: Jun 01, 2000
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
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.
subject: Use next,Previous, last and first in the resultset