ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Core Java  >>  Java J2EE  >>  Java Related
 
 


 

 
 Core Java interview questions  Core Java Interview Questions
 Advanced Java interview questions  Advanced Java Interview Questions
 Swing interview questions  Swing Interview Questions
 EJB interview questions  EJB Interview Questions
 Servlets interview questions  Servlets Interview Questions
 Struts interview questions  Struts Interview Questions
 JDBC interview questions  JDBC Interview Questions
 JMS interview questions  JMS Interview Questions
 SunOne interview questions  SunOne Interview Questions
 J2EE interview questions  J2EE Interview Questions
 Weblogic interview questions  Weblogic Interview Questions
 Websphere interview questions  Websphere Interview Questions
 Java Networking interview questions  Java Networking Interview Questions
 Java J2EE AllOther interview questions  Java J2EE AllOther Interview Questions
Question
what is difference between type 4 driver  and type 1 driver?
 Question Submitted By :: Gopalraop
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is difference between type 4 driver and type 1 driver?
Answer
# 1
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 ?    6 Yes 0 No
Ashokkumar
 
  Re: what is difference between type 4 driver and type 1 driver?
Answer
# 2
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 ?    1 Yes 0 No
Jigar
 
 
 

 
 
 
Other Core Java Interview Questions
 
  Question Asked @ Answers
 
String is an immutable object. Then how can the following code be justified. String s1 = ?ABC?; String s1 = s1+?XYZ?; s.o.p(s1); The output is ABCXYZ, which is the value of s1 ? Flextronics5
what is overloading in java? DNS4
What is Transient and volatile iFlex9
wht is mean by dirty read?  1
What is the preferred size of a component?  1
What do you mean by the term transient? Ericsson4
Program to find greatest prime number in n numbers? Huawei3
what is abstract method with example? Virtusa5
What are interfaces?  1
How do you set security in applets? Wipro1
can we declare private class in java file?  6
Hi Friends, Can u give few interview questions which relates ArrayList and Hashmap. I mean how to link ArrayList and HashMap.I know this is not good way of asking questions like this , but i need Microsoft1
1).what is the difference between below examples String s="vijay"; String s=new String("vijay"); TCS11
how to minimize the functionality to will not force garbage collector?  2
what is the difference between Java Command Line and C command Line?  1
what are ER diagrams?  2
Is there any use of an abstract class which has no methods and no attributes? Wipro1
what is multithreading? Virtusa4
I have an HashMap object, which has with key and value pair. It has 10 keys and values in that object. Now the question is I want insert new key and value in middle or any where in that list but not at the end or at the top. Is it possible or not. If yes how can we achieve this one? Huawei1
why java does not support mulitple inheritance directly? TCS2
 
For more Core Java Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com