Types of JDBC Drivers

Basic introduction of JDBC and different types of jdbc drivers have been explained in this tutorial. Advantage disadvantages of jdbc drivers are also explained.

JDBC and JDBC Drivers

Java Data Base Connectivity (JDBC) is an Application Programming Interface which is one of important usable in different business applications. The reason behind the widely use of JDBC is that because most of the business application software use database. 

jdbc drivers types

In order to retrieve and store the  data in database through GUI we need some kind of connectivity between front end database . Java Data Base Connectivity (JDBC) connects java application with database.

JDBC Drivers

JDBC API Package is java.sql and we imports this package in our jdbc application program. In this package there  are many interfaces. To connect java application  with any database we require a jdbc driver which implements all the interfaces provided in sql package.

Java provides jdbc-odbc bridge driver. It uses ODBC drivers available on your machine. It has limited operations. So it is not suitable for production environment.

Types of jdbc drivers in java

Different types of jdbc drivers in java with examples are as follow:

Type 1 JDBC Driver

java database connectivity steps

The type 1 JDBC driver, JDBC-ODBC Bridge simply  translates all JDBC calls into ODBC (Open DataBase Connectivity)  and send them to ODBC Driver. Advantage of type 1 jdbc odbc driver is that it is easy to use and can be connected to any database but it's Performance can be degrades because type 1 jdbc driver calls are converts into odbc function calls.

Type 2 JDBC Driver

Second type of JDBC drivers is the native-API/partly Java driver which converts JDBC calls into database specific calls for the databases. Example of such database are  SQL Server, Informix, Oracle or SybaseThis type of driver communicates directly with the database server. It requires that some binary code be present on the client machine.

advantages of jdbc drivers

Advantage of type 2 jdbc driver is that it provide better performance as compare to type 1 jdbc odbc bridge. This type of driver  Need  Vendor library and native driver should be installed on client computer.

Type 3 JDBC Driver

JDBC driver type 3 driver is the net-protocol/all-Java driver  and its architecture is based on three-tiered approach where at first  JDBC database requests are passed through the network to the middle-tier server.
Now this middle tier server  translates the received request either directly or indirectly to the database-specific native connectivity interface to further the request to the database server.

jdbc connectivity stpes
Advantages of using this type of driver is that there is no need of client side library because application server itself perform many tasks.If the middle-tier server is written in java then it can use Type 1 and Type 2 Driver also.

Type 4 JDBC Driver

JDBC driver type 4  is the native-protocol/all-Java driver which converts JDBC calls into the vendor specific database management system (DBMS) protocol.It make it easy for  client applications to communicate directly with the database server. 
Type 4 drivers are completely developed  in Java . Advantage of this is that it achieve platform independence and eliminate deployment administration issues.

jdbc steps
Advantages of Type 4 driver is that it gives better performance as compare to all other drivers and there is also no need of client and server side driver. But  it is database dependent.

Next : - jdbc steps to connect database in java



addressing modes types,1,advance-java,2,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,C Programming,18,C Plus Plus,1,c programming notes for gate,18,C programming Tutorials,8,Cache Memory,1,Childcare,1,CJ,1,Cloud Computing,1,CN,4,Computer Architecture,2,Computer architecture based questions for gate exam,11,Computer architecture Tutorials,1,Computer Network,3,Computer Network Study Material,2,Computer network study material for gate,1,Computer Networks,10,Computer networks gate questions with answer,3,computer networks notes,1,computer networks tutorial,1,Computer Science Study Material for Gate,13,computer science study material for gate exam,17,contiguous memory allocation,2,Core Java,3,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,data communications and networking,1,Data Structure,2,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,database normalization,1,dbmas study material,1,DBMS,8,dbms gate questions with answer,1,dbms multiple choice questions with answers for gate,1,dbms question paper,1,DE,1,Digital Electronics,1,DS,4,Electroencephalogram,1,ER diagram Tutorial,1,Gate 2017,3,Gate 2017 Admit card,1,GATE 2020,1,gate cse c programming questions,10,gate cse study material,2,gate cse syllabus,2,gate practice set,7,gate questions on c programming,10,gate study material for computer science,14,Gate study material for computer science 2017,1,gate study material for cse,46,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,4,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,Java Tutorials,3,JDBC,2,JDBC Tutorial,1,JS,1,memory fragmentation,1,memory management,1,memory management questions and answer in os,1,Motivational,4,NCER,1,Numerical Techniques Lab,1,OOT,1,Operating System,6,Operating System Gate Questions,2,Operating System Objective Questions,4,Operating System Questions Bank,1,operating system study material for gate exam,11,operating system tutorial notes,8,Operating System tutorials resident monitor,1,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,Regression testing,1,relocation register,1,routing table,1,Software Engineering,10,Software Engineering baes study material for gate,1,Software Quality Assurance,3,software verification methods,1,Stack,1,Study Material for gate Computer Science,5,swapping in memory management,1,swapping in operating system,1,TCS Code Vita,1,TCS Interview Questions,1,Technical Interview,1,Technical Questions from DBMS,1,Tips to Learn Coding,1,UML,1,Virtualization,1,What is process control block ?,1,what is software testing?,1,Wireless Sensor Network,3,worst fit algorithm for memory allocation,1,XML,2,
Computer Science Junction: Types of JDBC Drivers
Types of JDBC Drivers
Basic introduction of JDBC and different types of jdbc drivers have been explained in this tutorial. Advantage disadvantages of jdbc drivers are also explained.
Computer Science Junction
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy