Supported JDBC driver type

The JDBC data sources can use any of the four types of JDBC drivers:

Type 1: JDBC-ODBC Bridge

Type 2: Native-API/partly Java driver

Type 3: Net-protocol/all-Java driver

Type 4: Native-protocol/all-Java driver

Each type has advantages and disadvantages. You should run tests to decide which type of JDBC driver works the best for the specific application and database. Generally, Type 3 and Type 4 drivers show better performance than Type 2 drivers, so it is recommended that you evaluate Type 3 or Type 4 for both intranet and Internet deployments. Because of performance considerations, Type 2 drivers should only be used in an intranet environment where response times are generally faster.