# Transaction Group with H2 in memory database errored

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-with-h2-in-memory-database-errored/19313>\
**Category:** Ignition\
**Created:** [August 18, 2018, 4:16am UTC](https://forum.inductiveautomation.com/t/transaction-group-with-h2-in-memory-database-errored/19313 "2018-08-18T04:16:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\
**Post date:** [August 18, 2018, 4:16am UTC](https://forum.inductiveautomation.com/t/transaction-group-with-h2-in-memory-database-errored/19313/1 "2018-08-18T04:16:52Z")

</div>

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.