Getting error ORA-00904: "THIS_". on model


New member
I am wiring 2 pre existing (hibernate) model classes to my Gails 1.3 app.
I get this error on both model classes. Interestingly in both cases the
error is flagged on the last column in each table.

How can I resolve this?

Here is one error msg in full and corresponding model class.

Error 500: Executing action
  • of controller [] caused exception: could not execute query; SQL [select this_.module_id as module1_2_0_, this_.abbreviation as abbrevia2_2_0_, this_.forum_id as forum3_2_0_, as name2_0_, this_.path as path2_0_, this_.product_id as product6_2_0_, this_.product_name as product7_2_0_ from hmm_module this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    Servlet: grails
    URI: /mmt_admin/grails/HMMModule/list.dispatch
    Exception Message: ORA-00904: "THIS_"."PRODUCT_NAME": invalid identifier
    Caused by: ORA-00904: "THIS_"."PRODUCT_NAME": invalid identifier
    Class: HMMModuleController
    At Line: [13]

    java.sql.SQLSyntaxErrorException: ORA-00904: "THIS_"."PRODUCT_NAME": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError(

    at oracle.jdbc.driver.T4CTTIoer.processError(

    at oracle.jdbc.driver.T4C8Oall.processError(

    at oracle.jdbc.driver.T4CTTIfun.receive(

    at oracle.jdbc.driver.T4CTTIfun.doRPC(

    at oracle.jdbc.driver.T4C8Oall.doOALL(

    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(

    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(

    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(

    @Table(name = "HMM_MODULE")
    public class HMMModule implements Serializable {

    @Column(name = "product_name", length = 12, nullable = false)
    private String productName;

    public HMMModule() {


    public void setProductName(String productName) {
    this.productName = productName;

    public String getProductName() {
    return productName;