what is difference between type 4 driver and type 1 driver?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the pointers in Java?
What is the purpose of finalization in java programming?
What is backdrop?
How do you remove duplicates from an array in java?
How do you classify Dialog Box?
How we can generate random numbers in java?
Can a class be a super class and a sub-class at the same time? Give example.
What is externalizable interface?
how we can use debug in myeclipse 6.0 in order solve the problems that exist in our program when there are 900 to 1000 pages in a web application
When is finally block not called?
List some oops concepts in java?
how a programmer confirms that the data submitted has been succesfully inserted into the database(either oracle or my sql).. How a programmer confirm if there is any problem with the program he wrote for insertion... ANS:--- >executeupdate method is having boolean return type, if anything goes wrong in data insertion or data updation, it would return false. otherwise, if it successfully inserts data into the database, it would return true NOW HOW TO I CHECK IN MY DURING EXECUTION WHETHER IT RETURNS TRUE OR FALSE... WELL IT WILL DISPLAY ANY MESSAGE OR NOT
What is JDBC Driver interface?How can you retrieve data from the ResultSet
What are the topics in advance java?
What is an abstract class and what is it’s purpose?