Spring Hibernate Exception

I'm extracting the correct answer to this question from the comments of a different answer.

This Exception gets thrown because your used dialect doesn't match the database.

In your configuration you use

<beans:prop key="hibernate.dialect">org.hibernate.dialect.H2Dialect</beans:prop>

although you're accessing a MySQL database. You should use a MySQL dialect instead. E.g.

<beans:prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</beans:prop>

let you add this in the application.properties file

spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect

the the error will be disappeared.


Look at your error:

ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - could not get database metadata
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

You are mapping your MySQL to information_schema which is system database in MySQL and this database does not contain sequances table,

BTW, of the record, you need to take into consideration that MySQL does not have "CREATE Sequance" command.