what are the adv and disadv dirver1,2,3,4? expain type 1,type 2,type 3,type 4 drivers in JDBC. JDBC interview question

what are the adv and disadv dirver1,2,3,4? expain type 1,type 2,type 3,type 4 drivers in JDBC. JDBC interview question

what are the adv and disadv dirver1,2,3,4? expain type 1,type 2,type 3,type 4 drivers in jdbc? if there is more than one exception in sqlexception calss how to go about displayin it? how do you handle sql exception?

View Answers

May 9, 2012 at 12:53 PM

Type 1 Drivers

Bridge drivers such as the jdbc-odbc bridge. They rely on an intermediary such as ODBC to transfer the SQL calls to the database and also often rely on native code. It is not a serious solution for an application

Type 2 Drivers

Use the existing database API to communicate with the database on the client. Faster than Type 1, but need native code and require additional permissions to work in an applet. Client machine requires software to run.

Type 3 Drivers

JDBC-Net pure Java driver. It translates JDBC calls to a DBMS-independent network protocol, which is then translated to a DBMS protocol by a server. Flexible. Pure Java and no native code.

Type 4 Drivers

Native-protocol pure Java driver. It converts JDBC calls directly into the network protocol used by DBMSs. This allows a direct call from the client machine to the DBMS server. It doesn?t need any special native code on the client machine.

Advantages and Disadvantages of all Drivers

Handling SQL Exceptions









Related Tutorials/Questions & Answers:
jdbc interview question
type 4 drivers - JDBC
Advertisements
type 4 jdbc driver
Interview question - JDBC
jdbc drivers
jdbc interview question
jdbc interview question
java- jdbc with type 4 driver
Jdbc connectivity by type 4 driver
jdbc interview question
different JDBC drivers available
Database drivers - JDBC
fastest type of JDBC driver
What is JDBC?
What is the return type of execute mehtod in jdbc - Java Beginners
Fastest type of JDBC Driver
Jdbc Question
jdbc question - JDBC
jdbc question - JDBC
What is JDBC?
Write to the log used by DriverManager and JDBC drivers.
Types of JDBC drivers
What is ODBC - JDBC
what are the steps in jdbc?
What is JDBC Driver ?
What is DatabaseMetaData - JDBC
What is JDBC architecture?
Jdbc MS-Access question
Jdbc MS-Access question
The required JDBC drivers to establish connectivity to my database part of the JDK.
Which JDBC Type Using - Java Beginners
jdbc
Introduction to the JDBC
JDBC - JDBC
What is the advantage of hibernate over JDBC?
What is the advantage of hibernate over JDBC?
choosing best jdbc connection - JDBC
Maven Repository/Dependency: us.fatehi | schemacrawler-jdbc-drivers
what is ment by jdbc and how to connect with database?
org.apereo.cas - cas-server-support-jdbc-drivers version 6.0.5.1 Maven dependency. How to use cas-server-support-jdbc-drivers version 6.0.5.1 in pom.xml?
org.apereo.cas - cas-server-support-jdbc-drivers version 6.2.3 Maven dependency. How to use cas-server-support-jdbc-drivers version 6.2.3 in pom.xml?
org.apereo.cas - cas-server-support-jdbc-drivers version 5.3.14 Maven dependency. How to use cas-server-support-jdbc-drivers version 5.3.14 in pom.xml?
org.apereo.cas - cas-server-support-jdbc-drivers version 6.6.9 Maven dependency. How to use cas-server-support-jdbc-drivers version 6.6.9 in pom.xml?
jdbc - JDBC
JDBC - JDBC
Maven dependency for org.apereo.cas - cas-server-support-jdbc-drivers version 6.4.6.2 is released. Learn to use cas-server-support-jdbc-drivers version 6.4.6.2 in Maven based Java projects
Maven dependency for org.apereo.cas - cas-server-support-jdbc-drivers version 6.5.2 is released. Learn to use cas-server-support-jdbc-drivers version 6.5.2 in Maven based Java projects
Maven dependency for org.apereo.cas - cas-server-support-jdbc-drivers version 6.5.4 is released. Learn to use cas-server-support-jdbc-drivers version 6.5.4 in Maven based Java projects
Maven dependency for org.apereo.cas - cas-server-support-jdbc-drivers version 6.6.2 is released. Learn to use cas-server-support-jdbc-drivers version 6.6.2 in Maven based Java projects
Maven dependency for org.apereo.cas - cas-server-support-jdbc-drivers version 6.0.0 is released. Learn to use cas-server-support-jdbc-drivers version 6.0.0 in Maven based Java projects

Ads