Add SQL, CL, Pool, Connect tests and IN/INOUT/OUT support

[SanjulaGanepola]

Changes

• [x] Implement getPendingTransactions on SqlJob.java
• [x] Port more exceptions from the ts client as ClientException
• [x] Add tests for SQL queries, CL commands, connects, and tracing
• [x] #39
• [x] #38
• [ ] #43 <- I will fix this in a separate PR as this one is getting big. There will be several tests in this PR that fail without this fix.
• [x] IN/INOUT/OUT support
• [x] https://github.com/Mapepire-IBMi/mapepire-java/issues/42

The following tests are expected to fail for now until #43 is fixed:

[github-actions[bot]]

Dependency Review

✅ No vulnerabilities or license issues or OpenSSF Scorecard issues found.

Snapshot Warnings

⚠️: No snapshots were found for the head SHA 7055edc7f26f8b700c7ab16014b3cc842a317b66.

Ensure that dependencies are being submitted on PR branches and consider enabling retry-on-snapshot-warnings. See the documentation for more information and troubleshooting advice.

OpenSSF Scorecard

Package	Version	Score	Details
maven/org.mockito:mockito-core	4.11.0	:green_circle: 7.7	Details Check Score Reason Maintained :green_circle: 10 30 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 10 Code-Review :green_circle: 10 all changesets reviewed CII-Best-Practices :warning: 0 no effort to earn an OpenSSF best practices badge detected License :green_circle: 10 license file detected Branch-Protection :warning: -1 internal error: error during branchesHandler.setup: internal error: githubv4.Query: Resource not accessible by integration Signed-Releases :warning: -1 no releases found Security-Policy :green_circle: 9 security policy file detected Dangerous-Workflow :green_circle: 10 no dangerous workflow patterns detected Token-Permissions :green_circle: 10 GitHub workflow tokens follow principle of least privilege Vulnerabilities :green_circle: 10 0 existing vulnerabilities detected SAST :warning: 0 SAST tool is not run on all commits -- score normalized to 0 Pinned-Dependencies :warning: 0 dependency not pinned by hash detected -- score normalized to 0 Fuzzing :warning: 0 project is not fuzzed Packaging :green_circle: 10 packaging workflow detected Binary-Artifacts :green_circle: 10 no binaries found in the repo

Scanned Manifest Files

pom.xml

• org.mockito:mockito-core@4.11.0

[jonnyz32]

Opened https://github.com/Mapepire-IBMi/mapepire-java/issues/51 to keep track of remaining issues