Hello all,
Does anyone know how I can assign a sequence to an @AssociationTable? I’m using Oracle9iR2 and the latest version of Hibernate. I just need to assign <MySequenceName>.nextVal to each id column of my join table.

I’ve mapped a @ManyToMany relationship and can read my objects perfectly, but have to resort to using triggers to persist newly created objects. The trigger is causing a problem with another trigger I need to add to fix a different issue.

I have full freedom to use EJB3 or an XML mapping if it gets the job done. I'm also not adverse to inserting custom SQL into the mapping. I'd appreciate any hibernate-related suggestions.

Thanks in advance,
Steven

@AssociationTable is deprecated and is now @JoinTable
This is not possible as per the spec.
In Hibernate this will be possible using an @IdBag or something equivalent, but I need to do it.
For the other cases (ie set lists, maps) an extra ID doesn't really make sense since a PK is well defined.

I am trying to represent an IdBag using annotations.
Is there some alternative method to have a sequence in an association table?

Thanks,
-gabe

there is an open bug for me to implement Id bags in annotations.