Member Avatar for bencryer

What is JDBC? What are different types of JDBC drivers?

  • 3 Contributors
  • 2 Replies
  • 325 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by sachin khed

Dani AI

Generated

As already pointed out, JDBC is Java’s standard API for talking to relational databases. The practical bits that matter when choosing a driver are portability, performance, deployment complexity, and whether native client libraries are required. Ignore the lmgtfy redirect from — below is a concise, useful summary that fills in what the earlier posts leave implicit.

JDBC essentials: the API exposes Driver/DriverManager (or DataSource), Connection, Statement/PreparedStatement, and ResultSet. For modern apps prefer a DataSource plus a connection pool (faster, safer, easier to manage). Use PreparedStatement for parameter binding and to avoid SQL injection. Since JDBC 4, most drivers auto-register, so Class.forName(...) is usually unnecessary.

Driver types (practical view):

  • Type 1 — JDBC‑ODBC bridge: depends on the platform’s ODBC layer. Obsolete for production (the bridge was removed from the JDK in Java 8) and not recommended.
  • Type 2 — Native API driver: Java wrapper over a DB vendor native client (e.g., Oracle OCI). Good performance but platform-dependent and requires vendor client installation.
  • Type 3 — Network/proxy driver: pure Java client talks to a middleware server which then speaks the DB protocol. Useful when centralizing access, passing through firewalls, or supporting multiple DBs via one middleware.
  • Type 4 — Pure Java “thin” driver: implements DB protocol in Java. Portable, easiest to deploy, and generally the recommended choice for most applications.

Quick troubleshooting & recommendations: if you see ClassNotFoundException or “No suitable driver,” check that the correct driver JAR is on the classpath and the JDBC URL matches the driver. If native libs are missing, switch to a Type 4 driver. Always use try-with-resources for closing JDBC resources and prefer DataSource + pool in production.

Example (basic pattern):

try (Connection c = DriverManager.getConnection(url, user, pass);
     PreparedStatement ps = c.prepareStatement("SELECT id,name FROM person WHERE age > ?")) {
    ps.setInt(1, 21);
    try (ResultSet rs = ps.executeQuery()) {
        while (rs.next()) { /* process */ }
    }
}

Recommended Answers

All 2 Replies

Member Avatar for JamesCherrill

See this

commented: Why won't folk do this on their own? My only thought is it's a shill posting. +15
Member Avatar for sachin khed

JDBC stands for Java Database Connectivity. It is an Application Programming Interface (API) which helps to connect Java applications to external, relational database management systems (RDBMS).

JDBC API uses different JDBC drivers to connect with the database. The four types of JDBC drivers are:

• JDBC-ODBC Bridge Driver.
• Native-API Driver (Partially Java Driver).
• Network Protocol Driver (fully Java Driver).
• Thin Driver (fully Java Driver).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.