Can not connect from spring boot to postgresql schema - 'org.postgresql.util.PLSQLException: ERROR: schema "test" does not exist'

Question

I have postgresql database, version 11. There I created database schema 'test'. Sql of that schema:

CREATE SCHEMA TEST
AUTHORIZATION "user-xxx";
ALTER DEFAULT PRIVILEGES IN SCHEMA test
GRANT ALL ON TABLES TO postgres;
ALTER DEFAULT PRIVILEGES IN SCHEMA test
GRANT ALL ON TABLES TO PUBLIC;

My config in spring boot:

datasource:
  platform: postgres
  jdbc-url: jdbc:postgresql://localhost:5432/BDA
  username: user-xxx
  password: user-xxx
jpa:
  generate-ddl: true
  properties:
    hibernate:
      default_schema: TEST

When launching the application I always get following exception:

Can not connect from spring boot to postgresql schema - 'org.postgresql.util.PLSQLException: ERROR: schema "test" does not exist'

If I don't specify the schema then it works with default database schema, and everything is ok.

Dmitry Bakhtiarov · Accepted Answer · 2020-05-01 09:33:51Z

1

I fond the reason. When jpa driver connects to PostgreSQL schema 'TEST' it lowercase the letters, and searches for 'test'. So, I renamed the schema to 'test', and the configuration setting to 'test', and was able to connect then.

answered May 1, 2020 at 9:33

Dmitry Bakhtiarov

4031 gold badge6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can not connect from spring boot to postgresql schema - 'org.postgresql.util.PLSQLException: ERROR: schema "test" does not exist'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related