Interested to Buy Any Domain ? << Click Here >> for more details...
What are pros and cons of using of Type-2 and Type-4
Drivers over Type-1 driver?
- 4 Answers
- 8560 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How many types of JDBC drivers are there and what are they?
What are the considerations for deciding on transaction boundaries?
In JDBC, All the API?s are interfaces? Where is the actual implementation?
How can we execute stored procedures?
What is jdbc driver in java?
How to find that, a row is updated or not?
How can you make the connection using jdbc?
How can I get or redirect the log used by DriverManager and JDBC drivers?
How do I disallow NULL values in a table?
Is JDBC a language or Application?
How to execute bulk number of queries at once?
Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.
4 Answers Cybermate, Hexaware,
Core Java 
