Changing GORM table name

grails gorm
Matthias Hryniszak picture Matthias Hryniszak · Jun 18, 2010 · Viewed 7.8k times · Source

I'm fighting to get the following mapping working in Grails 1.3.1 and MySQL:

class Login {

    int id
    String email

    static mappings = {
        table 'my_table'
        id column: "Mgr_id"
        version false
    }
}

No matter what I do the queries that are being issued refer to "schema.login" table instead of "schema.my_table". This is very frustrating... Can anyone answer why this might not be working?

Answer

Matthias Hryniszak picture Matthias Hryniszak · Jun 18, 2010

Please forgive my blindness... The static is called mapping not mappings... eh. Shame on me...

Block should be

static mapping = {
    table 'my_table'
    id column: "Mgr_id"
    version false
}

Related questions

Why do I get a "Null value was assigned to a property of primitive type setter of" error message when using HibernateCriteriaBuilder in Grails

I get the following error when using a primitive attribute in my grails domain object: Null value was assigned to a property of primitive type setter of MyDomain.myAttribute org.hibernate.PropertyAccessException: Null value was assigned to a property of …

Read More
Found shared references to a collection org.hibernate.HibernateException

I got this error message: error: Found shared references to a collection: Person.relatedPersons When I tried to execute addToRelatedPersons(anotherPerson): person.addToRelatedPersons(anotherPerson); anotherPerson.addToRelatedPersons(person); anotherPerson.save(); person.save(); My domain: Person { static hasMany = [relatedPersons:Person]; } any idea …

Read More
How to order by more than one field in Grails?

Is there a way to get a list ordered by two fields, say last and first names? I know .listOrderByLastAndFirst and .list(sort:'last, first') won't work.

Read More