Grails spring-security UserRole - Role fetch :'join'

Question

I have typical auto-generated by spring-security classes. + I want to select Roles together with UserRoles (table join) in one query, therefore I have added fetch: 'join'.

class User {
    def springSecurityService
    String username 
    String password 
    static hasMany = [userRoles: UserRole]
    Set<Role> getAuthorities () {
        if (!this.id) {return []}
        def userAuthorities= userRoles*.role
        return userAuthorities
    }
}

class UserRole implements Serializable {

    User user
    Role role
...
    static mapping = {
        table 'UserRole'
        version false
        id composite: ['role', 'user']
        user column: 'UserID'
        role column: 'RoleID', fetch: 'join'
    }
class Role {
    String authority
    String description

    static mapping = {
        cache true
        table 'Role'
        id column: 'RoleID', generator: 'identity'
        authority column: 'Authority'
        description column:  'Description'
    }

But I am still getting lazy initialization of Roles, only when I am accessing it in getAuthorities (). And it cause a 'N+1' query performance problem. Why does grails/hibernate ignores fetch: 'join' directive? Is it somehow depends on spring-security?

There are reasons it was designed like it was designed in the first place. — James Kleeh, Jan 11 '13 at 12:35

score 0 · Answer 1 · answered Jan 13 '13 at 00:40

As I interpret the official documentation, fetch is used by grails when you do a multi select for your User (findBy non unique attribute methods), and lazy for a unique result (get or findBy unique attribute methods)

Official documentation :

lazy : http://grails.org/doc/latest/ref/Database%20Mapping/lazy.html
Eager and Lazy Fetching : http://grails.org/doc/latest/guide/single.html#fetching

Did you try the lazy way ?

Another possibility is about implementation of spring-security itself what is a portage of java implementation and knowing no information from gorm (only translate java code, perhaps)

Grails spring-security UserRole - Role fetch :'join'

1 Answers1