Grails map domain class custom column name

Question

In my Grails project I'm connecting to an existing DB and I'm having the following structure

class Country {
  Integer country
  String countryCode
  String label
}

class Address {
  String countryCode
  ....
}

DB tables:

country table

id, version, country, country_code, label

address table

id, version, country_code, ...

I would like to have something like:

class Address {
  Country country
}

But it seems it is automatically looking for a column called country_id in the address table, I've tried using

static mapping = {
    country column: 'country'
}

But I'm still having the same result.

I know it would better to link it to the country.id but the DB is existing and I cannot modify it.

Anybody can help on this?

So is there a column country in your existing db table address? — Shashank Agrawal
– Shashank Agrawal, Commented Feb 9, 2016 at 17:50

monty_bean · Accepted Answer · 2016-02-09 19:02:19Z

1

If you use one-to-many relationship, you do not need the property declared. Under the class Country you can add

static hasMany = [addresses: Address]

And add

static belongsTo = [country: Country]

You don't need to add Country country field.

Then you can use addressInstance.country.countryCode in your view to display the data.

answered Feb 9, 2016 at 19:02

monty_bean

5141 gold badge5 silver badges27 bronze badges

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

2 Comments

Bagbyte Over a year ago

I've tried it but I'm receiving this error: ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: column this_.country_id does not exist

monty_bean Over a year ago

I just reread your post and you cannot change the table. Did you try mapping static mapping = { country column: 'country_code' }

Michal_Szulc · Accepted Answer · 2016-02-09 22:32:29Z

0

Check out this and add to domain class Country:

static mapping = {
     id name: 'country'
}

edited Feb 9, 2016 at 22:32

answered Feb 9, 2016 at 14:18

Michal_Szulc

4,2076 gold badges35 silver badges63 bronze badges

1 Comment

Bagbyte Over a year ago

I've tried it but I'm receiving this error: ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: column this_.country_id does not exist

Collectives™ on Stack Overflow

Grails map domain class custom column name

DB tables:

country table

address table

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

DB tables:

country table

address table

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related