8.1. What is JDBC ?

JDBC is a specification and API that Java applications can use to interact with a relational database or other tabular data source. Using JDBC, Java platform classes can execute queries and examine the results, update data, and control transactions.

The JDBC API, like Microsoft’s ODBC, is based on the x/open ‘call-level interface’ (CLI) for database drivers. Most developers who have used database connectivity libraries will find the principles of JDBC quite familiar.

A key design element of JDBC was that it should be vendor-independent. However, because the starting point for most JDBC operations is the execution of an SQL query, and SQL dialects vary considerably from vendor to vendor, this independence can be difficult ...

Get Applied Enterprise JavaBeans™ Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.