My answer: Unfortunately, you'll need a driver to connect to the database. The java.sql.* is made up of mainly interfaces(no implementation) which means that you can not use them. The drivers are used to implement these interfaces so that you can access the databases, query tables, and process the results. There is a jdbc-odbc bridge from Sun available to ODBC compliant databases...but it is not recommended(lots of headaches!)
Sun's answer: this is how Sun describes their own Bridge: "Note that we do not recommend using the Bridge except for experimental purposes or when you have no other driver available. " see the complete FAQ as it is insightful on the jdbc-odbc bridge as a odbc solution. http://java.sun.com/products/jdbc/faq.html#2 Jamie [This message has been edited by Jamie Robertson (edited August 14, 2001).]
For learning purposes, the JDBC-ODBC driver will do fine. Compared to other drivers, it is much slower. So to answer your question, you can use the JDBC-ODBC driver that comes with the JDK to connect to a database as long as it supports ODBC (most do). Good luck!
One will have to use the driver to access the database. As drivers are the layer between any database and the applications. The drivers will send commands from application and receive results from the database engine. This is true for any application java is no exception. Regards, Ashish Saraf
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com