I am using hibernate for mapping my Virtuemart database to an object. I want to add the taxrate to an order item by using a double join.
I used the patch (
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1829)
for enabling to use the property-ref.
The problem is that i want to join on an join, which is possible in standard SQL but doesn't seem to be possible in Hibernate, i get an SQL error. The part of the mapping is as follows:
Code:
<join table="vm_product">
<key column="product_id" property-ref="productID" />
<property name="taxID" column="product_tax_id" />
</join>
<join table="vm_tax_rate" optional="true">
<key column="tax_rate_id" property-ref="taxID" />
<property name="taxRate" column="tax_rate" />
</join>
When i use this i get the following error:
Quote:
Unknown column 'orderitems0_.product_tax_id' in 'on clause'
Is there a way to fix this? Or is there a workaround? Or does anyone know how i can edit this in my current hibernate version (version 3.2.6).
Thanx in forward.
Timon
Login
FAQ
Search