1 2 Previous Next 17 Replies Latest reply on Dec 1, 2011 12:43 PM by jamat

    Session.getNodeByIdentifier() generates too many queries

    coolersport

      Hi,

       

      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}

        • 1. Re: Session.getNodeByIdentifier() generates too many queries
          rhauch

          Have you enabled 2nd-level caching on the JPA connector? If not, doing so is HIGHLY recommended. See How To Tune ModeShape for Better Performance for more information.

           

          Secondly, even with 2nd-level caching, the connector currently makes some extra, and that's one of the disadvantages of frameworks and base classes, and even JPA. We're working on simplifying things to improve performance, but we still have work to do.

          • 2. Re: Session.getNodeByIdentifier() generates too many queries
            jamat

            Hello,

             

            As I am also using a lot getNodeByIdentifier(), I tried to enable the second level cache following the doc you linked to.

            In this doc it is said to use org.hibernate.cache.infinispan.InfinispanRegionFactory for 'cacheProviderCacheName'.

            This must not be as simple as if I do that I got a ClassCastException because this class cannot be cast to a org.hibernate.cache.CacheProvider.

            The reference manual of modespape says that the value of 'cacheProviderCacheName' is used to configure the

            hibernate.cache.provider_class property. The infinispan doc says that InfinispanRegionFactory (and even the Jndi version if

            using jboss AS 6 or 7) has to be used to configure the hibernate.cache.region.factory_class

            I must be missing something: could you enlighten me ?

             

            Using latest modeshape on Jboss AS 6.

             

            Curiously too the doc suggests to use ehcache for non cluster setup. I would have thought that infinispan would be the preferred cache in all cases for jboss.

             

            BTW kind of related, if the identifier is 'wrong' (like some dummy string) this method does not throw a JCR exception but a modeshape one

            (sorry I do not have the exact exception right now).

             

            Thank you,

            Juan

            • 3. Re: Session.getNodeByIdentifier() generates too many queries
              jamat

              About the exception it is: org.modeshape.graph.property.InvalidPathException

              So if I call getNodeByIdentifier("aaaa") this is the exception stack trace:

               

              17:12:22,020 ERROR [STDERR] org.modeshape.graph.property.InvalidPathException: The path {}aaaa is not an absolute path

              17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.property.basic.AbstractPath.relativeTo(AbstractPath.java:480)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.session.GraphSession.findNodeWith(GraphSession.java:398)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.session.GraphSession.findNodeWith(GraphSession.java:381)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.SessionCache.findNode(SessionCache.java:532)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.SessionCache.findJcrNode(SessionCache.java:643)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNode(JcrSession.java:838)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNodeByIdentifier(JcrSession.java:872)

              17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNodeByIdentifier(JcrSession.java:96)

               

              I guess it should be wrapped in a RepositoryException.

              • 4. Re: Session.getNodeByIdentifier() generates too many queries
                rhauch

                About the exception it is: org.modeshape.graph.property.InvalidPathException

                So if I call getNodeByIdentifier("aaaa") this is the exception stack trace:

                 

                17:12:22,020 ERROR [STDERR] org.modeshape.graph.property.InvalidPathException: The path {}aaaa is not an absolute path

                17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.property.basic.AbstractPath.relativeTo(AbstractPath.java:480)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.session.GraphSession.findNodeWith(GraphSession.java:398)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.graph.session.GraphSession.findNodeWith(GraphSession.java:381)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.SessionCache.findNode(SessionCache.java:532)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.SessionCache.findJcrNode(SessionCache.java:643)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNode(JcrSession.java:838)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNodeByIdentifier(JcrSession.java:872)

                17:12:22,022 ERROR [STDERR]     at org.modeshape.jcr.JcrSession.getNodeByIdentifier(JcrSession.java:96)

                 

                I guess it should be wrapped in a RepositoryException.

                 

                 

                Yes, the InvalidPathException should be wrapped in a RepositoryException. I've logged it as a bug (see MODE-1313).

                 

                It also looks like the JPA connector is not properly setting up the 2nd-level cache and the region factory for Hibernate 3.3 and later. Would you mind logging this as a bug?

                • 5. Re: Session.getNodeByIdentifier() generates too many queries
                  rhauch

                  I had time to work on this today, so I logged MODE-1314 and am currently testing a fix.

                  • 6. Re: Session.getNodeByIdentifier() generates too many queries
                    jamat

                    Thank you Randall for looking into this (and you beat me to open the bug - PST will be my excuse).

                     

                    Do you have any idea if I can workaround this issue (by providing my own cache manager) ?

                    And if not to you have any ETA for the fix ?

                    We are not in production yet so there is still time for us.

                     

                    Again thank you for the product and for being so responsive.

                    • 7. Re: Session.getNodeByIdentifier() generates too many queries
                      rhauch

                      This will be fixed in the 2.7 release, which is coming in a week or two. With that release (or with the latest from 'master'), the following should give some guidance as to how the cacheProviderClassName property should be set.

                       

                      To use Infinispan as a 2nd-level cache (with a new cache manager, useful in non-appserver deployments), set this JPA connector property (and do not setcacheManagerLookup):

                      cacheProviderClassName=org.hibernate.cache.infinispan.InfinispanRegionFactory

                       

                      To use Infinispan in JBoss AS 6 and 7 (which come with a built-in Infinispan cache manager), set these JPA connector properties:

                      cacheProviderClassName=org.hibernate.cache.infinispan.JndiInfinispanRegionFactory

                      cacheManagerLookup=java:CacheManager/entity

                       

                      (or use an appropriate value for cacheManagerLookup).

                      To use a separate Ehcache instance for this connector, set this JPA connector property (and do not set cacheManagerLookup):

                      cacheProviderClassName=net.sf.ehcache.hibernate.EhCacheRegionFactory

                       

                      To use a singleton Ehcache instance, set this JPA connector property (and do not set cacheManagerLookup):

                      cacheProviderClassName=net.sf.ehcache.hibernate.SingletoneEhCacheRegionFactory

                       

                      To use a simple, in-memory cache provider (for testing, never for production), set this JPA connector property (and do not set cacheManagerLookup):

                      cacheProviderClassName=org.hibernate.cache.HashtableCacheProvider

                       

                      Note that ModeShape 2.6 and 2.7 uses Hibernate 3.5, so the above settings should work.

                      However, if you've overridden this and are using a version of Hibernate earlier than 3.3, you need to specify the CacheProvider class instead of theRegionFactory class. For example, to use a separate Ehcache instance, set this JPA connector property (and do not set cacheManagerLookup):

                      cacheProviderClassName=net.sf.ehcache.hibernate.EhCacheProvider

                       

                      or to use a singleton Ehcache instance, set this JPA connector property (and do not set cacheManagerLookup):

                      cacheProviderClassName=net.sf.ehcache.hibernate.SingletonEhCacheProvider
                      • 8. Re: Session.getNodeByIdentifier() generates too many queries
                        rhauch

                        I'd appreciate it if you could try this before we release 2.7 to be sure that we fixed everything. To do so, simple get the latest from our Git repository and do a local build to create the "2.7-SNAPSHOT" release in your local Maven repository.

                        • 9. Re: Session.getNodeByIdentifier() generates too many queries
                          jamat

                          OK I will try that.

                          • 10. Re: Session.getNodeByIdentifier() generates too many queries
                            jamat

                            So it did not work. Well, it did not work without your modifications!

                            I did the 'git clone' too soon.

                            So with the infinispan region factory my application runs fine (need to double check if the cache is really doing what it is supposed to do).

                            I may try ehcache later on.

                             

                            BTW one small comment on the implementation. As you are reusing the same parameter, to differentiate both cases you check if the provided name ends with 'RegionFactory'. Not sure if I like it too much. But hey, it worked. So who am I to complain ?

                             

                            Also what is the proper way to build the jboss kit zip file.

                            I did "mvn install -s ../settings.xml -DskipTests -Passembly" in the deploy directory.

                            (I had to modify the build.xml file as some jar files had newer versions)

                             

                            Thank you again.

                             

                            • 11. Re: Session.getNodeByIdentifier() generates too many queries
                              rhauch

                              So it did not work. Well, it did not work without your modifications!

                              I did the 'git clone' too soon.

                              Sorry about that!

                              So with the infinispan region factory my application runs fine (need to double check if the cache is really doing what it is supposed to do).

                              I may try ehcache later on.

                              That's good news. Ehcache should work pretty well, as its simply providing the name of the Ehcache class, and that's well tested outside of ModeShape. BTW, you asked earlier why we recommend Ehcache. I've cleaned up the language on How To Tune ModeShape for Better Performance to be clear that either Infinispan or Ehcache can be used for production, and that the in-memory one should not be used in production.

                               

                              BTW one small comment on the implementation. As you are reusing the same parameter, to differentiate both cases you check if the provided name ends with 'RegionFactory'. Not sure if I like it too much. But hey, it worked. So who am I to complain ?

                              I agree, it's not the cleanest. But it does work, and it's changing in 3.0 anyway (and yes we will be providing a migration path).

                               

                               

                              Also what is the proper way to build the jboss kit zip file.

                              I did "mvn install -s ../settings.xml -DskipTests -Passembly" in the deploy directory.

                              (I had to modify the build.xml file as some jar files had newer versions)

                              That's basically the right command. Did you change 3rd party library versions? If so, do you remember which ones? I'll need to fix that before we release 2.7. (I can do a build locally, too. So it's not a big deal if you don't have it handy or don't remember.)

                              • 12. Re: Session.getNodeByIdentifier() generates too many queries
                                jamat

                                Here is the list that I have used:

                                 

                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/common-3.3.0-v20070426.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/contenttype-3.4.100-v20100505-1235.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/core-3.3.0-v_771.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/expressions-3.4.200-v20100505.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/jobs-3.5.1-R36x_v20100824.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/osgi-3.6.1-R36x_v20100806.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/preferences-3.3.0-v20100503.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/registry-3.5.0-v20100503.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/resources-3.6.0-R36x_v20100825-0600.jar" />
                                      <unsignjar jar="modeshape-jbossas-service/target/distribution/modeshape-services-jar-content/runtime-3.6.0-v20100505.jar" />

                                All but 'common' and 'core' have newer versions I think.

                                • 13. Re: Session.getNodeByIdentifier() generates too many queries
                                  rhauch

                                  Thanks for providing the list. IIRC those are all Eclipse resources, and we're getting them via a dependency on a Maven module that uses version ranges (ugh!). Unfortunately we'll have to sort this out during the release, since who knows whether these will be the 'latest' at that time.

                                  • 14. Re: Session.getNodeByIdentifier() generates too many queries
                                    jamat

                                    One more thing.

                                    This is probably not a modeshape but maybe you have an idea.

                                    After I have enabled the 2nd level cache for modeshape my app was starting just fine. But.

                                    If I tried to redeploy it, it would not start and I got this error:

                                     

                                    java.lang.IllegalStateException: Cache 'local-query' is in 'TERMINATED' state and so it does not accept new invocations. Either restart it or recreate the cache container.

                                     

                                    In my app I do use modeshape but I have also other entities that are persited (JPA/hibernate) and I did also enable the 2nd level cache with, in fact, the same parameter as the ones for modeshape that is:

                                     

                                             <property name="hibernate.cache.region.factory_class" value="org.hibernate.cache.infinispan.JndiInfinispanRegionFactory"/>
                                             <property name="hibernate.cache.infinispan.cachemanager" value="java:CacheManager/entity"/>

                                     

                                    If I remove this configuration from my persistence.xml file, then I can redeploy my app.

                                    So it seems that there is some kind of conflicts between the two.

                                    Does it ring a bell to you ?

                                     

                                    Thank you

                                    1 2 Previous Next