Update bundled jdbc drivers for java 17
Assignee
Reporter
Sprint
Description
Steps to reproduce
Attachments
caused
relates to
Activity
Kamil Kočí August 24, 2023 at 8:27 AM
Please test our dockerimage with Oracle db.
Kamil Kočí August 23, 2023 at 6:42 AMEdited
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:
Release notes for the Microsoft JDBC Driver for SQL Server
Changes of MSSSQL server were reverted. Upgrade was moved to
Kamil Kočí August 21, 2023 at 1:29 PMEdited
Oracle
Driver was updated to ojdbc 23.2.0.0
Microsoft SQL Server
Requires a Java Runtime Environment (JRE) 1.8. Using JRE 1.7 or lower throws an exception.
PostgreSQL
MySQL
Connector/J 8.0 supports JRE 8 or higher.
IBM Db2
https://www.ibm.com/support/pages/which-db2-version-supports-java-8
APACHE DERBY
All classes were compiled by the javac from the 1.8.0_151 JDK, OpenJDK 64-Bit Server VM (build 25.151-b12, mixed mode)
Pavel Salamon July 31, 2023 at 4:21 PMEdited
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.
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