Hibernate version:3

Name and version of the database using: Oracle 8i

Can anyone give example of how to specify the mapping for <map> instead of a list or a set? My senario is mentoned below:

where:

PRODUCT (PRODUCT_CODE, DESCRIPTION)
PART (PART_CODE, DESCRIPTION)
PRODUCT_PART (PRODUCT_CODE , PART_ID)

In the Product.hbm.xml how to specify the mapping for PRODUCT_PART table via a <map> ?

pls help

thanks
Shanika

The Problem is not to give you an example for a map, but the example you are giving is a one-to-many relation between PRODUCT and PART. So you have one PRODUCT with a set or list of PARTs.

If you want to use a map than what should be the key and the value?

I was able to do this with using a Set. But now need to try it with a Map.


This is the way i gave the mapping which is in the Product.hbm.xml
:



I have DAO s and HBM s only for the PRODUCT and PART tables. PRODUCT_PART is a pure resolving table, which does not have a DAO and is mapped in the PRODUCT hbm.xml as shown above.


This gives an invalid column exception when a query is executed. But there arn't any mapping error at the JBoss start up.



thanks
Shanika

So you already answered your question and found a mapping.

If you want someone to have a look on your select than post the code and the exception and we'll see.