Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where do I download JDBC drivers for DB2 that are compatible with JDK 1.5?

Tags:

jdbc

db2

Where do I download JDBC drivers for DB2 that are compatible with JDK 1.5? They seem to be very elusive and I hit many dead-ends at IBM's website. I managed to find versions of the driver bundled with some tools such as IBM Data Studio. Unfortunately, these versions either target a JVM too modern (JDK 1.6, leading to class version errors) or too ancient (JDK 1.2, leading to known bugs when run on JDK 1.5).

like image 812
Adam Paynter Avatar asked Oct 06 '11 17:10

Adam Paynter


3 Answers

I know its late but i recently ran into this situation. After wasting entire day I finally found the solution. I am suprised that I got this info on oracle's website whereas this seems nowhere to be found on IBM's website.

If you want to use JDBC drivers for DB2 that are compatible with JDK 1.5 or 1.4 , you need to use the jar db2jcc.jar, which is available in SQLLIB/java/ folder of your db2 installation.

like image 187
Mustafa sabir Avatar answered Sep 30 '22 09:09

Mustafa sabir


official Link of DB 2 JDBC Driver from IBM

like image 31
java acm Avatar answered Sep 30 '22 10:09

java acm


Right here: http://jt400.sourceforge.net/

This is what I use for that exact purpose.

EDIT: Usage Examples (minus exceptions):

// Driver initialization
AS400JDBCDriver driver = new com.ibm.as400.access.AS400JDBCDriver();
DriverManager.registerDriver(driver);

// JDBC Connection URL
String url = "jdbc:as400://10.10.10.10" + ";promt=false" // disable GUI prompting by jt400 library

// Get a Connection object (this is used to create statements, etc)
Connection conn = DriverManager.getConnection(url, UserString, PassString);

Hope that helps!

like image 39
BenCole Avatar answered Sep 30 '22 10:09

BenCole