Hi,
I meet an error "Illegal attempt to associate a collection with two open sessions". By searching related mails in this mail list, I find similar problem. However, i still cannot figure out my problem. I track the source code of hibernate, i find the error happens when handling proudcts collection, which has o2r mapping as follows:

<set name="products" table="PI_TMP_CP_BR_PRODUCT" cascade="none">
<key column="BR_OID"/>
<many-to-many column="PRODUCT_ID" class="com.tsmc.pdmcp.basicrecord.CPProduct"/>
</set>
. Could someone help?

Regards,
Rice



2004-06-11 14:03:20,020 [69831] INFO [ExecuteThread: '14' for queue: 'default']
- initialize persistence session
net.sf.hibernate.HibernateException: Illegal attempt to associate a collection w
ith two open sessions
at net.sf.hibernate.collection.PersistentCollection.setCurrentSession(Pe
rsistentCollection.java:262)
at net.sf.hibernate.impl.OnUpdateVisitor.processCollection(OnUpdateVisit
or.java:38)
at net.sf.hibernate.impl.AbstractVisitor.processValue(AbstractVisitor.ja
va:69)
at net.sf.hibernate.impl.AbstractVisitor.processValues(AbstractVisitor.j
ava:36)
at net.sf.hibernate.impl.AbstractVisitor.process(AbstractVisitor.java:93
)
at net.sf.hibernate.impl.SessionImpl.doUpdateMutable(SessionImpl.java:14
26)
at net.sf.hibernate.impl.SessionImpl.doUpdate(SessionImpl.java:1440)
at net.sf.hibernate.impl.SessionImpl.update(SessionImpl.java:1326)
at com.tsmc.pdmcp.persistence.PersistenceManager.change(PersistenceManag
er.java:169)
at com.tsmc.pdmcp.basicrecord.CPBasicRecordManager.changeCPBasicRecord(C
PBasicRecordManager.java:67)
at com.tsmc.pdmcp.usecase.basicrecord.CPBasicRecordUseCase.saveCPBasicRe
cord(CPBasicRecordUseCase.java:257)
at com.tsmc.pdmcp.usecase.basicrecord.CPBasicRecordUseCase.doOperation(C
PBasicRecordUseCase.java:78)
at com.tsmc.pdmcp.ejb.PDMCPSessionBean.doUseCase(PDMCPSessionBean.java:5
0)
at com.tsmc.pdmcp.ejb.PDMCPSessionBean_70supp_EOImpl.doUseCase(PDMCPSess
ionBean_70supp_EOImpl.java:37)
at com.tsmc.pdmcp.ejb.PDMCPSessionBean_70supp_EOImpl_WLSkel.invoke(Unkno
wn Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:296)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.jav
a:265)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest
.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
2004-06-11 14:03:20,170 [69981] ERROR [ExecuteThread: '14' for queue: 'default']
- com.tsmc.pdmcp.persistence.PersistenceException: net.sf.hibernate.HibernateEx
ception: Illegal attempt to associate a collection with two open sessions
2004-06-11 14:03:20,180 [69991] INFO [ExecuteThread: '14' for queue: 'default']
- closing persistence session

Hi,

I find the error of this problem. Thanks.

Regards,
Rice

Hi,

What was the cause of the problem?

THanks...

The collection was loaded in one session
then a second sesison wa opened (wo closing the previous)
and the collection was reattached to the second session

emmanuel, would just closing the first session be enough for the collection to be correctly reattached to the second session?.

I had a simmilar problem to the one desribed above, where I was retrieving a Collection through session1, disconnecting it, and then saving the collection through a new session2.
So, in order to deassociate the collection from the first session, I tried closing session1, and then saving through session2, but the same exception would show up.

Thanks in advance,

I've solved my problem, which had nothing to do with Hibernate itself.
My IDE was simply not deploying cleanly, so what was being run is not what I was expecting.

So, the framework correctly reattaches the collection to a second session provided that at the moment of reattachment:
- the first session used to retrieve it, is closed.
- the Java identity of the collection is the same that Hibernate returned at the moment of retrieval.