aspose file tools*
The moose likes Java in General and the fly likes Dr. Watson and JDBC/ODBC Bridge Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Dr. Watson and JDBC/ODBC Bridge" Watch "Dr. Watson and JDBC/ODBC Bridge" New topic
Author

Dr. Watson and JDBC/ODBC Bridge

John Davis
Ranch Hand

Joined: Nov 02, 2000
Posts: 189
I get intermittent Dr. Watson errors (access exceptions) running servlets which access Microsoft Sequel Server via JDBC using the ODBC bridge driver. This is running in JRun 3.0 Professional version. Anybody got a clue on this one? If ODBC bridge driver is the problem, anybody know of a better driver on a free download basis?
Jesse Tilly
Ranch Hand

Joined: Jun 25, 2000
Posts: 37
The Type I driver isn't that good. Why the requirement for a zero-cost driver? Sounds like it's pretty expensive in terms of time working around the problems. I couldn't find anything on JRun's site mentioning included JDBC drivers (WebLogic comes with drivers)
http://www.openlinksw.com/info/pricing.htm
That's a pricing list for some MS SQL Server Type II/IV drivers. Looks like the max you could pay if $6000. If your site needed that many concurrent connections, $6000 is cheap insurance.
As for the Type I driver, it should work. Confirm using MS Query (or another ODBC-using application) to make sure that the client's ODBC configuration is correct. You may need an updated MS SQL ODBC driver or you may have a corrupted installation. Make sure the driver DLL isn't found in more than one place.
Jesse
Yoo-Jin Lee
Ranch Hand

Joined: Nov 01, 2000
Posts: 119
Hi,
What kind of exceptions are you getting? If you cannot connect to SQL Server perhaps you misspelled the driver or url name. Also, remember to register your ODBC driver data source. Check out:http://www.javaranch.com/ubb/Forum34/HTML/000279.html on how to do it.
There's lots of free JDBC drivers that you can use. From what I've experienced, many only allow 2 connections when you are testing them. To get a list of companies that offer JDBC drivers try Java's: http://industry.java.sun.com/products/jdbc/drivers
You may wish to try i-net's JDBC driver Type IV which supports SQL Server: http://www.inetsoftware.de/English/Produkte/JDBCTreiber/Default.htm
hope that helps,
Yoo-Jin.
Mirko Froehlich
Ranch Hand

Joined: Aug 21, 2000
Posts: 114
I can highly recommend the i-net driver mentioned in the previous posting. I have had lots of problems with the JDBC-ODBC bridge in general, and using it to access SQL Server in particular - it isn't meant for production anyway. Never ran into any problems with the i-net driver.
-Mirko

Originally posted by Yoo-Jin Lee:
Hi,
What kind of exceptions are you getting? If you cannot connect to SQL Server perhaps you misspelled the driver or url name. Also, remember to register your ODBC driver data source. Check out:http://www.javaranch.com/ubb/Forum34/HTML/000279.html on how to do it.
There's lots of free JDBC drivers that you can use. From what I've experienced, many only allow 2 connections when you are testing them. To get a list of companies that offer JDBC drivers try Java's: http://industry.java.sun.com/products/jdbc/drivers
You may wish to try i-net's JDBC driver Type IV which supports SQL Server: http://www.inetsoftware.de/English/Produkte/JDBCTreiber/Default.htm
hope that helps,
Yoo-Jin.

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Dr. Watson and JDBC/ODBC Bridge