Hi, could anyone please tell from where can I download new JDBC driver that support concurrency and many other advance features such as scrolling resultset. what are the steps (ie setting of path and classpath)to be followed for its installation and execution with Java platform - Java 2 StdEdition v 1.2.1 web server - tomcat Database -MSAccess OS -WIN98 and WIN NT I would appreciate your help Thanks
isn't this a contradiction? "support concurrency and many other advance features" & "MSAccess" if you are limited to MSAccess and you want a free driver, I only know of the jdbc dbc bridge packaged with your jdk. This is only as advanced as the underlying odbc installed on the users PC. In fact it is very limited, and basic as opposed to advanced(more info on jdbc dbc here http://java.sun.com/products/jdbc/faq.html ). If your willing to fork out some cash, then you have more options: http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html but even with the purchased drivers, Access itself is limited. Maybe if you could define what you need in "advanced features" we could better help you.
Joined: Dec 06, 2001
The advanced features that I meant are additional methods (compared to jdk 1.1 docs)included in interface ResultSet of java.sql package in jdk 1.2 documentation . If my knowledge is correct inorder to make use of that I will have to download J2SE 1.4 beta version consisting of jdbc-odbc driver having both java.sql and javax.sql package or buy JDBC driver for MSAccess. Thanks for your response.