Update bundled jdbc drivers for java 17

Assignee

Reporter

Sprint

Description

Extracted as separate issue from .

Some jdbc drivers distributed with CDX Designer at the moment don't support Java 17, they may need to be upgraded

 
Oracle example: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

 

Steps to reproduce

None

Attachments

2

Activity

Show:

Kamil Kočí August 24, 2023 at 8:27 AM

Please test our dockerimage with Oracle db.

Kamil Kočí August 23, 2023 at 6:42 AM
Edited

h2. Oracle 

Oracle driver was changed from ojdbc8 version 21.1.0.0 to ojdbc11 version 23.2.0.0. I had to change validations of release becauze new version has 7.0MB and old driver has only 5.0MB.
h2. MSSQL

MSSQL driver was changed from 8.4.1.jre to 10.2.1.jre11.

Driver version 10.2 introduced a breaking change that applies Encrypt=true by default, ref:

https://stackoverflow.com/questions/73291498/sql-server-spring-boot-pkix-path-building-failed-unable-to-find-valid-certific

https://techcommunity.microsoft.com/t5/sql-server-blog/jdbc-driver-10-2-for-sql-server-released/ba-p/3100754

https://stackoverflow.com/questions/3674160/using-encrypt-yes-in-a-sql-server-connection-string-provider-ssl-provider

Release notes for the Microsoft JDBC Driver for SQL Server

Changes of MSSSQL server were reverted. Upgrade was moved to

Pavel Salamon July 31, 2023 at 4:21 PM
Edited

All the bundled drivers actually work on java 17 (they are covered by server tests).

But at least the oracle driver should be updated, we still use ojdbc8 version which is compiled for java 8. We should switch to ojdbc11 that's oficially supported for java 11 and 17.

This can be done in branch from master right now. No need to wait for java 17 branch. We'll see any potential issues in tests later.

Fixed

Details

Story Points

Priority

Fix versions

QA Testing

UNDECIDED
Created July 31, 2023 at 4:19 PM
Updated February 12, 2024 at 1:59 PM
Resolved August 24, 2023 at 8:26 AM