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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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
jdbc drivers?
 Question Submitted By :: Devnaga
I also faced this Question!!     Rank Answer Posted By  
 
  Re: jdbc drivers?
Answer
# 1
Type 1: JDBC-ODBC  Bridge
Type 2: Native API partly Java Driver
Type 3: Network protocol Driver
Type 4: JDBC Net pure Java Driver -> thin driver
 
Is This Answer Correct ?    2 Yes 0 No
Devnaga
 
  Re: jdbc drivers?
Answer
# 2
we have 4 types drivers
1)JDBC-ODBC bridge.
2)native-API partly Java technology-enabled driver.
3)A net-protocol fully Java technology-enabled driver
4)A native-protocol fully Java technology-enabled driver
-------------------------------------
1)JDBC-ODBC bridge:-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
----------------------------------------------------------------
2)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. 
--------------------------------------------------------
3)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.
--------------------------------------------------------------
4)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.
 
Is This Answer Correct ?    4 Yes 1 No
Srinivas
 
 
 
  Re: jdbc drivers?
Answer
# 3
Could anyone say in which circumsances do we use these drivers?
 
Is This Answer Correct ?    0 Yes 1 No
Devnaga
 
  Re: jdbc drivers?
Answer
# 4
Type 1: JDBC-ODBC  Bridge
Type 2: Native API partly Java Driver
Type 3: Network protocol Driver
Type 4: JDBC Net pure Java Driver 

Type 1 Drivers

Bridge drivers such as the jdbc-odbc bridge. They rely on an
intermediary such as ODBC to transfer the SQL calls to the
database and also often rely on native code. It is not a
serious solution for an application
Type 2 Drivers

Use the existing database API to communicate with the
database on the client. Faster than Type 1, but need native
code and require additional permissions to work in an
applet. Client machine requires software to run.
Type 3 Drivers

JDBC-Net pure Java driver. It translates JDBC calls to a
DBMS-independent network protocol, which is then translated
to a DBMS protocol by a server. Flexible. Pure Java and no
native code.
Type 4 Drivers

Native-protocol pure Java driver. It converts JDBC calls
directly into the network protocol used by DBMSs. This
allows a direct call from the client machine to the DBMS
server. It doesn't need any special native code on the
client machine.
Recommended by Sun's tutorial, driver type 1 and 2 are
interim solutions where direct pure Java drivers are not yet
available. Driver type 3 and 4 are the preferred way to
access databases using the JDBC API, because they offer all
the advantages of Java technology, including automatic
installation. For more info, visit Sun JDBC page

http://faisalmb.50webs.com/kbinterviewjdbc.html
 
Is This Answer Correct ?    1 Yes 0 No
Devnaga
 
  Re: jdbc drivers?
Answer
# 5
For Stand alone applications u can use the type-1 driver 
and when your db is network u canu use the Type-4 driver 
but i i dont know about other drivers could any can tell me 
when to use other drivers.
 
Is This Answer Correct ?    0 Yes 1 No
Narasimha
 
  Re: jdbc drivers?
Answer
# 6
Hi... There are 4 type of drivers .
1:JDBC-ODBC BRIDGE OR (TYPE1)
2:PARTLY JAVA DRIVER OR(TYPE2)
3:NET PROTOCOL DRIVER OR(TYPE3)
4:PURE JAVA DRIVER OR THIN DRIVER OR(TYPE4)
Among these drivers TYPE4 driver will give u sophisticated 
performance
 
Is This Answer Correct ?    0 Yes 1 No
Devarathnam
 
  Re: jdbc drivers?
Answer
# 7
1>jdbc-odbc bridge driver
2>part java-part native driver
3>intermediate d/b acess server driver
4>pure java driver
 
Is This Answer Correct ?    0 Yes 1 No
Laxmi
 

 
 
 
Other Core Java Interview Questions
 
  Question Asked @ Answers
 
How to eliminate duplicates from an array? Wipro3
Difference between Application and Applet ? Wipro3
What are init(), start() methods and whey they are called?  2
Consider that class classA, abstract class classB, and final classC have been defined.Which one of the following is correct? 1. classA extends classC implements classB 2. class A extends classB, classC 3. classA extends classB 4. classB implements classC  1
How can be define MARKER interfce in java  1
why java not supproting multiple inheritance?  5
What is Applet Flickering ? Persistent1
What is the use of Getters and Setters method ?  2
String is a immutable objects . it means that string does not change........... But it will be chang......... { String s="kapil"; String s1="raj"; String s=s1; then print(.......) The String has been changed .. how it is possible and why its called immutable objects  3
what is main difference between architecture,framework and design pattren  1
what is ennumaration? AMDOC1
Can we place the any object to key attribute of HashMap<key,value>? HCL3
What is the root class for all Java classes?  4
suppose string s1="rajnish"; string s2="bhaskar"; then what will be happend ? Fidelity6
What are types of Java applications?  4
public class AboutStrings{ public static void main(String args[]){ String s1="hello"; String s2="hel"; String s3="lo"; String s4=s2+s3; //to know the hash codes of s1,s4. System.out.println(s1.hashCode()); System.out.println(s4.hashCode()); // these two s1 and s4 are having same hashcodes. if(s1==s4){ System.out.println("s1 and s4 are same."); }else System.out.println("s1 and s4 are not same."); } } Somebody told me that, == operator compares references of the objects. In the above example even though s1 and s4 are refering to same object(having same hash codes), it is printing s1 and s4 are not same. Can anybody explain in detail why it is behaving like this? Thanks in Advance RavuriVinod TCS3
What is the difference between abstract class and interface?  2
what is difference betwwen hashmap and hashtable ? Fidelity6
what is auto boxing UHG1
How are this() and super() used with constructors?  4
 
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