[Hibernate] Mapping a Map question

[Ruben Matthews]

Hello,

I have a Company entity which has a Map property called "companyValues".

private Map<Competence, Integer> companyValues;

The companyValues property uses a Competence entity as its key. Competence is another mapped entity in the system.

Could you explain how I would create this mapping in the Company mapping?

This is the Competence, which is just an id and a name for now.

<hibernate-mapping package="nl.marktmonitor.skillskompas.skillskompas.model">
	<class name="Competence" table="COMPETENCE">
		<id name="competenceId" type="integer" column="COMPETENCE_ID">
			<generator class="native" />
		</id>

		<property name="name" type="string" not-null="true" />

	</class>
</hibernate-mapping>

And this is the Company with the companyValues mapping.

<hibernate-mapping package="nl.marktmonitor.skillskompas.skillskompas.model">
	<class name="Company" table="COMPANY">
		<id name="companyId" type="integer" column="COMPANY_ID">
			<generator class="native" />
		</id>
		<property name="name" type="string" not-null="true" />
		
		<map name="companyValues" lazy="true" table="COMPANY_VALUES">
			<key column="COMPANY_ID"/>
			<index column="COMPETENCE_ID" type="integer"/>
			<element type="integer" column="LEVEL" not-null="true" />
		</map>
	</class>
</hibernate-mapping>

Is the companyValues property in the Company mapping correct like this? Or will this result in an <Integer, Integer> Map? I mean, will Hibernate understand that I need the entire Competence object as the key and return a <Competence, Integer> Map or will it return a <Integer, Integer> Map with the COMPETENCE_ID as the first integer?

Thanks!

[Ruben Matthews]

Hah! I may have once again answered my own question right after I posted it. I guess the companyValues mapping was wrong and that I must use a <index-many-to-many> tag with a class attribute instead of the plain <index> tag?

<map name="companyValues" lazy="true" table="COMPANY_VALUES">
			<key column="COMPANY_ID"/>
			<index-many-to-many column="COMPETENCE_ID" class="Competence" />
			<element type="integer" column="LEVEL" not-null="true" />
		</map>