There are four types of JDBC drivers each having its own functionality. They are classified based on how they access data from the database. They do not substitute one another.
JDBC-ODBC bridge driver- : It provides JDBC access via most ODBC drivers.
Native –API party : Java driver – It coverts JDBC calls into calls on the Client API for Oracle, Sybase, etc.
Native- protocol all –Java driver : It converts JDBC calls into the network protocol used by DBMS directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for intranet access.
Net-protocol all- Java driver : It translates JDBC calls into a DBMS independent net protocol which is then translated to DBMS protocol by a server. This net server middle-ware is able to connect all Java clients to many different databases.
Posted Date:- 2021-10-12 07:05:38
Why JDBC is needed once we have ODBC in hand?
Explain ODBC its Architecture?
How EJB Container handles exceptions?
What is Application level Exception in EJB?
What is Bean Managed Transactions?
What are the types of Enterprise Bean?
Which types of java classes can be mapped using @Lob annotation?
What are the different JDBC driver types?
What is enterprise information system?
What is Enterprise JavaBeans Query Language?
What is enterprise bean provider?
Define the term DDL, DML and DCL in Database Connectivity?
What is a Stored Procedure in JDBC?
What are the different properties of a Java Bean?
When will JavaBeans be supported on the [fill in the blank] platform/operating system?
What are the security implications for downloading Beans over the Internet?
Why do I get a duplicate name error when loading a JAR file?
What is the relationship between Sun s JFCs and JavaBeans?
Why nobody at Sun wants to read the messages sent to java-beans@java.sun.com?
Are there JavaBeans components available that I can buy today?
What kind of industry support exists for JavaBeans?
Why a component architecture for the Java platform?
Is JavaBeans a complete component architecture?
Is JavaBeans a complete component architecture?
Why are component architectures useful?
What is a Bean? Why is not a Bean an Applet?
Difference between java bean and bean?
What is property editor in java beans?
What are externizable interface?
What is bean persistance property?
Why do I get a NullPointerException when loading a JAR file into the BeanBox?