[AAA-221] Upgrade H2 database to 2.1.210 Created: 09/Mar/22  Updated: 17/Jan/23  Resolved: 06/Jul/22

Status: Resolved
Project: aaa
Component/s: General
Affects Version/s: None
Fix Version/s: 0.16.0

Type: Task Priority: Highest
Reporter: Robert Varga Assignee: Robert Varga
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by AAA-187 aaa datastore failures when writing d... Resolved

 Description   

There is a new major version (2.1.210) of H2 database, but it is not backwards compatible.

Unfortunately this major upgrade also introduces system tables which directly conflict on three out of our four tables. This means that the database cannot be directly upgraded.
The tables are renamed as DOMAINS -> AAA_DOMAINS, GRANTS -> AAA_GRANTS, ROLES -> AAA_ROLES and USERS -> AAA_USERS.
Note that AAA_DOMAINS.enabled and USERS.enabled are now a BOOLEAN.

 Comments   
Comment by Robert Varga [ 03/Jul/22 ]

Unit tests are failing for some reason. I suspect the lifecycle handling is slightly different.

Generated at Wed Feb 07 19:08:57 UTC 2024 using Jira 8.20.10#820010-sha1:ace47f9899e9ee25d7157d59aa17ab06aee30d3d.