• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Dr. Watson and JDBC/ODBC Bridge

 
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.


 
reply
    Bookmark Topic Watch Topic
  • New Topic