Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Answers Viewqa JDBC different JDBC drivers available

Have Programming Question? Ask it here!

different JDBC drivers available
1 Answer(s)      3 years and 10 months ago
Posted in : JDBC

What are the different JDBC drivers available?

View Answers

November 12, 2010 at 4:40 PM

Hi friends,

There are four categories of JDBC drivers..

TYPE1 : JDBC-ODBC bridge driver -- It use a bridge technology to connect a java client to an ODBC database.It requires a sort of non_java software to be installed on machine running your code and the are implemented using native code.

Type2 : Native-API Partly Java Drivers -- The Native to API driver converts JDBC commands to DBMS-specific native calls. This is much like the restriction of Type 1 drivers. The client must have some binary code loaded on its machine. These drivers do have an advantage over Type 1 drivers because they interface directly with the database.

TYPE3 : Network protocal/ pure java driver -- The JDBC-Net drivers are a three-tier solution. This type of driver translates JDBC calls into a databaseindependent network protocol that is sent to a middleware server. This server then translates this DBMSindependent protocol into a DBMS-specific protocol, which is sent to a particular database. The results are then routed back through the middleware server and sent back to the client. This type of solution makes it possible to implement a pure Java client. It also makes it possible to swap databases without affecting the client.

TYPE4 : Native-protocol/ fully java driver -- These are pure Java drivers that communicate directly with the vendor's database. They do this by converting JDBC commands directly into the database engine's native protocol. This driver has no additional translation or middleware layer, which improves performance tremendously.


Related Tutorials/Questions & Answers:
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
jdbc drivers
jdbc drivers  what are the various kinds of jdbc drivers explain in detail
type 4 drivers - JDBC
type 4 drivers  Hi! What is the syntax for Type - 4 drivers. give me any sample code. Thanks in advance..  Hi Friend, Please visit the following link:
Database drivers - JDBC
.   Hi friend, There are four types of JDBC drivers known...-types.shtml Thanks.  Hi! we have four types of drivers. JDBC-ODBC... drivers: 1. Jdbc Odbc Driver: using this driver, the jdbc can be accessed via
Drivers  How to insert Drivers in jdbc for java
Write to the log used by DriverManager and JDBC drivers.
Write to the log used by DriverManager and JDBC drivers.  How can I write to the log used by DriverManager and JDBC drivers
Types of JDBC drivers
of different environment. 3.The JDBC Client driver written in java, communicates...JDBC Driver's Type JDBC Driver can be broadly categorized into 4 categories-- JDBC-ODBC BRIDGE DRIVER(TYPE 1)  Features 1.Convert the query
The required JDBC drivers to establish connectivity to my database part of the JDK.
The required JDBC drivers to establish connectivity to my database part of the JDK.  Are all the required JDBC drivers to establish connectivity to my database part of the JDK
Java JDBC driver
Java JDBC driver  What are the different JDBC drivers available
A Brief Introduction to JDBC
to learn JDBC to develop java Data Access Application to different database to different database applications using different JDBC drivers. JDBC.... JDBC Driver Types There are 4 types of JDBC drivers available. Type 1: JDBC
List of JDBC Driver
List of JDBC Drivers JDBC driver is a software component, which enables.... The table given below shows the list of JDBC drivers... database we need its JDBC driver. Therefore we requires JDBC driver for database
Class.forName will do while loading drivers
Class.forName will do while loading drivers  What Class.forName will do while loading drivers
!  Hello,There are four types of JDBC drivers. There are mainly four type of JDBC drivers available. They are:Type 1 : JDBC-ODBC Bridge Driver A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers. Note that some
jdbc  why do we need to load jdbc drivers before connecting to database
Understanding the JDBC Architecture
Database drivers Driver manager The JDBC API... databases. The location of the driver manager with respect to the JDBC drivers... drivers. Type 1 JDBC-ODBC Bridge. Type 1 drivers act as a "bridge
JDBC Driver
JDBC Driver  I want to know the clear syntax and usages of $ types of JDBC drivers. Where can i get it? I search for it, nobody give Syntax for tat different drivers. can u give a sample codes for tat
how to connect mySql drivers into eclipse(configuration)?
how to connect mySql drivers into eclipse(configuration)?  how to connect mySql drivers into eclipse(configuration)? I need the configuration in eclipse. what do i have to download from mySql and just downloading is enough or do
jdbc - JDBC
drivers for concurrent access?   Question: Is the JDBC-ODBC Bridge... from different threads. The JDBC-ODBC Bridge uses synchronized methods... concurrent access from different threads. The JDBC-ODBC Bridge uses
JDBC Examples, JDBC Example code
JDBC or Java Database Connectivity is the set of API for accessing the database from Java program. JDBC allows the developers to access almost all the major databases. Appropriate database drivers are available for all major databases
java - JDBC
and the drivers. It keeps track of the drivers that are available and handles  drivermanager class loads the drivers to connect odbc..., The JDBC-ODBC Bridge uses synchronized methods to serialize all
Introduction to the JDBC
in their database driver. A list of currently available JDBC drivers... are JDBC Drivers? JDBC Drivers are set of classes... JDBC Drivers Types Sun has defined four JDBC
Features of JDBC
.style1 { text-align: center; } Feature A JDBC JDBC JDBC java database connectivity (JDBC) is an API (Application Programming Interface) for java that allows the Java programmer to access the Database. The JDBC API
Product Components of JDBC
; is used to provide a means of managing the different types of JDBC database... suite is to make ensure that the  JDBC drivers will run user's program... Product Components of  JDBC   
JDBC features
Database Connectivity or JDBC for short is the API available in Java for accessing... API provides the methods to access the data base easily. JDBC drivers are available for almost all the major database JDBC is the only API
servlet action not available - Struts
servlet action not available  hi i am new to struts and i am getting the error "servlet action not available".why it is displaying this error. Struts Blank Application action org.apache.struts.action.ActionServlet
jdbc - JDBC
jdbc  What is the difference b/w jdbc driver and jdbc driver manager... Class.forName("foo.bah.Driver") The DriverManager will try to load as many drivers... and refer JDBC API. Thanks Rajanikant
The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge.  Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge
jdbc,odbc,MySQL,swing - Java Beginners
jdbc,odbc,MySQL,swing  write a code that displays a menu list of all available database drivers in a window,and allows the user to select any driver... to the selected database driver.It is very well known as jdbc front end of a database
JDBC Driver and Its Types
main purpose is to provide a means of managing the different types of JDBC... responsibility to load all the drivers found in the system property jdbc. drivers... driver from the previously loaded drivers. The JDBC API defines the Java
JDBC  why we use batch in jdbc
jdbc  display the records using index in jdbc
jdbc  Hai , Give a steps for jdbc connectivity
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems
logical group of data with a number of columns. JDBC ResultSet Example Stored... by several clients using different input data. And when the procedure is modified, all
what are different type of locks  what are different type of locks   Types of locks in JDBC: Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency
First Step towards JDBC!
; A list of currently available JDBC drivers can be found at http... and Sun's JDBC-ODBC drivers are used. In the later sections we will show... Drivers? JDBC Drivers are set of classes that enables the Java
Best JDBC Driver and Why - JDBC
Best JDBC Driver and Why   Hi Friends , In JDBC 4 drivers are there among this which is best and why. which driver is most commonly used in web application
JDBC  How to add set of queries in a single query in JDBC
JDBC Training, Learn JDBC yourself
, New Features in JDBC 4.0 and More APIs Become Available. Understanding... programming language. It includes a framework where we different drivers can... responsibility of  JDBC database driver is to load all the drivers found
Java get available Font
Java get available Font       In this section, you will learn how to get the available font. In order to retrieve all the available fonts, we have used the AWT package
Confused in driver - JDBC
,There for different types of drivers. Please check it at in driver  I am confused about the concept Driver in JDBC. Although i know jdbc very well(in respect... mean to say theoretically
jdbc  please tell me sir.i dont know JDBC connection and how to create table in database
jdbc   how to write program to save data and retrieve data from the form in Java
JDBC  how to set classpath for eclipse, java, where to copy jdbc connector
JDBC  in class.forname which driver name we are writing for the connection from jdbc to sqlserver 2008
jdbc  is it possible to use doget & dopost method with jdbc to call in a servlet programe
Jdbc  A java program with jdbc connectivity with insert,delete,update options for name,regno,mark1,mark2,total
JDBC  can u send me the code of jdbc how to join two tables that are in relation