[jboss-user] [EJB 3.0] - Re: problems with optimistic locking/persistence data in EJB
wiggy
do-not-reply at jboss.com
Thu Jan 24 07:03:14 EST 2008
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 at 103b97<rs=com.mysql.jdbc.ResultSet at c5b819>
| 11:48:53,693 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext at 1b8378f<rs=com.mysql.jdbc.ResultSet at 1165e21>
| 11:48:53,693 WARN [LoadContexts] fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext at 147cab0<rs=com.mysql.jdbc.ResultSet at 38e9e9>
|
|
|
| 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 at 1b9bbf6<rs=com.mysql.jdbc.ResultSet at 18dbef1>
| |
|
| 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#4122997
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4122997
More information about the jboss-user
mailing list