eclipse-vertx / eclipse-vertx/vertx-sql-client

Add support for IBM Power System i

Open
#1,497 5 comments 0 reactions 0 assignees View on GitHub
enhancement help wanted module:db2
Dominant language
Java
Stars
912
Forks
212
Avg merge
17h 30m
Merged PRs (30d)
3

Description

#### General

We're encountering issues using Reactive Hibernate with Vert.x reactive db2 client and DB2 hosted on IBM Power i (AS400) v7.4. It appears that the Vert.x Reactive DB2 Client explicitly supports only DB2 on Linux, Unix, and Windows and and possibly DB2 for z/OS as mentioned [here](https://vertx.io/docs/vertx-db2-client/java/).

#### Problem Description:

When attempting to connect, the server's release version string on IBM Power i begins with "V" (e.g., V07R04M00). The Vert.x reactive db2 client expects the release version to start with either SQL (for Linux/Unix/Windows) or DSN (for DB2 z/OS). This mismatch triggers the following exception:
`java.lang.IllegalArgumentException: Received unknown server product release level: V07R04M00`

As a result, the DB connection initialization immediately fails.

#### Environment:

Reactive Hibernate

Vert.x

IBM Power i v7.4

#### Feature
Is the lack of support for DB2 on IBM Power i due to known compatibility issues or simply because it is a proprietary system and hasn't been tested/supported yet?

Clarification on this point would help us understand if there are inherent limitations or if future support could be expected.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.