Foundry and DB2 - Is there a Relational Database Adapter?

HCL Volt MX Volt MX Forum
,
1

Hi,

I'm working with Volt MX Go 2.0.1 / Volt MX Foundry Console Version V9 SP5 FP15 HF1 2023.09 and want to get some objects from a DB2 database. I tried to use the relational database adapter for that, but the default adapters don't include DB2.

What I tried so far:

  1. I added the necessary Java library (db2jcc4.jar) to the middleware_home directory under <install-dir>/middleware_home/lib/database. Foundry accepts the driver and doesn't throw any errors on startup.
  2. I created a new object service (following screenshot) and referenced the JDBC driver class from my JAR. Database connection URL, user id and password are correct.
    When I test the connection, Foundry prints "Test connection failed with error : null".
    If I change anything in the object service configuration (e.g. provide wrong credentials or url) Foundry prints another error message, telling me that the URL is wrong. My DB2 database accepts connections from Foundry, I checked that, too.
  3. I checked the server logs, such as catalina.out, but I can't see any error messages that help any further.
    66554288 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554295 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554303 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554311 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554319 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554327 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554339 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 9 ms to scan 1 urls, producing 60 keys and 132 values
66554347 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554354 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554362 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554370 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554378 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554385 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554393 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554401 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554409 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554416 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 60 keys and 132 values
66554424 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554432 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 60 keys and 132 values
66554440 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 8 ms to scan 1 urls, producing 27 keys and 70 values
66554447 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 7 ms to scan 1 urls, producing 27 keys and 70 values
66554466 [https-jsse-nio-443-exec-4] INFO org.reflections.Reflections - Reflections took 19 ms to scan 1 urls, producing 27 keys and 70 values
66554467 [https-jsse-nio-443-exec-4] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-27 - Starting...
66554487 [https-jsse-nio-443-exec-4] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-27 - Start completed.

    Community-Pasted-Attachment-1697121487018.png1027×969 40 KB

Has anyone already implemented the connection to a DB2? Or are there plans to include DB2 as a default adapter?

2

I found a DB2 adapter in the Volt MX Marketplace: DB2 data adapter | HCL Marketplace (demo-hclvoltmx.com). The marketplace says that the adapter ist "Available in Fabric" and I guess that it is not included in Foundry for certain reasons.

Are there any plans to update the adapter from the marketplace?

3

Are there any news on the support of DB2 in Volt MX?