ID lookup field in GORM in grails

Question

I am new to Grails and GORM and I am trying to One to Many relationship but not with default id field. Here is my scenario:

Table structure in the database:

USERPROFILE

iduserprofile
username

ROLE

idrole
rolename

USER_ROLE

iduserprofile
idrole

Domains:

class Userprofile {

long iduserprofile
String username

    static mapping = {
    datasource 'ALL'
    id name: 'iduserprofile'
    version false
}

class Role {

long idrole;
String rolename;

static mapping = {
    datasource 'ALL'
    id name: 'idrole'
    version false
}

}

class UserRole {

Userprofile user
Role role

static mapping = {
    datasource 'ALL'
    version false
}

}

When I try to get the user or role object from UserRole domain, it is always looking for user_id or role_id in the USER_ROLE table. Why is it not looking for iduserprofile or idrole? How can i change the code to look for isuserprofile or idrole?

Thanks

ikumen ikumen · Accepted Answer · 2013-07-08T18:17:36

GORM by convention will use/generate id as identifier for your domains. If you have legacy tables or just a desire to break convention, you'll need to specify your custom column names. For example for Role mapping, add the following:

static mapping = {
  datasource 'ALL'
  id name: 'idrole', column: 'idrole'
  version false
}

ID lookup field in GORM in grails

2 Answers