JDBC Info

What is JDBC?

JDBC (Java Database Connectivity) is the method that Java uses to connect to databases.

The main page on JDBC: http://java.sun.com/products/jdbc/overview.html
The list of JDBC features: http://java.sun.com/products/jdbc/features.html
Wikipedia on JDBC: http://en.wikipedia.org/wiki/JDBC

Weaknesses of JDBC

  • The developer needs to deal with lot of plumbing and infrastructure, such as endless try-catch-finally-try-catch blocks.
  • Applications need complex error handling to ensure that connections are properly closed after they're used, which makes the code verbose, bloated, and repetitive.
  • JDBC uses the rather uninformative SQLException.
  • JDBC has no exception hierarchy.