Hibernate version:
3.2.1, hibernate-annotations 3.3.0.ga

I'm using a Map<Entity, OtherEntity> property in an Entity. The annotation I'm using is the following:

@CollectionOfElements(fetch = FetchType.EAGER)
@MapKeyManyToMany(joinColumns = {@JoinColumn(name = "ID_ACCT", nullable = true) })
@JoinTable(name = "PROFILE_DETAIL", joinColumns = {@JoinColumn(name = "ID_COMM_TRANS") })
@Fetch(FetchMode.SUBSELECT)
@Column(name = "ID_CURVE")
private Map<Account, Curve> profileDetails;

The table PROFILE_DETAIL table is defined as:

PROFILE_DETAIL:
ID_PROFILE_DETAIL,
ID_ACCT, <- map key
ID_CURVE, <- map value
ID_COMM_TRANS

The problem is with the id_curve column, since the query done by hibernate is:

select profiledet0_.ID_COMM_TRANS as ID1_1_, profiledet0_.profileDetails_ID_CURVE as p ...

The column used by hibernate is "profileDetails_ID_CURVE" and not "ID_CURVE". Why hibernate adds the java property name to the column name? If I set the column name as the one used by hibernate, the mapping works fine, but I would like to avoid this kind of dependency.

Am I misusing the @MapKeyManyToMany/@Column annotations?

Cheers,
Filippo

replace @CollectionOfEmelents by @ManyToMany (I think that's what you want)
and the column name is defined by @JoinTable(inverseJoinColumn=...)

Thanks alot, you're suggestion was right.

Cheers,
Filippo