JDBC

Stands for "Java Database Connectivity." JDBC is an API that allows Java applications to connect to and query a wide range of databases. Examples include Java DB, Oracle, MySQL, PostgreSQL, DB2, Sybase ASE, and Microsoft SQL Server.

JDBC makes it possible for a software developer to run SQL queries within a Java application. The database connection and any required query translations are handled by the JDBC driver. For example, the same Java method can be used to query a MySQL database and a Microsoft SQL Server database. The goal is to provide developers with "write once, run anywhere" functionality, making it easy to work with different types of databases.

In order for an application to use JDBC, the appropriate driver must be installed. Examples include the JDBC Thin driver and the JDBC OCI (Oracle Call Interface) driver. The driver files are available as Java archives (.JAR files), which can be referenced by a Java application. Each Java archive contains .CLASS files that allow Java apps to communicate with different types of databases. Individual classes can be removed to reduce the disk space required by the corresponding Java app.

JDBC drivers are maintained and provided by Oracle, which took over the development of Java after acquiring Sun Microsystems in 2010.

What is the difference between JDBC and ODBC?

JDBC is designed specifically for Java applications, while ODBC is language independent. That means the ODBC API is available for multiple programming languages, while JDBC is only available for Java. A "bridge" can be used to translate commands between the two APIs. For example, an ODBC-JDBC bridge translates ODBC function-calls into JDBC method-calls, allowing them to be processed by a JDBC driver. A JDBC-ODBC driver converts JDBC method calls into ODBC function calls, allowing them to work with an ODBC driver.

Updated December 23, 2016 by Per C.

quizTest Your Knowledge

What is an OS that runs on a router or firewall called?

A
Network operating system
0%
B
Auto switching system
0%
C
Access point system
0%
D
Base station system
0%
Correct! Incorrect!     View the NOS definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of JDBC on this page is an original definition written by the TechTerms.com team. If you would like to reference this page or cite this definition, please use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about this definition or would like to suggest a new technical term, please contact us.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.