Java Database Connectivity (JDBC) examples. SQL with Java.
JDBC driver type 2 -- the native-API/partly Java driver -- converts JDBC calls into database-specific calls for databases such as SQL Server, Informix, Oracle, or Sybase. The type 2 driver communicates directly with the database server; therefore it requires that some binary code be present on the client machine. Pros
Type 2 drivers typically offer significantly better performance than the JDBC-ODBC Bridge. Cons
The vendor database library needs to be