[MODWRKFLOW-12] H2 does not work but Postgresql does. Created: 31/Jan/24  Updated: 01/Feb/24

Status: In Review
Project: mod-workflow
Components: None
Affects versions: None
Fix versions: None

Type: Tech Debt Priority: P4
Reporter: Kevin Day Assignee: Kevin Day
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Sprint: Aggies Sprint 2
Story Points: 0.5
Development Team: Aggies
RCA Group: TBD

 Description   

Using H2 is convenient for local development, however, H2 fails to work when configured properly.

The problem is that for H2, the word key is reserved.

The class EmbeddedVariable uses the word key for a column name.
The solution (suggested by William Welling) is to change the column name, such as like this:

@Embeddable
public class EmbeddedVariable {
...
  @NotNull
  @Size(min = 4, max = 64)
  @Column(name = "vkey", nullable = true)
  private String key;

Generated at Thu Feb 08 22:31:35 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.