JDBC Drivers

[Anil Vupputuri]

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.

[David O'Meara]

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.

[Franck Rasolo]

Is it advisable to use Jdbc-Odbc bridge for larger applications where production on Win-NT.

Sun Microsystems recommends against the use of the JDBC-ODBC driver that is shipped with the Java 2 Platform in a production environment: http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html

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

[rani bedi]

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.

[rani bedi]

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.

[Anil Vupputuri]

Thx. for the responses. Are there any Type4 drivers(for SQL Server) avilable for free of cost.

[Simon Xu]

you may find it in the link:
http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm

[Anil Vupputuri]

Originally posted by Simon Xu:
you may find it in the link:
http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm

Nope. Iam looking for SQLServer7, not oracle.
Thx.

[rani bedi]

JTurbo 1.22 by Ashna http://www.jturbo.com/downloads.html
I-net Sprinta 2000 by I-net Software http://www.inetsoftware.de/English/produkte/JDBC2/default_main.htm