Database drivers

Database drivers

View Answers

August 28, 2008 at 3:44 PM

Hi friend,


There are four types of JDBC drivers known as:

* JDBC-ODBC bridge plus ODBC driver, also called Type 1.
* Native-API, 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.


Read for more information.

http://www.roseindia.net/jdbc/introduction.shtml

http://www.roseindia.net/jdbc/jdbc-driver-and-its-types.shtml


Thanks.

September 1, 2008 at 7:21 PM

Hi!
we have four types of drivers.

JDBC-ODBC Bridge Driver
Native-API partly Java driver
JDBC-Net pure Java driver
Native-protocol pure Java driver

Very simply, I will explain about these four drivers:

1. Jdbc Odbc Driver:
using this driver, the jdbc can be accessed via odbc Driver. But odbc has some limitations that it should be installed manually in all the client machines. Therefore, it is not recommended for larger networks.

2. Native API, Partly java:
this driver converts the jdbc calls into client api for sybase/oracle and dbms. This driver is also not recommended for larger networks, because some binary code is to be installed manually in all the client machines.


3. Jdbc Net Pure java Driver:
This driver converts the jdbc calls into independent dbms net protocol. Again the server which translates this protocol into dbms.

4. Native Protocol:
this driver converts the jdbc calls into network protocol used by the server directly.


February 23, 2011 at 5:01 PM

Types of JDBC driver

Type 1 = JDBC-ODBC driver
Type 2 = JDBC Native Api
Type 3 = JDBC 100% pure java
Type 4=  JDBC 100% java
if you want anything pl mail me









Related Tutorials/Questions & Answers:
Database drivers - JDBC
Database drivers  Please give me types of drivers and explain them.   Hi friend, There are four types of JDBC drivers known...-types.shtml Thanks.  Hi! we have four types of drivers. JDBC-ODBC
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
Advertisements
Drivers
Drivers  How to insert Drivers in jdbc for java
jdbc drivers
jdbc drivers  what are the various kinds of jdbc drivers explain in detail
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
Version of com.cibuddy>drivers dependency
List of Version of com.cibuddy>drivers dependency
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... i have to install anything to create a database and tables
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: http://www.roseindia.net/jdbc/jdbc-driver-and-its
ModuleNotFoundError: No module named 'dexma_drivers'
ModuleNotFoundError: No module named 'dexma_drivers'  Hi, My... 'dexma_drivers' How to remove the ModuleNotFoundError: No module named 'dexma_drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'jake-drivers'
ModuleNotFoundError: No module named 'jake-drivers'  Hi, My Python... 'jake-drivers' How to remove the ModuleNotFoundError: No module named 'jake-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'jake-drivers'
ModuleNotFoundError: No module named 'jake-drivers'  Hi, My Python... 'jake-drivers' How to remove the ModuleNotFoundError: No module named 'jake-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'lantz-drivers'
ModuleNotFoundError: No module named 'lantz-drivers'  Hi, My... 'lantz-drivers' How to remove the ModuleNotFoundError: No module named 'lantz-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'linux-drivers'
ModuleNotFoundError: No module named 'linux-drivers'  Hi, My... 'linux-drivers' How to remove the ModuleNotFoundError: No module named 'linux-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'linux-drivers'
ModuleNotFoundError: No module named 'linux-drivers'  Hi, My... 'linux-drivers' How to remove the ModuleNotFoundError: No module named 'linux-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'livingbio-drivers'
ModuleNotFoundError: No module named 'livingbio-drivers'  Hi, My... named 'livingbio-drivers' How to remove the ModuleNotFoundError: No module named 'livingbio-drivers' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'shake-drivers'
ModuleNotFoundError: No module named 'shake-drivers'  Hi, My... 'shake-drivers' How to remove the ModuleNotFoundError: No module named 'shake-drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'dexma_drivers'
ModuleNotFoundError: No module named 'dexma_drivers'  Hi, My... 'dexma_drivers' How to remove the ModuleNotFoundError: No module named 'dexma_drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'hcam_drivers'
ModuleNotFoundError: No module named 'hcam_drivers'  Hi, My Python... 'hcam_drivers' How to remove the ModuleNotFoundError: No module named 'hcam_drivers' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'jake-drivers'
ModuleNotFoundError: No module named 'jake-drivers'  Hi, My Python... 'jake-drivers' How to remove the ModuleNotFoundError: No module named 'jake-drivers' error? Thanks   Hi, In your python
Class.forName will do while loading drivers
Class.forName will do while loading drivers  What Class.forName will do while loading drivers
database
database  database
database
database  database application
database
database  the code for initializing the database connection
database
database  i want to let the user select the name of database and then delete that database.......im doing project in swings netbeans
database
database  use of hyperlink to show the data from database
database
database  i need to insert time in my database. i need a code to insert time in my database. its very urgent
Maven Dependency drivers >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.cibuddy >> drivers version1.0.0 in your project
database
database  im doing my project in netbeans swings...wn a user wants to create a database from the gui...i want to display an error msg if a database with that name already exists and if it does not exist new database should
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  I wanted to know if it is possible to create a database in mysql by letting the user enter the name of the database in swing gui..im doing my project in netbeans...Thank You
database
database  I wanted to know if it is possible to establish database connection on a remote pc with mysql using java swings from netbeans and then create a database on the remote pc.... Kindly help me
DATABASE
DATABASE  How can i get combo box values from database?? or how can i get values in the drop down menu of the html which is similar to dat of combo box in java - from database
Database
Database  How to represent data from database in a tree?   Please visit the following link: Retrieve data from database in tree using Java Swing
Database
Database  I am working in jsf2.Fro a demo i created database in ms access.no wi want to retrive a record from database for a particular data.I need help as I am stuck
Database
Database  from java code i have to retrieve some data from a database, which is present in a different timezone. Scenario :- My database... in database timezone is 9PM 15APR2012. I want to retrieve something from database
DATABASE
DATABASE  I can't send different information from different form into a single table in my database
database
database  dateofbirth is not save into the database while i am enter from html browser.it shows as null.whats the reason
database
database  sir.. how we can uplaod the database in the data file(ms access)please send me a solution
database
database  how we ca upload the data in the database file(ms access
database
database  hi i want to develop one patient database can any one provide me the guide
Database
Database  Can i get a code for database connectivity Myeclipse 3.3 to MySql manager 2005
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
database
database  In my project where u helped me to display the databases present im mysql database on the Jlist and then the respective tables in that database on another jlist and then the column names on another jlist I dont want
database
database  In my project,i want the user to specify the name of the database he wants to create in mysql and then also the name of the table along with the column names he wants in that database....Im doing my project in netbeans
database
database  Im doing my project in java swings...netbeans I wanted java source code to establish connection to postgresql_8.1 using jdbc and create a user defined database and a table in that database and insert values Plz help me
database
database  Can you please help me to establish database connection to ms sql 2000 from java swing in netbeans
database
database  i need optimised searching algorithm to retrieve the data from the database and optimised ranking algorithm to display the reults into the user
database
database  I want to let the user select one of the database type... give the name of the database name that he want to create in a textfield... database..im doing my project in java swings.....netbeans Kindly help me ThankYou

Ads