Grails with Postgresql : can't create table in appropriate schema

Question

I want to use Grails 3.3.0 with a Postgresql database and also with three schema : openlearning, data and contrib. In domain classes, I specified the schema I want (see below). My issue is that tables are created only in public schema and not in the appropriate schema.

How can I do to create tables in the correct schema ?

note : Tables are all created in public schema.The other schema are created but are empty.They doesn't contain any table.

Question Domain class :

package fr.dr.openlearning
class Question {

 static mapping = {
 id generator: 'increment',params:[sequence:'incr']
 schema : "data"
}

application.yml :

dataSource:
  driverClassName: org.postgresql.Driver
  url: jdbc:postgresql://localhost:5432/openlearning
  username: postgres
  password: XXX
  pooled: true
  jmxExport: true


environments:
    development:
        dataSource:
            dbCreate: create-drop
        dataSources:
            data:
              dbCreate: create-drop
            contrib:
              dbCreate: create-drop

score 1 · Answer 1 · answered Sep 19 '17 at 17:45

1

In your application.yml file change the dbCreate: create-drop to dbCreate: create.

answered Sep 19 '17 at 17:45

kumar

41
2

Thanks to the answer but it is the same.Table are only create in public schema. – drieu Sep 19 '17 at 18:38

score 1 · Answer 2 · answered Sep 21 '17 at 06:29

1

Follow these steps:

Create a new schema in your database as Super Admin
Change your username and password as your new schema in application.yml
Change your dbCreate: create-drop to dbCreate: update

answered Sep 21 '17 at 06:29

Syed Sarek

373
2
12

Thanks for the answer, I will test it and I answer you later – drieu Sep 25 '17 at 12:24

Grails with Postgresql : can't create table in appropriate schema

2 Answers2