Types of JDBC technology drivers
JDBC technology drivers fit into one of four categories:
1 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, see JDBC-ODBC Bridge Driver.
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 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 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.
For further information on the topicc, visit
http://java.sun.com/products/jdbc/driverdesc.html
and associated links.
Tony Shen
> ----------
> From: Majid Khojastehpour[SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list about Java Server Pages specification and
> reference
> Sent: Tuesday, August 08, 2000 9:51 AM
> To: [EMAIL PROTECTED]
> Subject: what is type 4 driver and type 2 driver?
>
> Hi all,
>
> What is type 4 driver and type 2 driver? I have never heard them.
>
> Thanks,
> Majid
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
