Hi,
i tried to persist a Map with something like this:

[code]
@CollectionOfElements(targetElement=Title.class)
@JoinTable(name = "titleList")
@org.hibernate.annotations.MapKeyManyToMany(targetEntity=Integer.class)
private Map<Integer, Title> titleList;
[/code]

Title is a simple Entity with only one string attribute (+PK) and the following error occurs:

org.hibernate.exception.SQLGrammarException: could not insert collection
Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DBPRAK06.TITLELIST
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert collection
(some lines ommited)

cheers gerb

----

bleeding edge versions of hibernate and dependencies

You misuse @MapKeyManyToMany here. Ordinary map entity mapping assumes that the entity is a map entry's value (your situation). @MapKeyManyToMany is used when the entity is an entry's key.

So, the mapping looks like the following in your case:

hi denis,
thank you for your help!

one more thing:

there is no such column as the key of the map!? where is it persisted? if I load the objects from the db, and do something like:

[code]
cd.printTitleList()
[/code]

the cd knows the track number of it's tracks!

thanks!!

welcome



@MapKey allows to specify what property of the referenced entity should be used as a map key. Entity id is used by default (i.e. Title id in your case). You may specify any other property as well. The property is stored/loaded in accordance with the mapping settings defined at the referenced entity ('Title' in your case)

I.e. if you have 'Title.tracksNumber' property at the java level and want to define many-to-many mapping for Map<Integer/*tracks number*/, Title> with join table which columns are PKs of the 'Cd' and 'Title' entities, you can use the following mapping:

thanks again,

and if i don't want to save the trackNumber in Title?
What happens if i put the same title in two differnt cd's with different track numbers?

Ok, I see your point. So, you're interested in track number only in context of particular album. You can use hibernate's @MapKey annotation then:



Here your join table contains PKs of the Album and Title entities (composite TITLE_LIST PK) as well as a TRACK_NUMBER column that backs the key of the 'titleList' map.

it's finally working! thanks for your patience...

some small additional info for db2:

you have to add "nullable=false":

@org.hibernate.annotations.MapKey(columns = { @Column(name = "trackNumber", nullable=false)} )

if it's not added, it is not possible to generate the table!

cheers gerb