- Db2 JDBC Driver from DbSchema About JDBC Drivers. JDBC drivers are Java library files with the extension.jar used by all Java applications. Download Db2 JDBC Driver.
- Where do I download JDBC drivers for DB2 that are compatible with JDK. Db2jcc_license_cu.jar - and etc. At C: Program Files. Where do i download jdbc driver for.
As400 Jdbc Driver Download
DB2 JDBC Driver Versions and Downloads. JDBC and SQLJ package includes two JDBC drivers: db2jcc.jar. Ibm.db2.jcc.DB2Jcc -version. Or for drivers that are not.
Where can I find the redistributable version of the IBM DB2 Type 4 driver?I suppose this is the driver I would use to connect from a Java app (on windows) to DB2 on the mainframe?
6 Answers
You will not be able to connect to the mainframe with any redistributable JDBC driver. The driver pack consists of the actual type 4 driver (db2jcc.jar) and any number of license files of the form:
where the cisuz bit is variable, indicating the platforms that you're allowed to run on (iSeries, pSeries, System z, LUW and so on).
You're only likely to get cu with any freely distributable pack. You need the z to access DB2 on the mainframe and that's jealously guarded so you'll need to purchase a specific edition of DB2 Connect to get it. I think both PE and EE, the personal and enterprise editions, have this licence file.
Without that license file, the type 4 driver won't even try to talk to the server, you'll get an exception.
paxdiablopaxdiablo
IBM's Fix pack site has the 'IBM Data Server Driver for JDBC and SQLJ' which is nothing but the JDBC type 4 driver. Though the page I pointed to above happens to be the windows page, it's the same type 4 driver for all platforms, as should be expected.
I don't think any user/password is required.
TanktalusTanktalusThere is no need to download the JDBC driver separately it is already shipped with your DB2 product.You can easily find it at this location : C:Program FilesIBMSQLLIBjavadb2jcc.jar
db2jcc.jar is the driver name
Executable Jar File Download
You can get the drivers from the IBM site. You will need to have IBM ID and password to login (which you can obtain here). Zip file is about 7 MBs, in contains DB2 9.5 JDBC (type 2/4) and SQLJ drivers. Type 4 drivers are in db2jcc4.jar.However, you won't be able to connect to mainframes with this driver if mainframe is running DB2 for z/OS. To do so, you need at least to purchase DB2 Connect product, which will cost you about $500 minimum.
DasDas
If you're running on an AS/400 (or iSeries, or whatever the heck IBM is calling it these days), you'll probably want to get it from JTOpen.
Their toolbox replaces the old Java Toolbox and includes the JDBC drivers.
J.T. GrimesJ.T. GrimesIf I need any IBM JARs for DB2 or MQ, I usually just add it to the instructions that DB2 or MQ needs to be installed as a prerequisite along with a URL to download it.
The same goes for Java and many other not easily redistributable products as well.
This eliminates the need to worry about licensing issues as it would be on the onus of the user rather than the vendor to obtain the proper licenses.
Archimedes Trajano
Archimedes Trajano