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




Have Programming Question? Ask it here!
 
 
 


neelam
Java JDBC driver
1 Answer(s)      3 years and 6 months ago
Posted in : Java Interview Questions


What are the different JDBC drivers available?

Advertisement
View Answers

October 18, 2010 at 11:59 AM


Hi,

Type 1: JDBC-ODBC Bridge

JDBC-ODBC Bridge,translates all JDBC calls into ODBC (Open DataBase Connectivity) calls and sends them to the ODBC driver.As such, the ODBC driver, as well as, in many cases, the client database code, must be present on the client machine.

Type 2: Native-API/partly Java driver

The native-API/partly Java driver converts JDBC calls into database-specific calls for databases such as SQL Server, Informix, Oracle, or Sybase. The type 2 driver communicates directly with the database server; therefore it requires that some binary code be present on the client machine.

Type 3: Net-protocol/all-Java driver

The net-protocol/all-Java driver follows a three-tiered approach whereby the JDBC database requests are passed through the network to the middle-tier server. The middle-tier server then translates the request to the database-specific native-connectivity interface to further the request to the database server. If the middle-tier server is written in Java, it can use a type 1 or type 2 JDBC driver to do this.

Type 4- Pure Java Driver

Type 4 are direct-to-database pure Java drivers ("thin" drivers). a pure Java-based driver that communicates directly with vendor's database through socket connection. This is the highest performance driver available for the database and is usually provided by the vendor itself. Each DBMS requires its own Type 4 driver; therefore, there are more drivers to manage in a heterogeneous computing environment, but this is outweighed by the fact that Type 4 drivers provide faster performance and direct access to DBMS features.

Thanks.



Related Tutorials/Questions & Answers:
Java JDBC driver
Java JDBC driver  What is JDBC Driver
Java JDBC driver
Java JDBC driver  What are the different JDBC drivers available
Advertisements
jdbc driver for mysql - Java Beginners
jdbc driver for mysql  I need jdbc driver program for connecting java progrma to mysql. Please any one send me the url to download the driver... of jdbc-mysql database connectivity and idea about jdbc and mysql driver
java- jdbc with type 4 driver
java- jdbc with type 4 driver  My program code is----- import java.sql.*; import java.lang.* ; import java .io.*; import java.util.*; import... and Register the JDBC driver:*** DriverManager.registerDriver(new
jdbc driver
jdbc driver  hello, can we create a own jdbc driver? how can we create
Jdbc Driver - JDBC
-ODBC Driver)Type 2(java native driver)Type 3Type 4  Type of JDBC..., partly Java driver, also called Type 2. * JDBC-Net, pure Java driver, also called Type 3. * Native-protocol, pure Java driver, also called Type 4.For JDBC
no driver - JDBC
the program: run: SQL Exception: No suitable driver found for jdbc:db2... { try { //Loads Type 2 Driver Class.forName...) { System.err.println("Could not load DB2 driver! \n"); System.err.println(e.getMessage
java run time error in loading the driver - JDBC
JDBC driver's JAR file in your classpath and check it Thanks...java run time error in loading the driver  when i mrunning the program in oracle using type 4 driver it is giving the error as Error
JDBC Driver - JDBC
JDBC Driver  What are the diffrent types of JDBC driver
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
Connecting to the Database Using JDBC and Pure Java driver
Connecting to the Database JDBC Driver In our search... earlier MM.MySQL Driver is 100% pure Java Driver for MySQL... this driver to make connections to MySQL server from both Java
MySQL Driver for JDBC - JDBC
MySQL Driver for JDBC  Sir, I have started reading your JDBC tutorial...... Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306   Hi,Please download the driver from http://www.mysql.com/products/connector
What is JDBC Driver ?
What is JDBC Driver ?  What is JDBC Driver
JDBC Driver interface
JDBC Driver interface  What is JDBC Driver interface
fastest type of JDBC driver
fastest type of JDBC driver  What is the fastest type of JDBC driver
JDBC driver is the fastest one
JDBC driver is the fastest one  Which type of JDBC driver is the fastest one
Fastest type of JDBC Driver
Fastest type of JDBC Driver  hello, What is the fastest type of JDBC driver?   hii, Type 4 is the fastest JDBC driver
Set properties for a JDBC driver
Set properties for a JDBC driver  How do I set properties for a JDBC driver and where are the properties stored
type 4 jdbc driver
type 4 jdbc driver   i read in this site that type 4 jdbc driver is the fastest one so used it to connect with the database.......but not tried another drivers,....can u specifically answer me why type 4 is the fastest one
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
Confused in driver - JDBC
Confused in driver  I am confused about the concept Driver in JDBC. Although i know jdbc very well(in respect... mean to say theoretically it is not cleared please explain me the type of driver... of some picture i want o know
jdbc type-4 driver
jdbc type-4 driver  I was tried the code that you give to run type-4 driver . import java.sql.*; import oracle.jdbc.driver.*; import oracle.sql.*; while compiling the error was like: package oracle.jdbc.odbc.driver does
JDBC Driver and Its Types
DriverManager class defines objects which can connect Java applications to a JDBC driver... driver from the previously loaded drivers. The JDBC API defines the Java.... JDBC Driver This topic defines the Java(TM) Database
Jdbc connectivity by type 4 driver
Jdbc connectivity by type 4 driver  I have done a code with database connectivity with driver 4,it copiles,but while running it is showing...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","system","123
Java driver manager
Java driver manager  What is DriverManager
Frameworks and example source for writing a JDBC driver.
Frameworks and example source for writing a JDBC driver.  Where can I find info, frameworks and example source for writing a JDBC driver
Driver Manager Class
; The JDBC Driver Manager The JDBC Driver Manager... to a JDBC driver. Usually  Driver Manager is the backbone of the JDBC... of managing the different types of JDBC database driver running on an application
Connection using Jdbc-odbc bridge Driver
Connection using JDBC-ODBC bridge driver JDBCExample.java... bridge driver create connection between java application and 'MSAccess...;); --In this program "forName()" function is used to load the JDBC-ODBC bridge driver
MySQL JDBC Driver pom dependency code
MySQL JDBC Driver pom dependency code  Hi, What is the POM dependency code for MySQL's latest JDBC Driver? I can download the MySQL driver from mysql website but I need to use it in a application which is based on Maven 3
the JDBC Driver has been forcibly unregistered
the JDBC Driver has been forcibly unregistered  Hi my application... application was st opped. To prevent a memory leak, the JDBC Driver has been... the web application was stopped. To prevent a memory leak, the JDBC Driver has been
how to set fetch size for jdbc odbc driver
size for the JDBC ODBC driver and how can i fetch a set of results for JDBC ODBC driver?   Fetching results JDBC ODBC Driver A. The default fetch.... To fetch small number of rows from database, JDBC driver is designed so
Driver
Driver  can u send type4 jdbc driver class name and url for microsoft sql server 2008
No suitable driver found for jdbc:mysql://localhost:3306/TEST
No suitable driver found for jdbc:mysql://localhost:3306/TEST  hii, I.... ava.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/TEST...) the normal java project without server was working fine but in web project its
Specified JDBC Driver com.mysql.jdbc.Driver could not be loaded
Specified JDBC Driver com.mysql.jdbc.Driver could not be loaded  Hi... failedorg.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver... by: org.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver
Specified JDBC Driver com.mysql.jdbc.Driver could not be loaded
Specified JDBC Driver com.mysql.jdbc.Driver could not be loaded  Hi... failedorg.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver... by: org.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver
Redirect the log used by DriverManager and JDBC driver
Redirect the log used by DriverManager and JDBC driver  How can I get or redirect the log used by DriverManager and JDBC drivers
get UnsatisfiedLinkError when I try to use my JDBC driver.
get UnsatisfiedLinkError when I try to use my JDBC driver.  Why do I get UnsatisfiedLinkError when I try to use my JDBC driver
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.  Is there a way to find the primary key(s) for an Access Database table? Sun's JDBC-ODBC driver does not implement
Java JDBC
Java JDBC  What is the fastest type of JDBC driver
unable to retrive the data from mysql using servlet using jdbc driver
unable to retrive the data from mysql using servlet using jdbc driver ... Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "rapax"; String driver = "com.mysql.jdbc.Driver"; String
selenium rc java client driver - WebSevices
selenium rc java client driver  how to implement getcookies functions in selnium rc??? i m using getcookies function in selenium rc java client driver. but its given some error. pls tell me whether i have 2 write code
JDBC-Odbc Connection
; JDBC-ODBC Connection is a JDBC driver that translates the operation in  JDBC into ODBC. For ODBC,it is a normal java application program. This bridge... in explaining JDBC Odbc Connection in Java. The code explains you a how creation
How to Retrieve Excel data into mysql using type 2 JDBC-ODBC driver
How to Retrieve Excel data into mysql using type 2 JDBC-ODBC driver  ... type 1 driver and i have done successfully.but disadvantage is when i create... Sources(ODBC) Open User DSN tab Add a user DSN Select Microsoft Excel Driver
XLS JDBC Example
.style1 { background-color: #FFFFCC; } XLS JDBC XlS JDBC driver is used to access xls file from java application. It is read only JDBC driver... driver therefore you should use JDBC - ODBC bridge driver to connect your excel
java - JDBC
these driver manager classes are belongs to Jdbcapi,What about Odbc?  Hi friend, The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge
JAVA - JDBC
JAVA  how to store and retrieve an image in a database(ORACLE)using java or JSP?  Hi friend, I am sending you image insert code in jsp using mysql jdbc driver so please change driver name and implement
java - JDBC
automatically loaded. The driver is loaded by calling the Class.forName() method. JDBC... on JDBC visit to : http://www.roseindia.net/jdbc/understanding-driver..., The DriverManager class maintains the list of the Driver classes. Each driver has to be get
java - JDBC
the JDBC driver:*********** DriverManager.registerDriver(new... driver,you have to use: Connection conn = DriverManager.getConnection("jdbc...java  how can i connect jdbc with oracle 9i.please give detailed
Java jdbc
Java jdbc  What is JDBC
Java JDBC
Java JDBC   Is the JDBC-ODBC Bridge multi-threaded
Advertisements
 

 

 

DMCA.com