Try to execute a query where the property I am restricting is a composite-id (RProvinceState). See below for details. I keep recieving a SQL exception and think it is how I am binding the the RProvinceState.id parameter, but if below is not how you set it ... then how?

Thanks for any suggestions.



Hibernate version:
3.1
Mapping documents:


Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
[code]DEBUG [main] (CascadeEntityLoader.java:34) - Static select for action ACTION_MERGE on entity com.volant.pidm.model.Well: select well0_.UWI as UWI0_0_, well0_.COUNTRY as COUNTRY0_0_, well0_.PROVINCE_STATE as PROVINCE3_0_0_, well0_.PI_CURRENT_OPER_CD as PI4_0_0_, well0_.AGENT as AGENT0_0_, well0_.OPERATOR as OPERATOR0_0_, well0_.LICENSEE as LICENSEE0_0_, well0_.SOURCE as SOURCE0_0_, well0_.BASE_NODE_ID as BASE9_0_0_, well0_.SURFACE_NODE_ID as SURFACE10_0_0_, well0_.TERMINATING_FORM as TERMINA11_0_0_, well0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, well0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, well0_.CONF_INDEX_RATIO as CONF14_0_0_, well0_.CONF_INDEX_LEVEL as CONF15_0_0_, well0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, well0_.WELL_NUMBER as WELL17_0_0_, well0_.WELL_NAME as WELL18_0_0_, well0_.WATER_DEPTH_REF as WATER19_0_0_, well0_.WATER_DEPTH as WATER20_0_0_, well0_.TVD_DEPTH as TVD21_0_0_, well0_.SPUD_DATE as SPUD22_0_0_, well0_.SHORT_NAME as SHORT23_0_0_, well0_.RIG_RELEASE_DATE as RIG24_0_0_, well0_.REF_ELEV as REF25_0_0_, well0_.PROPRIETARY_IND as PROPRIE26_0_0_, well0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, well0_.PLOT_SYMBOL as PLOT28_0_0_, well0_.DISTRICT as DISTRICT0_0_, well0_.DISCOVERY_IND as DISCOVERY30_0_0_, well0_.DEVIATION_IND as DEVIATION31_0_0_, well0_.COUNTY as COUNTY0_0_, well0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, well0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, well0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, well0_.PLOT_NAME as PLOT36_0_0_, well0_.LEASE_NUMBER as LEASE37_0_0_, well0_.LEASE_NAME as LEASE38_0_0_, well0_.KB_ELEV as KB39_0_0_, well0_.INITIAL_CLASS as INITIAL40_0_0_, well0_.HOLE_DIRECTION as HOLE41_0_0_, well0_.GROUND_ELEV as GROUND42_0_0_, well0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, well0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, well0_.FINAL_DRILL_DATE as FINAL45_0_0_, well0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, well0_.FAULTED_IND as FAULTED47_0_0_, well0_.ELEVATION_REF as ELEVATION48_0_0_, well0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, well0_.DISTRICT_NUMBER as DISTRICT50_0_0_, well0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, well0_.CASING_FLANGE_ELEV as CASING52_0_0_, well0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, well0_.CLASS as CLASS0_0_, well0_.PI_TD_AGE_CODE as PI55_0_0_, well0_.PI_STATUS_DATE as PI56_0_0_, well0_.PI_CRSTATUS as PI57_0_0_, well0_.PI_PRSTATUS as PI58_0_0_, well0_.PI_FINAL_STATUS as PI59_0_0_, well0_.PI_COMP_DATE as PI60_0_0_, well0_.PI_LOG_TD as PI61_0_0_, well0_.PI_LAST_UPDATE as PI62_0_0_, well0_.PI_LOCATION_TABLE as PI63_0_0_, well0_.PI_ABAND_DATE as PI64_0_0_, well0_.PI_OLD_TD as PI65_0_0_, well0_.PI_CTS_CD as PI66_0_0_, well0_.PI_LEASE_TYPE as PI67_0_0_, well0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, well0_.PI_TAX_CREDIT as PI69_0_0_, well0_.PI_PRODUCT_DATE as PI70_0_0_, well0_.PI_RELEASED as PI71_0_0_, well0_.PI_BASIN as PI72_0_0_, well0_.PI_PERM_ELEV_REF as PI73_0_0_, well0_.PI_MD as PI74_0_0_, well0_.PI_OPERATOR_NAME as PI75_0_0_, well0_.PI_PROD_WELL_ID as PI76_0_0_, well0_.PLATFORM_ID as PLATFORM77_0_0_, well0_.PI_SEISMIC_DATUM as PI78_0_0_, well0_.PI_LEASE_AREA as PI79_0_0_, well0_.PI_LEASE_AREA_OUOM as PI80_0_0_, well0_.PI_SITUATION_CD as PI81_0_0_, well0_.PI_WELL_REGION as PI82_0_0_, well0_.PI_TVD_LGR as PI83_0_0_, well0_.PI_DOCUMENT_SOURCE as PI84_0_0_, well0_.PI_WELL_SLOT_NO as PI85_0_0_, well0_.PI_VENDOR_UPDATE as PI86_0_0_, well0_.PI_GROSS_NET_PAY as PI87_0_0_, well0_.PI_GRS_NETPY_OUOM as PI88_0_0_, well0_.PI_SURVEYOR as PI89_0_0_, well0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, well0_.PI_WATER_DPTH_OUOM as PI91_0_0_, well0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, well0_.PI_REF_ELEV_OUOM as PI93_0_0_, well0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, well0_.PI_KB_ELEV_OUOM as PI95_0_0_, well0_.PI_GRND_ELEV_OUOM as PI96_0_0_, well0_.PI_DRILL_TD_OUOM as PI97_0_0_, well0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, well0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, well0_.PI_LOG_TD_OUOM as PI100_0_0_, well0_.PI_OLD_TD_OUOM as PI101_0_0_, well0_.PI_MD_OUOM as PI102_0_0_, well0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, well0_.PI_TVD_LGR_OUOM as PI104_0_0_, well0_.PI_PRODUCTION_FLAG as PI105_0_0_, well0_.PI_ACTIVE_CODE as PI106_0_0_, well0_.PI_PROJECT_NUMBER as PI107_0_0_, well0_.PI_ADD_DATE as PI108_0_0_, well0_.PI_GOVT_CHANGE_NO as PI109_0_0_, well0_.PI_REC_UPD_DATE as PI110_0_0_, well0_.PI_USER_ID as PI111_0_0_, well0_.PI_WDS_ID as PI112_0_0_, well0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, well0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, well0_.PI_SURFACE_LAT as PI115_0_0_, well0_.PI_SURFACE_LONG as PI116_0_0_, well0_.PI_PLATFORM_SOURCE as PI117_0_0_, well0_.PI_PROPRIETARY_ID as PI118_0_0_, well0_.PI_DF_ELEV as PI119_0_0_, well0_.PI_DF_ELEV_OUOM as PI120_0_0_, well0_.PI_ABND_LOC_DATE as PI121_0_0_, well0_.PI_SUSPENDED_DATE as PI122_0_0_, well0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, well0_.PI_TERM_FORM_INTRP as PI124_0_0_, well0_.PI_PARENT_UWI as PI125_0_0_, well0_.PI_PARENT_RELATION as PI126_0_0_, well0_.PI_EST_COMP_DT_IND as PI127_0_0_, well0_.PI_EST_SPUD_DT_IND as PI128_0_0_, well0_.PI_EST_TD_DT_IND as PI129_0_0_, well0_.PI_EST_GR_ELEV_IND as PI130_0_0_, well0_.PI_EST_TD_IND as PI131_0_0_, well0_.PI_INFILL_CODE as PI132_0_0_, well0_.PI_UNIT_AREA as PI133_0_0_, well0_.PI_UNIT_AREA_OUOM as PI134_0_0_, well0_.PI_RIG_ON_SITE_DT as PI135_0_0_, well0_.PI_ROW_ADD_DATE as PI136_0_0_, well0_.PI_DEEPEST_DEPTH as PI137_0_0_, well0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, well0_.PI_WELL_NM_SUFFIX as PI139_0_0_, well0_.PI_OIL_LEASE_ID as PI140_0_0_, well0_.PI_GAS_LEASE_ID as PI141_0_0_, well0_.PI_STATE_REG_OP_ID as PI142_0_0_, well0_.PI_WELL_ID as PI143_0_0_, well0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL well0_ where well0_.UWI=?
DEBUG [main] (CascadeEntityLoader.java:34) - Static select for action ACTION_REFRESH on entity com.volant.pidm.model.Well: select well0_.UWI as UWI0_0_, well0_.COUNTRY as COUNTRY0_0_, well0_.PROVINCE_STATE as PROVINCE3_0_0_, well0_.PI_CURRENT_OPER_CD as PI4_0_0_, well0_.AGENT as AGENT0_0_, well0_.OPERATOR as OPERATOR0_0_, well0_.LICENSEE as LICENSEE0_0_, well0_.SOURCE as SOURCE0_0_, well0_.BASE_NODE_ID as BASE9_0_0_, well0_.SURFACE_NODE_ID as SURFACE10_0_0_, well0_.TERMINATING_FORM as TERMINA11_0_0_, well0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, well0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, well0_.CONF_INDEX_RATIO as CONF14_0_0_, well0_.CONF_INDEX_LEVEL as CONF15_0_0_, well0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, well0_.WELL_NUMBER as WELL17_0_0_, well0_.WELL_NAME as WELL18_0_0_, well0_.WATER_DEPTH_REF as WATER19_0_0_, well0_.WATER_DEPTH as WATER20_0_0_, well0_.TVD_DEPTH as TVD21_0_0_, well0_.SPUD_DATE as SPUD22_0_0_, well0_.SHORT_NAME as SHORT23_0_0_, well0_.RIG_RELEASE_DATE as RIG24_0_0_, well0_.REF_ELEV as REF25_0_0_, well0_.PROPRIETARY_IND as PROPRIE26_0_0_, well0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, well0_.PLOT_SYMBOL as PLOT28_0_0_, well0_.DISTRICT as DISTRICT0_0_, well0_.DISCOVERY_IND as DISCOVERY30_0_0_, well0_.DEVIATION_IND as DEVIATION31_0_0_, well0_.COUNTY as COUNTY0_0_, well0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, well0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, well0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, well0_.PLOT_NAME as PLOT36_0_0_, well0_.LEASE_NUMBER as LEASE37_0_0_, well0_.LEASE_NAME as LEASE38_0_0_, well0_.KB_ELEV as KB39_0_0_, well0_.INITIAL_CLASS as INITIAL40_0_0_, well0_.HOLE_DIRECTION as HOLE41_0_0_, well0_.GROUND_ELEV as GROUND42_0_0_, well0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, well0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, well0_.FINAL_DRILL_DATE as FINAL45_0_0_, well0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, well0_.FAULTED_IND as FAULTED47_0_0_, well0_.ELEVATION_REF as ELEVATION48_0_0_, well0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, well0_.DISTRICT_NUMBER as DISTRICT50_0_0_, well0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, well0_.CASING_FLANGE_ELEV as CASING52_0_0_, well0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, well0_.CLASS as CLASS0_0_, well0_.PI_TD_AGE_CODE as PI55_0_0_, well0_.PI_STATUS_DATE as PI56_0_0_, well0_.PI_CRSTATUS as PI57_0_0_, well0_.PI_PRSTATUS as PI58_0_0_, well0_.PI_FINAL_STATUS as PI59_0_0_, well0_.PI_COMP_DATE as PI60_0_0_, well0_.PI_LOG_TD as PI61_0_0_, well0_.PI_LAST_UPDATE as PI62_0_0_, well0_.PI_LOCATION_TABLE as PI63_0_0_, well0_.PI_ABAND_DATE as PI64_0_0_, well0_.PI_OLD_TD as PI65_0_0_, well0_.PI_CTS_CD as PI66_0_0_, well0_.PI_LEASE_TYPE as PI67_0_0_, well0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, well0_.PI_TAX_CREDIT as PI69_0_0_, well0_.PI_PRODUCT_DATE as PI70_0_0_, well0_.PI_RELEASED as PI71_0_0_, well0_.PI_BASIN as PI72_0_0_, well0_.PI_PERM_ELEV_REF as PI73_0_0_, well0_.PI_MD as PI74_0_0_, well0_.PI_OPERATOR_NAME as PI75_0_0_, well0_.PI_PROD_WELL_ID as PI76_0_0_, well0_.PLATFORM_ID as PLATFORM77_0_0_, well0_.PI_SEISMIC_DATUM as PI78_0_0_, well0_.PI_LEASE_AREA as PI79_0_0_, well0_.PI_LEASE_AREA_OUOM as PI80_0_0_, well0_.PI_SITUATION_CD as PI81_0_0_, well0_.PI_WELL_REGION as PI82_0_0_, well0_.PI_TVD_LGR as PI83_0_0_, well0_.PI_DOCUMENT_SOURCE as PI84_0_0_, well0_.PI_WELL_SLOT_NO as PI85_0_0_, well0_.PI_VENDOR_UPDATE as PI86_0_0_, well0_.PI_GROSS_NET_PAY as PI87_0_0_, well0_.PI_GRS_NETPY_OUOM as PI88_0_0_, well0_.PI_SURVEYOR as PI89_0_0_, well0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, well0_.PI_WATER_DPTH_OUOM as PI91_0_0_, well0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, well0_.PI_REF_ELEV_OUOM as PI93_0_0_, well0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, well0_.PI_KB_ELEV_OUOM as PI95_0_0_, well0_.PI_GRND_ELEV_OUOM as PI96_0_0_, well0_.PI_DRILL_TD_OUOM as PI97_0_0_, well0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, well0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, well0_.PI_LOG_TD_OUOM as PI100_0_0_, well0_.PI_OLD_TD_OUOM as PI101_0_0_, well0_.PI_MD_OUOM as PI102_0_0_, well0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, well0_.PI_TVD_LGR_OUOM as PI104_0_0_, well0_.PI_PRODUCTION_FLAG as PI105_0_0_, well0_.PI_ACTIVE_CODE as PI106_0_0_, well0_.PI_PROJECT_NUMBER as PI107_0_0_, well0_.PI_ADD_DATE as PI108_0_0_, well0_.PI_GOVT_CHANGE_NO as PI109_0_0_, well0_.PI_REC_UPD_DATE as PI110_0_0_, well0_.PI_USER_ID as PI111_0_0_, well0_.PI_WDS_ID as PI112_0_0_, well0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, well0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, well0_.PI_SURFACE_LAT as PI115_0_0_, well0_.PI_SURFACE_LONG as PI116_0_0_, well0_.PI_PLATFORM_SOURCE as PI117_0_0_, well0_.PI_PROPRIETARY_ID as PI118_0_0_, well0_.PI_DF_ELEV as PI119_0_0_, well0_.PI_DF_ELEV_OUOM as PI120_0_0_, well0_.PI_ABND_LOC_DATE as PI121_0_0_, well0_.PI_SUSPENDED_DATE as PI122_0_0_, well0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, well0_.PI_TERM_FORM_INTRP as PI124_0_0_, well0_.PI_PARENT_UWI as PI125_0_0_, well0_.PI_PARENT_RELATION as PI126_0_0_, well0_.PI_EST_COMP_DT_IND as PI127_0_0_, well0_.PI_EST_SPUD_DT_IND as PI128_0_0_, well0_.PI_EST_TD_DT_IND as PI129_0_0_, well0_.PI_EST_GR_ELEV_IND as PI130_0_0_, well0_.PI_EST_TD_IND as PI131_0_0_, well0_.PI_INFILL_CODE as PI132_0_0_, well0_.PI_UNIT_AREA as PI133_0_0_, well0_.PI_UNIT_AREA_OUOM as PI134_0_0_, well0_.PI_RIG_ON_SITE_DT as PI135_0_0_, well0_.PI_ROW_ADD_DATE as PI136_0_0_, well0_.PI_DEEPEST_DEPTH as PI137_0_0_, well0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, well0_.PI_WELL_NM_SUFFIX as PI139_0_0_, well0_.PI_OIL_LEASE_ID as PI140_0_0_, well0_.PI_GAS_LEASE_ID as PI141_0_0_, well0_.PI_STATE_REG_OP_ID as PI142_0_0_, well0_.PI_WELL_ID as PI143_0_0_, well0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL well0_ where well0_.UWI=?
DEBUG [main] (EntityLoader.java:79) - Static select for entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=?
DEBUG [main] (EntityLoader.java:79) - Static select for entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=?
DEBUG [main] (EntityLoader.java:79) - Static select for entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=? for update
DEBUG [main] (EntityLoader.java:79) - Static select for entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=? for update nowait
DEBUG [main] (CascadeEntityLoader.java:34) - Static select for action ACTION_MERGE on entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=?
DEBUG [main] (CascadeEntityLoader.java:34) - Static select for action ACTION_REFRESH on entity com.volant.pidm.model.BusinessAssociate: select businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.BA_ID=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.BusinessAssociate.businessAssociates: select businessas0_.NEW_BA_ID as NEW2_1_, businessas0_.BA_ID as BA1_1_, businessas0_.BA_ID as BA1_3_0_, businessas0_.NEW_BA_ID as NEW2_3_0_, businessas0_.BA_ABBREVIATION as BA3_3_0_, businessas0_.BA_CATEGORY as BA4_3_0_, businessas0_.BA_CODE as BA5_3_0_, businessas0_.BA_NAME as BA6_3_0_, businessas0_.BA_SHORT_NAME as BA7_3_0_, businessas0_.BA_TYPE as BA8_3_0_, businessas0_.CURRENT_STATUS as CURRENT9_3_0_, businessas0_.EFFECTIVE_DATE as EFFECTIVE10_3_0_, businessas0_.EMAIL_ADDRESS as EMAIL11_3_0_, businessas0_.EXPIRY_DATE as EXPIRY12_3_0_, businessas0_.FAX_NUM as FAX13_3_0_, businessas0_.FIRST_NAME as FIRST14_3_0_, businessas0_.LAST_NAME as LAST15_3_0_, businessas0_.PHONE_NUM as PHONE16_3_0_, businessas0_.WEB_URL as WEB17_3_0_, businessas0_.MIDDLE_INITIAL as MIDDLE18_3_0_, businessas0_.ORGANIZATION_BA as ORGANIZ19_3_0_, businessas0_.ORGANZATION_SEQ_NO as ORGANZA20_3_0_, businessas0_.REMARK as REMARK3_0_, businessas0_.SOURCE as SOURCE3_0_, businessas0_.PI_USER_ID as PI23_3_0_, businessas0_.PI_REC_UPD_DATE as PI24_3_0_, businessas0_.PI_ROW_ADD_DATE as PI25_3_0_, businessas0_.ACTIVE_IND as ACTIVE26_3_0_, businessas0_.NEW_CODE_REASON as NEW27_3_0_ from PI_CODES.BUSINESS_ASSOCIATE businessas0_ where businessas0_.NEW_BA_ID=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.RCountry.wells: select wells0_.COUNTRY as COUNTRY1_, wells0_.UWI as UWI1_, wells0_.UWI as UWI0_0_, wells0_.COUNTRY as COUNTRY0_0_, wells0_.PROVINCE_STATE as PROVINCE3_0_0_, wells0_.PI_CURRENT_OPER_CD as PI4_0_0_, wells0_.AGENT as AGENT0_0_, wells0_.OPERATOR as OPERATOR0_0_, wells0_.LICENSEE as LICENSEE0_0_, wells0_.SOURCE as SOURCE0_0_, wells0_.BASE_NODE_ID as BASE9_0_0_, wells0_.SURFACE_NODE_ID as SURFACE10_0_0_, wells0_.TERMINATING_FORM as TERMINA11_0_0_, wells0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, wells0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, wells0_.CONF_INDEX_RATIO as CONF14_0_0_, wells0_.CONF_INDEX_LEVEL as CONF15_0_0_, wells0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, wells0_.WELL_NUMBER as WELL17_0_0_, wells0_.WELL_NAME as WELL18_0_0_, wells0_.WATER_DEPTH_REF as WATER19_0_0_, wells0_.WATER_DEPTH as WATER20_0_0_, wells0_.TVD_DEPTH as TVD21_0_0_, wells0_.SPUD_DATE as SPUD22_0_0_, wells0_.SHORT_NAME as SHORT23_0_0_, wells0_.RIG_RELEASE_DATE as RIG24_0_0_, wells0_.REF_ELEV as REF25_0_0_, wells0_.PROPRIETARY_IND as PROPRIE26_0_0_, wells0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, wells0_.PLOT_SYMBOL as PLOT28_0_0_, wells0_.DISTRICT as DISTRICT0_0_, wells0_.DISCOVERY_IND as DISCOVERY30_0_0_, wells0_.DEVIATION_IND as DEVIATION31_0_0_, wells0_.COUNTY as COUNTY0_0_, wells0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, wells0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, wells0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, wells0_.PLOT_NAME as PLOT36_0_0_, wells0_.LEASE_NUMBER as LEASE37_0_0_, wells0_.LEASE_NAME as LEASE38_0_0_, wells0_.KB_ELEV as KB39_0_0_, wells0_.INITIAL_CLASS as INITIAL40_0_0_, wells0_.HOLE_DIRECTION as HOLE41_0_0_, wells0_.GROUND_ELEV as GROUND42_0_0_, wells0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, wells0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, wells0_.FINAL_DRILL_DATE as FINAL45_0_0_, wells0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, wells0_.FAULTED_IND as FAULTED47_0_0_, wells0_.ELEVATION_REF as ELEVATION48_0_0_, wells0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, wells0_.DISTRICT_NUMBER as DISTRICT50_0_0_, wells0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, wells0_.CASING_FLANGE_ELEV as CASING52_0_0_, wells0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, wells0_.CLASS as CLASS0_0_, wells0_.PI_TD_AGE_CODE as PI55_0_0_, wells0_.PI_STATUS_DATE as PI56_0_0_, wells0_.PI_CRSTATUS as PI57_0_0_, wells0_.PI_PRSTATUS as PI58_0_0_, wells0_.PI_FINAL_STATUS as PI59_0_0_, wells0_.PI_COMP_DATE as PI60_0_0_, wells0_.PI_LOG_TD as PI61_0_0_, wells0_.PI_LAST_UPDATE as PI62_0_0_, wells0_.PI_LOCATION_TABLE as PI63_0_0_, wells0_.PI_ABAND_DATE as PI64_0_0_, wells0_.PI_OLD_TD as PI65_0_0_, wells0_.PI_CTS_CD as PI66_0_0_, wells0_.PI_LEASE_TYPE as PI67_0_0_, wells0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, wells0_.PI_TAX_CREDIT as PI69_0_0_, wells0_.PI_PRODUCT_DATE as PI70_0_0_, wells0_.PI_RELEASED as PI71_0_0_, wells0_.PI_BASIN as PI72_0_0_, wells0_.PI_PERM_ELEV_REF as PI73_0_0_, wells0_.PI_MD as PI74_0_0_, wells0_.PI_OPERATOR_NAME as PI75_0_0_, wells0_.PI_PROD_WELL_ID as PI76_0_0_, wells0_.PLATFORM_ID as PLATFORM77_0_0_, wells0_.PI_SEISMIC_DATUM as PI78_0_0_, wells0_.PI_LEASE_AREA as PI79_0_0_, wells0_.PI_LEASE_AREA_OUOM as PI80_0_0_, wells0_.PI_SITUATION_CD as PI81_0_0_, wells0_.PI_WELL_REGION as PI82_0_0_, wells0_.PI_TVD_LGR as PI83_0_0_, wells0_.PI_DOCUMENT_SOURCE as PI84_0_0_, wells0_.PI_WELL_SLOT_NO as PI85_0_0_, wells0_.PI_VENDOR_UPDATE as PI86_0_0_, wells0_.PI_GROSS_NET_PAY as PI87_0_0_, wells0_.PI_GRS_NETPY_OUOM as PI88_0_0_, wells0_.PI_SURVEYOR as PI89_0_0_, wells0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, wells0_.PI_WATER_DPTH_OUOM as PI91_0_0_, wells0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, wells0_.PI_REF_ELEV_OUOM as PI93_0_0_, wells0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, wells0_.PI_KB_ELEV_OUOM as PI95_0_0_, wells0_.PI_GRND_ELEV_OUOM as PI96_0_0_, wells0_.PI_DRILL_TD_OUOM as PI97_0_0_, wells0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, wells0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, wells0_.PI_LOG_TD_OUOM as PI100_0_0_, wells0_.PI_OLD_TD_OUOM as PI101_0_0_, wells0_.PI_MD_OUOM as PI102_0_0_, wells0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, wells0_.PI_TVD_LGR_OUOM as PI104_0_0_, wells0_.PI_PRODUCTION_FLAG as PI105_0_0_, wells0_.PI_ACTIVE_CODE as PI106_0_0_, wells0_.PI_PROJECT_NUMBER as PI107_0_0_, wells0_.PI_ADD_DATE as PI108_0_0_, wells0_.PI_GOVT_CHANGE_NO as PI109_0_0_, wells0_.PI_REC_UPD_DATE as PI110_0_0_, wells0_.PI_USER_ID as PI111_0_0_, wells0_.PI_WDS_ID as PI112_0_0_, wells0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, wells0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, wells0_.PI_SURFACE_LAT as PI115_0_0_, wells0_.PI_SURFACE_LONG as PI116_0_0_, wells0_.PI_PLATFORM_SOURCE as PI117_0_0_, wells0_.PI_PROPRIETARY_ID as PI118_0_0_, wells0_.PI_DF_ELEV as PI119_0_0_, wells0_.PI_DF_ELEV_OUOM as PI120_0_0_, wells0_.PI_ABND_LOC_DATE as PI121_0_0_, wells0_.PI_SUSPENDED_DATE as PI122_0_0_, wells0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, wells0_.PI_TERM_FORM_INTRP as PI124_0_0_, wells0_.PI_PARENT_UWI as PI125_0_0_, wells0_.PI_PARENT_RELATION as PI126_0_0_, wells0_.PI_EST_COMP_DT_IND as PI127_0_0_, wells0_.PI_EST_SPUD_DT_IND as PI128_0_0_, wells0_.PI_EST_TD_DT_IND as PI129_0_0_, wells0_.PI_EST_GR_ELEV_IND as PI130_0_0_, wells0_.PI_EST_TD_IND as PI131_0_0_, wells0_.PI_INFILL_CODE as PI132_0_0_, wells0_.PI_UNIT_AREA as PI133_0_0_, wells0_.PI_UNIT_AREA_OUOM as PI134_0_0_, wells0_.PI_RIG_ON_SITE_DT as PI135_0_0_, wells0_.PI_ROW_ADD_DATE as PI136_0_0_, wells0_.PI_DEEPEST_DEPTH as PI137_0_0_, wells0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, wells0_.PI_WELL_NM_SUFFIX as PI139_0_0_, wells0_.PI_OIL_LEASE_ID as PI140_0_0_, wells0_.PI_GAS_LEASE_ID as PI141_0_0_, wells0_.PI_STATE_REG_OP_ID as PI142_0_0_, wells0_.PI_WELL_ID as PI143_0_0_, wells0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL wells0_ where wells0_.COUNTRY=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.RCountry.RProvinceStates: select rprovinces0_.COUNTRY as COUNTRY1_, rprovinces0_.PROVINCE_STATE as PROVINCE2_1_, rprovinces0_.COUNTRY as COUNTRY2_0_, rprovinces0_.PROVINCE_STATE as PROVINCE2_2_0_, rprovinces0_.ABBREVIATION as ABBREVIA3_2_0_, rprovinces0_.LONG_NAME as LONG4_2_0_, rprovinces0_.REMARK as REMARK2_0_, rprovinces0_.SHORT_NAME as SHORT6_2_0_, rprovinces0_.SOURCE as SOURCE2_0_, rprovinces0_.PI_REC_UPD_DATE as PI8_2_0_, rprovinces0_.PI_USER_ID as PI9_2_0_, rprovinces0_.PI_ROW_ADD_DATE as PI10_2_0_, rprovinces0_.PI_FIPS_STATE as PI11_2_0_, rprovinces0_.ACTIVE_IND as ACTIVE12_2_0_, rprovinces0_.EXPIRY_DATE as EXPIRY13_2_0_ from PI_CODES.R_PROVINCE_STATE rprovinces0_ where rprovinces0_.COUNTRY=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.BusinessAssociate.agent: select agent0_.AGENT as AGENT1_, agent0_.UWI as UWI1_, agent0_.UWI as UWI0_0_, agent0_.COUNTRY as COUNTRY0_0_, agent0_.PROVINCE_STATE as PROVINCE3_0_0_, agent0_.PI_CURRENT_OPER_CD as PI4_0_0_, agent0_.AGENT as AGENT0_0_, agent0_.OPERATOR as OPERATOR0_0_, agent0_.LICENSEE as LICENSEE0_0_, agent0_.SOURCE as SOURCE0_0_, agent0_.BASE_NODE_ID as BASE9_0_0_, agent0_.SURFACE_NODE_ID as SURFACE10_0_0_, agent0_.TERMINATING_FORM as TERMINA11_0_0_, agent0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, agent0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, agent0_.CONF_INDEX_RATIO as CONF14_0_0_, agent0_.CONF_INDEX_LEVEL as CONF15_0_0_, agent0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, agent0_.WELL_NUMBER as WELL17_0_0_, agent0_.WELL_NAME as WELL18_0_0_, agent0_.WATER_DEPTH_REF as WATER19_0_0_, agent0_.WATER_DEPTH as WATER20_0_0_, agent0_.TVD_DEPTH as TVD21_0_0_, agent0_.SPUD_DATE as SPUD22_0_0_, agent0_.SHORT_NAME as SHORT23_0_0_, agent0_.RIG_RELEASE_DATE as RIG24_0_0_, agent0_.REF_ELEV as REF25_0_0_, agent0_.PROPRIETARY_IND as PROPRIE26_0_0_, agent0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, agent0_.PLOT_SYMBOL as PLOT28_0_0_, agent0_.DISTRICT as DISTRICT0_0_, agent0_.DISCOVERY_IND as DISCOVERY30_0_0_, agent0_.DEVIATION_IND as DEVIATION31_0_0_, agent0_.COUNTY as COUNTY0_0_, agent0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, agent0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, agent0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, agent0_.PLOT_NAME as PLOT36_0_0_, agent0_.LEASE_NUMBER as LEASE37_0_0_, agent0_.LEASE_NAME as LEASE38_0_0_, agent0_.KB_ELEV as KB39_0_0_, agent0_.INITIAL_CLASS as INITIAL40_0_0_, agent0_.HOLE_DIRECTION as HOLE41_0_0_, agent0_.GROUND_ELEV as GROUND42_0_0_, agent0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, agent0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, agent0_.FINAL_DRILL_DATE as FINAL45_0_0_, agent0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, agent0_.FAULTED_IND as FAULTED47_0_0_, agent0_.ELEVATION_REF as ELEVATION48_0_0_, agent0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, agent0_.DISTRICT_NUMBER as DISTRICT50_0_0_, agent0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, agent0_.CASING_FLANGE_ELEV as CASING52_0_0_, agent0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, agent0_.CLASS as CLASS0_0_, agent0_.PI_TD_AGE_CODE as PI55_0_0_, agent0_.PI_STATUS_DATE as PI56_0_0_, agent0_.PI_CRSTATUS as PI57_0_0_, agent0_.PI_PRSTATUS as PI58_0_0_, agent0_.PI_FINAL_STATUS as PI59_0_0_, agent0_.PI_COMP_DATE as PI60_0_0_, agent0_.PI_LOG_TD as PI61_0_0_, agent0_.PI_LAST_UPDATE as PI62_0_0_, agent0_.PI_LOCATION_TABLE as PI63_0_0_, agent0_.PI_ABAND_DATE as PI64_0_0_, agent0_.PI_OLD_TD as PI65_0_0_, agent0_.PI_CTS_CD as PI66_0_0_, agent0_.PI_LEASE_TYPE as PI67_0_0_, agent0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, agent0_.PI_TAX_CREDIT as PI69_0_0_, agent0_.PI_PRODUCT_DATE as PI70_0_0_, agent0_.PI_RELEASED as PI71_0_0_, agent0_.PI_BASIN as PI72_0_0_, agent0_.PI_PERM_ELEV_REF as PI73_0_0_, agent0_.PI_MD as PI74_0_0_, agent0_.PI_OPERATOR_NAME as PI75_0_0_, agent0_.PI_PROD_WELL_ID as PI76_0_0_, agent0_.PLATFORM_ID as PLATFORM77_0_0_, agent0_.PI_SEISMIC_DATUM as PI78_0_0_, agent0_.PI_LEASE_AREA as PI79_0_0_, agent0_.PI_LEASE_AREA_OUOM as PI80_0_0_, agent0_.PI_SITUATION_CD as PI81_0_0_, agent0_.PI_WELL_REGION as PI82_0_0_, agent0_.PI_TVD_LGR as PI83_0_0_, agent0_.PI_DOCUMENT_SOURCE as PI84_0_0_, agent0_.PI_WELL_SLOT_NO as PI85_0_0_, agent0_.PI_VENDOR_UPDATE as PI86_0_0_, agent0_.PI_GROSS_NET_PAY as PI87_0_0_, agent0_.PI_GRS_NETPY_OUOM as PI88_0_0_, agent0_.PI_SURVEYOR as PI89_0_0_, agent0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, agent0_.PI_WATER_DPTH_OUOM as PI91_0_0_, agent0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, agent0_.PI_REF_ELEV_OUOM as PI93_0_0_, agent0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, agent0_.PI_KB_ELEV_OUOM as PI95_0_0_, agent0_.PI_GRND_ELEV_OUOM as PI96_0_0_, agent0_.PI_DRILL_TD_OUOM as PI97_0_0_, agent0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, agent0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, agent0_.PI_LOG_TD_OUOM as PI100_0_0_, agent0_.PI_OLD_TD_OUOM as PI101_0_0_, agent0_.PI_MD_OUOM as PI102_0_0_, agent0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, agent0_.PI_TVD_LGR_OUOM as PI104_0_0_, agent0_.PI_PRODUCTION_FLAG as PI105_0_0_, agent0_.PI_ACTIVE_CODE as PI106_0_0_, agent0_.PI_PROJECT_NUMBER as PI107_0_0_, agent0_.PI_ADD_DATE as PI108_0_0_, agent0_.PI_GOVT_CHANGE_NO as PI109_0_0_, agent0_.PI_REC_UPD_DATE as PI110_0_0_, agent0_.PI_USER_ID as PI111_0_0_, agent0_.PI_WDS_ID as PI112_0_0_, agent0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, agent0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, agent0_.PI_SURFACE_LAT as PI115_0_0_, agent0_.PI_SURFACE_LONG as PI116_0_0_, agent0_.PI_PLATFORM_SOURCE as PI117_0_0_, agent0_.PI_PROPRIETARY_ID as PI118_0_0_, agent0_.PI_DF_ELEV as PI119_0_0_, agent0_.PI_DF_ELEV_OUOM as PI120_0_0_, agent0_.PI_ABND_LOC_DATE as PI121_0_0_, agent0_.PI_SUSPENDED_DATE as PI122_0_0_, agent0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, agent0_.PI_TERM_FORM_INTRP as PI124_0_0_, agent0_.PI_PARENT_UWI as PI125_0_0_, agent0_.PI_PARENT_RELATION as PI126_0_0_, agent0_.PI_EST_COMP_DT_IND as PI127_0_0_, agent0_.PI_EST_SPUD_DT_IND as PI128_0_0_, agent0_.PI_EST_TD_DT_IND as PI129_0_0_, agent0_.PI_EST_GR_ELEV_IND as PI130_0_0_, agent0_.PI_EST_TD_IND as PI131_0_0_, agent0_.PI_INFILL_CODE as PI132_0_0_, agent0_.PI_UNIT_AREA as PI133_0_0_, agent0_.PI_UNIT_AREA_OUOM as PI134_0_0_, agent0_.PI_RIG_ON_SITE_DT as PI135_0_0_, agent0_.PI_ROW_ADD_DATE as PI136_0_0_, agent0_.PI_DEEPEST_DEPTH as PI137_0_0_, agent0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, agent0_.PI_WELL_NM_SUFFIX as PI139_0_0_, agent0_.PI_OIL_LEASE_ID as PI140_0_0_, agent0_.PI_GAS_LEASE_ID as PI141_0_0_, agent0_.PI_STATE_REG_OP_ID as PI142_0_0_, agent0_.PI_WELL_ID as PI143_0_0_, agent0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL agent0_ where agent0_.AGENT=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.BusinessAssociate.operator: select operator0_.OPERATOR as OPERATOR1_, operator0_.UWI as UWI1_, operator0_.UWI as UWI0_0_, operator0_.COUNTRY as COUNTRY0_0_, operator0_.PROVINCE_STATE as PROVINCE3_0_0_, operator0_.PI_CURRENT_OPER_CD as PI4_0_0_, operator0_.AGENT as AGENT0_0_, operator0_.OPERATOR as OPERATOR0_0_, operator0_.LICENSEE as LICENSEE0_0_, operator0_.SOURCE as SOURCE0_0_, operator0_.BASE_NODE_ID as BASE9_0_0_, operator0_.SURFACE_NODE_ID as SURFACE10_0_0_, operator0_.TERMINATING_FORM as TERMINA11_0_0_, operator0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, operator0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, operator0_.CONF_INDEX_RATIO as CONF14_0_0_, operator0_.CONF_INDEX_LEVEL as CONF15_0_0_, operator0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, operator0_.WELL_NUMBER as WELL17_0_0_, operator0_.WELL_NAME as WELL18_0_0_, operator0_.WATER_DEPTH_REF as WATER19_0_0_, operator0_.WATER_DEPTH as WATER20_0_0_, operator0_.TVD_DEPTH as TVD21_0_0_, operator0_.SPUD_DATE as SPUD22_0_0_, operator0_.SHORT_NAME as SHORT23_0_0_, operator0_.RIG_RELEASE_DATE as RIG24_0_0_, operator0_.REF_ELEV as REF25_0_0_, operator0_.PROPRIETARY_IND as PROPRIE26_0_0_, operator0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, operator0_.PLOT_SYMBOL as PLOT28_0_0_, operator0_.DISTRICT as DISTRICT0_0_, operator0_.DISCOVERY_IND as DISCOVERY30_0_0_, operator0_.DEVIATION_IND as DEVIATION31_0_0_, operator0_.COUNTY as COUNTY0_0_, operator0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, operator0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, operator0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, operator0_.PLOT_NAME as PLOT36_0_0_, operator0_.LEASE_NUMBER as LEASE37_0_0_, operator0_.LEASE_NAME as LEASE38_0_0_, operator0_.KB_ELEV as KB39_0_0_, operator0_.INITIAL_CLASS as INITIAL40_0_0_, operator0_.HOLE_DIRECTION as HOLE41_0_0_, operator0_.GROUND_ELEV as GROUND42_0_0_, operator0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, operator0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, operator0_.FINAL_DRILL_DATE as FINAL45_0_0_, operator0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, operator0_.FAULTED_IND as FAULTED47_0_0_, operator0_.ELEVATION_REF as ELEVATION48_0_0_, operator0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, operator0_.DISTRICT_NUMBER as DISTRICT50_0_0_, operator0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, operator0_.CASING_FLANGE_ELEV as CASING52_0_0_, operator0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, operator0_.CLASS as CLASS0_0_, operator0_.PI_TD_AGE_CODE as PI55_0_0_, operator0_.PI_STATUS_DATE as PI56_0_0_, operator0_.PI_CRSTATUS as PI57_0_0_, operator0_.PI_PRSTATUS as PI58_0_0_, operator0_.PI_FINAL_STATUS as PI59_0_0_, operator0_.PI_COMP_DATE as PI60_0_0_, operator0_.PI_LOG_TD as PI61_0_0_, operator0_.PI_LAST_UPDATE as PI62_0_0_, operator0_.PI_LOCATION_TABLE as PI63_0_0_, operator0_.PI_ABAND_DATE as PI64_0_0_, operator0_.PI_OLD_TD as PI65_0_0_, operator0_.PI_CTS_CD as PI66_0_0_, operator0_.PI_LEASE_TYPE as PI67_0_0_, operator0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, operator0_.PI_TAX_CREDIT as PI69_0_0_, operator0_.PI_PRODUCT_DATE as PI70_0_0_, operator0_.PI_RELEASED as PI71_0_0_, operator0_.PI_BASIN as PI72_0_0_, operator0_.PI_PERM_ELEV_REF as PI73_0_0_, operator0_.PI_MD as PI74_0_0_, operator0_.PI_OPERATOR_NAME as PI75_0_0_, operator0_.PI_PROD_WELL_ID as PI76_0_0_, operator0_.PLATFORM_ID as PLATFORM77_0_0_, operator0_.PI_SEISMIC_DATUM as PI78_0_0_, operator0_.PI_LEASE_AREA as PI79_0_0_, operator0_.PI_LEASE_AREA_OUOM as PI80_0_0_, operator0_.PI_SITUATION_CD as PI81_0_0_, operator0_.PI_WELL_REGION as PI82_0_0_, operator0_.PI_TVD_LGR as PI83_0_0_, operator0_.PI_DOCUMENT_SOURCE as PI84_0_0_, operator0_.PI_WELL_SLOT_NO as PI85_0_0_, operator0_.PI_VENDOR_UPDATE as PI86_0_0_, operator0_.PI_GROSS_NET_PAY as PI87_0_0_, operator0_.PI_GRS_NETPY_OUOM as PI88_0_0_, operator0_.PI_SURVEYOR as PI89_0_0_, operator0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, operator0_.PI_WATER_DPTH_OUOM as PI91_0_0_, operator0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, operator0_.PI_REF_ELEV_OUOM as PI93_0_0_, operator0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, operator0_.PI_KB_ELEV_OUOM as PI95_0_0_, operator0_.PI_GRND_ELEV_OUOM as PI96_0_0_, operator0_.PI_DRILL_TD_OUOM as PI97_0_0_, operator0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, operator0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, operator0_.PI_LOG_TD_OUOM as PI100_0_0_, operator0_.PI_OLD_TD_OUOM as PI101_0_0_, operator0_.PI_MD_OUOM as PI102_0_0_, operator0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, operator0_.PI_TVD_LGR_OUOM as PI104_0_0_, operator0_.PI_PRODUCTION_FLAG as PI105_0_0_, operator0_.PI_ACTIVE_CODE as PI106_0_0_, operator0_.PI_PROJECT_NUMBER as PI107_0_0_, operator0_.PI_ADD_DATE as PI108_0_0_, operator0_.PI_GOVT_CHANGE_NO as PI109_0_0_, operator0_.PI_REC_UPD_DATE as PI110_0_0_, operator0_.PI_USER_ID as PI111_0_0_, operator0_.PI_WDS_ID as PI112_0_0_, operator0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, operator0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, operator0_.PI_SURFACE_LAT as PI115_0_0_, operator0_.PI_SURFACE_LONG as PI116_0_0_, operator0_.PI_PLATFORM_SOURCE as PI117_0_0_, operator0_.PI_PROPRIETARY_ID as PI118_0_0_, operator0_.PI_DF_ELEV as PI119_0_0_, operator0_.PI_DF_ELEV_OUOM as PI120_0_0_, operator0_.PI_ABND_LOC_DATE as PI121_0_0_, operator0_.PI_SUSPENDED_DATE as PI122_0_0_, operator0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, operator0_.PI_TERM_FORM_INTRP as PI124_0_0_, operator0_.PI_PARENT_UWI as PI125_0_0_, operator0_.PI_PARENT_RELATION as PI126_0_0_, operator0_.PI_EST_COMP_DT_IND as PI127_0_0_, operator0_.PI_EST_SPUD_DT_IND as PI128_0_0_, operator0_.PI_EST_TD_DT_IND as PI129_0_0_, operator0_.PI_EST_GR_ELEV_IND as PI130_0_0_, operator0_.PI_EST_TD_IND as PI131_0_0_, operator0_.PI_INFILL_CODE as PI132_0_0_, operator0_.PI_UNIT_AREA as PI133_0_0_, operator0_.PI_UNIT_AREA_OUOM as PI134_0_0_, operator0_.PI_RIG_ON_SITE_DT as PI135_0_0_, operator0_.PI_ROW_ADD_DATE as PI136_0_0_, operator0_.PI_DEEPEST_DEPTH as PI137_0_0_, operator0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, operator0_.PI_WELL_NM_SUFFIX as PI139_0_0_, operator0_.PI_OIL_LEASE_ID as PI140_0_0_, operator0_.PI_GAS_LEASE_ID as PI141_0_0_, operator0_.PI_STATE_REG_OP_ID as PI142_0_0_, operator0_.PI_WELL_ID as PI143_0_0_, operator0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL operator0_ where operator0_.OPERATOR=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.BusinessAssociate.licensee: select licensee0_.LICENSEE as LICENSEE1_, licensee0_.UWI as UWI1_, licensee0_.UWI as UWI0_0_, licensee0_.COUNTRY as COUNTRY0_0_, licensee0_.PROVINCE_STATE as PROVINCE3_0_0_, licensee0_.PI_CURRENT_OPER_CD as PI4_0_0_, licensee0_.AGENT as AGENT0_0_, licensee0_.OPERATOR as OPERATOR0_0_, licensee0_.LICENSEE as LICENSEE0_0_, licensee0_.SOURCE as SOURCE0_0_, licensee0_.BASE_NODE_ID as BASE9_0_0_, licensee0_.SURFACE_NODE_ID as SURFACE10_0_0_, licensee0_.TERMINATING_FORM as TERMINA11_0_0_, licensee0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, licensee0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, licensee0_.CONF_INDEX_RATIO as CONF14_0_0_, licensee0_.CONF_INDEX_LEVEL as CONF15_0_0_, licensee0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, licensee0_.WELL_NUMBER as WELL17_0_0_, licensee0_.WELL_NAME as WELL18_0_0_, licensee0_.WATER_DEPTH_REF as WATER19_0_0_, licensee0_.WATER_DEPTH as WATER20_0_0_, licensee0_.TVD_DEPTH as TVD21_0_0_, licensee0_.SPUD_DATE as SPUD22_0_0_, licensee0_.SHORT_NAME as SHORT23_0_0_, licensee0_.RIG_RELEASE_DATE as RIG24_0_0_, licensee0_.REF_ELEV as REF25_0_0_, licensee0_.PROPRIETARY_IND as PROPRIE26_0_0_, licensee0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, licensee0_.PLOT_SYMBOL as PLOT28_0_0_, licensee0_.DISTRICT as DISTRICT0_0_, licensee0_.DISCOVERY_IND as DISCOVERY30_0_0_, licensee0_.DEVIATION_IND as DEVIATION31_0_0_, licensee0_.COUNTY as COUNTY0_0_, licensee0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, licensee0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, licensee0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, licensee0_.PLOT_NAME as PLOT36_0_0_, licensee0_.LEASE_NUMBER as LEASE37_0_0_, licensee0_.LEASE_NAME as LEASE38_0_0_, licensee0_.KB_ELEV as KB39_0_0_, licensee0_.INITIAL_CLASS as INITIAL40_0_0_, licensee0_.HOLE_DIRECTION as HOLE41_0_0_, licensee0_.GROUND_ELEV as GROUND42_0_0_, licensee0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, licensee0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, licensee0_.FINAL_DRILL_DATE as FINAL45_0_0_, licensee0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, licensee0_.FAULTED_IND as FAULTED47_0_0_, licensee0_.ELEVATION_REF as ELEVATION48_0_0_, licensee0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, licensee0_.DISTRICT_NUMBER as DISTRICT50_0_0_, licensee0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, licensee0_.CASING_FLANGE_ELEV as CASING52_0_0_, licensee0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, licensee0_.CLASS as CLASS0_0_, licensee0_.PI_TD_AGE_CODE as PI55_0_0_, licensee0_.PI_STATUS_DATE as PI56_0_0_, licensee0_.PI_CRSTATUS as PI57_0_0_, licensee0_.PI_PRSTATUS as PI58_0_0_, licensee0_.PI_FINAL_STATUS as PI59_0_0_, licensee0_.PI_COMP_DATE as PI60_0_0_, licensee0_.PI_LOG_TD as PI61_0_0_, licensee0_.PI_LAST_UPDATE as PI62_0_0_, licensee0_.PI_LOCATION_TABLE as PI63_0_0_, licensee0_.PI_ABAND_DATE as PI64_0_0_, licensee0_.PI_OLD_TD as PI65_0_0_, licensee0_.PI_CTS_CD as PI66_0_0_, licensee0_.PI_LEASE_TYPE as PI67_0_0_, licensee0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, licensee0_.PI_TAX_CREDIT as PI69_0_0_, licensee0_.PI_PRODUCT_DATE as PI70_0_0_, licensee0_.PI_RELEASED as PI71_0_0_, licensee0_.PI_BASIN as PI72_0_0_, licensee0_.PI_PERM_ELEV_REF as PI73_0_0_, licensee0_.PI_MD as PI74_0_0_, licensee0_.PI_OPERATOR_NAME as PI75_0_0_, licensee0_.PI_PROD_WELL_ID as PI76_0_0_, licensee0_.PLATFORM_ID as PLATFORM77_0_0_, licensee0_.PI_SEISMIC_DATUM as PI78_0_0_, licensee0_.PI_LEASE_AREA as PI79_0_0_, licensee0_.PI_LEASE_AREA_OUOM as PI80_0_0_, licensee0_.PI_SITUATION_CD as PI81_0_0_, licensee0_.PI_WELL_REGION as PI82_0_0_, licensee0_.PI_TVD_LGR as PI83_0_0_, licensee0_.PI_DOCUMENT_SOURCE as PI84_0_0_, licensee0_.PI_WELL_SLOT_NO as PI85_0_0_, licensee0_.PI_VENDOR_UPDATE as PI86_0_0_, licensee0_.PI_GROSS_NET_PAY as PI87_0_0_, licensee0_.PI_GRS_NETPY_OUOM as PI88_0_0_, licensee0_.PI_SURVEYOR as PI89_0_0_, licensee0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, licensee0_.PI_WATER_DPTH_OUOM as PI91_0_0_, licensee0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, licensee0_.PI_REF_ELEV_OUOM as PI93_0_0_, licensee0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, licensee0_.PI_KB_ELEV_OUOM as PI95_0_0_, licensee0_.PI_GRND_ELEV_OUOM as PI96_0_0_, licensee0_.PI_DRILL_TD_OUOM as PI97_0_0_, licensee0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, licensee0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, licensee0_.PI_LOG_TD_OUOM as PI100_0_0_, licensee0_.PI_OLD_TD_OUOM as PI101_0_0_, licensee0_.PI_MD_OUOM as PI102_0_0_, licensee0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, licensee0_.PI_TVD_LGR_OUOM as PI104_0_0_, licensee0_.PI_PRODUCTION_FLAG as PI105_0_0_, licensee0_.PI_ACTIVE_CODE as PI106_0_0_, licensee0_.PI_PROJECT_NUMBER as PI107_0_0_, licensee0_.PI_ADD_DATE as PI108_0_0_, licensee0_.PI_GOVT_CHANGE_NO as PI109_0_0_, licensee0_.PI_REC_UPD_DATE as PI110_0_0_, licensee0_.PI_USER_ID as PI111_0_0_, licensee0_.PI_WDS_ID as PI112_0_0_, licensee0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, licensee0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, licensee0_.PI_SURFACE_LAT as PI115_0_0_, licensee0_.PI_SURFACE_LONG as PI116_0_0_, licensee0_.PI_PLATFORM_SOURCE as PI117_0_0_, licensee0_.PI_PROPRIETARY_ID as PI118_0_0_, licensee0_.PI_DF_ELEV as PI119_0_0_, licensee0_.PI_DF_ELEV_OUOM as PI120_0_0_, licensee0_.PI_ABND_LOC_DATE as PI121_0_0_, licensee0_.PI_SUSPENDED_DATE as PI122_0_0_, licensee0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, licensee0_.PI_TERM_FORM_INTRP as PI124_0_0_, licensee0_.PI_PARENT_UWI as PI125_0_0_, licensee0_.PI_PARENT_RELATION as PI126_0_0_, licensee0_.PI_EST_COMP_DT_IND as PI127_0_0_, licensee0_.PI_EST_SPUD_DT_IND as PI128_0_0_, licensee0_.PI_EST_TD_DT_IND as PI129_0_0_, licensee0_.PI_EST_GR_ELEV_IND as PI130_0_0_, licensee0_.PI_EST_TD_IND as PI131_0_0_, licensee0_.PI_INFILL_CODE as PI132_0_0_, licensee0_.PI_UNIT_AREA as PI133_0_0_, licensee0_.PI_UNIT_AREA_OUOM as PI134_0_0_, licensee0_.PI_RIG_ON_SITE_DT as PI135_0_0_, licensee0_.PI_ROW_ADD_DATE as PI136_0_0_, licensee0_.PI_DEEPEST_DEPTH as PI137_0_0_, licensee0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, licensee0_.PI_WELL_NM_SUFFIX as PI139_0_0_, licensee0_.PI_OIL_LEASE_ID as PI140_0_0_, licensee0_.PI_GAS_LEASE_ID as PI141_0_0_, licensee0_.PI_STATE_REG_OP_ID as PI142_0_0_, licensee0_.PI_WELL_ID as PI143_0_0_, licensee0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL licensee0_ where licensee0_.LICENSEE=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.BusinessAssociate.piCurrentOperator: select picurrento0_.PI_CURRENT_OPER_CD as PI4_1_, picurrento0_.UWI as UWI1_, picurrento0_.UWI as UWI0_0_, picurrento0_.COUNTRY as COUNTRY0_0_, picurrento0_.PROVINCE_STATE as PROVINCE3_0_0_, picurrento0_.PI_CURRENT_OPER_CD as PI4_0_0_, picurrento0_.AGENT as AGENT0_0_, picurrento0_.OPERATOR as OPERATOR0_0_, picurrento0_.LICENSEE as LICENSEE0_0_, picurrento0_.SOURCE as SOURCE0_0_, picurrento0_.BASE_NODE_ID as BASE9_0_0_, picurrento0_.SURFACE_NODE_ID as SURFACE10_0_0_, picurrento0_.TERMINATING_FORM as TERMINA11_0_0_, picurrento0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, picurrento0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, picurrento0_.CONF_INDEX_RATIO as CONF14_0_0_, picurrento0_.CONF_INDEX_LEVEL as CONF15_0_0_, picurrento0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, picurrento0_.WELL_NUMBER as WELL17_0_0_, picurrento0_.WELL_NAME as WELL18_0_0_, picurrento0_.WATER_DEPTH_REF as WATER19_0_0_, picurrento0_.WATER_DEPTH as WATER20_0_0_, picurrento0_.TVD_DEPTH as TVD21_0_0_, picurrento0_.SPUD_DATE as SPUD22_0_0_, picurrento0_.SHORT_NAME as SHORT23_0_0_, picurrento0_.RIG_RELEASE_DATE as RIG24_0_0_, picurrento0_.REF_ELEV as REF25_0_0_, picurrento0_.PROPRIETARY_IND as PROPRIE26_0_0_, picurrento0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, picurrento0_.PLOT_SYMBOL as PLOT28_0_0_, picurrento0_.DISTRICT as DISTRICT0_0_, picurrento0_.DISCOVERY_IND as DISCOVERY30_0_0_, picurrento0_.DEVIATION_IND as DEVIATION31_0_0_, picurrento0_.COUNTY as COUNTY0_0_, picurrento0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, picurrento0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, picurrento0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, picurrento0_.PLOT_NAME as PLOT36_0_0_, picurrento0_.LEASE_NUMBER as LEASE37_0_0_, picurrento0_.LEASE_NAME as LEASE38_0_0_, picurrento0_.KB_ELEV as KB39_0_0_, picurrento0_.INITIAL_CLASS as INITIAL40_0_0_, picurrento0_.HOLE_DIRECTION as HOLE41_0_0_, picurrento0_.GROUND_ELEV as GROUND42_0_0_, picurrento0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, picurrento0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, picurrento0_.FINAL_DRILL_DATE as FINAL45_0_0_, picurrento0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, picurrento0_.FAULTED_IND as FAULTED47_0_0_, picurrento0_.ELEVATION_REF as ELEVATION48_0_0_, picurrento0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, picurrento0_.DISTRICT_NUMBER as DISTRICT50_0_0_, picurrento0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, picurrento0_.CASING_FLANGE_ELEV as CASING52_0_0_, picurrento0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, picurrento0_.CLASS as CLASS0_0_, picurrento0_.PI_TD_AGE_CODE as PI55_0_0_, picurrento0_.PI_STATUS_DATE as PI56_0_0_, picurrento0_.PI_CRSTATUS as PI57_0_0_, picurrento0_.PI_PRSTATUS as PI58_0_0_, picurrento0_.PI_FINAL_STATUS as PI59_0_0_, picurrento0_.PI_COMP_DATE as PI60_0_0_, picurrento0_.PI_LOG_TD as PI61_0_0_, picurrento0_.PI_LAST_UPDATE as PI62_0_0_, picurrento0_.PI_LOCATION_TABLE as PI63_0_0_, picurrento0_.PI_ABAND_DATE as PI64_0_0_, picurrento0_.PI_OLD_TD as PI65_0_0_, picurrento0_.PI_CTS_CD as PI66_0_0_, picurrento0_.PI_LEASE_TYPE as PI67_0_0_, picurrento0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, picurrento0_.PI_TAX_CREDIT as PI69_0_0_, picurrento0_.PI_PRODUCT_DATE as PI70_0_0_, picurrento0_.PI_RELEASED as PI71_0_0_, picurrento0_.PI_BASIN as PI72_0_0_, picurrento0_.PI_PERM_ELEV_REF as PI73_0_0_, picurrento0_.PI_MD as PI74_0_0_, picurrento0_.PI_OPERATOR_NAME as PI75_0_0_, picurrento0_.PI_PROD_WELL_ID as PI76_0_0_, picurrento0_.PLATFORM_ID as PLATFORM77_0_0_, picurrento0_.PI_SEISMIC_DATUM as PI78_0_0_, picurrento0_.PI_LEASE_AREA as PI79_0_0_, picurrento0_.PI_LEASE_AREA_OUOM as PI80_0_0_, picurrento0_.PI_SITUATION_CD as PI81_0_0_, picurrento0_.PI_WELL_REGION as PI82_0_0_, picurrento0_.PI_TVD_LGR as PI83_0_0_, picurrento0_.PI_DOCUMENT_SOURCE as PI84_0_0_, picurrento0_.PI_WELL_SLOT_NO as PI85_0_0_, picurrento0_.PI_VENDOR_UPDATE as PI86_0_0_, picurrento0_.PI_GROSS_NET_PAY as PI87_0_0_, picurrento0_.PI_GRS_NETPY_OUOM as PI88_0_0_, picurrento0_.PI_SURVEYOR as PI89_0_0_, picurrento0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, picurrento0_.PI_WATER_DPTH_OUOM as PI91_0_0_, picurrento0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, picurrento0_.PI_REF_ELEV_OUOM as PI93_0_0_, picurrento0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, picurrento0_.PI_KB_ELEV_OUOM as PI95_0_0_, picurrento0_.PI_GRND_ELEV_OUOM as PI96_0_0_, picurrento0_.PI_DRILL_TD_OUOM as PI97_0_0_, picurrento0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, picurrento0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, picurrento0_.PI_LOG_TD_OUOM as PI100_0_0_, picurrento0_.PI_OLD_TD_OUOM as PI101_0_0_, picurrento0_.PI_MD_OUOM as PI102_0_0_, picurrento0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, picurrento0_.PI_TVD_LGR_OUOM as PI104_0_0_, picurrento0_.PI_PRODUCTION_FLAG as PI105_0_0_, picurrento0_.PI_ACTIVE_CODE as PI106_0_0_, picurrento0_.PI_PROJECT_NUMBER as PI107_0_0_, picurrento0_.PI_ADD_DATE as PI108_0_0_, picurrento0_.PI_GOVT_CHANGE_NO as PI109_0_0_, picurrento0_.PI_REC_UPD_DATE as PI110_0_0_, picurrento0_.PI_USER_ID as PI111_0_0_, picurrento0_.PI_WDS_ID as PI112_0_0_, picurrento0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, picurrento0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, picurrento0_.PI_SURFACE_LAT as PI115_0_0_, picurrento0_.PI_SURFACE_LONG as PI116_0_0_, picurrento0_.PI_PLATFORM_SOURCE as PI117_0_0_, picurrento0_.PI_PROPRIETARY_ID as PI118_0_0_, picurrento0_.PI_DF_ELEV as PI119_0_0_, picurrento0_.PI_DF_ELEV_OUOM as PI120_0_0_, picurrento0_.PI_ABND_LOC_DATE as PI121_0_0_, picurrento0_.PI_SUSPENDED_DATE as PI122_0_0_, picurrento0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, picurrento0_.PI_TERM_FORM_INTRP as PI124_0_0_, picurrento0_.PI_PARENT_UWI as PI125_0_0_, picurrento0_.PI_PARENT_RELATION as PI126_0_0_, picurrento0_.PI_EST_COMP_DT_IND as PI127_0_0_, picurrento0_.PI_EST_SPUD_DT_IND as PI128_0_0_, picurrento0_.PI_EST_TD_DT_IND as PI129_0_0_, picurrento0_.PI_EST_GR_ELEV_IND as PI130_0_0_, picurrento0_.PI_EST_TD_IND as PI131_0_0_, picurrento0_.PI_INFILL_CODE as PI132_0_0_, picurrento0_.PI_UNIT_AREA as PI133_0_0_, picurrento0_.PI_UNIT_AREA_OUOM as PI134_0_0_, picurrento0_.PI_RIG_ON_SITE_DT as PI135_0_0_, picurrento0_.PI_ROW_ADD_DATE as PI136_0_0_, picurrento0_.PI_DEEPEST_DEPTH as PI137_0_0_, picurrento0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, picurrento0_.PI_WELL_NM_SUFFIX as PI139_0_0_, picurrento0_.PI_OIL_LEASE_ID as PI140_0_0_, picurrento0_.PI_GAS_LEASE_ID as PI141_0_0_, picurrento0_.PI_STATE_REG_OP_ID as PI142_0_0_, picurrento0_.PI_WELL_ID as PI143_0_0_, picurrento0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL picurrento0_ where picurrento0_.PI_CURRENT_OPER_CD=?
DEBUG [main] (OneToManyLoader.java:64) - Static select for one-to-many com.volant.pidm.model.RProvinceState.wells: select wells0_.COUNTRY as COUNTRY1_, wells0_.PROVINCE_STATE as PROVINCE3_1_, wells0_.UWI as UWI1_, wells0_.UWI as UWI0_0_, wells0_.COUNTRY as COUNTRY0_0_, wells0_.PROVINCE_STATE as PROVINCE3_0_0_, wells0_.PI_CURRENT_OPER_CD as PI4_0_0_, wells0_.AGENT as AGENT0_0_, wells0_.OPERATOR as OPERATOR0_0_, wells0_.LICENSEE as LICENSEE0_0_, wells0_.SOURCE as SOURCE0_0_, wells0_.BASE_NODE_ID as BASE9_0_0_, wells0_.SURFACE_NODE_ID as SURFACE10_0_0_, wells0_.TERMINATING_FORM as TERMINA11_0_0_, wells0_.CONFIDENTIAL_FORM as CONFIDE12_0_0_, wells0_.ASSIGNED_FIELD as ASSIGNED13_0_0_, wells0_.CONF_INDEX_RATIO as CONF14_0_0_, wells0_.CONF_INDEX_LEVEL as CONF15_0_0_, wells0_.WHIPSTOCK_DEPTH as WHIPSTOCK16_0_0_, wells0_.WELL_NUMBER as WELL17_0_0_, wells0_.WELL_NAME as WELL18_0_0_, wells0_.WATER_DEPTH_REF as WATER19_0_0_, wells0_.WATER_DEPTH as WATER20_0_0_, wells0_.TVD_DEPTH as TVD21_0_0_, wells0_.SPUD_DATE as SPUD22_0_0_, wells0_.SHORT_NAME as SHORT23_0_0_, wells0_.RIG_RELEASE_DATE as RIG24_0_0_, wells0_.REF_ELEV as REF25_0_0_, wells0_.PROPRIETARY_IND as PROPRIE26_0_0_, wells0_.PLUGBACK_DEPTH as PLUGBACK27_0_0_, wells0_.PLOT_SYMBOL as PLOT28_0_0_, wells0_.DISTRICT as DISTRICT0_0_, wells0_.DISCOVERY_IND as DISCOVERY30_0_0_, wells0_.DEVIATION_IND as DEVIATION31_0_0_, wells0_.COUNTY as COUNTY0_0_, wells0_.CONFIDLTY_TYPE as CONFIDLTY33_0_0_, wells0_.CONFIDLTY_RM_DATE as CONFIDLTY34_0_0_, wells0_.CONFIDLTY_IND as CONFIDLTY35_0_0_, wells0_.PLOT_NAME as PLOT36_0_0_, wells0_.LEASE_NUMBER as LEASE37_0_0_, wells0_.LEASE_NAME as LEASE38_0_0_, wells0_.KB_ELEV as KB39_0_0_, wells0_.INITIAL_CLASS as INITIAL40_0_0_, wells0_.HOLE_DIRECTION as HOLE41_0_0_, wells0_.GROUND_ELEV as GROUND42_0_0_, wells0_.GOVT_ASSIGN_NUMBER as GOVT43_0_0_, wells0_.GEOLOGIC_PROVINCE as GEOLOGIC44_0_0_, wells0_.FINAL_DRILL_DATE as FINAL45_0_0_, wells0_.FIELD_POOL_WILDCAT as FIELD46_0_0_, wells0_.FAULTED_IND as FAULTED47_0_0_, wells0_.ELEVATION_REF as ELEVATION48_0_0_, wells0_.DRILL_TOTAL_DEPTH as DRILL49_0_0_, wells0_.DISTRICT_NUMBER as DISTRICT50_0_0_, wells0_.CONFIDLTY_DEPTH as CONFIDLTY51_0_0_, wells0_.CASING_FLANGE_ELEV as CASING52_0_0_, wells0_.CONFIDENCE_INDEX as CONFIDENCE53_0_0_, wells0_.CLASS as CLASS0_0_, wells0_.PI_TD_AGE_CODE as PI55_0_0_, wells0_.PI_STATUS_DATE as PI56_0_0_, wells0_.PI_CRSTATUS as PI57_0_0_, wells0_.PI_PRSTATUS as PI58_0_0_, wells0_.PI_FINAL_STATUS as PI59_0_0_, wells0_.PI_COMP_DATE as PI60_0_0_, wells0_.PI_LOG_TD as PI61_0_0_, wells0_.PI_LAST_UPDATE as PI62_0_0_, wells0_.PI_LOCATION_TABLE as PI63_0_0_, wells0_.PI_ABAND_DATE as PI64_0_0_, wells0_.PI_OLD_TD as PI65_0_0_, wells0_.PI_CTS_CD as PI66_0_0_, wells0_.PI_LEASE_TYPE as PI67_0_0_, wells0_.PI_VNDR_ASSIGN_NO as PI68_0_0_, wells0_.PI_TAX_CREDIT as PI69_0_0_, wells0_.PI_PRODUCT_DATE as PI70_0_0_, wells0_.PI_RELEASED as PI71_0_0_, wells0_.PI_BASIN as PI72_0_0_, wells0_.PI_PERM_ELEV_REF as PI73_0_0_, wells0_.PI_MD as PI74_0_0_, wells0_.PI_OPERATOR_NAME as PI75_0_0_, wells0_.PI_PROD_WELL_ID as PI76_0_0_, wells0_.PLATFORM_ID as PLATFORM77_0_0_, wells0_.PI_SEISMIC_DATUM as PI78_0_0_, wells0_.PI_LEASE_AREA as PI79_0_0_, wells0_.PI_LEASE_AREA_OUOM as PI80_0_0_, wells0_.PI_SITUATION_CD as PI81_0_0_, wells0_.PI_WELL_REGION as PI82_0_0_, wells0_.PI_TVD_LGR as PI83_0_0_, wells0_.PI_DOCUMENT_SOURCE as PI84_0_0_, wells0_.PI_WELL_SLOT_NO as PI85_0_0_, wells0_.PI_VENDOR_UPDATE as PI86_0_0_, wells0_.PI_GROSS_NET_PAY as PI87_0_0_, wells0_.PI_GRS_NETPY_OUOM as PI88_0_0_, wells0_.PI_SURVEYOR as PI89_0_0_, wells0_.PI_WPSTK_DPTH_OUOM as PI90_0_0_, wells0_.PI_WATER_DPTH_OUOM as PI91_0_0_, wells0_.PI_TVD_DEPTH_OUOM as PI92_0_0_, wells0_.PI_REF_ELEV_OUOM as PI93_0_0_, wells0_.PI_PGBCK_DPTH_OUOM as PI94_0_0_, wells0_.PI_KB_ELEV_OUOM as PI95_0_0_, wells0_.PI_GRND_ELEV_OUOM as PI96_0_0_, wells0_.PI_DRILL_TD_OUOM as PI97_0_0_, wells0_.PI_CNFTY_DPTH_OUOM as PI98_0_0_, wells0_.PI_CSG_FLANGE_OUOM as PI99_0_0_, wells0_.PI_LOG_TD_OUOM as PI100_0_0_, wells0_.PI_OLD_TD_OUOM as PI101_0_0_, wells0_.PI_MD_OUOM as PI102_0_0_, wells0_.PI_SEIS_DATUM_OUOM as PI103_0_0_, wells0_.PI_TVD_LGR_OUOM as PI104_0_0_, wells0_.PI_PRODUCTION_FLAG as PI105_0_0_, wells0_.PI_ACTIVE_CODE as PI106_0_0_, wells0_.PI_PROJECT_NUMBER as PI107_0_0_, wells0_.PI_ADD_DATE as PI108_0_0_, wells0_.PI_GOVT_CHANGE_NO as PI109_0_0_, wells0_.PI_REC_UPD_DATE as PI110_0_0_, wells0_.PI_USER_ID as PI111_0_0_, wells0_.PI_WDS_ID as PI112_0_0_, wells0_.PI_BOTTOM_HOLE_LAT as PI113_0_0_, wells0_.PI_BOTTOM_HOLE_LNG as PI114_0_0_, wells0_.PI_SURFACE_LAT as PI115_0_0_, wells0_.PI_SURFACE_LONG as PI116_0_0_, wells0_.PI_PLATFORM_SOURCE as PI117_0_0_, wells0_.PI_PROPRIETARY_ID as PI118_0_0_, wells0_.PI_DF_ELEV as PI119_0_0_, wells0_.PI_DF_ELEV_OUOM as PI120_0_0_, wells0_.PI_ABND_LOC_DATE as PI121_0_0_, wells0_.PI_SUSPENDED_DATE as PI122_0_0_, wells0_.PI_REF_ELEV_SUBSEA as PI123_0_0_, wells0_.PI_TERM_FORM_INTRP as PI124_0_0_, wells0_.PI_PARENT_UWI as PI125_0_0_, wells0_.PI_PARENT_RELATION as PI126_0_0_, wells0_.PI_EST_COMP_DT_IND as PI127_0_0_, wells0_.PI_EST_SPUD_DT_IND as PI128_0_0_, wells0_.PI_EST_TD_DT_IND as PI129_0_0_, wells0_.PI_EST_GR_ELEV_IND as PI130_0_0_, wells0_.PI_EST_TD_IND as PI131_0_0_, wells0_.PI_INFILL_CODE as PI132_0_0_, wells0_.PI_UNIT_AREA as PI133_0_0_, wells0_.PI_UNIT_AREA_OUOM as PI134_0_0_, wells0_.PI_RIG_ON_SITE_DT as PI135_0_0_, wells0_.PI_ROW_ADD_DATE as PI136_0_0_, wells0_.PI_DEEPEST_DEPTH as PI137_0_0_, wells0_.PI_DEEP_DEPTH_OUOM as PI138_0_0_, wells0_.PI_WELL_NM_SUFFIX as PI139_0_0_, wells0_.PI_OIL_LEASE_ID as PI140_0_0_, wells0_.PI_GAS_LEASE_ID as PI141_0_0_, wells0_.PI_STATE_REG_OP_ID as PI142_0_0_, wells0_.PI_WELL_ID as PI143_0_0_, wells0_.PI_EST_KB_ELEV_IND as PI144_0_0_ from PIDM.WELL wells0_ where wells0_.COUNTRY=? and wells0_.PROVINCE_STATE=?
DEBUG [main] (SessionFactoryObjectFactory.java:39) - initializing class SessionFactoryObjectFactory
DEBUG [main] (SessionFactoryObjectFactory.java:76) - registered: 8a8281820650f625010650f631600000 (PidmSessionFactory)
INFO [main] (SessionFactoryObjectFactory.java:86) - Factory name: PidmSessionFactory
INFO [main] (NamingHelper.java:26) - JNDI InitialContext properties:{}
DEBUG [main] (NamingHelper.java:48) - binding: PidmSessionFactory
WARN [main] (SessionFactoryObjectFactory.java:98) - Could not bind factory to JNDI
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:247)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:284)
at javax.naming.InitialContext.getNameParser(InitialContext.java:439)
at org.hibernate.util.NamingHelper.bind(NamingHelper.java:52)
at org.hibernate.impl.SessionFactoryObjectFactory.addInstance(SessionFactoryObjectFactory.java:90)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:293)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1091)
at com.volant.pidm.db.PidmSessionFactory.currentSession(PidmSessionFactory.java:48)
at com.volant.pidm.db.PidmDAO.getUwiByStateAndCounty(PidmDAO.java:28)
at com.volant.pidm.test.db.TestPidmDAO.testUwiByStateAndCounty(TestPidmDAO.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
DEBUG [main] (SessionFactoryImpl.java:295) - instantiated session factory
INFO [main] (SessionFactoryImpl.java:427) - Checking 0 named queries
DEBUG [main] (SessionImpl.java:270) - opened session at timestamp: 4614716390268928
DEBUG [main] (SessionImpl.java:970) - find: from Well w where w.RProvinceState = :state
DEBUG [main] (SerializationHelper.java:141) - Starting serialization of object [com.volant.pidm.model.RProvinceStateId@2ffcb6]
DEBUG [main] (QueryParameters.java:261) - named parameters: {state=2c6d8085f3f280a6e3efedaef6efece1eef4aef0e9e4edaeedefe4e5ecaed2d0f2eff6e9eee3e5d3f4e1f4e5c9e48080808080808081828082cc8087e3eff5eef4f2f9f48092cceae1f6e1afece1eee7afd3f4f2e9eee7bbcc808df0f2eff6e9eee3e5d3f4e1f4e5f180fe8081f8f0f48083d5d3c1f48082b4b2}
DEBUG

Did a little more reading, and the correct way to set the id is ...

session.createQuery("select w.uwi from Well as w " +
"where w.RProvinceState.id.country = :country " +
" and w.RProvinceState.id.provinceState = :state")
.setParameter("country", "USA")
.setParameter("state", "42");

simple, just needed to pull my head out my @$$. :)