How to fix error with H2 plugin (version 1.4.200) when run Spring tests: JdbcSQLSyntaxErrorException: Column "start_value" not found

Thaks to @EvgenijRyazanov! When I debug, I found that the dialect was wrong:

org.hibernate.dialect.SQLServer2012Dialect

and I reviewd the application-test.yml and add:

spring.jpa.properties.hibernate.dialect: org.hibernate.dialect.H2Dialect

It solves my problem!

spring spring-boot h2 spock

The workaround I used was to set (in the application.yml or application.properties):

jpa.properties.hibernate.ddl-auto to "create" or to "none"

Changing this setting solved the issue for me, but it changes the behavior of your database initialisation so it might not be what you want.

CodeHunter