File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Drivers" Watch "JDBC Drivers" New topic
Author

JDBC Drivers

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
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.

SCJP 1.5, SCEA, ICED (287,484,486)
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

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
Greenhorn

Joined: May 29, 2001
Posts: 21
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


<i>Franck Rasolo<br />Independent Consultant<br />London, UK</i>
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
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.


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
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
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Thx. for the responses. Are there any Type4 drivers(for SQL Server) avilable for free of cost.
Simon Xu
Ranch Hand

Joined: Aug 16, 2000
Posts: 235
you may find it in the link:
http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm
Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
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
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
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
 
 
subject: JDBC Drivers
 
Similar Threads
Transaction Support in MySQL
Usage of Polymorphism feature in a project
Does JDBC works on all ODBC
jdbc driver needed
Database Independency