Hi all,

Hibernate 2.1.1 on servlet on JonAS 3.3.5

I have already tried to look for answers in this forum and the FAQ, but I can't figure out how I have to proceed.

I have two classes Group and User. In Group I have a list of users and in User I have a list of the groups where the user is registered.

Here is the mappings:




And here are the tables schema:






I have a in Group method to addUserToGroup (and this was to try a method in User to addGroupToUser). But when I addUserToGroup, it does not update properly the index column in the table and so the list of groups couldn't retrieve properly too.

What I do for the business code side is:


Here is the result in the association table :
uid gid i j
useressai1 groupessai NULL 0
useressai1 group1 0 NULL
useressai1 group2 0 NULL
useressai2 groupessai NULL 0
useressai3 groupessai NULL 0


So the question is does hibernate allow to have such a configuration and if yes how have I to do in order to make it work.

Thanks in advance for possible response.

Vlad

Thing is that when the update are performed by hibernate on the association table, there are done only on one of the index because hibernate has no idea of the other (I mean the one related to the other class, Group for example if we were updating a User).

So is there a way to work arount this?

Vlad

Ok, I have just found in this forum the exact same case than me:
http://forum.hibernate.org/viewtopic.ph ... manytomany

But I have the same since I put inverse="true" for the list groups in the HibernateUser class.

So if the guj of the topic still read this forum, how did you make it?

Vlad

Ok like I said, I had the inverse="true" for the groups attributes in User class and when I add a user to a group, I also add the group to the user and update manually both.

When I retrieve the users just after having created them, now it finds the groups where the user are registered, but if I try to get the same user later in another session, I get a "null index column for collection exception" which is normal because the index in the table hasn't been updated and is still set to null.

Table content now:
uid gid i j
useressai1 groupessai 0 NULL
useressai1 group1 0 NULL
useressai1 group2 0 NULL
useressai2 groupessai 1 NULL
useressai3 groupessai 2 NULL


Any idea?

Vlad

I made some more testing and the index which is not updated even if for every operation on one of the lists I do the reverse operation (like user.add(group) and group.add(user)) is the one whose mapping is set to inverse="false".

So is this a bug, I don't think, so is this the expected behavior?

Vlad