Ubuntu 18.4, Version,
Ignition 7.9.8 (b2018060714).
openjdk version “1.8.0_181”
OpenJDK Runtime Environment (build 1.8.0_181-8u181-b13-0ubuntu0.18.04.1-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)
…
H2 db connection details:
JDBC Driver: H2 JDBC Driver
Connect URL: jdbc:h2:mem:test;DB_CLOSE_DELAY=-1
Username:
Password:
(when username and password are empty, connection becomes valid. If i enter the default username “sa” and empty password as per the H2 documentation, connection gets faulted).
Extra Connection Properties: Mode=MySQL
…
I have configured a TG with H2 in memory database, to update latest values . First time when i enable the TG, it automatically creates the table, logs data and everything works normal. When i Disable/Enable the TG, it faults and displays “Errored”. If i drop the table and Disable/Enable again, table is automatically created and everything works normal until i Disable/Enable and the cycle repeats. How to make TG work normal with H2?. Thanks.