Many apologies for the previous query, I wasn't really thinking straight when I posted it.
Anyway, I have simplified it as much as possible down to just the 4 map files.
I'm running Hibernate 2.1.2 on IBM JDK1.3.1 against UDB7.2 fp5.
Code:
15:47:33,938 INFO - Hibernate 2.1.2
15:47:33,938 INFO - loaded properties from resource hibernate.properties: {hibernate.cglib.use_reflection_optimizer=false}
15:47:33,938 INFO - JVM does not support Statement.getGeneratedKeys()
15:47:33,938 INFO - JVM does not support LinkedHasMap, LinkedHashSet - ordered maps and sets disabled
15:47:33,938 INFO - using workaround for JVM bug in java.sql.Timestamp
15:47:33,938 INFO - configuring from resource: /hibernate.cfg.xml
15:47:33,938 INFO - Configuration resource: /hibernate.cfg.xml
15:47:34,250 DEBUG - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd in classpath under net/sf/hibernate/
15:47:34,250 DEBUG - found http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd in classpath
15:47:34,359 DEBUG - connection.datasource=jdbc/clex/CLEX_DS
15:47:34,359 DEBUG - dialect=net.sf.hibernate.dialect.DB2Dialect
15:47:34,359 DEBUG - show_sql=false
15:47:34,359 DEBUG - use_outer_join=false
15:47:34,359 DEBUG - transaction.manager_lookup_class=net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
15:47:34,359 DEBUG - hibernate/SessionFactory<-org.dom4j.tree.DefaultAttribute@3120f2f5 [Attribute: name resource value "com/landg/clex2/hibernate/Tia00569.hbm.xml"]
15:47:34,359 INFO - Mapping resource: com/landg/clex2/hibernate/Tia00569.hbm.xml
15:47:34,375 DEBUG - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
15:47:34,375 DEBUG - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
15:47:34,750 INFO - Mapping class: com.landg.clex2.hibernate.Tia00569 -> TIA00569
15:47:34,844 DEBUG - Mapped property: cntrId -> CNTR_ID, type: string
15:47:34,859 DEBUG - Mapped property: cntrbrodBsnsCtgy -> CNTRBROD_BSNS_CTGY, type: string
...more mapped properties
15:47:34,875 DEBUG - Mapped property: maintUserId -> MAINT_USER_ID, type: string
15:47:34,891 DEBUG - Mapped property: tia00571s, type: java.util.Set
15:47:34,891 DEBUG - hibernate/SessionFactory<-org.dom4j.tree.DefaultAttribute@312f32f5 [Attribute: name resource value "com/landg/clex2/hibernate/Tia00570.hbm.xml"]
15:47:34,891 INFO - Mapping resource: com/landg/clex2/hibernate/Tia00570.hbm.xml
15:47:34,906 DEBUG - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
15:47:34,906 DEBUG - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
15:47:35,047 INFO - Mapping class: com.landg.clex2.hibernate.Tia00570 -> TIA00570
15:47:35,047 DEBUG - Mapped property: claimCaseNumber -> CLAIM_CASE_NUMBER, type: integer
15:47:35,047 DEBUG - Mapped property: claimType -> CLAIM_TYPE, type: string
...more mapped properties
15:47:35,062 DEBUG - Mapped property: maintUserId -> MAINT_USER_ID, type: string
15:47:35,062 DEBUG - Mapped property: tia00571s, type: java.util.Set
15:47:35,062 DEBUG - hibernate/SessionFactory<-org.dom4j.tree.DefaultAttribute@30b232f5 [Attribute: name resource value "com/landg/clex2/hibernate/Tia00571.hbm.xml"]
15:47:35,062 INFO - Mapping resource: com/landg/clex2/hibernate/Tia00571.hbm.xml
15:47:35,062 DEBUG - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
15:47:35,062 DEBUG - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
15:47:35,938 INFO - Mapping class: com.landg.clex2.hibernate.Tia00571 -> TIA00571
15:47:35,938 DEBUG - Mapped property: tia00570 -> CLAIM_CASE_NUMBER, type: com.landg.clex2.hibernate.Tia00570
15:47:35,938 DEBUG - Mapped property: tia00569 -> CNTR_ID, type: com.landg.clex2.hibernate.Tia00569
15:47:36,156 DEBUG - Mapped property: comp_id -> CLAIM_CASE_NUMBER, CNTR_ID, type: com.landg.clex2.hibernate.Tia00571PK
15:47:36,156 DEBUG - Mapped property: titleType -> TITLE_TYPE, type: string
...more mapped properties
15:47:36,172 DEBUG - Mapped property: maintUserId -> MAINT_USER_ID, type: string
15:47:36,172 DEBUG - Mapped property: tia00573, type: com.landg.clex2.hibernate.Tia00573
15:47:36,172 DEBUG - hibernate/SessionFactory<-org.dom4j.tree.DefaultAttribute@30b872f5 [Attribute: name resource value "com/landg/clex2/hibernate/Tia00573.hbm.xml"]
15:47:36,172 INFO - Mapping resource: com/landg/clex2/hibernate/Tia00573.hbm.xml
15:47:36,188 DEBUG - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
15:47:36,188 DEBUG - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
15:47:36,250 INFO - Mapping class: com.landg.clex2.hibernate.Tia00573 -> TIA00573
15:47:36,250 DEBUG - Mapped property: tia00571 -> CLAIM_CASE_NUMBER, CNTR_ID, type: com.landg.clex2.hibernate.Tia00571
15:47:36,266 DEBUG - Mapped property: comp_id -> CLAIM_CASE_NUMBER, CNTR_ID, type: com.landg.clex2.hibernate.Tia00573PK
15:47:36,266 DEBUG - Mapped property: leadContractId -> LEAD_CONTRACT_ID, type: string
...more mapped properties
15:47:36,266 DEBUG - Mapped property: tia00571, type: com.landg.clex2.hibernate.Tia00571
15:47:36,266 INFO - Configured SessionFactory: hibernate/SessionFactory
15:47:36,266 INFO - processing one-to-many association mappings
15:47:36,266 DEBUG - Second pass for collection: com.landg.clex2.hibernate.Tia00569.tia00571s
15:47:36,266 INFO - Mapping collection: com.landg.clex2.hibernate.Tia00569.tia00571s -> TIA00571
15:47:36,266 DEBUG - Mapped collection key: CNTR_ID, one-to-many: com.landg.clex2.hibernate.Tia00571
15:47:36,266 DEBUG - Second pass for collection: com.landg.clex2.hibernate.Tia00570.tia00571s
15:47:36,266 INFO - Mapping collection: com.landg.clex2.hibernate.Tia00570.tia00571s -> TIA00571
15:47:36,266 DEBUG - Mapped collection key: CLAIM_CASE_NUMBER, one-to-many: com.landg.clex2.hibernate.Tia00571
15:47:36,266 INFO - processing one-to-one association property references
15:47:36,266 INFO - processing foreign key constraints
15:47:36,266 DEBUG - resolving reference to class: com.landg.clex2.hibernate.Tia00571
15:47:36,266 DEBUG - resolving reference to class: com.landg.clex2.hibernate.Tia00570
15:47:36,266 DEBUG - resolving reference to class: com.landg.clex2.hibernate.Tia00569
15:47:36,297 INFO - Using dialect: net.sf.hibernate.dialect.DB2Dialect
15:47:36,312 INFO - Use outer join fetching: false
15:47:36,312 INFO - JNDI InitialContext properties:{}
15:47:37,203 INFO - Using datasource: jdbc/clex/CLEX_DS
15:47:37,219 INFO - instantiating TransactionManagerLookup: net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
15:47:37,219 INFO - instantiated TransactionManagerLookup
15:47:38,844 INFO - Use scrollable result sets: true
15:47:38,844 INFO - Use JDBC3 getGeneratedKeys(): false
15:47:38,844 INFO - Optimize cache for minimal puts: false
15:47:38,844 INFO - Query language substitutions: {}
15:47:38,844 INFO - cache provider: net.sf.ehcache.hibernate.Provider
15:47:38,859 INFO - instantiating and configuring caches
15:47:38,875 INFO - building session factory
15:47:38,875 DEBUG - instantiating session factory with properties: {java.assistive=ON, java.runtime.name=Java(TM) 2 Runtime
...etc
15:47:40,062 DEBUG - initializing class SessionFactoryObjectFactory
15:47:40,062 DEBUG - registered: 8a828dddfac94f9000fac94f959e0000 (hibernate/SessionFactory)
15:47:40,062 INFO - Factory name: hibernate/SessionFactory
15:47:40,062 INFO - JNDI InitialContext properties:{}
15:47:40,062 DEBUG - binding: hibernate/SessionFactory
15:47:40,062 DEBUG - Returning a Reference to the SessionFactory
15:47:40,078 DEBUG - Bound name: hibernate/SessionFactory
15:47:40,078 INFO - Bound factory to JNDI name: hibernate/SessionFactory
15:47:40,078 WARN - InitialContext did not implement EventContext
15:47:40,078 DEBUG - instantiated session factory
15:47:40,078 DEBUG - obtaining JTA TransactionManager
15:47:40,094 INFO - WebSphere 4
15:47:40,156 DEBUG - opened session
15:47:40,156 DEBUG - begin
15:47:40,156 DEBUG - current autocommit status:true
15:47:40,156 DEBUG - disabling autocommit
15:47:40,156 DEBUG - find: from com.landg.clex2.hibernate.Tia00573 as tia00573
15:47:40,188 DEBUG - compiling query
15:47:40,203 DEBUG - flushing session
15:47:40,203 DEBUG - Flushing entities and processing referenced collections
15:47:40,203 DEBUG - Processing unreferenced collections
15:47:40,203 DEBUG - Scheduling collection removes/(re)creates/updates
15:47:40,203 DEBUG - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
15:47:40,203 DEBUG - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
15:47:40,203 DEBUG - Dont need to execute flush
15:47:40,203 DEBUG - HQL: from com.landg.clex2.hibernate.Tia00573 as tia00573
15:47:40,203 DEBUG - SQL: select tia005730_.CLAIM_CASE_NUMBER as CLAIM_CA1_, tia005730_.CNTR_ID as CNTR_ID, tia005730_.LEAD_CONTRACT_ID as LEAD_CON3_, tia005730_.PROD_ID as PROD_ID, tia005730_.PRODUCT_VER_TYPE as PRODUCT_5_, tia005730_.TTL_EXC_CLOSED_IND as TTL_EXC_6_, tia005730_.TTL_EXC_CLOSED_DAT as TTL_EXC_7_, tia005730_.ISA_IND as ISA_IND, tia005730_.TARGET_MAT_VAL as TARGET_M9_, tia005730_.MAINT_USER_ID as MAINT_U10_ from CLEX.TIA00573 tia005730_
15:47:40,203 DEBUG - about to open: 0 open PreparedStatements, 0 open ResultSets
15:47:40,203 DEBUG - select tia005730_.CLAIM_CASE_NUMBER as CLAIM_CA1_, tia005730_.CNTR_ID as CNTR_ID, tia005730_.LEAD_CONTRACT_ID as LEAD_CON3_, tia005730_.PROD_ID as PROD_ID, tia005730_.PRODUCT_VER_TYPE as PRODUCT_5_, tia005730_.TTL_EXC_CLOSED_IND as TTL_EXC_6_, tia005730_.TTL_EXC_CLOSED_DAT as TTL_EXC_7_, tia005730_.ISA_IND as ISA_IND, tia005730_.TARGET_MAT_VAL as TARGET_M9_, tia005730_.MAINT_USER_ID as MAINT_U10_ from CLEX.TIA00573 tia005730_
15:47:40,203 DEBUG - preparing statement
15:47:40,234 DEBUG - processing result set
15:47:40,250 DEBUG - loading [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,250 DEBUG - loading [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,266 DEBUG - attempting to resolve [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,266 DEBUG - object not resolved in any cache [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,266 DEBUG - Materializing entity: [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,266 DEBUG - about to open: 1 open PreparedStatements, 1 open ResultSets
15:47:40,266 DEBUG - select tia005700_.CLAIM_CASE_NUMBER as CLAIM_CA1_0_, tia005700_.CLAIM_TYPE as CLAIM_TYPE0_, tia005700_.CLAIM_CASE_ST_TYPE as CLAIM_CA3_0_, tia005700_.MANUAL_INPUT_IND as MANUAL_I4_0_, tia005700_.CREATE_TIMESTAMP as CREATE_T5_0_, tia005700_.SALARY as SALARY0_, tia005700_.OCCUPATION_TYPE as OCCUPATI7_0_, tia005700_.PERS_ID as PERS_ID0_, tia005700_.LOGON_ID as LOGON_ID0_, tia005700_.OTH_CONTRACT_IND as OTH_CON10_0_, tia005700_.OTH_MAT_CNTR_IND as OTH_MAT11_0_, tia005700_.CLM_PACK_DESPD_IND as CLM_PAC12_0_, tia005700_.MAINT_USER_ID as MAINT_U13_0_ from CLEX.TIA00570 tia005700_ where tia005700_.CLAIM_CASE_NUMBER=?
15:47:40,266 DEBUG - preparing statement
15:47:40,266 DEBUG - processing result set
15:47:40,266 DEBUG - result row: 1022
15:47:40,266 DEBUG - Initializing object from ResultSet: 1022
15:47:40,266 DEBUG - Hydrating entity: com.landg.clex2.hibernate.Tia00570#1022
15:47:40,266 DEBUG - done processing result set (1 rows)
15:47:40,266 DEBUG - done closing: 1 open PreparedStatements, 1 open ResultSets
15:47:40,266 DEBUG - closing statement
15:47:40,266 DEBUG - total objects hydrated: 1
15:47:40,266 DEBUG - resolving associations for [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,281 DEBUG - creating collection wrapper:[com.landg.clex2.hibernate.Tia00570.tia00571s#1022]
15:47:40,281 DEBUG - done materializing entity [com.landg.clex2.hibernate.Tia00570#1022]
15:47:40,281 DEBUG - attempting to resolve [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,281 DEBUG - object not resolved in any cache [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,281 DEBUG - Materializing entity: [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,281 DEBUG - about to open: 1 open PreparedStatements, 1 open ResultSets
15:47:40,281 DEBUG - select tia005690_.CNTR_ID as CNTR_ID0_, tia005690_.CNTRBROD_BSNS_CTGY as CNTRBROD2_0_, tia005690_.CNTRUWTG_PROD_CTGY as CNTRUWTG3_0_, tia005690_.INCN_MNTH as INCN_MNTH0_, tia005690_.INCN_YEAR as INCN_YEAR0_, tia005690_.EXPY_YEAR as EXPY_YEAR0_, tia005690_.SUM_ASRD as SUM_ASRD0_, tia005690_.VALN_CLSS as VALN_CLSS0_, tia005690_.RSNC_IND as RSNC_IND0_, tia005690_.POL_STTS as POL_STTS0_, tia005690_.LOCK_NMBR as LOCK_NMBR0_, tia005690_.PRODUCT_TYPE as PRODUCT12_0_, tia005690_.SCHEME_NUMBER as SCHEME_13_0_, tia005690_.MAINT_USER_ID as MAINT_U14_0_ from COMMON.TIA00569 tia005690_ where tia005690_.CNTR_ID=?
15:47:40,281 DEBUG - preparing statement
15:47:40,281 DEBUG - processing result set
15:47:40,281 DEBUG - result row: UK52308103
15:47:40,281 DEBUG - Initializing object from ResultSet: UK52308103
15:47:40,281 DEBUG - Hydrating entity: com.landg.clex2.hibernate.Tia00569#UK52308103
15:47:40,281 DEBUG - done processing result set (1 rows)
15:47:40,281 DEBUG - done closing: 1 open PreparedStatements, 1 open ResultSets
15:47:40,281 DEBUG - closing statement
15:47:40,281 DEBUG - total objects hydrated: 1
15:47:40,281 DEBUG - resolving associations for [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,281 DEBUG - creating collection wrapper:[com.landg.clex2.hibernate.Tia00569.tia00571s#UK52308103]
15:47:40,281 DEBUG - done materializing entity [com.landg.clex2.hibernate.Tia00569#UK52308103]
15:47:40,281 DEBUG - loading [com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - attempting to resolve [com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - object not resolved in any cache [com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - Materializing entity: [com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - about to open: 1 open PreparedStatements, 1 open ResultSets
15:47:40,297 DEBUG - select tia005710_.CLAIM_CASE_NUMBER as CLAIM_CA1_0_, tia005710_.CNTR_ID as CNTR_ID0_, tia005710_.TITLE_TYPE as TITLE_TYPE0_, tia005710_.FREQUENCY_TYPE as FREQUENC4_0_, tia005710_.PURCH_REASON_TYPE as PURCH_RE5_0_, tia005710_.OCCUPATION_TYPE as OCCUPATI6_0_, tia005710_.REASSUR_BASIS_TYPE as REASSUR_7_0_, tia005710_.PROCUR_METHOD_TYPE as PROCUR_M8_0_, tia005710_.SALES_QUOTE_DATE as SALES_QU9_0_, tia005710_.INCEPTION_DATE as INCEPTI10_0_, tia005710_.EFFECTIVE_END_DATE as EFFECTI11_0_, tia005710_.DD_DETAIL_PRES_IND as DD_DETA12_0_, tia005710_.SIGNIFICNT_ALT_IND as SIGNIFI13_0_, tia005710_.CLAIM_ALREADY_IND as CLAIM_A14_0_, tia005710_.REINSTATED_IND as REINSTA15_0_, tia005710_.REINSTATEMENT_DATE as REINSTA16_0_, tia005710_.PREMIUM_AMOUNT as PREMIUM17_0_, tia005710_.INDEXED_IND as INDEXED18_0_, tia005710_.INDEXATION_DATE as INDEXAT19_0_, tia005710_.COVER_EXCL_IND as COVER_E20_0_, tia005710_.CNTR_SBTYP as CNTR_SBTYP0_, tia005710_.LEGACY_MKTING_NAME as LEGACY_22_0_, tia005710_.CONTRACT_AGE as CONTRAC23_0_, tia005710_.REASONS_FOR_RATING as REASONS24_0_, tia005710_.CREATE_TIMESTAMP as CREATE_25_0_, tia005710_.MATURITY_OPT_TYPE as MATURIT26_0_, tia005710_.MAINT_USER_ID as MAINT_U27_0_ from CLEX.TIA00571 tia005710_ where tia005710_.CLAIM_CASE_NUMBER=? and tia005710_.CNTR_ID=?
15:47:40,297 DEBUG - preparing statement
15:47:40,297 DEBUG - processing result set
15:47:40,297 DEBUG - result row: com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]
15:47:40,297 DEBUG - Initializing object from ResultSet: com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]
15:47:40,297 DEBUG - Hydrating entity: com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]
15:47:40,297 DEBUG - done processing result set (1 rows)
15:47:40,297 DEBUG - done closing: 1 open PreparedStatements, 1 open ResultSets
15:47:40,297 DEBUG - closing statement
15:47:40,297 DEBUG - total objects hydrated: 1
15:47:40,297 DEBUG - resolving associations for [com.landg.clex2.hibernate.Tia00571#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - loading [com.landg.clex2.hibernate.Tia00573#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - attempting to resolve [com.landg.clex2.hibernate.Tia00573#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - object not resolved in any cache [com.landg.clex2.hibernate.Tia00573#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - Materializing entity: [com.landg.clex2.hibernate.Tia00573#com.landg.clex2.hibernate.Tia00571PK@3012b2f5[tia00570=com.landg.clex2.hibernate.Tia00570@5e06f2f6[claimCaseNumber=1022],tia00569=com.landg.clex2.hibernate.Tia00569@1bb272f6[cntrId=UK52308103]]]
15:47:40,297 DEBUG - about to open: 1 open PreparedStatements, 1 open ResultSets
15:47:40,297 DEBUG - select tia005730_.CLAIM_CASE_NUMBER as CLAIM_CA1_0_, tia005730_.CNTR_ID as CNTR_ID0_, tia005730_.LEAD_CONTRACT_ID as LEAD_CON3_0_, tia005730_.PROD_ID as PROD_ID0_, tia005730_.PRODUCT_VER_TYPE as PRODUCT_5_0_, tia005730_.TTL_EXC_CLOSED_IND as TTL_EXC_6_0_, tia005730_.TTL_EXC_CLOSED_DAT as TTL_EXC_7_0_, tia005730_.ISA_IND as ISA_IND0_, tia005730_.TARGET_MAT_VAL as TARGET_M9_0_, tia005730_.MAINT_USER_ID as MAINT_U10_0_ from CLEX.TIA00573 tia005730_ where tia005730_.CLAIM_CASE_NUMBER=? and tia005730_.CNTR_ID=?
15:47:40,297 DEBUG - preparing statement
15:47:40,297 ERROR - IllegalArgumentException in class: com.landg.clex2.hibernate.Tia00573PK, getter method of property: tia00571
15:47:40,312 DEBUG - done closing: 1 open PreparedStatements, 1 open ResultSets
15:47:40,312 DEBUG - closing statement
15:47:40,312 ERROR - Exception initializing proxy
net.sf.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of com.landg.clex2.hibernate.Tia00573PK.tia00571
at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:110)
at net.sf.hibernate.type.ComponentType.getPropertyValue(ComponentType.java:179)
at net.sf.hibernate.type.ComponentType.getPropertyValues(ComponentType.java:205)
at net.sf.hibernate.type.ComponentType.nullSafeGetValues(ComponentType.java:164)
at net.sf.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:151)
at net.sf.hibernate.loader.Loader.bindPositionalParameters(Loader.java:674)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:713)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:831)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:851)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2081)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1982)
at net.sf.hibernate.impl.SessionImpl.internalLoadOneToOne(SessionImpl.java:1909)
at net.sf.hibernate.type.OneToOneType.resolveIdentifier(OneToOneType.java:72)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:215)
at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2169)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:240)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:831)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:851)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2081)
at net.sf.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:1899)
at net.sf.hibernate.proxy.LazyInitializer.initialize(LazyInitializer.java:53)
at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:60)
at net.sf.hibernate.proxy.LazyInitializer.getImplementation(LazyInitializer.java:164)
at net.sf.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:108)
at com.landg.clex2.hibernate.Tia00571$$EnhancerByCGLIB$$dc1bd4ef.toString(<generated>)
at java.lang.String.valueOf(String.java:2466)
at java.lang.StringBuffer.append(StringBuffer.java:387)
at org.apache.commons.lang.builder.ToStringStyle.appendDetail(ToStringStyle.java:337)
at org.apache.commons.lang.builder.ToStringStyle.appendInternal(ToStringStyle.java:322)
at org.apache.commons.lang.builder.ToStringStyle.append(ToStringStyle.java:224)
at org.apache.commons.lang.builder.ToStringBuilder.append(ToStringBuilder.java:326)
at com.landg.clex2.hibernate.Tia00573PK.toString(Tia00573PK.java:32)
at net.sf.hibernate.engine.Key.toString(Key.java:54)
at java.lang.String.valueOf(String.java:2466)
at java.lang.StringBuffer.append(StringBuffer.java:387)
at net.sf.hibernate.util.StringHelper.toString(StringHelper.java:164)
at net.sf.hibernate.loader.Loader.getRow(Loader.java:405)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:209)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
at net.sf.hibernate.loader.Loader.list(Loader.java:941)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1483)
at com.landg.clex2.test.hibernate.Tia00573TestCase.testGetAllRows(Tia00573TestCase.java:105)
at java.lang.reflect.Method.invoke(Native Method)
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 junit.textui.TestRunner.doRun(TestRunner.java:116)
at junit.textui.TestRunner.doRun(TestRunner.java:109)
at junit.textui.TestRunner.run(TestRunner.java:72)
at junit.textui.TestRunner.run(TestRunner.java:57)
at com.landg.clex2.test.hibernate.Tia00573TestCase.main(Tia00573TestCase.java:307)
Caused by:
java.lang.IllegalArgumentException: object is not an instance of declaring class
at java.lang.reflect.Method.invoke(Native Method)
at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:96)
... 68 more
15:47:40,312 DEBUG - done closing: 0 open PreparedStatements, 0 open ResultSets
15:47:40,312 DEBUG - closing statement
15:47:40,312 DEBUG - commit
15:47:40,312 DEBUG - flushing session
15:47:40,312 DEBUG - Flushing entities and processing referenced collections
15:47:40,328 DEBUG - Collection found: [com.landg.clex2.hibernate.Tia00570.tia00571s#1022], was: [com.landg.clex2.hibernate.Tia00570.tia00571s#1022]
15:47:40,328 DEBUG - Collection found: [com.landg.clex2.hibernate.Tia00569.tia00571s#UK52308103], was: [com.landg.clex2.hibernate.Tia00569.tia00571s#UK52308103]
15:47:40,328 DEBUG - Processing unreferenced collections
15:47:40,328 DEBUG - Scheduling collection removes/(re)creates/updates
15:47:40,328 DEBUG - Flushed: 0 insertions, 0 updates, 0 deletions to 3 objects
15:47:40,328 DEBUG - Flushed: 0 (re)creations, 0 updates, 0 removals to 2 collections
15:47:40,328 DEBUG - listing entities:
15:47:40,328 DEBUG - com.landg.clex2.hibernate.Tia00569{valnClss=250W, lockNmbr=null, cntruwtgProdCtgy=null, productType=AM, tia00571s=uninitialized, maintUserId=pp10000, polStts=01, cntrId=UK52308103, incnMnth=null, incnYear=null, cntrbrodBsnsCtgy=null, schemeNumber=null, rsncInd= , expyYear= , sumAsrd=null}
15:47:40,344 DEBUG - com.landg.clex2.hibernate.Tia00570{persId=BBBBL8PY0, clmPackDespdInd=N, othContractInd= , occupationType= , tia00571s=uninitialized, maintUserId=pp10000, claimCaseStType=AA, manualInputInd=y, claimType=AA, claimCaseNumber=1022, salary=null, othMatCntrInd= , createTimestamp=17 December 2003 13:54:47, logonId=pp10000}
15:47:40,344 DEBUG - com.landg.clex2.hibernate.Tia00571{inceptionDate=null, purchReasonType=null, reassurBasisType=null, titleType=null, tia00573=null, maturityOptType=null, cntrSbtyp=null, legacyMktingName=null, indexationDate=null, claimAlreadyInd=null, createTimestamp=null, indexedInd=null, reinstatedInd=null, contractAge=null, frequencyType=null, premiumAmount=null, significntAltInd=null, procurMethodType=null, maintUserId=null, effectiveEndDate=null, reasonsForRating=null, occupationType=null, reinstatementDate=null, ddDetailPresInd=null, coverExclInd=null, comp_id=Tia00571PK{tia00569=Tia00569#UK52308103, tia00570=Tia00570#1022}, salesQuoteDate=null}
15:47:40,344 DEBUG - executing flush
15:47:40,344 DEBUG - post flush
15:47:40,344 DEBUG - transaction completion
15:47:40,344 DEBUG - re-enabling autocommit
15:47:40,344 DEBUG - closing session
15:47:40,344 DEBUG - disconnecting session
15:47:40,344 DEBUG - transaction completion
15:47:40,344 DEBUG - opened session
15:47:40,344 DEBUG - begin
15:47:40,344 DEBUG - current autocommit status:true
15:47:40,344 DEBUG - disabling autocommit
15:47:40,344 DEBUG - iterate: select count(*) from com.landg.clex2.hibernate.Tia00573 as tia00573
15:47:40,344 DEBUG - compiling query
15:47:40,359 DEBUG - flushing session
15:47:40,359 DEBUG - Flushing entities and processing referenced collections
15:47:40,359 DEBUG - Processing unreferenced collections
15:47:40,359 DEBUG - Scheduling collection removes/(re)creates/updates
15:47:40,359 DEBUG - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
15:47:40,359 DEBUG - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
15:47:40,359 DEBUG - Dont need to execute flush
15:47:40,359 DEBUG - HQL: select count(*) from com.landg.clex2.hibernate.Tia00573 as tia00573
15:47:40,359 DEBUG - SQL: select count(*) as x0_0_ from CLEX.TIA00573 tia005730_
15:47:40,359 DEBUG - about to open: 0 open PreparedStatements, 0 open ResultSets
15:47:40,359 DEBUG - select count(*) as x0_0_ from CLEX.TIA00573 tia005730_
15:47:40,359 DEBUG - preparing statement
15:47:40,359 DEBUG - retrieving next results
15:47:40,359 DEBUG - exhausted results
15:47:40,359 DEBUG - closing iterator
15:47:40,359 DEBUG - done closing: 0 open PreparedStatements, 0 open ResultSets
15:47:40,359 DEBUG - closing statement
15:47:40,359 DEBUG - returning current results
15:47:40,359 DEBUG - commit
15:47:40,359 DEBUG - flushing session
15:47:40,359 DEBUG - Flushing entities and processing referenced collections
15:47:40,359 DEBUG - Processing unreferenced collections
15:47:40,359 DEBUG - Scheduling collection removes/(re)creates/updates
15:47:40,359 DEBUG - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
15:47:40,359 DEBUG - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
15:47:40,359 DEBUG - executing flush
15:47:40,359 DEBUG - post flush
15:47:40,359 DEBUG - transaction completion
15:47:40,359 DEBUG - re-enabling autocommit
15:47:40,359 DEBUG - closing session
15:47:40,359 DEBUG - disconnecting session
15:47:40,359 DEBUG - transaction completion
15:47:40,391 DEBUG - running Session.finalize()
15:47:40,391 DEBUG - running Session.finalize()
The mappings are as follows:
Code:
<hibernate-mapping package="com.landg.clex2.hibernate">
<class name="Tia00569" table="TIA00569" schema="COMMON" proxy="Tia00569">
<id name="cntrId" type="java.lang.String" column="CNTR_ID">
<generator class="assigned" />
</id>
<property name="cntrbrodBsnsCtgy" type="java.lang.String" column="CNTRBROD_BSNS_CTGY" length="1" />
<!-- other properties removed for clarity -->
<property name="maintUserId" type="java.lang.String" column="MAINT_USER_ID" not-null="true" length="7" />
<!-- bi-directional one-to-many association to Tia00571 -->
<set name="tia00571s" lazy="true" inverse="true">
<key>
<column name="CNTR_ID" />
</key>
<one-to-many class="Tia00571" />
</set>
</class>
</hibernate-mapping>
<hibernate-mapping package="com.landg.clex2.hibernate">
<class name="Tia00570" table="TIA00570" schema="CLEX" proxy="Tia00570">
<id name="claimCaseNumber" type="java.lang.Integer" column="CLAIM_CASE_NUMBER">
<generator class="assigned" />
</id>
<property name="claimType" type="java.lang.String" column="CLAIM_TYPE" not-null="true" length="2" />
<!-- other properties removed for clarity -->
<property name="maintUserId" type="java.lang.String" column="MAINT_USER_ID" not-null="true" length="7" />
<!-- bi-directional one-to-many association to Tia00571 -->
<set name="tia00571s" lazy="true" inverse="true">
<key>
<column name="CLAIM_CASE_NUMBER" />
</key>
<one-to-many class="Tia00571" />
</set>
</class>
</hibernate-mapping>
<hibernate-mapping package="com.landg.clex2.hibernate">
<class name="Tia00571" table="TIA00571" schema="CLEX" proxy="Tia00571">
<composite-id name="comp_id" class="Tia00571PK">
<!-- bi-directional many-to-one association to Tia00570 -->
<key-many-to-one name="tia00570" class="Tia00570">
<column name="CLAIM_CASE_NUMBER" />
</key-many-to-one>
<!-- bi-directional many-to-one association to Tia00569 -->
<key-many-to-one name="tia00569" class="Tia00569">
<column name="CNTR_ID" />
</key-many-to-one>
</composite-id>
<property name="titleType" type="java.lang.String" column="TITLE_TYPE" length="1" />
<!-- other properties removed for clarity -->
<property name="maintUserId" type="java.lang.String" column="MAINT_USER_ID" not-null="true" length="7" />
<!-- bi-directional one-to-one association to Tia00573 -->
<one-to-one name="tia00573" class="Tia00573" outer-join="auto" />
</class>
</hibernate-mapping>
<hibernate-mapping package="com.landg.clex2.hibernate">
<class name="Tia00573" table="TIA00573" schema="CLEX" proxy="Tia00573">
<composite-id name="comp_id" class="Tia00573PK">
<!-- bi-directional one-to-one association to Tia00571 -->
<key-many-to-one name="tia00571" class="Tia00571">
<column name="CLAIM_CASE_NUMBER" />
<column name="CNTR_ID" />
</key-many-to-one>
</composite-id>
<property name="leadContractId" type="java.lang.String" column="LEAD_CONTRACT_ID" not-null="true" length="10" />
<!-- other properties removed for clarity -->
<property name="maintUserId" type="java.lang.String" column="MAINT_USER_ID" not-null="true" length="7" />
<!-- bi-directional one-to-one association to Tia00571 -->
<one-to-one name="tia00571" class="Tia00571" outer-join="auto" constrained="true" />
</class>
</hibernate-mapping>
Again, I appreciate you looking at this for me. I have been stumped for days now.
Best regards
Chris