jQuery in Action, 3rd edition
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
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 db2java.zip file, and if you have db2java.zip 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: 24199

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: http://aspose.com/file-tools
subject: JDBC ODBC
It's not a secret anymore!