Since this question got upvoted several times I would like to share what I did in the end: Since I had some more requirements to be implemented like security etc. I implemented a service layer which hides the domain objects from the controllers. I introduced a “dynamic DTO layer” which translates Domain Objects to Groovy … Read more
Part 1: Hibernate does the right thing. The query cache is not per entity. There is a single query cache region, shared by all queries, unless you set a specific region for a query. Each time a table is updated, its timestamp in the timestamps cache is updated. Each time a query is executed, the … Read more
Do I ever need to explicitly flush GORM save calls in grails? In short Yes!, if you want to use the object immediately as you are doing in your code. I faced same problem, so this is the picture I got after reading some refs. This is hibernate session issue. Hibernate session is created when … Read more
Hates_ criteria answer didn’t seem to work for me; putting “last,first” in order will only cause exceptions saying, “Property ‘last,first’ not found”. To order on two fields, you can do the following: def c = MyDomain.createCriteria() def results = c.list { and{ order(‘last’,’desc’) order(‘first’,’desc’) } }
getAll is an enhanced version of get that takes multiple ids and returns a List of instances. The list size will be the same as the number of provided ids; any misses will result in a null at that slot. See http://grails.org/doc/latest/ref/Domain%20Classes/getAll.html findAll lets you use HQL queries and supports pagination, but they’re not limited … Read more
Hibernate shows this error when you attempt to persist more than one entity instance sharing the same collection reference (i.e. the collection identity in contrast with collection equality). Note that it means the same collection, not collection element – in other words relatedPersons on both person and anotherPerson must be the same. Perhaps you’re resetting … Read more
According to this SO thread, the solution is to use the non-primitive wrapper types; e.g., Integer instead of int.