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.
