Why jdbc driver

JDBC helps you to write Java applications that manage these three programming activities: Attention reader! Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready.

Connect to a data source, like a database. Send queries and update statements to the database Retrieve and process the results received from the database in answer to your query Structure of JDBC.

Skip to content. Change Language. Unsupported driver versions aren't available for download here. We're continually improving the Java connectivity support. Note If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please select Read in English at the top of this page.

Discrete Mathematics. Ethical Hacking. Computer Graphics. Software Engineering. Web Technology. Cyber Security. C Programming. Control System. Data Mining. Data Warehouse. The JDBC clients use standard network sockets to communicate with a middleware application server. The socket information is then translated by the middleware application server into the call format required by the DBMS, and forwarded to the database server.

This kind of driver is extremely flexible, since it requires no code installed on the client and a single driver can actually provide access to multiple databases. You can think of the application server as a JDBC "proxy," meaning that it makes calls for the client application. As a result, you need some knowledge of the application server's configuration in order to effectively use this driver type.

Your application server might use a Type 1, 2, or 4 driver to communicate with the database, understanding the nuances will prove helpful. In a Type 4 driver, a pure Java-based driver communicates directly with the vendor's database through socket connection.