dimanche 28 octobre 2018

Tests using h2 and spring boot

I am developing an application using the Postgresql database, and using schema. In Entity, I use annotation @table (schema = 'schema name'). When I run the tests on h2, I'm getting the error:

Caused by: org.h2.jdbc.JdbcSQLException: Schema "schema name" not found; SQL statement:

I tried to create the file schema.sql, containing:

CREATE SCHEMA IF NOT EXISTS schema name AUTHORIZATION sa;
CREATE SCHEMA IF NOT EXISTS shcema name2... AUTHORIZATION sa;

but without success. Could anyone help?

Aucun commentaire:

Enregistrer un commentaire