org.springframework.dao.InvalidDataAccessApiUsageException when using grails dynamic finder

Question

Using Grails i'm trying a dynamic finder like this one

Policy.findAllByResourceAndUser(resource,user)

But When i call this, grails raise this exception

Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: object references
an unsaved transient instance - save the transient instance before flushing: gmedia.User;
nested exception is org.hibernate.TransientObjectException: object references an unsaved
transient instance - save the transient instance before flushing: gmedia.User

Do we need to save the parameter of the finder? Where i'm wrong?

Answer 1

http://www.grails.org/DomainClass+Dynamic+Methods#findAllBy*

Policy.findAllByResourceAndUser(resource,user)

capital "B" in "By" is the first thing I see wrong? Is that a type on the question?

 def res = new Resource(name:"resource name").save()
 def user = new User(name:"My Name").save()
 def policy = new Policy( user:user, resource:res, right: "right string").save()

 println Policy.findAllByResourceAndUser(res,user)

not elegant, but you get the idea, there must be a problem in the way you are saving your objects

your user object will "never" get saved with that code... you have to specify values for all of you properties or define your constraints appropriately. I think you should review the documentation for Domain Objects in Grails because it appears there are fundamental problems in your approach see http://www.grails.org/GORM+-+Creating+a+domain+class

Answer 2

@Aaron Saunders these are two domain class

class Resource{
static contraints={}
}

class User extends Resource{
  String name
  String password
  String email
  Date creationDate
  Date lastModicationDate
}

class Policy{
Resource resource
User user
String right
static mapping={
  user cascade:'all-delete-orpahn'
  resource cascade:'all-delete-orpahn'
}

Maybe it a consequence of the inheritance between User and Resource