ORA-00918

Brought to you by: ekkelenkamp

#16 ORA-00918

Status: open

Owner: nobody

Labels: None

Priority: 5

Updated: 2010-04-22

Created: 2010-04-22

Creator: Anonymous

Private: No

When importing from a legacy oracle db, we get an error in grails when using the list action in the generated controller.

java.sql.SQLException: ORA-00918: column ambiguously defined

The solution was to add in the mapping block:
name:"personId", generator: "assigned" for the id

We use oracle 10g express