Hi,
Sun provide type-1 driver for just testing purpose, you never relay on
type-1 driver for development purpose. According to my knowledge, Type-4
driver is best driver for Java 2 platforms, Although your driver selection
is very according to your Java Applications.
If you use pure Java application then better to go with Type - 2 driver.
This Java application is traditional client server application, in this
application client connect to the server. This driver use Native Language
Interface so it's not pure Java driver but for client server application
this driver will increase your performance. Major drawback of this driver
is, when you change your platform from Windows to Linux or vice versa then
you have to find Linux version of this driver, because this driver use OS
specific native interface.
If you develop Web Application using JSP or you develop Applet then you use
Type-4 driver. This driver is pure Java driver. When you use Type-4 driver
in Applet then along with applet this driver is download at client side. So
in Web application and in Applet this driver increase your performance. You
may use this driver in above client server application, but performance is
reduce as compare to Type-2 driver but vice versa is not true.
I hope this will help you.
Regards,
Bhavesh Vakil.
----- Original Message -----
From: Sunil Roy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 03, 2000 9:34 PM
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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
===========================================================================
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
