Mapping a domain with a table that doesn't have a primary key

Question

I'm making a Grails application using GORM and as the title says I've come across a table that doesn't contain a primary key that I need to map in my domain. I know it requires an ID but in this case what can I do to get around it? I've searched and searched but haven't found an answer.

Regards,

Jamie

Answer 1

Ideally you should always have a primary key in your table.

If for some reason it's completely impossible to create one, I've seen in the Grails documentation that they allow composite identifiers. They don't recommend it, though, and I've never been forced to do it so proceed at your own risk!