* Types of JDBC technology drivers
JDBC technology drivers fit into one of four categories:
* 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.
TYPE 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.
TYPE 3 :
* 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.
TYPE 4:
* native-protocol fully Java technology-enabled driver converts JDBC
technology calls into the network protcol 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.
> Type 4 driver, or, "native protocol, pure Java" driver converts
>JDBC calls into the network protocol used by the database directly.
>A Type 4 driver requires no client software, so it's ideal for
>deployment to browsers at runtime. Each of these driver types has its
>own optimal usage scenarios, and will affect the way you deploy a given
>Java application. For example, because Type 4 drivers are 100% Java,
>use Java sockets to connect to the database, and require no client-side
>data access code, they are ideal for applets or other download
>situations inside a firewall
>----------
>From: Harichandra Reddy S[SMTP:[EMAIL PROTECTED]]
>Sent: Monday, December 13, 1999 3:47 PM
>To: [EMAIL PROTECTED]
>Subject: types of jdbc drivers
>
>hi all,
> i want information about how many types jdbc drivers are there(for
>ex
>type 2).significance of each of that.
> if any body knows please send me.if you know site than send that
>site.
> thanks,
> hari
>
>________________________________________________________________________
>___
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the
>body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
