Hello everybody,

i have a "Performance problem" on insert/update in Hibernate, because Hibernate issues the query (see bottom) in Oracle.

I have analyzed it and found the hibernate select the whole Business Object I have modeled using "cascade-all" on each "Insert" of an object.
So the query is executed several 1000 times, which consumes to much time.

I learend the "using" UUID (hibernate generated) will consume 2 db transaction on each insert. Why??
Is there a way to supress the execution of the select statement beyond

Is there a way to coming out of this, with out nuking the DB/object schema?
What about own "uuid" generation (so not using the <generate id tag>)?

Regards,
nightowl



select persistent0_.uuid as uuid0_, persistent0_.internalLock as
internal2_0_, persistent0_.DATA_SOURCE_UUID as DATA3_0_,
persistent0_1_.refValue1 as refValue2_1_,
persistent0_1_.refValue2 as refValue3_1_,
persistent0_1_.projectValue2 as projectV4_1_,
persistent0_1_.projectValue1 as projectV5_1_,
persistent0_1_.COST_CENTER_UUID as COST6_1_,
persistent0_1_.HARDWARE_TYPE_UUID as HARDWARE7_1_,
persistent0_1_.DEVISION_GROUP_UUID as DEVISION8_1_,
persistent0_1_.FUNCTION_TYPE_UUID as FUNCTION9_1_,
persistent0_1_.PRODUCTION_TYPE_UUID as PRODUCTION10_1_,
persistent0_1_.PLANNING_UUID as PLANNING11_1_,
persistent0_2_.acl as acl2_, persistent0_2_.CREATED_UUID as
CREATED3_2_, persistent0_2_.SAVED_UUID as SAVED4_2_,
persistent0_2_.LOCKED_UUID as LOCKED5_2_,
persistent0_2_.LOCK_STATUS_UUID as LOCK6_2_,
persistent0_3_.name as name3_, persistent0_3_.description as
descript3_3_, persistent0_3_.OBJECT_TYPE_UUID as OBJECT4_3_,
persistent0_3_.FOLDER_UUID as FOLDER5_3_,
persistent0_3_.CURRENT_PROPERTY_SET_UUID as CURRENT6_3_,
persistent0_4_.REV_ITEM_UUID as REV2_4_,
persistent0_4_.BOM_UUID as BOM3_4_, persistent0_5_.OWNER_UUID
as OWNER2_5_, persistent0_6_.isDefault as isDefault6_,
persistent0_6_.isLatestRev as isLatest3_6_,
persistent0_6_.revId as revId6_, persistent0_6_.PRE_REV_UUID
as PRE5_6_, persistent0_6_.CURRENT_RELEASE_OBJ_UUID as
CURRENT6_6_, persistent0_6_.FIRST_REV_UUID as FIRST7_6_,
persistent0_6_.REVISED_UUID as REVISED8_6_,
persistent0_6_.ITEM_UUID as ITEM9_6_,
persistent0_7_.engineNewZP4 as engineNe2_7_,
persistent0_7_.eptNewZP7 as eptNewZP3_7_,
persistent0_7_.engineNewZP7 as engineNe4_7_,
persistent0_7_.eptNewZP4 as eptNewZP5_7_,
persistent0_7_.powerTrainKnown as powerTra6_7_,
persistent0_7_.ENGINE_UUID as ENGINE7_7_,
persistent0_7_.REGION_UUID as REGION8_7_,
persistent0_7_.POWER_TRAIN_UUID as POWER9_7_,
persistent0_7_.EMISSION_STD_UUID as EMISSION10_7_,
persistent0_7_.INFLUENCES_UUID as INFLUENCES11_7_,
persistent0_8_.name as name8_, persistent0_8_.UE_MODEL_UUID
as UE3_8_, persistent0_8_.AWS100P_PROJECT_UUID as AWS4_8_,
persistent0_9_.OWNER_UUID as OWNER2_9_,
persistent0_9_.REV_ITEM_UUID as REV3_9_,
persistent0_11_.EPT_MODEL_UUID as EPT2_11_,
persistent0_13_.type as type13_,
persistent0_13_.EPT_MODEL_UUID as EPT3_13_,
persistent0_14_.type as type14_,
persistent0_14_.EPT_MODEL_UUID as EPT3_14_,
persistent0_15_.EPT_MODEL_UUID as EPT2_15_,
persistent0_15_.AWS100P_PROJECT_UUID as AWS3_15_,
persistent0_16_.abbr as abbr16_, persistent0_16_.costUnit as
costUnit16_, persistent0_16_.EPT_MODEL_UUID as EPT4_16_,
persistent0_18_.UE_MODEL_UUID as UE2_18_,
persistent0_19_.UE_MODEL_UUID as UE2_19_,
persistent0_20_.UE_MODEL_UUID as UE2_20_,
persistent0_21_.UE_MODEL_UUID as UE2_21_,
persistent0_22_.GEAR_UUID as GEAR2_22_,
persistent0_22_.UE_MODEL_UUID as UE3_22_,
persistent0_22_.DRIVE_UUID as DRIVE4_22_,
persistent0_23_.UE_MODEL_UUID as UE2_23_,
persistent0_24_.EFFORT_TYPES_UUID as EFFORT2_24_,
persistent0_24_.CHILDREN_UUID as CHILDREN3_24_,
persistent0_24_.SCOPE_UUID as SCOPE4_24_,
persistent0_24_.PPMS_MODEL_UUID as PPMS5_24_,
persistent0_25_.PROJECT_UUID as PROJECT2_25_,
persistent0_25_.PPMS_MODEL_UUID as PPMS3_25_,
persistent0_26_.erpId as erpId26_, persistent0_26_.no as
no26_, persistent0_26_.PROJECT_UUID as PROJECT4_26_,
persistent0_26_.CHILDREN_UUID as CHILDREN5_26_,
persistent0_26_.RESPONSIBLE_UUID as RESPONSI6_26_,
persistent0_26_.HOURLY_RATES_UUID as HOURLY7_26_,
persistent0_26_.ORGA_UUID as ORGA8_26_,
persistent0_27_.PROJECT_UUID as PROJECT2_27_,
persistent0_27_.EFFORT_TYPES_UUID as EFFORT3_27_,
persistent0_27_.COST_CENTER_UUID as COST4_27_,
persistent0_28_.valueValue as valueValue28_,
persistent0_28_.valueUnit as valueUnit28_,
persistent0_28_.valueFormula as valueFor4_28_,
persistent0_28_.PROJECT_UUID as PROJECT5_28_,
persistent0_28_.RATE_UUID as RATE6_28_,
persistent0_28_.COST_TYPE_UUID as COST7_28_,
persistent0_29_.effortEditable as effortEd2_29_,
persistent0_29_.costEditable as costEdit3_29_,
persistent0_29_.PROJECT_UUID as PROJECT4_29_,
persistent0_29_.EFFORT_TYPE_CLASS_UUID as EFFORT5_29_,
persistent0_29_.PPMS_MODEL_UUID as PPMS6_29_,
persistent0_30_.PPMS_MODEL_UUID as PPMS2_30_,
persistent0_31_.SCOPE_UUID as SCOPE2_31_,
persistent0_31_.PPMS_MODEL_UUID as PPMS3_31_,
persistent0_32_.valueValue as valueValue32_,
persistent0_32_.valueUnit as valueUnit32_,
persistent0_32_.valueFormula as valueFor4_32_,
persistent0_32_.fractionFormula as fraction5_32_,
persistent0_32_.fractionUnit as fraction6_32_,
persistent0_32_.fractionValue as fraction7_32_,
persistent0_32_.HOURLY_RATE_SYSTEM_UUID as HOURLY8_32_,
persistent0_33_.COST_CENTER_UUID as COST2_33_,
persistent0_34_.TIME_LINE_MODEL_UUID as TIME2_34_,
persistent0_35_.ROOTCC_UUID as ROOTCC2_35_,
persistent0_37_.unitDefinition as unitDefi2_37_,
persistent0_37_.steps as steps37_,
persistent0_37_.PROJECT_UUID as PROJECT4_37_,
persistent0_37_.TIME_LINE_MODEL_UUID as TIME5_37_,
persistent0_41_.amountUnit as amountUnit41_,
persistent0_41_.amountFormula as amountFo3_41_,
persistent0_41_.amountValue as amountVa4_41_,
persistent0_41_.EFFORT_UUID as EFFORT5_41_,
persistent0_42_.hasTimeLine as hasTimeL2_42_,
persistent0_42_.pspCode as pspCode42_,
persistent0_42_.TIME_LINE_UUID as TIME4_42_,
persistent0_42_.RESPONSIBLE_UUID as RESPONSI5_42_,
persistent0_42_.CREATOR_UUID as CREATOR6_42_,
persistent0_42_.SOURCE_UUID as SOURCE7_42_,
persistent0_43_.blockedFormula as blockedF2_43_,
persistent0_43_.activeFormula as activeFo3_43_,
persistent0_43_.blockedValue as blockedV4_43_,
persistent0_43_.endDate as endDate43_,
persistent0_43_.detailDesc as detailDesc43_,
persistent0_43_.activeValue as activeVa7_43_,
persistent0_43_.useable as useable43_,
persistent0_43_.amountFixed as amountFi9_43_,
persistent0_43_.startDate as startDate43_,
persistent0_43_.CHILDREN_UUID as CHILDREN11_43_,
persistent0_43_.ACTIVITY_TYPE_UUID as ACTIVITY12_43_,
persistent0_43_.PROJECT_UUID as PROJECT13_43_,
persistent0_44_.valueValue as valueValue44_,
persistent0_44_.valueUnit as valueUnit44_,
persistent0_44_.valueFormula as valueFor4_44_,
persistent0_44_.PROJECT_UUID as PROJECT5_44_,
persistent0_44_.COST_CENTER_UUID as COST6_44_,
persistent0_44_.COST_TYPE_OCCURRANCE_UUID as COST7_44_,
persistent0_44_.ACTIVITY_RES_ASSOC_UUID as ACTIVITY8_44_,
persistent0_45_.valueValue as valueValue45_,
persistent0_45_.reducedValueValue as reducedV3_45_,
persistent0_45_.reductionFactorValue as reductio4_45_,
persistent0_45_.komplexityFormula as komplexi5_45_,
persistent0_45_.unit as unit45_, persistent0_45_.valueUnit as
valueUnit45_, persistent0_45_.basisValueUnit as basisVal8_45_,
persistent0_45_.komplexityValue as komplexi9_45_,
persistent0_45_.reducedValueUnit as reduced10_45_,
persistent0_45_.reductionFactorFormula as reducti11_45_,
persistent0_45_.komplexityUnit as komplex12_45_,
persistent0_45_.reductionFactorUnit as reducti13_45_,
persistent0_45_.CBVFormula as CBVFormula45_,
persistent0_45_.CBVUnit as CBVUnit45_,
persistent0_45_.valueFormula as valueFo16_45_,
persistent0_45_.basisValueFormula as basisVa17_45_,
persistent0_45_.reducedValueFormula as reduced18_45_,
persistent0_45_.CBVValue as CBVValue45_,
persistent0_45_.basisValueValue as basisVa20_45_,
persistent0_45_.EFFORT_VARIANT_UUID as EFFORT21_45_,
persistent0_45_.ACTIVITY_UUID as ACTIVITY22_45_,
persistent0_45_.EFFORT_TYPE_UUID as EFFORT23_45_,
persistent0_46_.acl as acl46_, persistent0_46_.FUNCTION_UUID
as FUNCTION3_46_, persistent0_46_.PROJECT_UUID as
PROJECT4_46_, persistent0_47_.simulation as simulation47_,
persistent0_47_.privateSandbox as privateS3_47_,
persistent0_47_.toDate as toDate47_,
persistent0_47_.releasedTemplate as released5_47_,
persistent0_47_.fromDate as fromDate47_,
persistent0_47_.calculated as calculated47_,
persistent0_47_.TIME_LINE_MODEL_UUID as TIME8_47_,
persistent0_47_.DERIVED_FROM_UUID as DERIVED9_47_,
persistent0_47_.ROOT_ACTIVITY_UUID as ROOT10_47_,
persistent0_47_.PPMS_MODEL_UUID as PPMS11_47_,
persistent0_47_.ORGA_UUID as ORGA12_47_,
persistent0_47_.TIME_LINE_DEFINITION_UUID as TIME13_47_,
persistent0_48_.awsVersion as awsVersion48_,
persistent0_48_.sop as sop48_, persistent0_48_.awsNo as
awsNo48_, persistent0_48_.eaNo as eaNo48_,
persistent0_48_.PRODUCT_LINE_UUID as PRODUCT6_48_,
persistent0_48_.DERIVED_UUID as DERIVED7_48_,
persistent0_48_.CURRENT_INFLUENCES_UUID as CURRENT8_48_,
persistent0_48_.CURRENT_PLANNING_UUID as CURRENT9_48_,
persistent0_49_.OWNER_UUID as OWNER2_49_,
persistent0_49_.TIME_LINE_DEFINITION_UUID as TIME3_49_,
persistent0_50_.LINKED_RELEASE_TYPES_UUID as LINKED2_50_,
persistent0_50_.VALID_OBJECT_TYPE_UUID as VALID3_50_,
persistent0_51_.name as name51_, persistent0_51_.description
as descript3_51_, persistent0_52_.FROM_LINK_UUID as FROM2_52_,
persistent0_52_.TO_LINK_UUID as TO3_52_,
persistent0_53_.valueUnit as valueUnit53_,
persistent0_53_.valueValue as valueValue53_,
persistent0_53_.valueType as valueType53_,
persistent0_53_.valueName as valueName53_,
persistent0_53_.PROPERTY_SET_UUID as PROPERTY6_53_,
persistent0_54_.currentRole as currentR2_54_,
persistent0_54_.name as name54_, persistent0_54_.description
as descript4_54_, persistent0_54_.DISPLAY_OBJECT_UUID as
DISPLAY5_54_, persistent0_55_.BOM_UUID as BOM2_55_,
persistent0_55_.OBJECT_TYPE_UUID as OBJECT3_55_,
persistent0_56_.value as value56_, persistent0_56_.lang as
lang56_, persistent0_56_.key as key56_,
persistent0_56_.DISPLAY_OBJECT_UUID as DISPLAY5_56_,
persistent0_57_.FOLDER_UUID as FOLDER2_57_,
persistent0_57_.OBJECT_TYPE_UUID as OBJECT3_57_,
persistent0_58_.text as text58_, persistent0_58_.source_uuid
as source3_58_, persistent0_58_.sourceType as sourceType58_,
persistent0_58_.serializedValues as serializ5_58_,
persistent0_58_.SAVED_UUID as SAVED6_58_,
persistent0_59_.itemId as itemId59_,
persistent0_60_.CREATED_UUID as CREATED2_60_,
persistent0_60_.FOLDER_UUID as FOLDER3_60_,
persistent0_60_.DISPLAY_OBJECT_UUID as DISPLAY4_60_,
persistent0_60_.LINK_TYPE_UUID as LINK5_60_,
persistent0_61_.name as name61_, persistent0_62_.logReason as
logReason62_, persistent0_62_.logDate as logDate62_,
persistent0_62_.role as role62_, persistent0_62_.CREATOR_UUID
as CREATOR5_62_, persistent0_63_.conditionFormula as
conditio2_63_, persistent0_63_.conditionValue as
conditio3_63_, persistent0_63_.conditionUnit as conditio4_63_,
persistent0_63_.SOURCE_UUID as SOURCE5_63_,
persistent0_63_.ACTIVITY_UUID as ACTIVITY6_63_,
persistent0_64_.userText as userText64_,
persistent0_64_.EFFORT_TYPE_UUID as EFFORT3_64_,
persistent0_64_.CALC_BASE_UUID as CALC4_64_,
persistent0_65_.t100pValueExtern2 as t2_65_,
persistent0_65_.amountFormula2 as amountFo3_65_,
persistent0_65_.TEMAT1 as TEMAT4_65_, persistent0_65_.TEMAT2
as TEMAT5_65_, persistent0_65_.TSum2 as TSum6_65_,
persistent0_65_.TSum1 as TSum7_65_, persistent0_65_.TVMAT2 as
TVMAT8_65_, persistent0_65_.TVMAT1 as TVMAT9_65_,
persistent0_65_.HEffort2 as HEffort10_65_,
persistent0_65_.HEffort1 as HEffort11_65_,
persistent0_65_.PRedFactor2 as PRedFactor12_65_,
persistent0_65_.PRedFactor1 as PRedFactor13_65_,
persistent0_65_.t100pValue2 as t14_65_,
persistent0_65_.TRedSum2 as TRedSum15_65_,
persistent0_65_.PSum1 as PSum16_65_, persistent0_65_.PSum2 as
PSum17_65_, persistent0_65_.TEffort2 as TEffort18_65_,
persistent0_65_.TEffort1 as TEffort19_65_,
persistent0_65_.h100pValueExtern1 as h20_65_,
persistent0_65_.amountFormula1 as amountF21_65_,
persistent0_65_.h100pValue2 as h22_65_,
persistent0_65_.TPVSum2 as TPVSum23_65_,
persistent0_65_.amountValue1 as amountV24_65_,
persistent0_65_.TPVSum1 as TPVSum25_65_,
persistent0_65_.t100pValueExtern1 as t26_65_,
persistent0_65_.amountValue2 as amountV27_65_,
persistent0_65_.TEffortExtern1 as TEffort28_65_,
persistent0_65_.TEffortExtern2 as TEffort29_65_,
persistent0_65_.TRedEMAT2 as TRedEMAT30_65_,
persistent0_65_.TRedEMAT1 as TRedEMAT31_65_,
persistent0_65_.TRedSum1 as TRedSum32_65_,
persistent0_65_.h100pValue1 as h33_65_,
persistent0_65_.h100pValueExtern2 as h34_65_,
persistent0_65_.comment2 as comment35_65_,
persistent0_65_.TRedVMAT2 as TRedVMAT36_65_,
persistent0_65_.TRedVMAT1 as TRedVMAT37_65_,
persistent0_65_.comment1 as comment38_65_,
persistent0_65_.TSupplierSum2 as TSuppli39_65_,
persistent0_65_.TSupplierSum1 as TSuppli40_65_,
persistent0_65_.HEffortExtern1 as HEffort41_65_,
persistent0_65_.HEffortExtern2 as HEffort42_65_,
persistent0_65_.t100pValue1 as t43_65_,
persistent0_66_.extentFraction2 as extentFr2_66_,
persistent0_66_.extentFraction1 as extentFr3_66_,
persistent0_66_.extentExtern2 as extentEx4_66_,
persistent0_66_.defaultExtern2 as defaultE5_66_,
persistent0_66_.extentExtern1 as extentEx6_66_,
persistent0_66_.defaultFraction2 as defaultF7_66_,
persistent0_66_.defaultFraction1 as defaultF8_66_,
persistent0_66_.defaultExtern1 as defaultE9_66_,
persistent0_66_.PPlatformFraction2 as PPlatfo10_66_,
persistent0_66_.PPlatformFraction1 as PPlatfo11_66_,
persistent0_66_.TPlatformFraction2 as TPlatfo12_66_,
persistent0_66_.TPlatformFraction1 as TPlatfo13_66_,
persistent0_67_.PInfluence1 as PInfluence2_67_,
persistent0_67_.PScalDefault2 as PScalDef3_67_,
persistent0_67_.PScaleFactor2 as PScaleFa4_67_,
persistent0_67_.PScaleFactor1 as PScaleFa5_67_,
persistent0_67_.PScalDefault1 as PScalDef6_67_,
persistent0_67_.PScalLower1 as PScalLower7_67_,
persistent0_67_.PScalLower2 as PScalLower8_67_,
persistent0_67_.PInfluence2 as PInfluence9_67_,
persistent0_67_.PScalUpper2 as PScalUpper10_67_,
persistent0_67_.PScalUpper1 as PScalUpper11_67_,
persistent0_68_.HPV122 as HPV2_68_, persistent0_68_.HPV121 as
HPV3_68_, persistent0_68_.TPV12Extern2 as TPV4_68_,
persistent0_68_.TPV12Extern1 as TPV5_68_,
persistent0_68_.TPV122 as TPV6_68_, persistent0_68_.TPV121 as
TPV7_68_, persistent0_68_.HPV12Extern2 as HPV8_68_,
persistent0_68_.HPV12Extern1 as HPV9_68_,
persistent0_69_.blockedFormula as blockedF2_69_,
persistent0_69_.activeFormula as activeFo3_69_,
persistent0_69_.blockedValue as blockedV4_69_,
persistent0_69_.activeValue as activeVa5_69_,
persistent0_69_.transitive as transitive69_,
persistent0_69_.LINK_UUID as LINK7_69_,
persistent0_69_.ACTIVITY_UUID as ACTIVITY8_69_,
persistent0_70_.step as step70_,
persistent0_70_.TIME_LINE_DEFINITION_UUID as TIME3_70_,
persistent0_70_.MILESTONE_DEFINITION_UUID as MILESTONE4_70_,
persistent0_71_.valueValue as valueValue71_,
persistent0_71_.valueMatValue as valueMat3_71_,
persistent0_71_.valueUnit as valueUnit71_,
persistent0_71_.fractionFormula as fraction5_71_,
persistent0_71_.fractionMatValue as fraction6_71_,
persistent0_71_.fractionValue as fraction7_71_,
persistent0_71_.fractionUnit as fraction8_71_,
persistent0_71_.valueMatUnit as valueMat9_71_,
persistent0_71_.step as step71_, persistent0_71_.valueFormula
as valueFo11_71_, persistent0_71_.valueMatFormula as
valueMa12_71_, persistent0_71_.fractionMatUnit as
fractio13_71_, persistent0_71_.fractionMatFormula as
fractio14_71_, persistent0_71_.TIME_LINE_UUID as TIME15_71_,
persistent0_72_.RELEASED_UUID as RELEASED2_72_,
persistent0_72_.PRE_RELEASE_OBJ_UUID as PRE3_72_,
persistent0_72_.REV_ITEM_UUID as REV4_72_,
persistent0_72_.RELEASE_TYPE_UUID as RELEASE5_72_,
persistent0_73_.account as account73_, persistent0_73_.name
as name73_, case when persistent0_11_.UUID is not null then
11 when persistent0_12_.UUID is not null then 12 when
persistent0_13_.UUID is not null then 13 when
persistent0_14_.UUID is not null then 14 when
persistent0_15_.UUID is not null then 15 when
persistent0_16_.UUID is not null then 16 when
persistent0_17_.UUID is not null then 17 when
persistent0_18_.UUID is not null then 18 when
persistent0_19_.UUID is not null then 19 when
persistent0_20_.UUID is not null then 20 when
persistent0_21_.UUID is not null then 21 when
persistent0_22_.UUID is not null then 22 when
persistent0_23_.UUID is not null then 23 when
persistent0_24_.UUID is not null then 24 when
persistent0_25_.UUID is not null then 25 when
persistent0_26_.UUID is not null then 26 when
persistent0_27_.UUID is not null then 27 when
persistent0_28_.UUID is not null then 28 when
persistent0_29_.UUID is not null then 29 when
persistent0_30_.UUID is not null then 30 when
persistent0_31_.UUID is not null then 31 when
persistent0_32_.UUID is not null then 32 when
persistent0_33_.UUID is not null then 33 when
persistent0_34_.UUID is not null then 34 when
persistent0_35_.UUID is not null then 35 when
persistent0_36_.UUID is not null then 36 when
persistent0_37_.UUID is not null then 37 when
persistent0_38_.UUID is not null then 38 when
persistent0_39_.UUID is not null then 39 when
persistent0_43_.UUID is not null then 43 when
persistent0_44_.UUID is not null then 44 when
persistent0_45_.UUID is not null then 45 when
persistent0_48_.UUID is not null then 48 when
persistent0_7_.UUID is not null then 7 when
persistent0_8_.UUID is not null then 8 when
persistent0_9_.UUID is not null then 9 when
persistent0_10_.UUID is not null then 10 when
persistent0_40_.UUID is not null then 40 when
persistent0_41_.UUID is not null then 41 when
persistent0_42_.UUID is not null then 42 when
persistent0_46_.UUID is not null then 46 when
persistent0_47_.UUID is not null then 47 when
persistent0_49_.UUID is not null then 49 when
persistent0_50_.UUID is not null then 50 when
persistent0_4_.UUID is not null then 4 when
persistent0_5_.UUID is not null then 5 when
persistent0_6_.UUID is not null then 6 when
persistent0_52_.UUID is not null then 52 when
persistent0_3_.UUID is not null then 3 when
persistent0_51_.UUID is not null then 51 when
persistent0_53_.UUID is not null then 53 when
persistent0_54_.UUID is not null then 54 when
persistent0_66_.UUID is not null then 66 when
persistent0_67_.UUID is not null then 67 when
persistent0_68_.UUID is not null then 68 when
persistent0_65_.UUID is not null then 65 when
persistent0_1_.UUID is not null then 1 when
persistent0_2_.UUID is not null then 2 when
persistent0_55_.UUID is not null then 55 when
persistent0_56_.UUID is not null then 56 when
persistent0_57_.UUID is not null then 57 when
persistent0_58_.UUID is not null then 58 when
persistent0_59_.UUID is not null then 59 when
persistent0_60_.UUID is not null then 60 when
persistent0_61_.UUID is not null then 61 when
persistent0_62_.UUID is not null then 62 when
persistent0_63_.UUID is not null then 63 when
persistent0_64_.UUID is not null then 64 when
persistent0_69_.UUID is not null then 69 when
persistent0_70_.UUID is not null then 70 when
persistent0_71_.UUID is not null then 71 when
persistent0_72_.UUID is not null then 72 when
persistent0_73_.UUID is not null then 73 when
persistent0_.uuid is not null then 0 end as clazz_
from PERSISTENT persistent0_, LINE persistent0_1_, APP_OBJECT
persistent0_2_, DISPLAY_OBJECT persistent0_3_, BOM_LINE
persistent0_4_, FOLDER persistent0_5_, REV_ITEM
persistent0_6_, EPT_USAGE persistent0_7_, INFLUENCES
persistent0_8_, BOM persistent0_9_, BASE_OBJ persistent0_10_,
DEVISION_GROUP persistent0_11_, EPT_MODEL persistent0_12_,
FUNCTION_TYPE persistent0_13_, HARDWARE_TYPE persistent0_14_,
PLANNING persistent0_15_, PRODUCTION_TYPE persistent0_16_,
PRODUCT_LINE persistent0_17_, DRIVE persistent0_18_,
EMISSION_STD persistent0_19_, ENGINE persistent0_20_, GEAR
persistent0_21_, POWER_TRAIN persistent0_22_, REGION
persistent0_23_, ACTIVITY_TYPE persistent0_24_,
BUSINESS_FUNCTION persistent0_25_, COST_CENTER
persistent0_26_, COST_TYPE persistent0_27_,
COST_TYPE_OCCURRANCE persistent0_28_, EFFORT_TYPE
persistent0_29_, EFFORT_TYPE_CLASS persistent0_30_,
EFFORT_VARIANT persistent0_31_, HOURLY_RATE persistent0_32_,
HOURLY_RATE_SYSTEM persistent0_33_, MILESTONE_DEFINITION
persistent0_34_, ORGA persistent0_35_, PPMS_MODEL
persistent0_36_, TIME_LINE_DEFINITION persistent0_37_,
TIME_LINE_MODEL persistent0_38_, UE_MODEL persistent0_39_,
DATA_SOURCE persistent0_40_, ACTIVITY_RES_ASSOC
persistent0_41_, CALC_BASE persistent0_42_, ACTIVITY
persistent0_43_, COST_TYPE_RES_OCC persistent0_44_, EFFORT
persistent0_45_, PROCESSACL persistent0_46_, PROJECT
persistent0_47_, AWS100P_PROJECT persistent0_48_, TIME_LINE
persistent0_49_, RELEASE_TYPE persistent0_50_, OBJECT_TYPE
persistent0_51_, LINK_TYPE persistent0_52_, PROPERTY
persistent0_53_, PROPERTY_SET persistent0_54_,
BOM_OBJECT_TYPE persistent0_55_, DISPLAY_TEXT persistent0_56_,
FOLDER_OBJECT_TYPE persistent0_57_, HISTORY persistent0_58_,
ITEM persistent0_59_, LINK_OBJECT persistent0_60_,
LOCK_STATUS persistent0_61_, LOG_INFO persistent0_62_,
ACTIVITY_CONDITION persistent0_63_, CALC_DATA persistent0_64_,
AWS100P_PROJECT_VALUES persistent0_65_, AWS100P_COST_VALUES
persistent0_66_, AWS100P_DETAIL_VALUES persistent0_67_,
AWS100P_VALUES persistent0_68_, LINKED_ACTIVITY
persistent0_69_, MILESTONE persistent0_70_, TIME_LINE_STEP
persistent0_71_, RELEASE_OBJ persistent0_72_, USER_INFO
persistent0_73_
where persistent0_.uuid=persistent0_1_.UUID(+)
and persistent0_.uuid=persistent0_2_.UUID(+)
and persistent0_.uuid=persistent0_3_.UUID(+)
and persistent0_.uuid=persistent0_4_.UUID(+)
and persistent0_.uuid=persistent0_5_.UUID(+)
and persistent0_.uuid=persistent0_6_.UUID(+)
and persistent0_.uuid=persistent0_7_.UUID(+)
and persistent0_.uuid=persistent0_8_.UUID(+)
and persistent0_.uuid=persistent0_9_.UUID(+)
and persistent0_.uuid=persistent0_10_.UUID(+)
and persistent0_.uuid=persistent0_11_.UUID(+)
and persistent0_.uuid=persistent0_12_.UUID(+)
and persistent0_.uuid=persistent0_13_.UUID(+)
and persistent0_.uuid=persistent0_14_.UUID(+)
and persistent0_.uuid=persistent0_15_.UUID(+)
and persistent0_.uuid=persistent0_16_.UUID(+)
and persistent0_.uuid=persistent0_17_.UUID(+)
and persistent0_.uuid=persistent0_18_.UUID(+)
and persistent0_.uuid=persistent0_19_.UUID(+)
and persistent0_.uuid=persistent0_20_.UUID(+)
and persistent0_.uuid=persistent0_21_.UUID(+)
and persistent0_.uuid=persistent0_22_.UUID(+)
and persistent0_.uuid=persistent0_23_.UUID(+)
and persistent0_.uuid=persistent0_24_.UUID(+)
and persistent0_.uuid=persistent0_25_.UUID(+)
and persistent0_.uuid=persistent0_26_.UUID(+)
and persistent0_.uuid=persistent0_27_.UUID(+)
and persistent0_.uuid=persistent0_28_.UUID(+)
and persistent0_.uuid=persistent0_29_.UUID(+)
and persistent0_.uuid=persistent0_30_.UUID(+)
and persistent0_.uuid=persistent0_31_.UUID(+)
and persistent0_.uuid=persistent0_32_.UUID(+)
and persistent0_.uuid=persistent0_33_.UUID(+)
and persistent0_.uuid=persistent0_34_.UUID(+)
and persistent0_.uuid=persistent0_35_.UUID(+)
and persistent0_.uuid=persistent0_36_.UUID(+)
and persistent0_.uuid=persistent0_37_.UUID(+)
and persistent0_.uuid=persistent0_38_.UUID(+)
and persistent0_.uuid=persistent0_39_.UUID(+)
and persistent0_.uuid=persistent0_40_.UUID(+)
and persistent0_.uuid=persistent0_41_.UUID(+)
and persistent0_.uuid=persistent0_42_.UUID(+)
and persistent0_.uuid=persistent0_43_.UUID(+)
and persistent0_.uuid=persistent0_44_.UUID(+)
and persistent0_.uuid=persistent0_45_.UUID(+)
and persistent0_.uuid=persistent0_46_.UUID(+)
and persistent0_.uuid=persistent0_47_.UUID(+)
and persistent0_.uuid=persistent0_48_.UUID(+)
and persistent0_.uuid=persistent0_49_.UUID(+)
and persistent0_.uuid=persistent0_50_.UUID(+)
and persistent0_.uuid=persistent0_51_.UUID(+)
and persistent0_.uuid=persistent0_52_.UUID(+)
and persistent0_.uuid=persistent0_53_.UUID(+)
and persistent0_.uuid=persistent0_54_.UUID(+)
and persistent0_.uuid=persistent0_55_.UUID(+)
and persistent0_.uuid=persistent0_56_.UUID(+)
and persistent0_.uuid=persistent0_57_.UUID(+)
and persistent0_.uuid=persistent0_58_.UUID(+)
and persistent0_.uuid=persistent0_59_.UUID(+)
and persistent0_.uuid=persistent0_60_.UUID(+)
and persistent0_.uuid=persistent0_61_.UUID(+)
and persistent0_.uuid=persistent0_62_.UUID(+)
and persistent0_.uuid=persistent0_63_.UUID(+)
and persistent0_.uuid=persistent0_64_.UUID(+)
and persistent0_.uuid=persistent0_65_.UUID(+)
and persistent0_.uuid=persistent0_66_.UUID(+)
and persistent0_.uuid=persistent0_67_.UUID(+)
and persistent0_.uuid=persistent0_68_.UUID(+)
and persistent0_.uuid=persistent0_69_.UUID(+)
and persistent0_.uuid=persistent0_70_.UUID(+)
and persistent0_.uuid=persistent0_71_.UUID(+)
and persistent0_.uuid=persistent0_72_.UUID(+)
and persistent0_.uuid=persistent0_73_.UUID(+)
and persistent0_.uuid=:1