Adding a new instance to a already existing collection

mmesh · **Joined:** Thu May 13, 2004 5:51 am **Posts:** 28

I have a many-to-many relationship between two tables A and B. I need to update A by setting a new B to the collection of Bs in A.

Set Bs = A.getB();
Bs.add(b)
session.flush();

My Bs collection is lazy. My problem is, when I add a new B to the collection, I am reading the entire collection and then adding to it! :( I dont want to be doing that, since I just need to save another B and link it up in A-B linking table. What should I be doing to avoid this?

Also every update, delete is accompanied by a prior select. I do not have any version/optimistic-locking/select before update set. What could be the reason for this?

--

rtayek · **Posted:** Mon Jun 14, 2004 7:38 pm

mmesh wrote:

I have a many-to-many relationship ...
My Bs collection is lazy. My problem is, when I add a new B to the collection, I am reading the entire collection and then adding to it! ...

it may be working as designed. someone posted the links below to answer a related question. iirc, you can prevent the lazy load by just pointing the child to the parent, but then hibernate may become out of sync with the db.

http://www.hibernate.org/155.html

http://www.hibernate.org/hib_docs/refer ... child.html

thanks