I was trying to do something I thought would be straight forward.. but after a couple of hours of trying, and browsing the forums.. I have nothing.

I am trying to create a relation table.

Basically:


<composite-id name="comp_id" class="InvoiceExportItemPK">
<key-many-to-one name="invoice" class="Invoice" column="INVOICE_ID"/>
<key-many-to-one name="invoiceExport" class="InvoiceExport" column="INVOICE_EXPORT_ID"/>
</composite-id>

Where:
InvoiceExportDetail {
INTEGER Invoice_ID (FK) PK1
INTEGER InvoiceExport_ID (FK) PK2
VARCHAR Notes
}

INVOICE {
INTEGER INVOICE_ID (PK)
...
}

INVOICE_EXPORT {
INTEGER INVOICE_EXPORT_ID (PK)
...
}

I have tried a number of variations with no luck.. and would appreciate any insight.

Thanks



-- ERROR:


net.sf.hibernate.MappingException: invalid join columns for association: invoiceExportDetail

So.. the problem was my one-to-one relation in the Invoice mapping.

After rereading (a dozen times) the post at: http://forum.hibernate.org/viewtopic.ph ... ssociation

I finally figured it out.

I will just give the following a try:


<many-to-one name="invoice"
class="Invoice"
insert="false"
update="false"
constrained="true">
<column name="invoice_id"/>
<column name="invoice_item_id"/>
</many-to-one>

Note: Some of my initial problem appears to be an issue with Middlegen. The <composite-id> tag had nested META tags and it was blowing up as well.

Cheers

If you are interested,
we've implemented such a case this week with "composite element",
just let me know if you want example mapping/value objects files.

Examples would be helpful and greatly appreciated.

Thanks

Troy