Setup on mysql

I use all windows x86 32 bit:
java 1.8.0_152; apache-tomcat-8.5.37; mysql-5.7.24;
on first tomcat startup ihave many:
java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
at com.axelor.meta.loader.ModuleManager.initialize(
at com.axelor.web.AppInitializer.init(

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.internal.ExceptionConverterImpl.convert(
at org.hibernate.internal.ExceptionConverterImpl.convert(
at org.hibernate.query.internal.AbstractProducedQuery.list(
at org.hibernate.query.Query.getResultList(

Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
at org.hibernate.loader.Loader.doList(

Caused by: java.sql.SQLException: Cannot convert value ‘2019-01-13 11:11:51.000000’ from column 7 to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(
at com.mysql.jdbc.SQLError.createSQLException(

Caused by: java.lang.IllegalArgumentException: nanos > 999999999 or < 0
at java.sql.Timestamp.setNanos(
at com.mysql.jdbc.TimeUtil.fastTimestampCreate(
at com.mysql.jdbc.ResultSetImpl.fastTimestampCreate(
at com.mysql.jdbc.ResultSetRow.getTimestampFast(


It seams to be a compatibility problem with timestamp field. Which version of Mysql and driver do u use ?
Is it not possible for u to use Postgres instead ?


java 1.8.0_152; apache-tomcat-8.5.37; mysql-5.7.24; mysql-connector-java-5.1.41.jar; axelor-erp-5.0.2.war.
I’m testing axelor with other people (same vesion but on Linux OS) and i work with Windows, i need to test the same tools;

You are using the lastest 5 release (db and driver) so normally it should work. I never test with Mysql so i’m sorry to not be able to help you more. Maybe someone else in this forum could do.

After installing MySQL on my system I was also unable to open it. It was showing some errors then I followed the suggestions from computer repair dubai and those suggestions from their expert technician were really helpful to solve my problem.

Could you share those suggestions with us?