Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas
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 ? | 7 Yes | 2 No |
Post New Answer View All Answers
Can a class with private constructor be extended?
What is the benefit of lambda expressions?
Write an algorithm program in java for the following question.. In a VLSI design techniques,they used rectangles to design circuits. EVery rectangle is to be placed according to x,y coordinates. Check whether or not two rectangles overlap each other. Here overlapping of rectangles is acceptable, if 1) one rectangle intersect with other. 2) one rectangle fully covers other. The time of algorithm should not exceed o(n logn).
Is java map thread safe?
How do you achieve polymorphism in java?
Does string is thread-safe in java?
What is the size of integer?
Can we use static class instead of singleton?
What is the significance of listiterator?
What is a map in java?
What is thread start?
I want my class to be developed in such a way that no other class (even derived class) can create its objects. How can I do so?
What java is used for?
What is the difference between delete and delete[]
What is the use of generics? When was it added to the Java development Kit?
