gorm - Grails, querying self-referencing table -


i have table self-referencing field:

class book{      integer id     string name     book version } 

when add books without "version", version field null have query book table records don't have version (their version field null), following code won't work:

def results = book.withcriteria{     eq("version", "null") }  

but i'm getting exception:

org.hibernate.propertyaccessexception: illegalargumentexception occurred calling getter of book.id 

what query should use?

version keyword in gorm used optimistic locking. modify domain , criteria below make criteria return appropriate results.

//domain

class book {     integer id     string name     book bookversion } 

//criteria

def book = new book(name: "test", version: null) book.id = 1 book.save(flush: true)  def results = book.withcriteria{     isnull("bookversion") }  assert results && results[0] instanceof book 

also note, bookversion in question of type book, cannot compared string null.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -