Grails

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s: 1.1-beta3
• Component/s: Persistence
• Labels:

  None

If you have a many-to-many relationship, you cannot use a List collection type or you get the following error:

could not insert: [Bar]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [Bar]
org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [Bar]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [Bar]
at FooTests.testManyToManyBars(FooTests.groovy:51)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [Bar]
at $Proxy5.saveOrUpdate(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'bars_id' in 'field list'

1. 

   Bar.groovy

   11/Nov/08 2:47 PM

   0.1 kB

   Robert Fischer

2. 

   Foo.groovy

   11/Nov/08 2:47 PM

   0.1 kB

   Robert Fischer

3. 

   FooTests.groovy

   11/Nov/08 2:47 PM

   2 kB

   Robert Fischer

• Assignee:

  Graeme Rocher

  Reporter:

  Robert Fischer

• Created:

  11/Nov/08 2:47 PM

  Updated:

  18/May/11 8:41 AM

  Resolved:

  22/Jan/09 4:41 AM