How to Map database table without id with grails domain

http://www.intelligrape.com/blog/2010/09/07/how-to-map-database-table-without-id-with-grails-domain/

How to Map database table without id with grails domain

Posted by Uday Pratap Singh

Recently I got a query regarding mapping a database table which do not have any id and version. For example the table have two varchar fields username and password nothing more than that.
Although it was something strange for me that table doesn’t have the id field. The good thing is that the username is a primary key in the table and this is not auto incremented user want to create it by his own method.

The good thing about grails is, in most of the cases you get your answer in the docs http://grails.org/doc/latest/ . So in this case we just need to change the id field in grails domain like this

class
 Test {

    String
 username
    String
 password
 
    static
 mapping =
 {

        id name: 'username'

        version false

        id generator: 'assigned'

    }

    static
 constraints =
 {

        username(
nullable: true
)

    }

}

and we are done .
Hope it helps
## Uday Pratap Singh ##
uday@intelligrape.com

http://www.IntelliGrape.com/
http://in.linkedin.com/in/meudaypratap