File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC ODBC" Watch "JDBC ODBC" New topic


Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

Okay, I'm a little confused as to why you want an ODBC driver for DB2, when DB2 ships with two very sexy drivers, the .net driver and the .app driver. Both of these drivers are in the file, and if you have on your Java classpath, you can connect very easily to db2.

Using the JDBC-ODBC bridge with DB2 combines all of the worst features of db2 with the worst features of odbc. Not a way that I would go.

Is your main concern with just connecting to db2 from a Java application? If it is, throw away everything you know about odbc, and do it with JDBC.

Expand on what you are trying to accomplish,and maybe I can help you out more.


-Cameron McKenzie
Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24195

This sounds like a reply to something; maybe another thread here in "Other Java Products" which was moved to JDBC several days ago and so is now closed. In any case, I'm going to move this to JDBC and hope somebody over there knows what it's referring to.

[Jess in Action][AskingGoodQuestions]
I agree. Here's the link:
subject: JDBC ODBC
jQuery in Action, 3rd edition