I know how to use Cross Tables in Hibernate, but now I have an extra attribute in my cross table, how can I retrieve that?
The attribute is used to save the order of some tasks.

This is my many-to-many part from my mapping file




My Cross table looks like this

At least someone should have had this kind of problem or am I the only one?

Hi,

I'm not sure if this is the problem, but I think bags are unordered. If you change it to an array, then I think it requires an index column to specify the ordering.

http://www.hibernate.org/hib_docs/nhibernate/html/collections.html#collections-ofvalues



Is that what you meant?

Regards,
Richard

you mean how to retrieve via code?

one solution would be to map that "cross table" to an object
and to replace the many-to-many association with 2 one-to-many's

by cross table you mean a table for many-to-many associations,
right?

What FlukeFan said is right for me although I have one small problem left:
it should be possible to add the same tasks, but when using the solution of FlukeFan, I get an exception:



When using a bag, I don't get this exception, I've tried to use list in case of array, but that has the same result.
Is there a way to avoid this error?
Edit: solved, I check now if I had already added the object in the list and I just add the same object again, instead of making a new object.