hi sunil
actually every driver has its own adv and disadv
type 1 is bridge with odbc works fine with sqlserver and oracle also but it
is alway preferable to user database dependent driver like oracle thin for
oracle and club it with jdbc it is mostly used for prototyping
type 2 which is suitable for native database libraries connected to
databases
type 3 it is a three tier solution where middleware is involved it is pure
java driver and used to swap databases without affecting the client,
type 4 pure java driver and communicate directly with vendor database the
performance rating of this is high compared all above drivers it is most
flexible and most desirable arch.
i feel happy u got enough info for ur query
surya
----- Original Message -----
From: Sunil Roy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 3:04 AM
Subject: JDBC DRIVER TYPE
> Hai all,
>
> Could anyone pl. tell me whether we should use Type1 or 2 or 3 or 4 Driver
> for my Java programs?
> I am presently using MSSQL jdbc-odbc driver.
>
> What are the advantages of each?
>
> Sunil K. Roy
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> 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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
