03-19-2007 12:29 PM
03-19-2007 12:41 PM
03-20-2007 05:51 AM
4 Execute [43] select childassoc0_.type_qname as col_0_0_, childassoc0_.qname as col_1_0_, childassoc0_.is_primary as col_2_0_, childassoc0_.assoc_index as col_3_0_, nodeimpl2_.id as col_4_0_, nodeimpl2_.protocol as col_5_0_, nodeimpl2_.identifier as col_6_0_, nodeimpl2_.uuid as col_7_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodeimpl2_.id where childassoc0_.parent_node_id=24 order by childassoc0_.assoc_index, childassoc0_.id
4 Prepare [44]
4 Execute [44] select nodestatus0_.protocol as protocol3_3_, nodestatus0_.identifier as identifier3_3_, nodestatus0_.guid as guid3_3_, nodestatus0_.transaction_id as transact4_3_3_, nodestatus0_.node_id as node5_3_3_, nodeimpl1_.id as id0_0_, nodeimpl1_.protocol as protocol0_0_, nodeimpl1_.identifier as identifier0_0_, nodeimpl1_.uuid as uuid0_0_, nodeimpl1_.type_qname as type5_0_0_, nodeimpl1_.acl_id as acl6_0_0_, storeimpl2_.protocol as protocol6_1_, storeimpl2_.identifier as identifier6_1_, storeimpl2_.root_node_id as root3_6_1_, aspects3_.node_id as node1_5_, aspects3_.qname as qname5_, parentasso4_.child_node_id as child3_6_, parentasso4_.id as id6_, parentasso4_.id as id4_2_, parentasso4_.parent_node_id as parent2_4_2_, parentasso4_.child_node_id as child3_4_2_, parentasso4_.type_qname as type4_4_2_, parentasso4_.qname as qname4_2_, parentasso4_.child_node_name as child6_4_2_, parentasso4_.child_node_name_crc as child7_4_2_, parentasso4_.is_primary as is8_4_2_, parentasso4_.assoc_index as assoc9_4_2_ from alf_node_status nodestatus0_ left outer join alf_node nodeimpl1_ on nodestatus0_.node_id=nodeimpl1_.id left outer join alf_store storeimpl2_ on nodeimpl1_.protocol=storeimpl2_.protocol and nodeimpl1_.identifier=storeimpl2_.identifier left outer join alf_node_aspects aspects3_ on nodeimpl1_.id=aspects3_.node_id left outer join alf_child_assoc parentasso4_ on nodeimpl1_.id=parentasso4_.child_node_id where nodestatus0_.protocol='workspace' and nodestatus0_.identifier='SpacesStore' and nodestatus0_.guid='028e80ff-d233-11db-ab77-f97d674cf932'
4 Prepare [45]
4 Execute [45] select childassoc0_.type_qname as col_0_0_, childassoc0_.qname as col_1_0_, childassoc0_.is_primary as col_2_0_, childassoc0_.assoc_index as col_3_0_, nodeimpl2_.id as col_4_0_, nodeimpl2_.protocol as col_5_0_, nodeimpl2_.identifier as col_6_0_, nodeimpl2_.uuid as col_7_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodeimpl2_.id where childassoc0_.parent_node_id=391 order by childassoc0_.assoc_index, childassoc0_.id
4 Prepare [46]
4 Execute [46] select nodestatus0_.protocol as protocol3_3_, nodestatus0_.identifier as identifier3_3_, nodestatus0_.guid as guid3_3_, nodestatus0_.transaction_id as transact4_3_3_, nodestatus0_.node_id as node5_3_3_, nodeimpl1_.id as id0_0_, nodeimpl1_.protocol as protocol0_0_, nodeimpl1_.identifier as identifier0_0_, nodeimpl1_.uuid as uuid0_0_, nodeimpl1_.type_qname as type5_0_0_, nodeimpl1_.acl_id as acl6_0_0_, storeimpl2_.protocol as protocol6_1_, storeimpl2_.identifier as identifier6_1_, storeimpl2_.root_node_id as root3_6_1_, aspects3_.node_id as node1_5_, aspects3_.qname as qname5_, parentasso4_.child_node_id as child3_6_, parentasso4_.id as id6_, parentasso4_.id as id4_2_, parentasso4_.parent_node_id as parent2_4_2_, parentasso4_.child_node_id as child3_4_2_, parentasso4_.type_qname as type4_4_2_, parentasso4_.qname as qname4_2_, parentasso4_.child_node_name as child6_4_2_, parentasso4_.child_node_name_crc as child7_4_2_, parentasso4_.is_primary as is8_4_2_, parentasso4_.assoc_index as assoc9_4_2_ from alf_node_status nodestatus0_ left outer join alf_node nodeimpl1_ on nodestatus0_.node_id=nodeimpl1_.id left outer join alf_store storeimpl2_ on nodeimpl1_.protocol=storeimpl2_.protocol and nodeimpl1_.identifier=storeimpl2_.identifier left outer join alf_node_aspects aspects3_ on nodeimpl1_.id=aspects3_.node_id left outer join alf_child_assoc parentasso4_ on nodeimpl1_.id=parentasso4_.child_node_id where nodestatus0_.protocol='workspace' and nodestatus0_.identifier='SpacesStore' and nodestatus0_.guid='0445a6e2-d233-11db-ab77-f97d674cf932'
4 Prepare [47]
4 Execute [47] select properties0_.node_id as node1_0_, properties0_.actual_type as actual2_0_, properties0_.multi_valued as multi3_0_, properties0_.persisted_type as persisted4_0_, properties0_.boolean_value as boolean5_0_, properties0_.long_value as long6_0_, properties0_.float_value as float7_0_, properties0_.double_value as double8_0_, properties0_.string_value as string9_0_, properties0_.serializable_value as seriali10_0_, properties0_.qname as qname0_ from alf_node_properties properties0_ where properties0_.node_id=392
Je ne vais pas mettre celle générées lors de la création et ajout de fichier, pour info il y a plein de update sur les noeuds, associations… et de insert into, qui sont totalement inexistant pour l'import!
03-28-2007 10:14 AM
03-28-2007 02:48 PM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.