We are trying to use hibernate to paginate results from a db2 database.
Retrieving the first page is no problem, however on the second/subsequent page, the following error is occurring.
Hibernate version:
3.1.3
Mapping documents:
AccidentType.hbm.xml
Code:
<?xml version="1.0" ?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="au.gov.wa.icwa.business.domain.AccidentType" table="ACCIDENT_TYPE" mutable="true" lazy="false">
<id name="accidentType" column="ACCIDENT_TYPE" >
<generator class="native"/>
</id>
<property name="keyword" column="KEYWORD" type="java.lang.String" not-null="true" />
<property name="version" column="VERSION" type="java.lang.String" />
<property name="narrative" column="NARRATIVE" type="java.lang.String" not-null="true" />
<property name="commonDesc" column="COMMON_DESC" type="java.lang.String" not-null="true" />
<property name="startDate" column="START_DATE" type="date" not-null="true" />
<property name="endDate" column="END_DATE" type="date" not-null="true" />
<property name="worksafeCode" column="WORKSAFE_CODE" not-null="false" />
</class>
</hibernate-mapping>
applicationContext.xml
Code:
<!-- DataSource Property-->
<bean id="employersIndemnityDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${database.jdbc.driver}" />
<property name="url" value="${database.url}" />
<property name="username" value="${database.username}" />
<property name="password" value="${database.password}" />
</bean>
<!-- Hibernate transaction manager -->
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<!-- Default properties for Hibernate -->
<bean id="defaultHibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.default_schema">DEVT</prop>
<!-- JDBC connection pool (use the built-in) -->
<prop key="connection.pool_size">2</prop>
<!-- SQL dialect -->
<prop key="hibernate.dialect">org.hibernate.dialect.${database.dialect}Dialect</prop>
<!-- Enable Hibernate's automatic session context management -->
<prop key="current_session_context_class">thread</prop>
<!-- Set the second-level cache -->
<prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
<!-- Echo all executed SQL to stdout -->
<prop key="hibernate.show_sql">true</prop>
<!-- Drop and re-create the database schema on startup -->
<!-- prop key="hibernate.hbm2ddl.auto">create</prop-->
<prop key="hibernate.cache.use_query_cache">true</prop>
<!-- Auto-close session -->
<prop key="hibernate.transaction.auto_close_session">true</prop>
<prop key="hibernate.transaction.flush_before_completion">true</prop>
</props>
</property>
</bean>
<!-- Hibernate Session Factories-->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingResources">
<list>
<value>/META-INF/hibernateMappings/AccidentType.hbm.xml</value>
<value>/META-INF/hibernateMappings/NameRelationship.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<ref local="defaultHibernateProperties" />
</property>
<property name="dataSource">
<ref bean="employersIndemnityDataSource" />
</property>
</bean>
Method Code:Code:
public List findAccidentTypes(String keyword,
Date claimAddedDate, PagingFilter thePagingFilter)
throws AccidentTypeNotFoundException,
ReadAccidentTypeErrorException {
try {
this.getHibernateTemplate().setAlwaysUseNewSession(true);
DetachedCriteria criteria = DetachedCriteria
.forClass(AccidentType.class);
// use keyword as criterion
if (keyword != null) {
SimpleExpression criterion = Property.forName("keyword").like(
keyword, MatchMode.START);
criterion.ignoreCase();
criteria.add(criterion);
}
// use date as criterion
if (claimAddedDate != null) {
SimpleExpression ltCriterion = Property.forName("startDate").lt(
claimAddedDate);
criteria.add(ltCriterion);
SimpleExpression gtCriterion = Property.forName("endDate").gt(claimAddedDate);
criteria.add(gtCriterion);
}
int start = (thePagingFilter.getPageNumber() - 1)
* thePagingFilter.getMaxResultsPerPage();
int numResults = thePagingFilter.getMaxResultsPerPage();
// Execute the query
HibernateTemplate template = this.getHibernateTemplate();
List resultList = template.findByCriteria(criteria, start,
numResults);
return resultList;
} catch (Exception e) {
throw new ReadAccidentTypeErrorException(e);
}
}
Full stack trace of any exception that occurs:
43375 [main] DEBUG org.hibernate.util.JDBCExceptionReporter - could not execute query [select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>?]
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00E7009A", type of resource: "100", and resource name: "TEMP DATABASE". SQLSTATE=57011
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:275)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:212)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:463)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:2114)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1600)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:961)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:951)
at au.gov.wa.icwa.business.employersindemnity.impl.integration.hibernate.AccidentTypeDaoImpl.findAccidentTypes(AccidentTypeDaoImpl.java:82)
at au.gov.wa.icwa.business.employersindemnity.impl.LookupServiceImpl.findAccidentTypes(LookupServiceImpl.java:1547)
at au.gov.wa.icwa.business.employersindemnity.test.impl.LookupServiceImplTest.findAccidentTypesTest(LookupServiceImplTest.java:1205)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
at java.lang.reflect.Method.invoke(Method.java:386)
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:436)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:311)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
43375 [main] DEBUG org.hibernate.util.JDBCExceptionReporter - could not execute query [select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>?]
Name and version of the database you are using:
Currently using DB2 Version 7.2.1
The generated SQL (show_sql=true):
Hibernate: select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>? fetch first 40 rows only
Debug level Hibernate log excerpt:
2328 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=?
2328 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=? for read only with rs
2328 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=? for read only with rs
2328 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=? for read only with rs
2328 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=? for read only with rs
2344 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=?
2344 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=?
2344 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=?
2344 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity au.gov.wa.icwa.business.domain.NameRelationship: select namerelati0_.NAME_NO1 as NAME1_1_0_, namerelati0_.NAME_NO2 as NAME2_1_0_, namerelati0_.RELATIONSHIP_TYPE as RELATION3_1_0_, namerelati0_.RELATION_DIRECTION as RELATION4_1_0_, namerelati0_.START_DATE as START5_1_0_, namerelati0_.END_DATE as END6_1_0_, namerelati0_.COMMENT as COMMENT1_0_ from DEVT.NAME_RELATIONSHIP namerelati0_ where namerelati0_.NAME_NO1=? and namerelati0_.NAME_NO2=?
2344 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2344 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2359 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - registered: 8a818fc10f7f5fe5010f7f5fe8380000 (unnamed)
2359 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - registered: 8a818fc10f7f5fe5010f7f5fe8380000 (unnamed)
2359 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2359 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2359 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiated session factory
2359 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiated session factory
2359 [main] INFO org.hibernate.cache.UpdateTimestampsCache - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
2359 [main] INFO org.hibernate.cache.UpdateTimestampsCache - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
2375 [main] INFO org.hibernate.cache.StandardQueryCache - starting query cache at region: org.hibernate.cache.StandardQueryCache
2375 [main] INFO org.hibernate.cache.StandardQueryCache - starting query cache at region: org.hibernate.cache.StandardQueryCache
2375 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Checking 0 named HQL queries
2375 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Checking 0 named HQL queries
2375 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Checking 0 named SQL queries
2375 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Checking 0 named SQL queries
12109 [main] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 4776235576066048
12109 [main] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 4776235576066048
12140 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
12140 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
12140 [main] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
12140 [main] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
12187 [main] DEBUG org.hibernate.SQL - select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>? fetch first 20 rows only
12187 [main] DEBUG org.hibernate.SQL - select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>? fetch first 20 rows only
Hibernate: select this_.ACCIDENT_TYPE as ACCIDENT1_0_0_, this_.KEYWORD as KEYWORD0_0_, this_.VERSION as VERSION0_0_, this_.NARRATIVE as NARRATIVE0_0_, this_.COMMON_DESC as COMMON5_0_0_, this_.START_DATE as START6_0_0_, this_.END_DATE as END7_0_0_, this_.WORKSAFE_CODE as WORKSAFE8_0_0_ from DEVT.ACCIDENT_TYPE this_ where lcase(this_.KEYWORD) like ? and this_.START_DATE<? and this_.END_DATE>? fetch first 20 rows only
12187 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
12187 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
12187 [main] DEBUG org.hibernate.type.StringType - binding '%' to parameter: 1
12187 [main] DEBUG org.hibernate.type.StringType - binding '%' to parameter: 1
12187 [main] DEBUG org.hibernate.type.DateType - binding '03 June 2003' to parameter: 2
12187 [main] DEBUG org.hibernate.type.DateType - binding '03 June 2003' to parameter: 2
12187 [main] DEBUG org.hibernate.type.DateType - binding '03 June 2003' to parameter: 3
12187 [main] DEBUG org.hibernate.type.DateType - binding '03 June 2003' to parameter: 3
12219 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
12219 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
12219 [main] DEBUG org.hibernate.loader.Loader - processing result set
12219 [main] DEBUG org.hibernate.loader.Loader - processing result set
12219 [main] DEBUG org.hibernate.loader.Loader - result set row: 0
12219 [main] DEBUG org.hibernate.loader.Loader - result set row: 0
12219 [main] DEBUG org.hibernate.type.IntegerType - returning '92' as column: ACCIDENT1_0_0_
12219 [main] DEBUG org.hibernate.type.IntegerType - returning '92' as column: ACCIDENT1_0_0_
12219 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#92]
12219 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#92]
12234 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#92]
12234 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#92]
12250 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#92]
12250 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#92]
12250 [main] DEBUG org.hibernate.type.StringType - returning 'ACCIDENT ' as column: KEYWORD0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'ACCIDENT ' as column: KEYWORD0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'Vehicle accident ' as column: NARRATIVE0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'Vehicle accident ' as column: NARRATIVE0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'Vehicle accident ' as column: COMMON5_0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'Vehicle accident ' as column: COMMON5_0_0_
12250 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12250 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12250 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12250 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12250 [main] DEBUG org.hibernate.type.IntegerType - returning '92' as column: WORKSAFE8_0_0_
12250 [main] DEBUG org.hibernate.type.IntegerType - returning '92' as column: WORKSAFE8_0_0_
12250 [main] DEBUG org.hibernate.loader.Loader - result set row: 1
12250 [main] DEBUG org.hibernate.loader.Loader - result set row: 1
12250 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: ACCIDENT1_0_0_
12250 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: ACCIDENT1_0_0_
12250 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#62]
12250 [main] DEBUG org.hibernate.type.StringType - returning 'ALLERGIC ' as column: KEYWORD0_0_
12250 [main] DEBUG org.hibernate.type.StringType - returning 'ALLERGIC ' as column: KEYWORD0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning '5' as column: VERSION0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning '5' as column: VERSION0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Long term contact with chemicals or substance' as column: NARRATIVE0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Long term contact with chemicals or substance' as column: NARRATIVE0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Long term contact with chemicals or substance' as column: COMMON5_0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Long term contact with chemicals or substance' as column: COMMON5_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: WORKSAFE8_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: WORKSAFE8_0_0_
12266 [main] DEBUG org.hibernate.loader.Loader - result set row: 2
12266 [main] DEBUG org.hibernate.loader.Loader - result set row: 2
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: ACCIDENT1_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: ACCIDENT1_0_0_
12266 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#22]
12266 [main] DEBUG org.hibernate.type.StringType - returning 'ANIMAL ' as column: KEYWORD0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'ANIMAL ' as column: KEYWORD0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Being bitten by an animal ' as column: NARRATIVE0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Being bitten by an animal ' as column: NARRATIVE0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Being bitten by an animal ' as column: COMMON5_0_0_
12266 [main] DEBUG org.hibernate.type.StringType - returning 'Being bitten by an animal ' as column: COMMON5_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12266 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: WORKSAFE8_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: WORKSAFE8_0_0_
12266 [main] DEBUG org.hibernate.loader.Loader - result set row: 3
12266 [main] DEBUG org.hibernate.loader.Loader - result set row: 3
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '23' as column: ACCIDENT1_0_0_
12266 [main] DEBUG org.hibernate.type.IntegerType - returning '23' as column: ACCIDENT1_0_0_
12266 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#23]
12266 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#23]
12281 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#23]
12281 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#23]
12281 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#23]
12281 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#23]
12281 [main] DEBUG org.hibernate.type.StringType - returning 'ANIMAL ' as column: KEYWORD0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'ANIMAL ' as column: KEYWORD0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'Being hit by an animal ' as column: NARRATIVE0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'Being hit by an animal ' as column: NARRATIVE0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'Being hit by an animal ' as column: COMMON5_0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'Being hit by an animal ' as column: COMMON5_0_0_
12281 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12281 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12281 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12281 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12281 [main] DEBUG org.hibernate.type.IntegerType - returning '23' as column: WORKSAFE8_0_0_
12281 [main] DEBUG org.hibernate.type.IntegerType - returning '23' as column: WORKSAFE8_0_0_
12281 [main] DEBUG org.hibernate.loader.Loader - result set row: 4
12281 [main] DEBUG org.hibernate.loader.Loader - result set row: 4
12281 [main] DEBUG org.hibernate.type.IntegerType - returning '26' as column: ACCIDENT1_0_0_
12281 [main] DEBUG org.hibernate.type.IntegerType - returning '26' as column: ACCIDENT1_0_0_
12281 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#26]
12281 [main] DEBUG org.hibernate.type.StringType - returning 'BETWEEN ' as column: KEYWORD0_0_
12281 [main] DEBUG org.hibernate.type.StringType - returning 'BETWEEN ' as column: KEYWORD0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Being trapped between stationary & moving obj' as column: NARRATIVE0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Being trapped between stationary & moving obj' as column: NARRATIVE0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Being trapped between stationary & moving obj' as column: COMMON5_0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Being trapped between stationary & moving obj' as column: COMMON5_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '26' as column: WORKSAFE8_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '26' as column: WORKSAFE8_0_0_
12297 [main] DEBUG org.hibernate.loader.Loader - result set row: 5
12297 [main] DEBUG org.hibernate.loader.Loader - result set row: 5
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '71' as column: ACCIDENT1_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '71' as column: ACCIDENT1_0_0_
12297 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#71]
12297 [main] DEBUG org.hibernate.type.StringType - returning 'BIOLOGICAL ' as column: KEYWORD0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'BIOLOGICAL ' as column: KEYWORD0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '3' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '3' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with, exposure to biological factors ' as column: NARRATIVE0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with, exposure to biological factors ' as column: NARRATIVE0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with, exposure to biological factors ' as column: COMMON5_0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with, exposure to biological factors ' as column: COMMON5_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12297 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '71' as column: WORKSAFE8_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '71' as column: WORKSAFE8_0_0_
12297 [main] DEBUG org.hibernate.loader.Loader - result set row: 6
12297 [main] DEBUG org.hibernate.loader.Loader - result set row: 6
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '63' as column: ACCIDENT1_0_0_
12297 [main] DEBUG org.hibernate.type.IntegerType - returning '63' as column: ACCIDENT1_0_0_
12297 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#63]
12297 [main] DEBUG org.hibernate.type.StringType - returning 'BITES ' as column: KEYWORD0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'BITES ' as column: KEYWORD0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Insect and spider bites and stings ' as column: NARRATIVE0_0_
12297 [main] DEBUG org.hibernate.type.StringType - returning 'Insect and spider bites and stings ' as column: NARRATIVE0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning 'Insect and spider bites and stings ' as column: COMMON5_0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning 'Insect and spider bites and stings ' as column: COMMON5_0_0_
12312 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12312 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12312 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12312 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '63' as column: WORKSAFE8_0_0_
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '63' as column: WORKSAFE8_0_0_
12312 [main] DEBUG org.hibernate.loader.Loader - result set row: 7
12312 [main] DEBUG org.hibernate.loader.Loader - result set row: 7
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: ACCIDENT1_0_0_
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '22' as column: ACCIDENT1_0_0_
12312 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#22]
12312 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#22]
12312 [main] DEBUG org.hibernate.loader.Loader - result set row: 8
12312 [main] DEBUG org.hibernate.loader.Loader - result set row: 8
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '41' as column: ACCIDENT1_0_0_
12312 [main] DEBUG org.hibernate.type.IntegerType - returning '41' as column: ACCIDENT1_0_0_
12312 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#41]
12312 [main] DEBUG org.hibernate.type.StringType - returning 'CARRYING ' as column: KEYWORD0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning 'CARRYING ' as column: KEYWORD0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning '4' as column: VERSION0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning '4' as column: VERSION0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning 'Muscular stress-lift,carry,putdownobjects ' as column: NARRATIVE0_0_
12312 [main] DEBUG org.hibernate.type.StringType - returning 'Muscular stress-lift,carry,putdownobjects ' as column: NARRATIVE0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Muscular stress-lift,carry,putdownobjects ' as column: COMMON5_0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Muscular stress-lift,carry,putdownobjects ' as column: COMMON5_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12328 [main] DEBUG org.hibernate.type.IntegerType - returning '41' as column: WORKSAFE8_0_0_
12328 [main] DEBUG org.hibernate.type.IntegerType - returning '41' as column: WORKSAFE8_0_0_
12328 [main] DEBUG org.hibernate.loader.Loader - result set row: 9
12328 [main] DEBUG org.hibernate.loader.Loader - result set row: 9
12328 [main] DEBUG org.hibernate.type.IntegerType - returning '91' as column: ACCIDENT1_0_0_
12328 [main] DEBUG org.hibernate.type.IntegerType - returning '91' as column: ACCIDENT1_0_0_
12328 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#91]
12328 [main] DEBUG org.hibernate.type.StringType - returning 'CAVE-IN ' as column: KEYWORD0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'CAVE-IN ' as column: KEYWORD0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Slide or cave-in ' as column: NARRATIVE0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Slide or cave-in ' as column: NARRATIVE0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Slide or cave-in ' as column: COMMON5_0_0_
12328 [main] DEBUG org.hibernate.type.StringType - returning 'Slide or cave-in ' as column: COMMON5_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12328 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '91' as column: WORKSAFE8_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '91' as column: WORKSAFE8_0_0_
12344 [main] DEBUG org.hibernate.loader.Loader - result set row: 10
12344 [main] DEBUG org.hibernate.loader.Loader - result set row: 10
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '13' as column: ACCIDENT1_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '13' as column: ACCIDENT1_0_0_
12344 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#13]
12344 [main] DEBUG org.hibernate.type.StringType - returning 'CHAFING ' as column: KEYWORD0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'CHAFING ' as column: KEYWORD0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Rubbing and chafing ' as column: NARRATIVE0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Rubbing and chafing ' as column: NARRATIVE0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Rubbing and chafing ' as column: COMMON5_0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Rubbing and chafing ' as column: COMMON5_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12344 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '13' as column: WORKSAFE8_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '13' as column: WORKSAFE8_0_0_
12344 [main] DEBUG org.hibernate.loader.Loader - result set row: 11
12344 [main] DEBUG org.hibernate.loader.Loader - result set row: 11
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '61' as column: ACCIDENT1_0_0_
12344 [main] DEBUG org.hibernate.type.IntegerType - returning '61' as column: ACCIDENT1_0_0_
12344 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#61]
12344 [main] DEBUG org.hibernate.type.StringType - returning 'CHEMICAL ' as column: KEYWORD0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'CHEMICAL ' as column: KEYWORD0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Single contact with chemical or substance ' as column: NARRATIVE0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Single contact with chemical or substance ' as column: NARRATIVE0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Single contact with chemical or substance ' as column: COMMON5_0_0_
12344 [main] DEBUG org.hibernate.type.StringType - returning 'Single contact with chemical or substance ' as column: COMMON5_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '61' as column: WORKSAFE8_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '61' as column: WORKSAFE8_0_0_
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 12
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 12
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '69' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '69' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#69]
12359 [main] DEBUG org.hibernate.type.StringType - returning 'CHEMICAL ' as column: KEYWORD0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'CHEMICAL ' as column: KEYWORD0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning '3' as column: VERSION0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning '3' as column: VERSION0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Other & unspecified contact with chem or sub ' as column: NARRATIVE0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Other & unspecified contact with chem or sub ' as column: NARRATIVE0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Other & unspecified contact with chem or sub ' as column: COMMON5_0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Other & unspecified contact with chem or sub ' as column: COMMON5_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12359 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '69' as column: WORKSAFE8_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '69' as column: WORKSAFE8_0_0_
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 13
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 13
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '62' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#62]
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#62]
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 14
12359 [main] DEBUG org.hibernate.loader.Loader - result set row: 14
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: ACCIDENT1_0_0_
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#52]
12359 [main] DEBUG org.hibernate.type.StringType - returning 'COLD ' as column: KEYWORD0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'COLD ' as column: KEYWORD0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning '1' as column: VERSION0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with cold objects ' as column: NARRATIVE0_0_
12359 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with cold objects ' as column: NARRATIVE0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with cold objects ' as column: COMMON5_0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with cold objects ' as column: COMMON5_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: WORKSAFE8_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: WORKSAFE8_0_0_
12375 [main] DEBUG org.hibernate.loader.Loader - result set row: 15
12375 [main] DEBUG org.hibernate.loader.Loader - result set row: 15
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '54' as column: ACCIDENT1_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '54' as column: ACCIDENT1_0_0_
12375 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#54]
12375 [main] DEBUG org.hibernate.type.StringType - returning 'COLD ' as column: KEYWORD0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'COLD ' as column: KEYWORD0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning '2' as column: VERSION0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Exposure to environmental cold ' as column: NARRATIVE0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Exposure to environmental cold ' as column: NARRATIVE0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Exposure to environmental cold ' as column: COMMON5_0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Exposure to environmental cold ' as column: COMMON5_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12375 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '54' as column: WORKSAFE8_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '54' as column: WORKSAFE8_0_0_
12375 [main] DEBUG org.hibernate.loader.Loader - result set row: 16
12375 [main] DEBUG org.hibernate.loader.Loader - result set row: 16
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '51' as column: ACCIDENT1_0_0_
12375 [main] DEBUG org.hibernate.type.IntegerType - returning '51' as column: ACCIDENT1_0_0_
12375 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#51]
12375 [main] DEBUG org.hibernate.type.StringType - returning 'CONTACT ' as column: KEYWORD0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'CONTACT ' as column: KEYWORD0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning ' ' as column: VERSION0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning ' ' as column: VERSION0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with hot objects ' as column: NARRATIVE0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with hot objects ' as column: NARRATIVE0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with hot objects ' as column: COMMON5_0_0_
12375 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with hot objects ' as column: COMMON5_0_0_
12390 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12390 [main] DEBUG org.hibernate.type.DateType - returning '01 July 1991' as column: START6_0_0_
12390 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12390 [main] DEBUG org.hibernate.type.DateType - returning '31 December 9999' as column: END7_0_0_
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '51' as column: WORKSAFE8_0_0_
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '51' as column: WORKSAFE8_0_0_
12390 [main] DEBUG org.hibernate.loader.Loader - result set row: 17
12390 [main] DEBUG org.hibernate.loader.Loader - result set row: 17
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: ACCIDENT1_0_0_
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '52' as column: ACCIDENT1_0_0_
12390 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#52]
12390 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#52]
12390 [main] DEBUG org.hibernate.loader.Loader - result set row: 18
12390 [main] DEBUG org.hibernate.loader.Loader - result set row: 18
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '57' as column: ACCIDENT1_0_0_
12390 [main] DEBUG org.hibernate.type.IntegerType - returning '57' as column: ACCIDENT1_0_0_
12390 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.loader.Loader - result row: EntityKey[au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.loader.Loader - Initializing object from ResultSet: [au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Hydrating entity: [au.gov.wa.icwa.business.domain.AccidentType#57]
12390 [main] DEBUG org.hibernate.type.StringType - returning 'CONTACT ' as column: KEYWORD0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning 'CONTACT ' as column: KEYWORD0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning ' ' as column: VERSION0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning ' ' as column: VERSION0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with electricity ' as column: NARRATIVE0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with electricity ' as column: NARRATIVE0_0_
12390 [main] DEBUG org.hibernate.type.StringType - returning 'Contact with electricity ' as column: COMMON5_0_0_
12390 [main] DEBUG org.hibernate.type.Str