What are the different JDB drivers available?

Recent Questions

Image upload from JSP to DataBase ? view answer
How to Upload Image into Data Base ? view answer
Q. What is Rowset ? CachedRowSet,JDBCRowSet and WebRowSet ? view answer
Q. What is Batch Updates Using Statements in JDBC ? view answer
Q.Handling Blob and CLOB data using JDBC ? Insert CLOB and Retrive CLOB , Convert into String ? view answer
Q. Calling Stored procedures with Callable Statement ? view answer
Q.What is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ? view answer
Q. How java retrive the result returns from stored procedure ? view answer
Q.How to retrive the results in java returned by refcursor in Stored procedure ? view answer
Q.Reading an Oracle ARRAY from a stored procedure as an out ? view answer
What is Metadata and why should I use it? view answer
How Class.forName() load the Driver and DriverManager.getConnection() return connection? view answer
What will Class.forName do while loading drivers? view answer
How to Determining If a Result Set Is Scrollable? view answer
How Getting the Number of Rows in a Table Using a Scrollable Result Set? view answer
What is Scrollable Result Set ? view answer
What does setAutoCommit do? view answer
What is the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE? view answer
How to Make Updates to Updatable Result Sets? view answer
How can you move the cursor in scrollable result sets? view answer
What are the different types of Statements with Example? view answer
How can you retrieve data from the ResultSet? view answer
How can you create JDBC statements and what are they? view answer
How can you make the connection? view answer
What will Class.forName do while loading drivers? view answer
How can you load the drivers? view answer
What is PreparedStatement ? view answer
what is rowset? and how does it differ from resultset ? view answer
How to find total column from a resultset? view answer
What is the fastest type of JDBC driver? view answer
What are the different JDB drivers available? view answer
Q.What are collection pools? What are the advantages? view answer
Q.What are different types of Transaction Isolation Levels? view answer
Q. What is Dirty read? view answer
Q.Difference between Statement , PreparedStatement and CallableStatement ? view answer
Q.What is the advantage of using PreparedStatement? view answer
Q.What is Single-Phase Commit ? view answer
Q.What is two-phase commit? view answer
Q. How JDBC work with REF CURSOR returned by stored procedure and retrive results? view answer
Q. How do i get result return from stored procedure in JDBC? view answer
Q.How do you call a Stored Procedure from JDBC? view answer
Q.How do you handle your own transaction ? view answer
Q.What are the steps in the JDBC connection? view answer

!!! JDBC Frequently Asked Questions !!!

What are the different JDB drivers available?

Click to View Answer Below

!!!Answer!!!- From Technical Expert

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 ODBC native code and in many cases native database client code must be loaded on each client machine that uses this type of driver. Hence, this kind of driver is generally most appropriate when automatic installation and downloading of a Java technology application is not important. For information on the JDBC-ODBC bridge driver provided by Sun.

Type 2: Native API Partly Java Driver- A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.

Type 3: Network protocol Driver- A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server. This net server middleware is able to connect all of its Java technology-based clients to many different databases. The specific protocol used depends on the vendor. In general, this is the most flexible JDBC API alternative. It is likely that all vendors of this solution will provide products suitable for Intranet use. In order for these products to also support Internet access they must handle the additional requirements for security, access through firewalls, etc., that the Web imposes. Several vendors are adding JDBC technology-based drivers to their existing database middleware products.

Type 4: JDBC Net pure Java Driver - A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access. Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver. Several database vendors have these in progress.

Answered By :	null Replied Date : Mar 2 2012
Answer :
Answered By :	null Replied Date : Dec 5 2011
Answer :
Answered By :	null Replied Date : Oct 18 2011
Answer :
Answered By :	null Replied Date : Jul 24 2011
Answer :
Answered By :	null Replied Date : Jul 6 2011
Answer :
Answered By :	null Replied Date : Jun 17 2011
Answer :
Answered By :	null Replied Date : Jun 1 2011
Answer :
Answered By :	null Replied Date : Apr 1 2011
Answer :
Answered By :	null Replied Date : Mar 10 2011
Answer :
Answered By :	null Replied Date : Mar 3 2011
Answer :
Answered By :	null Replied Date : Jan 16 2011
Answer :
Answered By :	null Replied Date : Jan 16 2011
Answer :
Answered By :	null Replied Date : Jan 15 2011
Answer :
Answered By :	null Replied Date : Jan 13 2011
Answer :
Answered By :	null Replied Date : Jan 8 2011
Answer :
Answered By :	null Replied Date : Jan 5 2011
Answer :
Answered By :	null Replied Date : Jan 1 2011
Answer :
Answered By :	null Replied Date : Jan 1 2011
Answer :
Answered By :	null Replied Date : Dec 30 2010
Answer :
Answered By :	null Replied Date : Dec 18 2010
Answer :
Answered By :	null Replied Date : Nov 29 2010
Answer :
Answered By :	null Replied Date : Nov 22 2010
Answer :
Answered By :	null Replied Date : Oct 11 2010
Answer :
Answered By :	null Replied Date : Oct 11 2010
Answer :
Answered By :	null Replied Date : Oct 10 2010
Answer :
Answered By :	null Replied Date : Aug 19 2010
Answer :
Answered By :	null Replied Date : Jun 24 2012
Answer :
Answered By :	null Replied Date : Oct 10 2012
Answer :
Answered By :	null Replied Date : Nov 9 2012
Answer :
Answered By :	null Replied Date : Nov 25 2012
Answer :
Answered By :	null Replied Date : Nov 28 2012
Answer :
Answered By :	null Replied Date : Jan 1 2013
Answer :
Answered By :	null Replied Date : Mar 24 2013
Answer :

Ask Question and get answer from Expert.
View Answers List from Expert.

TechFAQ

Technology Expert Comments

Recent Questions

!!! JDBC Frequently Asked Questions !!!

What are the different JDB drivers available?

Click to View Answer Below

!!!Answer!!!- From Technical Expert

You can also contribute to this answer: