Relation not found error with play and postgres (while table does exists)

Question

I have a table called ETL_TABLES which resides on the public schema. In my application.conf I have the following line:

hibernate.default_schema=public

that should mean the search_path of postgres is set to the public schema.

I have a class Tables, with the @Table(name="ETL_TABLES") annotation. But when I try to access the entity class, for example by Tables.findAll(); then the error says relation "public.etl_tables" does not exist.

The table is present on the postgres public schema, so what am I doing wrong here ?

Answer 1

make sure you have set postgresql dialect:

jpa.dialect=org.hibernate.dialect.PostgreSQLDialect