EDB Postgres Connectors → 9.5.1 → User Guides → JDBC Guide Other versions of this page: 11.0.3 · 11.0.2 · 11.0.1 · 10.0.3 · 10.0.2 · 10.0.1 · 10.0.0 · 9.6.0.3 · 9.6.0.2 · 9.5.1
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
Try it Now Free
2.1 JDBC Driver Types There are currently four different types of JDBC drivers, each with its own specific implementation, use and limitations. The Advanced Server JDBC Connector is a Type 4 driver. Type 1 Driver • This driver type is the JDBC-ODBC bridge. • It is limited to running locally. • Must have ODBC installed on computer. • Must have ODBC driver for specific database installed on computer. • Generally can’t run inside an applet because of Native Method calls. Type 2 Driver • This is the native database library driver. • Uses Native Database library on computer to access database. • Generally can’t run inside an applet because of Native Method calls. • Must have database library installed on client. Type 3 Driver • 100% Java Driver, no native methods. • Does not require pre-installation on client. • Can be downloaded and configured on-the-fly just like any Java class file. • Uses a proprietary protocol for talking with a middleware server. • Middleware server converts from proprietary calls to DBMS specific calls Type 4 Driver • 100% Java Driver, no native methods. • Does not require pre-installation on client. • Can be downloaded and configured on-the-fly just like any Java class file. • Unlike Type III driver, talks directly with the DBMS server. • Converts JDBC calls directly to database specific calls.