What are pros and cons of using of Type-2 and Type-4
Drivers over Type-1 driver?

Answers were Sorted based on User's Feedback



What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver?..

Answer / niranjanravi

they are fastest than type-1 drivers

Is This Answer Correct ?    2 Yes 0 No

What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver?..

Answer / chandrarekha

native API partly java driver(type-2 driver) doesn't have
the ODBC intermediate layer as the type 1 driver and the
native protocol pure java driver(type-4 driver) interacts
directly with the database(no native class libraries nor
driver as the intermediate layer) hence high perfomance
delivered compared to type-1 driver

Is This Answer Correct ?    1 Yes 0 No

What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver?..

Answer / eswar

Type1 driver is bridge driver which is not written in java.
So it is not Platform Independent. we canot use this for
mulitple purpose It will stick to one OS thats y it is used
only for practical purpose....

Is This Answer Correct ?    1 Yes 0 No

What are pros and cons of using of Type-2 and Type-4 Drivers over Type-1 driver?..

Answer / sujit kumar panda

type1 driver is platform depandent where type2 & type4 are
platform independent.also type1 driver is a thin driver
means it can handle very few request form client at time
but type 2 is a fat driver which is generally used in
banking solution for handling large numbers of request form
client.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More JDBC Interview Questions

While in CallableStatament using in the oracle my procedure is return no.of columns so in java how can i retrivbe the data and i wnat to view all data which is reetrive from my procedure

0 Answers   ADP,


Which type of JDBC driver is the fastest one?

0 Answers  


What do you mean by batch processing in jdbc?

0 Answers  


How to rollback a JDBC transaction?

0 Answers  


java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,






What are devices?

0 Answers  


JDBC Drivers properties?

1 Answers   Infosys,


What is “dirty read” in JDBC? Which isolation level prevents dirty read?

0 Answers  


What are the conditions applies to varchar variable, when using in procedures?

0 Answers  


What is JDBC?

3 Answers   Akamai Technologies,


What are the types of jdbc drivers that exist?

0 Answers  


Is java a database?

0 Answers  


Categories