java data base connectivity (JDBC) presentation

In this we tell about the java data base connectivity their are totally 4

1. JDBC

2. WHAT IS JDBC? Java Database Connectivity (JDBC) is an API specification for connecting applications written in Java to data in popular databases. The JDBC API lets you encode access request statements in Structured Query Language (SQL) that are then passed to the application that manages the database. It returns the results through a similar interface.

3. WHAT IS AN API? API stands for Application Programming Interface. In the context of APIs, the word Application refers to any software with a distinct function. Interface can be thought of as a contract of service between two applications. This contract defines how the two communicate with each other using requests and responses.

4. NEED OF JDBC IT IS IMPORTANT TO UNDERSTAND WHY WE NEED JAVA DATABASE CONNECTIVITY. JAVA APPLICATIONS ARE REQUIRED TO CONNECT WITH DATABASES. JAVA APPLICATIONS ARE WRITTEN IN JAVA PROGRAMMING LANGUAGE, BUT THE DATABASE ONLY UNDERSTANDS STRUCTURED QUERY LANGUAGE (SQL). IN ORDER TO ESTABLISH A CONNECTION BETWEEN JAVA APPLICATION AND DATABASE, JDBC IS USED. JDBC CONTAINS A SET OF INTERFACES AND CLASSES WHICH HELPS TO CONNECT JAVA APPLICATIONS TO THE DATABASE.

5. JDBC DRIVERS AS WE HAVE UNDERSTOOD, JDBC IS USED TO CONNECT JAVA APPLICATIONS WITH THE DATABASE. WE SHOULD ALSO KNOW THAT JDBC USES DIFFERENT JDBC DRIVERS TO PERFORM THIS TASK. BASICALLY, A JDBC DRIVER IS A SOFTWARE COMPONENT WHICH ENABLES JAVA APPLICATIONS TO INTERACT WITH THE DATABASE.

6. THERE ARE FOUR TYPES OF JDBC DRIVERS IN USE: JDBC-ODBC BRIDGE A JDBC-ODBC BRIDGE PROVIDES APPLICATION DEVELOPERS WITH A WAY TO ACCESS JDBC DRIVERS VIA THE JDBC API. TYPE 1 JDBC DRIVERS TRANSLATE THE JDBC CALLS INTO ODBC CALLS AND THEN SEND THE CALLS TO THE ODBC DRIVER. TYPE 1 JDBC DRIVERS ARE GENERALLY USED WHEN THE DATABASE CLIENT LIBRARIES NEED TO BE LOADED ON EVERY CLIENT MACHINE.NATIVE API/PARTLY JAVA DRIVER A NATIVE API/PARTLY JAVA DRIVER IS A PARTIAL JAVA DRIVER BECAUSE IT CONVERTS JDBC CALLS INTO DATABASE SPECIFIC CALLS.

7. TYPE 2 NATIVE API/PARTLY JAVA DRIVER COMMUNICATES DIRECTLY WITH THE DATABASE SERVER. PURE JAVA DRIVER A PURE JAVA DRIVER WORKS IN A THREE TIERED ARCHITECTURE. THE JDBC CALLS ARE PASSED VIA THE NETWORK TO THE MIDDLE TIER SERVER. THIS SERVER TRANSLATES THE CALLS TO THE DATABASE SPECIFIC NATIVE INTERFACE TO FURTHER REQUEST THE SERVER. JDBC DRIVERS AVAILABLE FROM SIMBA ARE TYPE 3 AND TYPE 4 DRIVERS. NATIVE PROTOCOL JAVA DRIVER A NATIVE PROTOCOL JAVA DRIVER CONVERTS JDBC CALLS INTO THE DATABASE SPECIFIC CALLS SO THAT THE CLIENT APPLICATIONS CAN COMMUNICATE DIRECTLY WITH THE SERVE R.

8. THERE ARE 6 MAIN COMPONENTS OF JDBC: DRIVER MANAGER : DRIVER MANAGER IS A CLASS WHICH MANAGES ALL THE DATABASE DRIVERS. THE DRIVER MANAGER IS USED TO LOAD THE SPECIFIC DATABASE DRIVERS IN AN APPLICATION TO ESTABLISH A CONNECTION WITH THE DATABASE. DRIVER : DRIVER IS THE INTERFACE WHICH MANAGES THE COMMUNICATIONS HAPPENING BETWEEN THE APPLICATION AND THE DATABASE SERVER.

9. CONNECTION : CONNECTION IS AN INTERFACE WHICH CONTAINS METHODS FOR CONTACTING THE DATABASE. STATEMENT : STATEMENT IS AN INTERFACE THAT CREATES AN OBJECT TO SUBMIT SQL QUERIES OR STATEMENTS TO THE DATABASE. RESULT SET : RESULT SET CONTAINS THE RESULTS THAT ARE RETRIEVED FROM THE DATABASE AFTER THE EXECUTION OF SQL STATEMENTS OR QUERIES. SQL EXCEPTION : SQL EXCEPTION CLASS IS USED TO HANDLE ANY OF THE ERRORS THAT OCCUR IN A DATABASE APPLICATION.