How-to upgrade from MySQL 5.7.x to 8.x

If you used LUY with MySQL 5.7.x and want to upgrade MySQL to 8.x it is necessary to update your driver and a few settings in the properties.

Please change the following settings:

• Change the following properies in luy-db.properties:

  • hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

  • database.driver=com.mysql.cj.jdbc.Driver

  • iturm.datasource.config.driverClassName=com.mysql.cj.jdbc.Driver

• If iturm is used: Change the JDBC driver class in META-INF/context.xml for iturm:

  • driverClassName="com.mysql.cj.jdbc.Driver"

• As we don’t include JDBC drivers is the LUY release, they need to be updated to the version supporting MySQL 8.x manually