what is difference between type 4 driver and type 1 driver?
- 2 Answers
- 12441 Views
- CMC, CTS, IBM, JK Technosoft, Napier Healthcare, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashokkumar
Type 1 –(JDBC-ODBC bridge, plus an ODBC driver). The JDBC
API are implemented as mapping to other Database driver API.
All the JDBC calls will be translated to an ODBC request and
sent to ODBC driver,which then will be take care of the
request. This translation results in the degradation of
performance
Type4 -are direct-to-database pure Java drivers ("thin"
drivers). A Type 4 driver takes JDBC calls and translates
them into the network protocol (proprietary protocol) used
directly by the DBMS. Thus, client machines or application
servers can make direct calls to the DBMS server.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.
| Is This Answer Correct ? | 21 Yes | 0 No |
Answer / jigar
Type 1: JDBC-ODBC Bridge Driver
The first type of JDBC driver is JDBC-ODBC Bridge which
provide JDBC access to any ODBC complaint databases through
ODBC drivers. Sun's JDBC-ODBC bridge is example of type 1
driver.
Type 4: Native-Protocol Pure Java Driver
Type 4 drivers are entirely written in Java that communicate
directly with vendor's database through socket connection.
Here no translation or middleware layer, are required which
improves performance tremendously.
| Is This Answer Correct ? | 6 Yes | 2 No |
Name and explain the types of ways which are used to pass arguments in any function in java.
What is an array and a vector? How they different from each other?
Why only one Class is public in one file? Explain in details. Thanks in Advance.
What are loops in java? What are three types of loops?
Diff between Comparator and Comparable?
What do you understand by garbage collection in Java? Can it be forced to run?
How will you load a specific locale?
abstract class Demo { public void show() { System.out.println("Hello I am In show method of Abstract class"); } } class Sample extends Demo { public void show() { super.show(); System.out.println("Hello I am In Sample "); } } public class Test { public static void main(String[] args) { //I WANT TO CALL THE METHOD OF BASE CLASS IT IS POSSIBLE OR NOT CAN WE USE SCOPE RESOLUTION OPERATOR TO CALL OR JAVA NOT SUPPORTED THAT :: OPERATORE } }
What is the purpose of a default constructor?
List interface?
What is the preferred size of a component?
Why inputstreamreader is used in java?
Core Java 
