Is it advisable to use Jdbc-Odbc bridge for larger applications where production on Win-NT. What are the Type4 (pure Java) drivers for SQLServer7.0 which supports JDBC2.0 ? If so, where can I get. Which version of drivers support JDBC3.0 for SQLServer7.0. Thx.
As I understand it, the JdbcOdbcDriver used for the bridge enforces synchronisation which means it is not something you'd want to do with a large application. There is a page at the sun site that lists all of the drives they currently know about and it is here --> http://industry.java.sun.com/products/jdbc/drivers All the info you need should be available there. Dave.
Which version of drivers support JDBC3.0 for SQLServer7.0.
Given that the JDBC 3.0 specification has not yet been finalized, it is highly unlikely that you will find any JDBC 3.0-compliant driver at all at this stage. I would advise you to take a look at NetDirect as soon as JDBC 3.0 is finalized... Franck Rasolo Independent Java Consultant London, UK
The type 1 driver, JDBC-ODBC Bridge, translates all JDBC calls into ODBC (Open DataBase Connectivity) calls and sends them to the ODBC driver.The performance is degraded since the JDBC call goes through the bridge to the ODBC driver, then to the native database connectivity interface. The result comes back through the reverse process. Considering the performance issue, type 1 drivers may not be suitable for large-scale applications. Secondly the ODBC driver and native connectivity interface must already be installed on the client machine.
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.