技术文章 - CS240872
在使用 com.ptc.windchill.option.variantspec.loader.VariantSpecLoader 加载变体规范时重复多次相同的数据库查询,结果应该被缓存/重用
已修改: 23-Jun-2022
适用于
- Windchill PDMLink 10.2 M030
说明
- 在使用com.ptc.windchill.option.variantspec.loader.VariantSpecLoader加载变体规范时,相同的数据库查询会重复多次,结果应该被缓存/重用。
- 下面的 SQL 针对相同的绑定参数值重复执行:
SELECT 'com.ptc.windchill.option.model.Option',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.description,A0 .classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.hasHangingChange,A0.hasPendingChange,A0.hasResultingChange,A0.hasVariance,A0.index ,A0.inheritedDomain,A0.branchIditerationInfo,A0.classnamekeyD2iterationInfo,A0.idA3D2iterationInfo,A0.classnamekeyE2iterationInfo,A0.idA3E2iterationInfo,A0.iterationIdA2iterationInfo,A0.latestiterationInfo,A0.classnamekeyB2iterationInfo,A0.idA3B2iterationInfo,A0.noteiterationInfo,A00. .idA3C2iterationInfo,A0.stateiterationInfo,TO_CHAR(A0.datelock,'dd mm yyyy hh24:mi:ss'),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReferen ce,A0.idA3masterReference,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.requiredOption,A0.securityLabels,A0.singleChoiceSelection,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId, A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24: mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0。 versionSortIdA2versionInfo,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.classnamekeyA5,A0B.idA3A5,A0B.name,A0B.optionnumber,A0B.optionDataType,A0B.overrideDisplayUnits,A0B.classnamekeyB5,A0B.idA3B5,A0B.series,TO_CHAR(A0B. createStampA2,'dd mm yyyy hh24:mi:ss'),A0B.markForDeleteA2,TO_CHAR(A0B.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0B.c lassnameA2A2,A0B.idA2A2,A0B.updateCountA2,TO_CHAR(A0B.updateStampA2,'dd mm yyyy hh24:mi:ss') FROM ATOOption2 A0,ATOOption2Master A0B WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((A0.idA2A2 = ?))
这是文章 240872 的 PDF 版本,可能已过期。最新版本 CS240872