Well - Db2 team assumed that for connectivity using JDBC/SQLJ - a complete package called IBM Data Server Driver for JDBC and SQLJ is an appropriate package. It does provide complete development and execution environment.
Whether it would be convenient/feasible/appropriate to maintain a repository of stricte JDBC/SQLJ drivers - it would be best answered by Product Planner - which is completely out of our (you and me) jurisdiction :-)
Original Message:
Sent: Tue August 29, 2023 06:57 AM
From: Ulf Weiland
Subject: JDBC Driver for DB2 accessible from Maven
Thanks Jan,
Though this is mostly for our users. We will need a more permanent/stable location for the drivers. Preferably a Maven repository.
My thought is that IBM are probably losing customers due to this issue.
Thanks for taking the time to answer though.
Regards
Ulf
------------------------------
Ulf Weiland
Original Message:
Sent: Fri August 25, 2023 05:39 PM
From: Jan Nelken
Subject: JDBC Driver for DB2 accessible from Maven
Hi Ulf,
If you are interested in Db2 JDBC driver for Db2 LUW, then version 4.32.47 of db2jcc4.jar is bundled with Db2 V11.5.8 CSB build available from:
https://www.ibm.com/support/pages/download-db2-fix-packs-version-db2-linux-unix-and-windows
Db2 V11.5.8 CSB identifies itself as"
"DB2 v11.5.8000.7748", "special_32821"
------------------------------
Jan Nelken
Original Message:
Sent: Thu August 24, 2023 07:06 AM
From: Ulf Weiland
Subject: JDBC Driver for DB2 accessible from Maven
Hi Yves-Antoine,
Thanks for the answer. The page you sent me refers to a version Db2 v11.5.8 of the database and the download bundles a lot artifacts and seem to be a special packaging. The DB2 JDBC Driver is a separate product with its own release cycle. According to IBM documents it is supposed to be backward compatible with all older versions of the DB2 database (LUW and z/OS).
I was searching for a repository with that product. The maven repository previously mentioned seems not be maintained any more.
Frankly I don't think this is rocket science, IBM should be able to have this managed on a driver product level.
Thanks for the effort!
Regards
Ulf
------------------------------
Ulf Weiland
Original Message:
Sent: Thu August 24, 2023 06:07 AM
From: Yves-Antoine Emmanuelli
Subject: JDBC Driver for DB2 accessible from Maven
Hello Ulf,
Version 4.32.28 relates to the driver and version 11.5.8.0 relates to the DB2 Database product.
You can safely download the latest JDBC and SQLJ drivers from this page :
https://www.ibm.com/support/pages/node/6856211#32821
There used to be a mapping between the driver and database product versions, but I cannot find it...
Hope this helps :-)
Yves-Antoine Emmanuelli
------------------------------
Yves-Antoine Emmanuelli
Original Message:
Sent: Wed August 23, 2023 08:54 AM
From: Ulf Weiland
Subject: JDBC Driver for DB2 accessible from Maven
The page "IBM® Data Server Driver for JDBC and SQLJ versions and DB2" (I believe the driver works for DB2 LUW as well ) states the driver latest version is 4.32.46. Is there a Maven repository delivering this driver (and all versions of the driver)?
We have previously downloaded the driver from https://mvnrepository.com/artifact/com.ibm.db2/jcc which lists the latest version as 11.5.8.0 (Updated Oct 25, 2022 ). Apparently the 11.5.8.0 packages the "IBM Data Server Driver for JDBC and SQLJ 4.32.28" which seem to be outdated.
If this repository is not maintained where can one download the latest driver?
The page DB2 JDBC Driver Versions and Downloads seems outdated as it only lists drivers for DB2 up to version 11.5.
Having a central place (preferably Maven) for access to Driver artifacts is crucial for the decision on what database product to use/invest in.
Having users searching for the correct driver by endless googling will certainly increasing the probability of the users choosing another database engine.
I am working for a company delivering a product that uses JDBC drivers extensively. The product is used by over 28K companies (6milj downloads) world wide. Having JDBC drivers accessible through Maven makes life much easier for these users. As stated this might also affect the likelihood for them to choose DB2
Kind regards
Ulf
------------------------------
Ulf Weiland
------------------------------