后台查询数据前台用树形展示

15030479317

15030479317 发表于 2017-7-13 16:30
2017-07-13 16:20:11                |-->完成 CompExpressionNode, stack:[, , , , , , ]
2017-07-13 16 ...

exec KSQL: select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.sOrgID as sOrgID from COM_Management COM_Management OPTIONAL join COM_DynamicView COM_DynamicView ON COM_DynamicView=COM_Management.sDynamicViewID or COM_Management.sDynamicViewID is null where COM_Management.sValidState=1 and COM_Management.sConcept=:concept and (COM_Management.sProcess=:sProcess or COM_Management.sProcess is null)  and (COM_Management.sActivity=:sActivity or COM_Management.sActivity is null)
  --> sql:SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) )
--> binds:[1, V_COST_SUPPLYTREE, /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, mainActivity]
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前：SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) )
处理隔离字段后：SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) )
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11 sql 执行时间：3ms
2017-07-13 16:20:11 [SQL Time]sql 执行时间：3ms, exec KSQL: select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.sOrgID as sOrgID from COM_Management COM_Management OPTIONAL join COM_DynamicView COM_DynamicView ON COM_DynamicView=COM_Management.sDynamicViewID or COM_Management.sDynamicViewID is null where COM_Management.sValidState=1 and COM_Management.sConcept=:concept and (COM_Management.sProcess=:sProcess or COM_Management.sProcess is null)  and (COM_Management.sActivity=:sActivity or COM_Management.sActivity is null)
  --> sql:SELECT  COM_DynamicView.SWHERE AS sWhere, COM_DynamicView.SNAME AS sName, COM_Management.SORGID AS sOrgID FROM COM_Management COM_Management LEFT JOIN COM_DynamicView COM_DynamicView ON  (COM_DynamicView.sID = COM_Management.SDYNAMICVIEWID) OR (COM_Management.SDYNAMICVIEWID IS NULL)   WHERE  (COM_Management.SVALIDSTATE = ?) AND (COM_Management.SCONCEPT =  ? ) AND ( (COM_Management.SPROCESS =  ? ) OR (COM_Management.SPROCESS IS NULL) ) AND ( (COM_Management.SACTIVITY =  ? ) OR (COM_Management.SACTIVITY IS NULL) )
--> binds:[1, V_COST_SUPPLYTREE, /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, mainActivity]
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=sWhere, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=sName, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=sOrgID, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 查找define=COM_DynamicView.sWhere对应的modelObject
2017-07-13 16:20:11 根据名字COM_DynamicView获取概念 ->/system/ontology/COM_DynamicView@Concept
2017-07-13 16:20:11 查找define=COM_DynamicView.sName对应的modelObject
2017-07-13 16:20:11 根据名字COM_DynamicView获取概念 ->/system/ontology/COM_DynamicView@Concept
2017-07-13 16:20:11 查找define=COM_Management.sOrgID对应的modelObject
2017-07-13 16:20:11 根据名字COM_Management获取概念 ->/system/ontology/COM_Management@Concept
2017-07-13 16:20:11 关闭连接：<CoreConnection name=java:comp/env/system, active=1, count=1, closed=false, conn =jdbcracle:thinlocalhost:1521rcl, UserName=HBJS_X5SYS, Oracle JDBC driver, autocommit=true>
2017-07-13 16:20:11

15030479317

15030479317 发表于 2017-7-13 16:30
exec KSQL: select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.s ...

/PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYTREEAction -> close conn: name=java:comp/env/system, connNum = 0
2017-07-13 16:20:11 KSQL 执行时间：29ms, ksql: select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.sOrgID as sOrgID from COM_Management COM_Management OPTIONAL join COM_DynamicView COM_DynamicView ON COM_DynamicView=COM_Management.sDynamicViewID or COM_Management.sDynamicViewID is null where COM_Management.sValidState=1 and COM_Management.sConcept=:concept and (COM_Management.sProcess=:sProcess or COM_Management.sProcess is null)  and (COM_Management.sActivity=:sActivity or COM_Management.sActivity is null)
2017-07-13 16:20:11 [KSQL Time]sql 执行时间：29ms, ksql:select COM_DynamicView.sWhere as sWhere,COM_DynamicView.sName as sName,COM_Management.sOrgID as sOrgID from COM_Management COM_Management OPTIONAL join COM_DynamicView COM_DynamicView ON COM_DynamicView=COM_Management.sDynamicViewID or COM_Management.sDynamicViewID is null where COM_Management.sValidState=1 and COM_Management.sConcept=:concept and (COM_Management.sProcess=:sProcess or COM_Management.sProcess is null)  and (COM_Management.sActivity=:sActivity or COM_Management.sActivity is null)
2017-07-13 16:20:11 execute query :SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
2017-07-13 16:20:11 根据名字dataSource获取Config ->/PM/PM/data/dataSource@Config
2017-07-13 16:20:11 根据名字dataSource获取Config ->/PM/PM/data/dataSource@Config
2017-07-13 16:20:11 获取数据库的连接参数：java:comp/env/system
2017-07-13 16:20:11 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYTREEAction -> create conn :  name=java:comp/env/system, connNum = 1
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取Store ->/PM/PM/data/V_COST_SUPPLYTREE@Store
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取Mapping ->/PM/PM/data/V_COST_SUPPLYTREE@Mapping
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11    |-->开始 SelectSentenceNode, stack:[]
2017-07-13 16:20:11       |-->开始 SelectListNode, stack:[]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[]
2017-07-13 16:20:11             |-->开始 IdentiferNode, stack:[]
2017-07-13 16:20:11             |-->完成 IdentiferNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>]

15030479317

15030479317 发表于 2017-7-13 16:30
/PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYT ...

2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL AS fURL, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL AS fURL, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL AS fURL, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL AS fURL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.VERSION, binds=[]>]>]

15030479317

15030479317 发表于 2017-7-13 16:31
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[, , , , ]
2017-07-13 16:20:11     ...

2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FNAME AS fName, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent AS fParent, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.FURL AS fURL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>]
2017-07-13 16:20:11       |-->完成 SelectListNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>]
2017-07-13 16:20:11       |-->开始 FromNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 ConceptDeclareNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 ConceptDeclareNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11       |-->完成 FromNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11       |-->开始 WhereNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 OneRelationNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 CompExpressionNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>]
2017-07-13 16:20:11       |-->完成 WhereNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>]

15030479317

15030479317 发表于 2017-7-13 16:31
2017-07-13 16:20:11          |-->完成 SelectColumnNode, stack:[, , , , , , , ]
2017-07-13 16:20:11 ...

2017-07-13 16:20:11       |-->开始 OrderByNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>]
2017-07-13 16:20:11          |-->开始 OrderNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>]
2017-07-13 16:20:11             |-->开始 IdentiferNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>]
2017-07-13 16:20:11             |-->完成 IdentiferNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=fName, binds=[]>]>]
2017-07-13 16:20:11          |-->完成 OrderNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=fName DESC, binds=[]>]>]
2017-07-13 16:20:11       |-->完成 OrderByNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp=FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= WHERE V_COST_SUPPLYTREE.fParent IS NULL, binds=[]>]>, <SQLValue dimension=1, values=[<OneValue exp= ORDER BY fName DESC, binds=[]>]>]
2017-07-13 16:20:11    |-->完成 SelectSentenceNode, stack:[<SQLValue dimension=1, values=[<OneValue exp=SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC, binds=[]>]>]
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11  exec KSQL: SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
--> sql:SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC
--> binds:[]
--> dataModel|M|/PM/PM/data
--> fnModel|M|/system/logic/fn
2017-07-13 16:20:11
exec KSQL: SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
  --> sql:SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC
--> binds:[]
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前：SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC
处理隔离字段后：SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11 sql 执行时间：160ms
2017-07-13 16:20:11 [SQL Time]sql 执行时间：160ms, exec KSQL: SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
  --> sql:SELECT  V_COST_SUPPLYTREE.fID AS V_COST_SUPPLYTREE, V_COST_SUPPLYTREE.FBIZSTATE AS fBizState, V_COST_SUPPLYTREE.FBIZSTATENAME AS fBizStateName, V_COST_SUPPLYTREE.FNAME AS fName, V_COST_SUPPLYTREE.fParent AS fParent, V_COST_SUPPLYTREE.FPROJECTID AS fProjectID, V_COST_SUPPLYTREE.FURL AS fURL, V_COST_SUPPLYTREE.VERSION AS version FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL  ORDER BY fName DESC
--> binds:[]

15030479317

15030479317 发表于 2017-7-13 16:31
2017-07-13 16:20:11       |-->开始 OrderByNode, stack:[, , ]
2017-07-13 16:20:11          |-->开始 ...

2017-07-13 16:20:11 添加列meta信息:<CMetaData name=V_COST_SUPPLYTREE, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fBizState, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fBizStateName, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fName, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fParent, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fProjectID, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=fURL, type=String, index=0, define=null, store=false>
2017-07-13 16:20:11 添加列meta信息:<CMetaData name=version, type=Integer, index=0, define=null, store=false>
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fBizState对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fBizStateName对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fName对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fParent对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fProjectID对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.fURL对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 查找define=V_COST_SUPPLYTREE.version对应的modelObject
2017-07-13 16:20:11 根据名字V_COST_SUPPLYTREE获取概念 ->/PM/PM/ontology/V_COST_SUPPLYTREE@Concept
2017-07-13 16:20:11 关闭连接：<CoreConnection name=java:comp/env/system, active=1, count=1, closed=false, conn =jdbcracle:thinlocalhost:1521rcl, UserName=HBJS_X5SYS, Oracle JDBC driver, autocommit=true>
2017-07-13 16:20:11 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYTREEAction -> close conn: name=java:comp/env/system, connNum = 0
2017-07-13 16:20:11 KSQL 执行时间：180ms, ksql: SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
2017-07-13 16:20:11 [KSQL Time]sql 执行时间：180ms, ksql:SELECT V_COST_SUPPLYTREE.*  FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE WHERE ((V_COST_SUPPLYTREE.fParent IS NULL)) ORDER BY fName DESC LIMIT 0, 20
2017-07-13 16:20:11 查询count：
->SQL :SELECT count(*) FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL
->binds:[]
2017-07-13 16:20:11 根据名字dataSource获取Config ->/PM/PM/data/dataSource@Config
2017-07-13 16:20:11 根据名字dataSource获取Config ->/PM/PM/data/dataSource@Config
2017-07-13 16:20:11 获取数据库的连接参数：java:comp/env/system
2017-07-13 16:20:11 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYTREEAction -> create conn :  name=java:comp/env/system, connNum = 1
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:11
exec KSQL:
  --> sql:SELECT count(*) FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL
--> binds:[]
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前：SELECT count(*) FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL
处理隔离字段后：SELECT count(*) FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL
2017-07-13 16:20:11 Connection product name:Oracle
2017-07-13 16:20:11 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:12 sql 执行时间：166ms
2017-07-13 16:20:12 [SQL Time]sql 执行时间：166ms, exec KSQL:
  --> sql:SELECT count(*) FROM V_COST_SUPPLYTREE V_COST_SUPPLYTREE  WHERE V_COST_SUPPLYTREE.fParent IS NULL
--> binds:[]
2017-07-13 16:20:12 关闭连接：<CoreConnection name=java:comp/env/system, active=1, count=1, closed=false, conn =jdbcracle:thinlocalhost:1521rcl, UserName=HBJS_X5SYS, Oracle JDBC driver, autocommit=true>
2017-07-13 16:20:12 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/queryV_COST_SUPPLYTREEAction -> close conn: name=java:comp/env/system, connNum = 0
2017-07-13 16:20:12 __invokeProcedureFromLua end
2017-07-13 16:20:12 __invokeProcedureToLua end
2017-07-13 16:20:12 __doAction end
2017-07-13 16:20:12 __doActionFromLua end
2017-07-13 16:20:12 __doActionToLua end
2017-07-13 16:20:12 __doActionEventToLua begin
__doActionEventFromLua begin...
2017-07-13 16:20:12 __doActionEventFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureToLua begin
__invokeProcedureFromLua begin...
2017-07-13 16:20:12 __invokeProcedureFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureFromLua end
2017-07-13 16:20:12 __invokeProcedureToLua end
2017-07-13 16:20:12 __doActionEventFromLua end
2017-07-13 16:20:12 __doActionEventToLua end
2017-07-13 16:20:12 [JVM]end.....7961A0B445FE4F8999B69627540A0567, process: /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, activity: mainActivity, action: queryV_COST_SUPPLYTREEAction, operator: PSN01, system, total: 3066MB, free: 179MB, use: 2887MB, leak free: 0MB, leak use: 0MB

15030479317

15030479317 发表于 2017-7-13 16:32
2017-07-13 16:20:11 添加列meta信息:
2017-07-13 16:20:11 添加列meta信息:
2017-07-13 16:20:11 添加列 ...

2017-07-13 16:20:12 [Action Time]action执行时间：403ms,/PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess,mainActivity,queryV_COST_SUPPLYTREEAction
2017-07-13 16:20:12 __invokeActionFromLua end
2017-07-13 16:20:12 __invokeActionToLua end
2017-07-13 16:20:12 start translate ...
2017-07-13 16:20:12 translate data : {"actionFlag":"__action_0__","value":{"@type":"table","rows":[{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7AB6ED3FA134433AA3538929D681DF61"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"95DE26B427884ED9A40B6C83C5DB5CE9"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"2968E7465CE44A2BA8669B1B3731F172"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"44B7BBD95F454083B1E44C679CE79006"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"EC2E76AA1F9646E9885856A6E3B305CA"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"BA72E9B6A40A492AA799657DFC037F30"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"58BB3347197D4B1FB4AD9F4C54743AF0"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"0F289844B7F649D5A73D5F2D4CBBF95E"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"17FB3DDADF614B72BA9C53EC2289591F"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"D6E5873D9EEF4F99A3F58A59F5165B48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"D20570B8B4564ED2816E683C30EB112B"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"63A5742D7CC84C79AFB85EAC07E55E9C"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"9AD4956606BE48C391DA684EF751482B"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7D3546F8C39248DDB48774FA60EE21C7"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"A788A6B1BDAB4A82BB16B6E48A0AAC48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"00102FA1350340ABB30E970B50F29721"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"B350CC9F817B494DB3E05D82930EC2B2"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"FD473075F7074E148058D559E076E49E"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"9C489D5539EE41629508DF9E1F9CBA30"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7CFD72E7ED334E0A90A2563F9D17DC48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}}],"userdata":{"idColumnDefine":"V_COST_SUPPLYTREE","idColumnName":"V_COST_SUPPLYTREE","idColumnType":"String","model":"/PM/PM/data","relationAlias":"fBizState,fBizStateName,fName,fParent,fProjectID,fURL,version","relationTypes":"String,String,String,String,String,String,Integer","relations":"V_COST_SUPPLYTREE.fBizState,V_COST_SUPPLYTREE.fBizStateName,V_COST_SUPPLYTREE.fName,V_COST_SUPPLYTREE.fParent,V_COST_SUPPLYTREE.fProjectID,V_COST_SUPPLYTREE.fURL,V_COST_SUPPLYTREE.version","sys.count":495,"sys.rowid":"V_COST_SUPPLYTREE","updateMode":"whereVersion"}}}
devDebug true
2017-07-13 16:20:12 invoke invokeActions before lock.unlockWrite()
devDebug true
2017-07-13 16:20:12 invoke invokeActions after lock.unlockWrite()
2017-07-13 16:20:12 __invokeActionsFromLua end
2017-07-13 16:20:12 __invokeActionsToLua end
devDebug true
2017-07-13 16:20:12 invoke getTrackingCode, sessionid:FA403AEA630681D517E9494A98690BD0

15030479317

15030479317 发表于 2017-7-13 16:33
2017-07-13 16:20:12 [Action Time]action执行时间：403ms,/PM/PM/process/cont_SupplyTrendChart/cont_S ...

2017-07-13 16:20:12 >>>> business action cost: 430 ms, (action: [queryV_COST_SUPPLYTREEAction], session: FA403AEA630681D517E9494A98690BD0)
2017-07-13 16:20:12 action result:{"aCode":"","code":"","customer":"0","data":{"actionFlag":"__action_0__","value":{"@type":"table","rows":[{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7AB6ED3FA134433AA3538929D681DF61"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"95DE26B427884ED9A40B6C83C5DB5CE9"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"2968E7465CE44A2BA8669B1B3731F172"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"44B7BBD95F454083B1E44C679CE79006"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"EC2E76AA1F9646E9885856A6E3B305CA"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"BA72E9B6A40A492AA799657DFC037F30"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"58BB3347197D4B1FB4AD9F4C54743AF0"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"0F289844B7F649D5A73D5F2D4CBBF95E"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"17FB3DDADF614B72BA9C53EC2289591F"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"D6E5873D9EEF4F99A3F58A59F5165B48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"D20570B8B4564ED2816E683C30EB112B"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"63A5742D7CC84C79AFB85EAC07E55E9C"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"9AD4956606BE48C391DA684EF751482B"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7D3546F8C39248DDB48774FA60EE21C7"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"A788A6B1BDAB4A82BB16B6E48A0AAC48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"00102FA1350340ABB30E970B50F29721"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"B350CC9F817B494DB3E05D82930EC2B2"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"FD473075F7074E148058D559E076E49E"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"9C489D5539EE41629508DF9E1F9CBA30"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}},{"V_COST_SUPPLYTREE":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"fBizState":{"value":"tesReady"},"fBizStateName":{"value":"尚未处理"},"fName":{"value":"装修工程"},"fParent":{},"fProjectID":{"value":"7CFD72E7ED334E0A90A2563F9D17DC48"},"fURL":{"value":"F21332BB6E6549EC9DE92E6967229B21"},"userdata":{"id":{"value":"F21332BB6E6549EC9DE92E6967229B21"}},"version":{"value":0}}],"userdata":

15030479317

15030479317 发表于 2017-7-13 16:33
2017-07-13 16:20:12 >>>> business action cost: 430 ms, (action: [queryV_COST_SUPPLYTREEAction], se ...

{"idColumnDefine":"V_COST_SUPPLYTREE","idColumnName":"V_COST_SUPPLYTREE","idColumnType":"String","model":"/PM/PM/data","relationAlias":"fBizState,fBizStateName,fName,fParent,fProjectID,fURL,version","relationTypes":"String,String,String,String,String,String,Integer","relations":"V_COST_SUPPLYTREE.fBizState,V_COST_SUPPLYTREE.fBizStateName,V_COST_SUPPLYTREE.fName,V_COST_SUPPLYTREE.fParent,V_COST_SUPPLYTREE.fProjectID,V_COST_SUPPLYTREE.fURL,V_COST_SUPPLYTREE.version","sys.count":495,"sys.rowid":"V_COST_SUPPLYTREE","updateMode":"whereVersion"}}},"ext":"","flag":true,"guid":"0","md5":"","message":"","messages":"[]","reason":"","stack":"","sys":"7b73e2e6d863411029d28e929890ae85becf224300792ae1bef64ad324d4096c6de5479b6115490ac2ed2c6b631a17cc15862670049b63169c483d3fd5f872c20b13c888a77c0a5e40f6d3c3f896bf528aa5ac60c01cc64d1012ffaf67f028bbf58fb60f6d726863a1002c22e4ea8ddf82f92daafc001b5c007b3e7e0df095ccb9acf32a3cf2aeb9d9e15496aea75706c6cb361ee4b6836f4f9fd823201ed9542431894e7ed1f5f605cbaacf9f819028783133113c9bc4560429461ec959bf95a8f040abef823abd9fa0c90e73890090b5067d6ca541d124662e785905d3353764ca644e5efc938c07515c72a6e78420b048f1ddda007a4f49f32552a71b932e81e6341cdffb3987cee489f90f8e2d11aa1de3e5b2b42c4f800304c0aee3a17ec256148b4505918b773592cffddd633a8bf34b70b2af8cc0aae6569f67eb3488a77c80c019685b5848fa2f51fa120fe82ba2b3712be31a793963cd6b6dea7dafe6f83217c1cd9617cad3d214921cb348b2e7cd9743ea4980bd7d59f967df0441afbd96387beadc06eee7dc5fd945e96b445e23b64cfa19af8c54bdde29cb4942a2c3bb08c31046c3f3082e4c768d31f1828173304542392db6a4bb3d9b245713f3f362fd322d400b305d9f5ce92e61bf521275889bf62162eaf1100551e2834e236bbbcb8b9407337412a8e54db330ae26cdbc0a80fb2e7f275d297859e89901bc126a30dffa8a870d151a21f45e7c9a5c0a1fa1d64b4e7d51e3cbf24a6b3e2c78fd99c52285474c1f7954ed1a97a662e91ec0bf45fc0f5090983f46999986794fef5353a590e9ac6f9b64c4453274981024290c9f2f9982df5c38ca4d4e78935816ee7ec87323c3b70d7342d73662744826a3cd42b93f45c2bbdc2b63a03c51fe4e989b681f478ffd06f36548a1018f96500e5dbfd653845459df38f9fa65fa131c73bf3aa75715bc7b795b9f33992f61f69c75da464f0c936af9f1fbd95cd74fd8c4a537e6815cdce097c244583a554f2ef6d75184834e0fb03c10e97e9419e3c43d0e67bf3f7e459040fd6d67829f4393e8b7bcdd45a61daf911d11850bf7d3fa55efa12c7cd3b56eb7dd5e4183c92689da1b90aaa96cc7d85e9d6956ab017c6c093ca054beb36d2f253b2bd51625a701925a3340781e615e20dd5b7d7246091e32e257f4b143a4fcfae22b6aa0eba0fdad266a440194ff0b697999311cd1725edc9b4ca9ed1229324d2168ae40b71bf94460ff765b71d1ac7529f19e7723491f58ecac10422ba7878cef3baa57189c85b378998199a88c004505862f5bf57f7373855c19f5707f0a30ac91852ba1578f97d1ac14f7d0e6867902a777ef78ebd185a3e1a2d81e2b09582add36cf1b0b270c1300e5b1e3de60760ce35f83ea14315261ed83da6643e07de920c51741daa6339cf27ed9a759aafe224d469edc0cb6e705dc4b0791a37880ec08cf0305ae4af7713bfcabe22c25b763777678184a5afd0d1867f106dd6d98d47ab27aee4f9303cd07fcf3049e9ceecd926c9e6db641b588ac154ce130820868c88711fb6cf985081a08af39edb59b47a51baf1c3bf1d85c633e61b0902aef9b9ba55432d19d5cfd0b77030f36579c7d68b7153b91de488447d697792565aeb1a5ee03f8e3215710e49e3baa63036928d51ac98a489e4161f11fa85ac57623763c9d22ab66d34ba29e489b02a80b7634d92229ed49dba20771dcff4be39762ceff323e2351e1942f617a6e166e16fa8d94d6f536ed2694939b9e3ebb9f0ab742ad593ac0a9d8744cca1464c76c798fc7834803255962116cce4c54d920c15d5cfbcb15ee1effd3139b69046405b4e6c9ac20c013b9255fcd11545dfc326dd3b59041d55e28ee55c5359e87bc58204dc8fab7bdeb72fed1fcc4690808d1f529c692ce71aaeae27d368b50bfbad3c4480aa7a46ad1369b64f82e6c4998529f926e974bc685814ae906bfa937315cd01652dd005f9601677c8bc72b378096ca0ad5ecae8ee614da52f2e3861af3269a15c050030b729378696f251f348962bcaa0998f4f8768dd9afc086f8d0db32226f9ff1393f8896c2531178d2a0d0bd7beaed4f6955db6a65f2828be89e09ef2088cb35b0a4d9ba64cac89b3c2917303ba3b92660d6aea6a0e1c7f41cccf88cbafc8fc54c6edeec7218f1db0b5f6e7e8e77129703fa6a9015a3bcf409cde3fb2eaba03a307c9ac45378a981a941531920be20d5d3daec1474a9e7659a6df0d77542405f878e2db63e9c199cddfc406e53fe4c22dca0f7c3b7a99e108d1b69ee3eb9961c6d5cc37e680242d687f47da15d7a0c51db898570bdd98e0444c3ffbaeba26d4a52e48fdba875ca3e03c9aef5a72757e0607e8990258c6255329b785205ad8cefa60da6022b1fbeca5c8ea5394a565d822cb18c3eda3b870953e6e8074cc4b57c9aee063459ab0972a22e17a492c16c9ca738d95490cd5a24ffaabb70ef2eae20be524db0ec57005f99135dbe77c4a049404cde5672201ffe4886d418a326de76dbbd510a46744f0284599ccf41931880ed9a7a18fc12bda9144df1bd56b4df5319a280a21fd8e6f4cf61651709e7b2e31d0c71c4e10c986147e2e0e6e04d4a4bad2061c196574ffe90f6ffc3962b419596de3065fb6d677180e22ea29cc4cb35495d193d89a78ffa2dcbef3b1dc586f087fec73383a140647c708612153e8e77dc4861aca47b1ea760d80724ca98c267eb446d7118310947e90e2327fc9de722432f5c0df4bde71288cd603cbffc913ed65a125b7a42b7c34c35eec08d349e19e66b8592139439e1a2d9db362fdc9cab955e6743a2879260ef62d23b7c32c9d26ad8a3962984521b285d4f41494a895610d910705f81418751eb3aa1d5d60e362c9e1b44268a92302edc51026c0427c50cd1ed1d883033350f7df466208a19ac25587991f6d32fd793c2302b2b5d420b0f8cfb7303d40430b046b0aa190f553953771821e862683896e0e5708dadf464b61bf8873569e9ee813fa05d8ad80f716f5ecd82ba693429517ccbee8c59a9d396e119b85e8bca39eb0ef3a0c9910dd3b00bf452301b1f4873c8406150aa2e95417e9836a9ee66b5841a0cd9e99c3f88ecc273f766a8d9db3302d67553","ver":"0"}
devDebug true
2017-07-13 16:20:12 action result:<?xml version="1.0" encoding="UTF-8"?>
<root><flag>true</flag><message></message><code></code><reason></reason><stack></stack><data>0a3a12ab2078af56a0786fd4fe5badd7</data><messages>[]</messages></root>
2017-07-13 16:20:12 execute stream actions params:{"accept":"application/json","action":"openActivityAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"application/json","executeContext":"","executor":"","parameters":{},"process":"/PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess"}
devDebug true
devDebug true
2017-07-13 16:20:12 __invokeActionsToLua begin
__invokeActionsFromLua begin...
2017-07-13 16:20:12 __invokeActionsFromLua begin
devDebug true
2017-07-13 16:20:12 invoke invokeActions before lock.lockWrite()
devDebug true
2017-07-13 16:20:12 invoke invokeActions after lock.lockWrite()
2017-07-13 16:20:12 __invokeActionToLua begin
__invokeActionFromLua begin...
2017-07-13 16:20:12 __invokeActionFromLua begin
devDebug true
devDebug true
devDebug true
devDebug true
2017-07-13 16:20:12 invoke getSessionContextKey, sessionid:FA403AEA630681D517E9494A98690BD0, result:KdSgTOmpgsP/LX9dagGMnE50zkNIioPUBn4qS595RMuG1Hg27zpxadAia9l0YuQt

15030479317

15030479317 发表于 2017-7-13 16:34
{"idColumnDefine":"V_COST_SUPPLYTREE","idColumnName":"V_COST_SUPPLYTREE","idColumnType":"String"," ...

2017-07-13 16:20:12 根据名字checkPermission获取Config ->/system/config/checkPermission@Config
2017-07-13 16:20:12
exec sql:insert into SA_Log  (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue)
--> binds:[管理者代表, mainActivity, openActivityAction, /ORG01.ogn/A1441C0125684347BA166ADD78F3AC0C.ogn/25A84FF8B99049ADBD7E92CAC93A2EC9.dpt/1EA5FB1BA7A74E82A91CB2F9E18F7642.pos/PSN01@1EA5FB1BA7A74E82A91CB2F9E18F7642.psm, /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, system, 2017-07-13 16:20:12.43, , 打开功能, 0:0:0:0:0:0:0:1, Computer, 采购价格趋势, 失败, null, /华北建设集团有限公司/集团总公司/公司领导/管理者代表/system, PSN01, 集团总公司, WINDOWS_7, 0, 2DE7C46F7EE8432D9F501D985FEDAF95, , 1EA5FB1BA7A74E82A91CB2F9E18F7642, 采购价格趋势, 25A84FF8B99049ADBD7E92CAC93A2EC9, 操作日志, 公司领导, A1441C0125684347BA166ADD78F3AC0C]
2017-07-13 16:20:12 根据名字dataSource获取Config ->/system/data/dataSource@Config
2017-07-13 16:20:12 根据名字dataSource获取Config ->/system/data/dataSource@Config
2017-07-13 16:20:12 获取数据库的连接参数：java:comp/env/system
2017-07-13 16:20:12 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/openActivityAction -> create conn :  name=java:comp/env/system, connNum = 1
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:12 事务状态转换，当前状态：6, 接受倒的状态:10, 正在启动懒惰事务
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前：insert into SA_Log  (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue)
处理隔离字段后：insert into SA_Log  (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID
) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:12 事务状态转换，当前状态：10, 接受倒的状态:3, 正在提交事务
2017-07-13 16:20:12 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/openActivityAction -> close conn:name=java:comp/env/system, active=1, connNum = 0
2017-07-13 16:20:12 关闭连接：<CoreConnection name=java:comp/env/system, active=1, count=1, closed=true, conn =NULL, autocommit=unknow>
2017-07-13 16:20:12 [JVM]start...B9976DDF01D24AE7921DA6C142B14FFC, process: /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, activity: mainActivity, action: openActivityAction
2017-07-13 16:20:12 __doActionEventToLua begin
__doActionEventFromLua begin...
2017-07-13 16:20:12 __doActionEventFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureToLua begin
__invokeProcedureFromLua begin...
2017-07-13 16:20:12 __invokeProcedureFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureFromLua end
2017-07-13 16:20:12 __invokeProcedureToLua end
2017-07-13 16:20:12 __doActionEventFromLua end
2017-07-13 16:20:12 __doActionEventToLua end
2017-07-13 16:20:12 __doActionToLua begin
__doActionFromLua begin...
2017-07-13 16:20:12 __doActionFromLua begin
2017-07-13 16:20:12 __doAction begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureToLua begin
__invokeProcedureFromLua begin...
2017-07-13 16:20:12 __invokeProcedureFromLua begin
devDebug true
2017-07-13 16:20:12 invoke procedure, find code method:SystemProcedure.openActivity
2017-07-13 16:20:12 /system/logic/code下获取方法：SystemProcedure.openActivity ...
2017-07-13 16:20:12 在/system/logic/code中查找dynamic类：SystemProcedure
2017-07-13 16:20:12 __invokeProcedureFromLua end
2017-07-13 16:20:12 __invokeProcedureToLua end
2017-07-13 16:20:12 __doAction end
2017-07-13 16:20:12 __doActionFromLua end
2017-07-13 16:20:12 __doActionToLua end
2017-07-13 16:20:12 __doActionEventToLua begin
__doActionEventFromLua begin...
2017-07-13 16:20:12 __doActionEventFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureToLua begin
__invokeProcedureFromLua begin...
2017-07-13 16:20:12 __invokeProcedureFromLua begin
devDebug true
2017-07-13 16:20:12 __invokeProcedureFromLua end
2017-07-13 16:20:12 __invokeProcedureToLua end
2017-07-13 16:20:12 __doActionEventFromLua end
2017-07-13 16:20:12 __doActionEventToLua end
2017-07-13 16:20:12
exec sql:update SA_Log set sStatusName=?,sResult=? where SID='2DE7C46F7EE8432D9F501D985FEDAF95' and $clientFilter(NULL)
--> binds:[成功, ]
2017-07-13 16:20:12 根据名字dataSource获取Config ->/system/data/dataSource@Config
2017-07-13 16:20:12 根据名字dataSource获取Config ->/system/data/dataSource@Config
2017-07-13 16:20:12 获取数据库的连接参数：java:comp/env/system
2017-07-13 16:20:12 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/openActivityAction -> create conn :  name=java:comp/env/system, connNum = 1
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:12 事务状态转换，当前状态：6, 接受倒的状态:10, 正在启动懒惰事务
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
处理隔离字段前：update SA_Log set sStatusName=?,sResult=? where SID='2DE7C46F7EE8432D9F501D985FEDAF95' and $clientFilter(NULL)
处理隔离字段后：update SA_Log set sStatusName=?,sResult=? where SID='2DE7C46F7EE8432D9F501D985FEDAF95' and
1=1
2017-07-13 16:20:12 Connection product name:Oracle
2017-07-13 16:20:12 Connection product version:Oracle Database 11g Release 11.1.0.0.0 - Production
2017-07-13 16:20:12 事务状态转换，当前状态：10, 接受倒的状态:3, 正在提交事务
2017-07-13 16:20:12 /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess/mainActivity/openActivityAction -> close conn:name=java:comp/env/system, active=1, connNum = 0
2017-07-13 16:20:12 关闭连接：<CoreConnection name=java:comp/env/system, active=1, count=1, closed=true, conn =NULL, autocommit=unknow>
2017-07-13 16:20:12 [JVM]end.....B9976DDF01D24AE7921DA6C142B14FFC, process: /PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess, activity: mainActivity, action: openActivityAction, operator: PSN01, system, total: 3066MB, free: 184MB, use: 2882MB, leak free: -1MB, leak use: 0MB
2017-07-13 16:20:12 [Action Time]action执行时间：191ms,/PM/PM/process/cont_SupplyTrendChart/cont_SupplyTrendChartProcess,mainActivity,openActivityAction
2017-07-13 16:20:12 __invokeActionFromLua end
2017-07-13 16:20:12 __invokeActionToLua end
2017-07-13 16:20:12 start translate ...
2017-07-13 16:20:12 translate data : {"actionFlag":"__action_0__"}
devDebug true
2017-07-13 16:20:12 invoke invokeActions before lock.unlockWrite()
devDebug true
2017-07-13 16:20:12 invoke invokeActions after lock.unlockWrite()
2017-07-13 16:20:12 __invokeActionsFromLua end
2017-07-13 16:20:12 __invokeActionsToLua end
devDebug true
2017-07-13 16:20:12 invoke getTrackingCode, sessionid:FA403AEA630681D517E9494A98690BD0