Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  JDBC Driver for DB2 accessible from Maven

    Posted Wed August 23, 2023 10:14 AM

    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
    ------------------------------


  • 2.  RE: JDBC Driver for DB2 accessible from Maven

    Posted Thu August 24, 2023 06:07 AM

    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
    ------------------------------



  • 3.  RE: JDBC Driver for DB2 accessible from Maven

    Posted Thu August 24, 2023 07:07 AM

    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
    ------------------------------



  • 4.  RE: JDBC Driver for DB2 accessible from Maven

    Posted Fri August 25, 2023 05:39 PM

    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
    ------------------------------



  • 5.  RE: JDBC Driver for DB2 accessible from Maven

    Posted Tue August 29, 2023 06:57 AM

    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
    ------------------------------



  • 6.  RE: JDBC Driver for DB2 accessible from Maven

    Posted Tue August 29, 2023 02:15 PM
    Edited by Jan Nelken Tue August 29, 2023 07:19 PM

    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 :-)



    ------------------------------
    Jan Nelken
    ------------------------------