I am using openHAB 2.3.0 with the jdbc-mysql persistence because the mysql persistence does not understand the config tableUseRealItemNames.
It is basically working, but cannot create the tables for some of the items, others work. Example for error:
java.sql.SQLException: Invalid default value for ‘value’ Query: CREATE TABLE IF NOT EXISTS unifiredminote5_lastseen_8 (time TIMESTAMP(3) NOT NULL, value TIMESTAMP(3), PRIMARY KEY(time)) Parameters: 
Any ideas? Thanks!
This would be the correct SQL:
CREATE TABLE IF NOT EXISTS unifiredminote5_lastseen_8
(time TIMESTAMP NOT NULL, value TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(time))
This would also be correct:
CREATE TABLE IF NOT EXISTS OpenHAB.unifiredminote5_lastseen_8
(time DATETIME NOT NULL, value DATETIME, PRIMARY KEY(time))
So, I was able to fix it by configuring this in jdbc.cfg:
sqltype.DATETIME = DATETIME
So, the default of TIMESTAMP(3) is not correct for MySQL, at least not for the current version.