-
Java and DB's
hi
i'm quite good at java, and really like the language...i'm wondering how i'd get some databse connectivity going??
i've used VB and access a lot, i'm wondering if i can do the same database stuff i can with VB
or what db can i connect java to...easily and with mostly everything from vb and access...
thanx
--770
-
You can use JDBC, same idea as ODBC. You can connect to any database that has a JDBC driver, Access should not be a problem
-
Actually Access IS a problem because MS doesn't provide JDBC drivers for their DBs. You can use 3rd party drivers or the JDBC-ODBC bridge and the Jet ODBC driver.
-
Yes CornedBee is correct. Sun says the following......
"Most ODBC 2.0 drivers should work with the Bridge. Since there is some variation in functionality between ODBC drivers, the functionality of the bridge may be affected. The bridge works with popular PC databases, such as Microsoft Access and FoxPro."
Im assuming by this statement that is would be better to get a specific driver rather than use the JDBC-ODBC bridge.
Here is the main page for the JDBC Data Access API technology.
http://java.sun.com/products/jdbc/
Here is Suns look up page to find JDBC drivers for various Data Bases. http://servlet.java.sun.com/products/jdbc/drivers