Using a List for association gives error (DataIntegrityViolationException: not-null property references a null or transient value)

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Duplicate
Affects Version/s: 1.1-RC1
Fix Version/s: 1.3-RC1
Component/s: Persistence
Labels:
None

Description

Using these domain class to model a relationship of type List gives an error when trying to create a book class.

class Author {

    static hasMany = [books: Book]

    String name
    List books

    static constraints = {
        name(nullable: false, blank: false, maxSize: 50)
    }

    String toString() { name }
}

class Book {

    static belongsTo = [author: Author]
    
    String title
    BigDecimal price

    static constraints = {
        author(nullable: false)
        title(nullable: false, blank: false, maxSize: 50)
        price(nullable: false, min: 0.00, max: 999.99)
    }

    String toString() { title }
}

Error 500: org.springframework.dao.DataIntegrityViolationException: not-null property references a null or transient value: Book._Author_booksBackref; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: Book._Author_booksBackref
Servlet: grails
URI: /testerror/grails/book/save.dispatch
Exception Message: not-null property references a null or transient value: Book._Author_booksBackref 
Caused by: org.springframework.dao.DataIntegrityViolationException: not-null property references a null or transient value: Book._Author_booksBackref; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: Book._Author_booksBackref 
Class: script1235145028159 
At Line: [91] 
Code Snippet:

org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.DataIntegrityViolationException: not-null property references a null or transient value: Book._Author_booksBackref; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: Book._Author_booksBackref
	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:92)
	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:234)
	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1061)
	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:910)
	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:892)
	at groovy.lang.Closure.call(Closure.java:279)
	at groovy.lang.Closure.call(Closure.java:274)
	at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleAction(SimpleGrailsControllerHelper.java:363)
	at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.executeAction(SimpleGrailsControllerHelper.java:243)
	at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:203)
	at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:138)
	at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:88)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.codehaus.groovy.grails.web.servlet.GrailsDispatcherServlet.doDispatch(GrailsDispatcherServlet.java:264)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1124)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334)
	at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
	at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:247)
	at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:224)
	at org.codehaus.groovy.grails.web.mapping.filter.UrlMappingsFilter.doFilterInternal(UrlMappingsFilter.java:178)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.obtainContent(GrailsPageFilter.java:171)
	at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.doFilter(GrailsPageFilter.java:110)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.codehaus.groovy.grails.web.servlet.filter.GrailsReloadServletFilter.doFilterInternal(GrailsReloadServletFilter.java:101)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.codehaus.groovy.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:65)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:741)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)
Caused by: org.springframework.dao.DataIntegrityViolationException: not-null property references a null or transient value: Book._Author_booksBackref; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: Book._Author_booksBackref
	at BookController$_closure8.doCall(script1235145028159.groovy:91)
	at BookController$_closure8.doCall(script1235145028159.groovy)
Caused by: org.hibernate.PropertyValueException: not-null property references a null or transient value: Book._Author_booksBackref
	at $Proxy7.saveOrUpdate(Unknown Source)
	... 2 more

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Jeff Brown added a comment - 20/Feb/09 6:01 PM

Can you provide some details on what you are doing to trigger the error?

The following works with 1.1RC1 with the domain defined above:

$ grails shell
Welcome to Grails 1.1-RC1 - http://grails.org/
Licensed under Apache Standard License 2.0
Grails home is set to: /Users/jeff/Tools/grails

Base Directory: /Users/jeff/t/relstuff
Running script /Users/jeff/Tools/grails/scripts/Shell.groovy
Environment set to development
Groovy Shell (1.6.0, JVM: 1.5.0_16)
Type 'help' or '\h' for help.
-------------------------------------------------------------------------------------------------------------------------------------------------
groovy:000> auth = new Author(name: 'Jeff Brown')
===> Jeff Brown
groovy:000> auth.addToBooks(title: 'Book One', price: 21.12) 
===> Jeff Brown
groovy:000> auth.addToBooks(new Book(title: 'Book Two', price: 42.0))
===> Jeff Brown
groovy:000> auth.save(flush: true)
===> Jeff Brown
groovy:000> Book.count()
===> 2
groovy:000> Author.count()
===> 1
groovy:000>

Show

Jeff Brown added a comment - 20/Feb/09 6:01 PM Can you provide some details on what you are doing to trigger the error? The following works with 1.1RC1 with the domain defined above: $ grails shell Welcome to Grails 1.1-RC1 - http://grails.org/ Licensed under Apache Standard License 2.0 Grails home is set to: /Users/jeff/Tools/grails Base Directory: /Users/jeff/t/relstuff Running script /Users/jeff/Tools/grails/scripts/Shell.groovy Environment set to development Groovy Shell (1.6.0, JVM: 1.5.0_16) Type 'help' or '\h' for help. ------------------------------------------------------------------------------------------------------------------------------------------------- groovy:000> auth = new Author(name: 'Jeff Brown') ===> Jeff Brown groovy:000> auth.addToBooks(title: 'Book One', price: 21.12) ===> Jeff Brown groovy:000> auth.addToBooks(new Book(title: 'Book Two', price: 42.0)) ===> Jeff Brown groovy:000> auth.save(flush: true) ===> Jeff Brown groovy:000> Book.count() ===> 2 groovy:000> Author.count() ===> 1 groovy:000>

Hide

Permalink

Marcel Overdijk added a comment - 20/Feb/09 6:06 PM

I use the 2 domain classes as described and created 2 dynamic scaffolding controllers.

I can create and save an author successfully using the scaffolding controller/views,
but when I try to save a new book I get the error as posted.

Show

Marcel Overdijk added a comment - 20/Feb/09 6:06 PM I use the 2 domain classes as described and created 2 dynamic scaffolding controllers. I can create and save an author successfully using the scaffolding controller/views, but when I try to save a new book I get the error as posted.

Hide

Permalink

Marcel Overdijk added a comment - 21/Feb/09 12:36 PM - edited

I also tested against 1.0.4 and it gives the same error there.

I think the default scaffolding controller does not support using a List.
It's also explaned in the ref guide:

// This won't work!
def book = new Book(title: 'The Shining')
book.save()
author.addToBooks(book)

// Do it this way instead.
def book = new Book(title: 'Misery')
author.addToBooks(book)
author.save()

But maybe it should be documented that the List relation is not supported by the default scaffolding.

Show

Marcel Overdijk added a comment - 21/Feb/09 12:36 PM - edited I also tested against 1.0.4 and it gives the same error there. I think the default scaffolding controller does not support using a List. It's also explaned in the ref guide: // This won't work! def book = new Book(title: 'The Shining') book.save() author.addToBooks(book) // Do it this way instead. def book = new Book(title: 'Misery') author.addToBooks(book) author.save() But maybe it should be documented that the List relation is not supported by the default scaffolding.

Hide

Permalink

Marcel Overdijk added a comment - 21/Feb/09 12:40 PM

I'm thinking... but could we check during scaffolding genereation that we have a 'List' relation?

Then we could generate different controller code.

Instead of save the child itself, we can get the parent, add the child, and then save the parent.

Show

Marcel Overdijk added a comment - 21/Feb/09 12:40 PM I'm thinking... but could we check during scaffolding genereation that we have a 'List' relation? Then we could generate different controller code. Instead of save the child itself, we can get the parent, add the child, and then save the parent.

Hide

Permalink

Burt Beckwith added a comment - 28/Mar/10 7:58 PM

See ~~GRAILS-5351~~

Show

Burt Beckwith added a comment - 28/Mar/10 7:58 PM See GRAILS-5351

People

Assignee:

Burt Beckwith

Reporter:

Marcel Overdijk

Vote (3)

Watch (4)

Dates

Created:

20/Feb/09 9:51 AM

Updated:

28/Mar/10 7:58 PM

Resolved:

28/Mar/10 7:58 PM

Agile

View on Board