Type 2: Drivers that are written partly in the Java programming language and partly in native code. Consider using this only if your DBMS does not offer a Java-only JDBC driver. Note: The JDBC-ODBC Bridge should be considered a transitional solution.

The JDBC-ODBC Bridge is an example of a Type 1 driver.

Drivers of this type are generally dependent on a native library, which limits their portability. Type 1: Drivers that implement the JDBC API as a mapping to another data access API, such as ODBC (Open Database Connectivity). These implementations are categorized as follows: There are many possible implementations of JDBC drivers. If you are using MySQL, install the latest version of the JDBC driver for MySQL, Connector/J.Ĭontact the vendor of your database to obtain a JDBC driver for your DBMS. If you are using Java DB, it already comes with a JDBC driver. Install a JDBC driver from the vendor of your database Note that if you are using another DBMS, you might have to alter the code of the tutorial samples. If you would like to use Java DB, then download the latest version from The Apache DB Project. Java DB was a rebranding of Apache Derby.

Note: Java DB is no longer included in recent versions of the JDK. This tutorial has been tested for the following DBMS: Install your database management system (DBMS) if needed Install the latest version of the Java SE SDK on your computer.Įnsure that the full directory path of the Java SE SDK bin directory is in your PATH environment variable so that you can run the Java compiler and the Java application launcher from any directory. Install the latest version of the Java SE SDK on your computer

Create databases, tables, and populate tables.

Install a JDBC driver from the vendor of your database.

Install your database management system (DBMS) if needed.

Install the latest version of the Java SE SDK on your computer.

The following steps configure a JDBC development environment with which you can compile and run the tutorial samples: The sample code that comes with this tutorial creates a database that is used by a proprietor of a small coffee house called The Coffee Break, where coffee beans are sold by the pound and brewed coffee is sold by the cup.

Install java8