[CAY-2861] Derby version upgrade

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: 5.0-M2
• Component/s: Database integration
• Assignee: Unassigned
• Reporter: Nikita Timofeev
• Created: 26/Jun/24 09:57
• Updated: 06/Aug/24 12:32

Description

Here are a few things to keep in mind:

• there's only one particular version we could upgrade to: 10.15.2.0 as 10.16 requires Java 17 and 10.17 requires Java 19
• starting with 10.15 Derby requires additional dependency org.apache.derby:derbytools to use embedded driver
• tests related to DB structure (all integration tests and specifically db import related) start to fail as constraint naming (or DDL queries validation) changed, and constraint names should always be quoted

I'm attaching a patch with some experiments, but it's not ready yet