Neal, go for type 4.
Type 1 is slow and cumbersome. You also lose several meta-data related calls.
Type 2 (native) is fast but require specialized drivers (not portable).
Type 3 is great if you want to develop using several different databases.
Type 4 is fast, runs everywhere and all you need is a JAR and an URL.
Neal Cabage wrote:
>
> Does anyone know if there is performance differences between using a type1
> JDBC:ODBC driver and a native driver? I see other programmatic advantages
> but have not seen performance addressed.
>
> Thanks.
> Neal
===========================================================================
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
