Session.getNodeByIdentifier() generates too many queries
coolersport Oct 27, 2011 8:07 PMHi,
Can someone kindly explain why a call to Session.getNodeByIdentifier() produce to many queries to the database? We are using JpaConnector. With each call, it executes more than 20 queries (see attached) and look like they retrieve all information about the workspace, parent, children... over and over again.
Would it have anything to do with session re-login for every request?
Thanks,
Tien
{code}
2011-10-28 10:59:40,729 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,735 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,739 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,743 DEBUG [org.hibernate.SQL-111] - select workspacee0_.NAME as col_0_0_ from DNA_WORKSPACES workspacee0_
2011-10-28 10:59:40,764 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,768 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,773 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,777 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,781 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,785 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,787 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,787 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,788 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,790 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,791 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,791 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,793 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,795 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,796 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,797 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,802 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,807 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,808 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,809 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,810 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,812 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,813 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,815 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,816 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,818 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,820 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,821 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,823 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,825 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,834 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,837 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,839 DEBUG [org.hibernate.SQL-111] - select largevalue0_.SHA1 as SHA1_32_0_, largevalue0_.COMPRESSED as COMPRESSED32_0_, largevalue0_.DATA as DATA32_0_, largevalue0_.LENGTH as LENGTH32_0_, largevalue0_.TYPE as TYPE32_0_ from MODE_SIMPLE_LARGE_VALUES largevalue0_ where largevalue0_.SHA1=?
2011-10-28 10:59:40,842 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,842 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,849 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,850 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,852 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,853 DEBUG [org.hibernate.SQL-111] - select workspacee0_.NAME as col_0_0_ from DNA_WORKSPACES workspacee0_
2011-10-28 10:59:40,854 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,858 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,862 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,865 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,869 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,873 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,874 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,875 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,876 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,877 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,877 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,878 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,879 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_0_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_0_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_0_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_0_, nodeentity0_.COMPRESSED as COMPRESSED33_0_, nodeentity0_.DATA as DATA33_0_, nodeentity0_.CHILD_INDEX as CHILD6_33_0_, nodeentity0_.NODE_UUID as NODE7_33_0_, nodeentity0_.PARENT_ID as PARENT13_33_0_, nodeentity0_.NUM_PROPS as NUM8_33_0_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_0_, nodeentity0_.SNS_INDEX as SNS10_33_0_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.ID=?
2011-10-28 10:59:40,881 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,882 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,883 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,888 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,893 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,894 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,895 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,897 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,898 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,900 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,901 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,903 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,904 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,906 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,908 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,910 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,911 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,919 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,923 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,924 DEBUG [org.hibernate.SQL-111] - select largevalue0_.SHA1 as SHA1_32_0_, largevalue0_.COMPRESSED as COMPRESSED32_0_, largevalue0_.DATA as DATA32_0_, largevalue0_.LENGTH as LENGTH32_0_, largevalue0_.TYPE as TYPE32_0_ from MODE_SIMPLE_LARGE_VALUES largevalue0_ where largevalue0_.SHA1=?
2011-10-28 10:59:40,927 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,928 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,962 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,964 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,965 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,966 DEBUG [org.hibernate.SQL-111] - select workspacee0_.NAME as col_0_0_ from DNA_WORKSPACES workspacee0_
2011-10-28 10:59:40,968 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,971 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,979 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,984 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,988 DEBUG [org.hibernate.SQL-111] - select workspacee0_.id as id31_, workspacee0_.NAME as NAME31_ from DNA_WORKSPACES workspacee0_ where workspacee0_.NAME=? limit ?
2011-10-28 10:59:40,991 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,993 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,994 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
2011-10-28 10:59:40,995 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,996 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:40,998 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:40,999 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:41,001 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:41,003 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:41,005 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:41,006 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:41,008 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:41,010 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:41,012 DEBUG [org.hibernate.SQL-111] - select nodeentity0_.ID as ID33_, nodeentity0_.ALLOWS_SNS as ALLOWS2_33_, nodeentity0_.CHILD_NAME_LOCAL as CHILD3_33_, nodeentity0_.CHILD_NAME_NS_ID as CHILD12_33_, nodeentity0_.COMPRESSED as COMPRESSED33_, nodeentity0_.DATA as DATA33_, nodeentity0_.CHILD_INDEX as CHILD6_33_, nodeentity0_.NODE_UUID as NODE7_33_, nodeentity0_.PARENT_ID as PARENT13_33_, nodeentity0_.NUM_PROPS as NUM8_33_, nodeentity0_.ENFORCEREFINTEG as ENFORCER9_33_, nodeentity0_.SNS_INDEX as SNS10_33_, nodeentity0_.WORKSPACE_ID as WORKSPACE11_33_ from MODE_SIMPLE_NODE nodeentity0_ where nodeentity0_.WORKSPACE_ID=? and nodeentity0_.NODE_UUID=? limit ?
2011-10-28 10:59:41,013 DEBUG [org.hibernate.SQL-111] - select children0_.PARENT_ID as PARENT13_33_1_, children0_.ID as ID1_, children0_.ID as ID33_0_, children0_.ALLOWS_SNS as ALLOWS2_33_0_, children0_.CHILD_NAME_LOCAL as CHILD3_33_0_, children0_.CHILD_NAME_NS_ID as CHILD12_33_0_, children0_.COMPRESSED as COMPRESSED33_0_, children0_.DATA as DATA33_0_, children0_.CHILD_INDEX as CHILD6_33_0_, children0_.NODE_UUID as NODE7_33_0_, children0_.PARENT_ID as PARENT13_33_0_, children0_.NUM_PROPS as NUM8_33_0_, children0_.ENFORCEREFINTEG as ENFORCER9_33_0_, children0_.SNS_INDEX as SNS10_33_0_, children0_.WORKSPACE_ID as WORKSPACE11_33_0_ from MODE_SIMPLE_NODE children0_ where children0_.PARENT_ID=? order by children0_.CHILD_INDEX asc
2011-10-28 10:59:41,015 DEBUG [org.hibernate.SQL-111] - select namespacee0_.id as id30_0_, namespacee0_.URI as URI30_0_ from DNA_NAMESPACES namespacee0_ where namespacee0_.id=?
{code}