joinTable(旧数据库)中多对多关系中复合键的Grails自定义名称

Question

如果一个域类具有复合 id，grails/gorm 似乎会忽略多对多关系连接表上的列名，例如:

class Following implements Serializable {
    ...
    static hasMany = [operationTypes:OperationType]
    static belongsTo = OperationType
    static mappedBy = [operationTypes:'followings']

    static mapping = {
        ...
        id composite: ['offer', 'user']
        offer column: 'offer_oid'
        user column: 'user_oid'
        operationTypes joinTable: [name: 'operationtype_following', key: ['favorite_user_offer_oid', 'favorite_user_user_oid']]
    }
}

和:

class OperationType implements Serializable {
    ...
    static hasMany = [offers:Offer, advices:Advice, followings:Following]
    static mappedBy = [followings:'operationTypes']

    static mapping = {
        ....
        followings joinTable: [name: 'operationtype_following', key: 'operationtype_oid']
    }
}

结果: MappingException: 外键 (FK_lhri681gwbef5a9y6ylhoakpj:operationtype_following [favorite_user_offer_oid, favorite_user_user_oid,Following_offer_id,Following_user_id])) 必须与引用的主键 (favorite_user [user_oid,offer_oid]) 具有相同的列数

那么为什么它不真正忽略列名而是将生成的列名添加到指定的列名中呢？

使用 Grails 2.4.3。任何帮助表示赞赏

Answer 1

我能够在 m:m 关系中使用复合外键。这使用以下映射语法。 SITE和MACHINE_FK是连接表的属性。

static mapping = {
        mstAttributeList {
            column name: 'SITE'
            column name: 'MACHINE_FK', sqlType: 'nvarchar2'             
        }           
        mstAttributeList joinTable: [name: 'MST_MACHINE_ATTRIBUTE', key: ['MACHINE_FK', 'SITE']]
}

static hasMany = [ mstAttributeList : com.gknsintermetals.mda.master.MstAttribute ]