JDBC persistant data store error Unknown system variable 'tx_isolation'

I have recently upgraded to Ubuntu 20.04 and after upgrade the charts are not showing I am seeing the following in openhab.log: Unknown system variable ‘tx_isolation

I’m using MySQL v8 on Linux

I found a reference to say this variable is obsolete in Mysql 8


If you are using MYSQL8, try to show variables like 'transaction_isolation'. Mysql8 has renamed tx_isolation to transaction_isolation.

> 2020-12-27 14:41:07.876 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
> 2020-12-27 14:41:07.941 [ERROR] [org.openhab.persistence.jdbc        ] - bundle org.openhab.persistence.jdbc:1.14.0 (260)[org.openhab.persistence.jdbc(265)] : The activate method has thrown an exception
> com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Unknown system variable 'tx_isolation'
>         at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516) ~[?:?]
>         at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:118) ~[?:?]
>         at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71) ~[?:?]