The JDBC-ODBC Bridge should be considered only a transitional solution. For large-scale applications
you should consider one of the type 2, type 3, or type 4 drivers.
For intranet applications it would be useful to consider type 2 drivers. But since type 3 and type 4 drivers show significantly better performance than type 2 drivers and the trend is towards development of more robust pure-Java drivers, it might be useful to evaluate type 3 or type 4 for intranet situations too.
For Internet-related applications, there is no option but to use type 3 or type 4 drivers. Type 3 drivers are best suited for environments that need to provide connectivity to a variety of DBMS servers and heterogeneous databases and that require significantly high levels of concurrently connected users where performance and scalability are major concerns. Type 4 drivers are generally aimed at the workgroup level.
Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD