[jboss-user] [EJB 3.0] - Re: problems with optimistic locking/persistence data in EJB

okay - still dont get this at all ! i've just watched the code through the debugger again - heres what i see on the hibernate sql console heres the client code again | | if (nodeEAO.removeLink(uNode, zNode)) | { | | System.out.println ("deleted link : \n"); | } | | //now just calls a local em.find to get db copy | yNode = resynch (uNode); | | //then call server side refresh (merge - then refresh | yNode = nodeEAO.refresh(uNode); | | List<Node> nodeList2 = nodeEAO.getConnectedToNodes(uNode); if (nodeList2 != null) | { | for (Node n : nodeList2 ) | { | System.out.println ("got connected node : " + n.getNodeName() + "/n"); | } | } | else | System.out.println ("got empty connection : /n"); | | } | | when i call the server side refresh action - it does a row insert !?? | | 11:48:53,452 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | 11:48:53,492 INFO [STDOUT] Hibernate: select linksfromo0_.toNode_nodeID as toNode6_2_, linksfromo0_.linkID as linkID2_, linksfromo0_.linkID as linkID14_1_, linksfromo0_.version as version14_1_, linksfromo0_.toNode_nodeID as toNode6_14_1_, linksfromo0_.fromNode_nodeID as fromNode7_14_1_, linksfromo0_.name as name14_1_, linksfromo0_.description as descript4_14_1_, linksfromo0_.lastUpdated as lastUpda5_14_1_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_ from Link linksfromo0_ left outer join Node node1_ on linksfromo0_.fromNode_nodeID=node1_.nodeID where linksfromo0_.toNode_nodeID=? | 11:48:53,502 INFO [STDOUT] Hibernate: select link0_.linkID as linkID14_2_, link0_.version as version14_2_, link0_.toNode_nodeID as toNode6_14_2_, link0_.fromNode_nodeID as fromNode7_14_2_, link0_.name as name14_2_, link0_.description as descript4_14_2_, link0_.lastUpdated as lastUpda5_14_2_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_, mylinksto2_.fromNode_nodeID as fromNode7_4_, mylinksto2_.linkID as linkID4_, mylinksto2_.linkID as linkID14_1_, mylinksto2_.version as version14_1_, mylinksto2_.toNode_nodeID as toNode6_14_1_, mylinksto2_.fromNode_nodeID as fromNode7_14_1_, mylinksto2_.name as name14_1_, mylinksto2_.description as descript4_14_1_, mylinksto2_.lastUpdated as lastUpda5_14_1_ from Link link0_ left outer join Node node1_ on link0_.toNode_nodeID=node1_.nodeID left outer join Link mylinksto2_ on node1_.nodeID=mylinksto2_.fromNode_nodeID where link0_.linkID=? | 11:48:53,512 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | 11:48:53,512 INFO [STDOUT] Hibernate: select linksfromo0_.toNode_nodeID as toNode6_2_, linksfromo0_.linkID as linkID2_, linksfromo0_.linkID as linkID14_1_, linksfromo0_.version as version14_1_, linksfromo0_.toNode_nodeID as toNode6_14_1_, linksfromo0_.fromNode_nodeID as fromNode7_14_1_, linksfromo0_.name as name14_1_, linksfromo0_.description as descript4_14_1_, linksfromo0_.lastUpdated as lastUpda5_14_1_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_ from Link linksfromo0_ left outer join Node node1_ on linksfromo0_.fromNode_nodeID=node1_.nodeID where linksfromo0_.toNode_nodeID=? | 11:48:53,522 INFO [STDOUT] Hibernate: insert into Link (version, toNode_nodeID, fromNode_nodeID, name, description, lastUpdated) values (?, ?, ?, ?, ?, ?) | 11:48:53,522 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | 11:48:53,532 INFO [STDOUT] Hibernate: select link0_.linkID as linkID14_2_, link0_.version as version14_2_, link0_.toNode_nodeID as toNode6_14_2_, link0_.fromNode_nodeID as fromNode7_14_2_, link0_.name as name14_2_, link0_.description as descript4_14_2_, link0_.lastUpdated as lastUpda5_14_2_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_, mylinksto2_.fromNode_nodeID as fromNode7_4_, mylinksto2_.linkID as linkID4_, mylinksto2_.linkID as linkID14_1_, mylinksto2_.version as version14_1_, mylinksto2_.toNode_nodeID as toNode6_14_1_, mylinksto2_.fromNode_nodeID as fromNode7_14_1_, mylinksto2_.name as name14_1_, mylinksto2_.description as descript4_14_1_, mylinksto2_.lastUpdated as lastUpda5_14_1_ from Link link0_ left outer join Node node1_ on link0_.toNode_nodeID=node1_.nodeID left outer join Link mylinksto2_ on node1_.nodeID=mylinksto2_.fromNode_nodeID where link0_.linkID=? | 11:48:53,542 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | 11:48:53,623 INFO [STDOUT] Hibernate: select link0_.linkID as linkID14_2_, link0_.version as version14_2_, link0_.toNode_nodeID as toNode6_14_2_, link0_.fromNode_nodeID as fromNode7_14_2_, link0_.name as name14_2_, link0_.description as descript4_14_2_, link0_.lastUpdated as lastUpda5_14_2_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_, mylinksto2_.fromNode_nodeID as fromNode7_4_, mylinksto2_.linkID as linkID4_, mylinksto2_.linkID as linkID14_1_, mylinksto2_.version as version14_1_, mylinksto2_.toNode_nodeID as toNode6_14_1_, mylinksto2_.fromNode_nodeID as fromNode7_14_1_, mylinksto2_.name as name14_1_, mylinksto2_.description as descript4_14_1_, mylinksto2_.lastUpdated as lastUpda5_14_1_ from Link link0_ left outer join Node node1_ on link0_.toNode_nodeID=node1_.nodeID left outer join Link mylinksto2_ on node1_.nodeID=mylinksto2_.fromNode_nodeID where link0_.linkID=? | 11:48:53,633 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | 11:48:53,693 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@103b97&lt;rs=com.mysql.jdbc.ResultSet(a)c5b819&gt; | 11:48:53,693 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@1b8378f&lt;rs=com.mysql.jdbc.ResultSet(a)1165e21&gt; | 11:48:53,693 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@147cab0&lt;rs=com.mysql.jdbc.ResultSet(a)38e9e9&gt; | | | | i then run a query action to get connected nodes to this uNode and the query action causes another DB insert at the server!!!??? | | | | | | 11:57:23,756 INFO [STDOUT] Hibernate: select node0_.nodeID as nodeID17_2_, node0_.version as version17_2_, node0_.lastUpdated as lastUpda4_17_2_, node0_.nodeName as nodeName17_2_, node0_.aliasName as aliasName17_2_, node0_.description as descript7_17_2_, node0_.weight as weight17_2_, node0_.importance as importance17_2_, node0_.firstName as firstName17_2_, node0_.middleName as middleName17_2_, node0_.lastName as lastName17_2_, node0_.nickName as nickName17_2_, node0_.dateOfBirth as dateOfB14_17_2_, node0_.dateOfDeath as dateOfD15_17_2_, node0_.sex as sex17_2_, node0_.nodeType as nodeType17_2_, mylinksto1_.fromNode_nodeID as fromNode7_4_, mylinksto1_.linkID as linkID4_, mylinksto1_.linkID as linkID14_0_, mylinksto1_.version as version14_0_, mylinksto1_.toNode_nodeID as toNode6_14_0_, mylinksto1_.fromNode_nodeID as fromNode7_14_0_, mylinksto1_.name as name14_0_, mylinksto1_.description as descript4_14_0_, mylinksto1_.lastUpdated as lastUpda5_14_0_, node2_.nodeID as nodeID17_1_, node2_.version as version17_1_, node2_.lastUpdated as lastUpda4_17_1_, node2_.nodeName as nodeName17_1_, node2_.aliasName as aliasName17_1_, node2_.description as descript7_17_1_, node2_.weight as weight17_1_, node2_.importance as importance17_1_, node2_.firstName as firstName17_1_, node2_.middleName as middleName17_1_, node2_.lastName as lastName17_1_, node2_.nickName as nickName17_1_, node2_.dateOfBirth as dateOfB14_17_1_, node2_.dateOfDeath as dateOfD15_17_1_, node2_.sex as sex17_1_, node2_.nodeType as nodeType17_1_ from Node node0_ left outer join Link mylinksto1_ on node0_.nodeID=mylinksto1_.fromNode_nodeID left outer join Node node2_ on mylinksto1_.toNode_nodeID=node2_.nodeID where node0_.nodeID=? | | 11:57:23,776 INFO [STDOUT] Hibernate: select linksfromo0_.toNode_nodeID as toNode6_2_, linksfromo0_.linkID as linkID2_, linksfromo0_.linkID as linkID14_1_, linksfromo0_.version as version14_1_, linksfromo0_.toNode_nodeID as toNode6_14_1_, linksfromo0_.fromNode_nodeID as fromNode7_14_1_, linksfromo0_.name as name14_1_, linksfromo0_.description as descript4_14_1_, linksfromo0_.lastUpdated as lastUpda5_14_1_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_ from Link linksfromo0_ left outer join Node node1_ on linksfromo0_.fromNode_nodeID=node1_.nodeID where linksfromo0_.toNode_nodeID=? | | 11:57:23,806 INFO [STDOUT] Hibernate: select link0_.linkID as linkID14_2_, link0_.version as version14_2_, link0_.toNode_nodeID as toNode6_14_2_, link0_.fromNode_nodeID as fromNode7_14_2_, link0_.name as name14_2_, link0_.description as descript4_14_2_, link0_.lastUpdated as lastUpda5_14_2_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_, mylinksto2_.fromNode_nodeID as fromNode7_4_, mylinksto2_.linkID as linkID4_, mylinksto2_.linkID as linkID14_1_, mylinksto2_.version as version14_1_, mylinksto2_.toNode_nodeID as toNode6_14_1_, mylinksto2_.fromNode_nodeID as fromNode7_14_1_, mylinksto2_.name as name14_1_, mylinksto2_.description as descript4_14_1_, mylinksto2_.lastUpdated as lastUpda5_14_1_ from Link link0_ left outer join Node node1_ on link0_.toNode_nodeID=node1_.nodeID left outer join Link mylinksto2_ on node1_.nodeID=mylinksto2_.fromNode_nodeID where link0_.linkID=? | | 11:57:23,826 INFO [STDOUT] Hibernate: select linksfromo0_.toNode_nodeID as toNode6_2_, linksfromo0_.linkID as linkID2_, linksfromo0_.linkID as linkID14_1_, linksfromo0_.version as version14_1_, linksfromo0_.toNode_nodeID as toNode6_14_1_, linksfromo0_.fromNode_nodeID as fromNode7_14_1_, linksfromo0_.name as name14_1_, linksfromo0_.description as descript4_14_1_, linksfromo0_.lastUpdated as lastUpda5_14_1_, node1_.nodeID as nodeID17_0_, node1_.version as version17_0_, node1_.lastUpdated as lastUpda4_17_0_, node1_.nodeName as nodeName17_0_, node1_.aliasName as aliasName17_0_, node1_.description as descript7_17_0_, node1_.weight as weight17_0_, node1_.importance as importance17_0_, node1_.firstName as firstName17_0_, node1_.middleName as middleName17_0_, node1_.lastName as lastName17_0_, node1_.nickName as nickName17_0_, node1_.dateOfBirth as dateOfB14_17_0_, node1_.dateOfDeath as dateOfD15_17_0_, node1_.sex as sex17_0_, node1_.nodeType as nodeType17_0_ from Link linksfromo0_ left outer join Node node1_ on linksfromo0_.fromNode_nodeID=node1_.nodeID where linksfromo0_.toNode_nodeID=? | | 11:57:23,846 INFO [STDOUT] Hibernate: insert into Link (version, toNode_nodeID, fromNode_nodeID, name, description, lastUpdated) values (?, ?, ?, ?, ?, ?) | | 11:57:23,856 INFO [STDOUT] Hibernate: update Node set version=?, lastUpdated=?, nodeName=?, aliasName=?, description=?, weight=?, importance=? where nodeID=? | | 11:57:23,856 INFO [STDOUT] Hibernate: update Node set version=?, lastUpdated=?, nodeName=?, aliasName=?, description=?, weight=?, importance=? where nodeID=? | | 11:57:23,866 INFO [STDOUT] Hibernate: select node1_.nodeID as nodeID17_, node1_.version as version17_, node1_.lastUpdated as lastUpda4_17_, node1_.nodeName as nodeName17_, node1_.aliasName as aliasName17_, node1_.description as descript7_17_, node1_.weight as weight17_, node1_.importance as importance17_, node1_.firstName as firstName17_, node1_.middleName as middleName17_, node1_.lastName as lastName17_, node1_.nickName as nickName17_, node1_.dateOfBirth as dateOfB14_17_, node1_.dateOfDeath as dateOfD15_17_, node1_.sex as sex17_, node1_.nodeType as nodeType17_ from Link link0_ inner join Node node1_ on link0_.toNode_nodeID=node1_.nodeID where link0_.fromNode_nodeID=? | | 11:57:24,097 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@1b9bbf6&lt;rs=com.mysql.jdbc.ResultSet(a)18dbef1&gt; | | | | so somehow starting from having a uNode with two links - i delete one at the server EJB end - then by doing a find (issues a select only), and a refresh and a query i get three links in the database when I only expected 1. | | What is happening here - I cant see why it keeps inserting rows | | Weird | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4122997#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...