Re: types of jdbc drivers

1999-12-14 Thread Ajay singh bhadauria

*   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



Re: types of jdbc drivers

1999-12-13 Thread Harichandra Reddy S

hi giri,
   tahnks for help.
At 12:02 PM 12/13/99 -0500, you wrote:
>check the Sun site @   java.sun.com/products/jdbc/drivers.html
>
>Giri
>
>
>
>
>Harichandra Reddy S <[EMAIL PROTECTED]>@JAVA.SUN.COM> on 12/13/99
>05:17:26 AM
>
>Please respond to "A mailing list for discussion about Sun Microsystem's
>  Java Servlet API Technology." <[EMAIL PROTECTED]>
>
>Sent by:  "A mailing list for discussion about Sun Microsystem's Java
>  Servlet API Technology." <[EMAIL PROTECTED]>
>
>
>To:   [EMAIL PROTECTED]
>cc:
>
>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
>

___
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



Re: types of jdbc drivers

1999-12-13 Thread Harichandra Reddy S

hi dave,
   tahnks for help.
At 12:03 PM 12/13/99 -0500, you wrote:
>http://java.sun.com/products/jdbc/drivers.html
>
>dave.
>
>Harichandra Reddy S wrote:
>
>> 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
>
>--
>David Mossakowski  [EMAIL PROTECTED]
>Programmer   212.310.7275
>Instinet Corporation
>
>"I don't sit idly by, I'm planning a big surprise"
>
>___
>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



Re: types of jdbc drivers

1999-12-13 Thread Giri Lingamarla

check the Sun site @   java.sun.com/products/jdbc/drivers.html

Giri




Harichandra Reddy S <[EMAIL PROTECTED]>@JAVA.SUN.COM> on 12/13/99
05:17:26 AM

Please respond to "A mailing list for discussion about Sun Microsystem's
  Java Servlet API Technology." <[EMAIL PROTECTED]>

Sent by:  "A mailing list for discussion about Sun Microsystem's Java
  Servlet API Technology." <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:

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



Re: types of jdbc drivers

1999-12-13 Thread David Mossakowski

http://java.sun.com/products/jdbc/drivers.html

dave.

Harichandra Reddy S wrote:

> 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

--
David Mossakowski  [EMAIL PROTECTED]
Programmer   212.310.7275
Instinet Corporation

"I don't sit idly by, I'm planning a big surprise"

___
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