grails, disable eager fetching when render a domain list as JSON

Question

model:

class Author{
   String name
   static hasMany = [books: Book]    
}

class Book{
  String name
  Author author

  static belongsTo = Author
}

Then i have a controller

class MyController{
  def authors{
     def authors = Author.getAll()
     render authors as JSON
  }

The problem is that even if the association Author-Books is lazy, N+1 queries are executed to fetch eagerly the books for each Author. What does it happen and how can i disable it

What is the full classpath of the JSON converted you're using? — Mike Sickler, Mar 12 '12 at 15:20
im using the default JSON implementation : grails.converters.JSON — user711189, Mar 12 '12 at 15:45

score 5 · Accepted Answer · answered Mar 12 '12 at 15:41

You are using default JSON converter, which tries to convert all fields of your model. Thats why it is doing all those selects.

You should implement your own JSON converter for you model which would not ask DB for books. You can do it in BootStrap like this:

import grails.converters.JSON
class BootStrap {
    def init = {servletContext ->
        JSON.registerObjectMarshaller(Author) {
            def returnArray = [:]
            returnArray['name'] = it.name
            return returnArray
    }

}

grails, disable eager fetching when render a domain list as JSON

1 Answers1