Hi
Having some problems with a LazyInitializationException on collections when mapping using an outer join. In the configuration
file below, if I set outer-join="true" I get the error outlined below. If I set outer-join="false" however the error goes away.
I found a post about this error a little earlier on in this forum but it ended a little abruptly and without an answer.
Any help much appreciated
Thanks
Tim
######################################################################################################################
Version Details
######################################################################################################################
Hibernate 3.0.5
Oracle 8
######################################################################################################################
The stack Trace
######################################################################################################################
org.springframework.orm.hibernate3.HibernateSystemException: illegal access to loading collection; nested exception is org.hibernate.LazyInitializationException: illegal access to loading collection
org.hibernate.LazyInitializationException: illegal access to loading collection
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:172)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:48)
at org.hibernate.collection.PersistentSet.hashCode(PersistentSet.java:324)
at org.apache.commons.lang.builder.HashCodeBuilder.append(HashCodeBuilder.java:392)
at au.gov.wa.dpi.trelis.licence.Restrictions.hashCode(Restrictions.java:86)
at org.apache.commons.lang.builder.HashCodeBuilder.append(HashCodeBuilder.java:392)
at au.gov.wa.dpi.trelis.licence.LicenceClass.hashCode(LicenceClass.java:154)
at java.util.HashMap.hash(HashMap.java:261)
at java.util.HashMap.put(HashMap.java:379)
at java.util.HashSet.add(HashSet.java:192)
at java.util.AbstractCollection.addAll(AbstractCollection.java:319)
at org.hibernate.collection.PersistentSet.endRead(PersistentSet.java:242)
at org.hibernate.engine.CollectionLoadContext.endLoadingCollection(CollectionLoadContext.java:183)
at org.hibernate.engine.CollectionLoadContext.endLoadingCollections(CollectionLoadContext.java:268)
at org.hibernate.engine.CollectionLoadContext.endLoadingCollections(CollectionLoadContext.java:249)
at org.hibernate.loader.Loader.endCollectionLoad(Loader.java:554)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:541)
at org.hibernate.loader.Loader.doQuery(Loader.java:436)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1345)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2471)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:351)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:332)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:151)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:621)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:614)
at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:389)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:383)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:378)
at au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryImpl.getLicence(LicenceRepositoryImpl.java:87)
at au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryUtils$1.transform(LicenceRepositoryUtils.java:35)
at org.apache.commons.collections.CollectionUtils.transform(CollectionUtils.java:431)
at au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryUtils.getLicences(LicenceRepositoryUtils.java:33)
at au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryTest.testFindByLicenceNumber(LicenceRepositoryTest.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
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:421)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
######################################################################################################################
Hibernate Mapping
######################################################################################################################
<?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 package="au.gov.wa.dpi.trelis.licence" default-lazy="false">
<!-- Licence Class Definition -->
<class name="LicenceClass" table="MDL_LICENCE_ENTITLEMENTS" optimistic-lock="version">
<!-- The primary key -->
<id name="objectIdentifier" type="java.lang.Long" column="MDLLE_ROID">
<generator class="native">
<param name="sequence">ROID_SEQUENCE</param>
</generator>
</id>
<!-- The opt lock version field -->
<version name="objectUpdateLevel" type="java.lang.Long" column="UPDATE_LEVEL"/>
<!-- Simple properties -->
<property name="classCode" type="java.lang.String" column="MDL_ENTITLEMENT_CODE"/>
<property name="issueDate" type="java.util.Date" column="ISSUE_DATE"/>
<property name="transferIssueDate" type="java.util.Date" column="TRANSFER_ISSUE_DATE"/>
<component name="restrictions" class="au.gov.wa.dpi.trelis.licence.Restrictions" unique="true">
<component name="nationalRestriction1" class="au.gov.wa.dpi.trelis.licence.NationalRestriction" unique="true">
<property name="conditionCode" type="string" column="MDL_CONDITION_CODE1"/>
</component>
<component name="nationalRestriction2" class="au.gov.wa.dpi.trelis.licence.NationalRestriction" unique="true">
<property name="conditionCode" type="string" column="MDL_CONDITION_CODE2"/>
</component>
<!-- Can't use outer-join option here as it causes a LazyInitializationException! -->
<set name="stateRestrictions" lazy="false" outer-join="true">
<key column="MDLLE_ROID" not-null="true"/>
<one-to-many class="StateRestriction"/>
</set>
</component>
</class>
</hibernate-mapping>
######################################################################################################################
Spring Configuration
######################################################################################################################
<?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 package="au.gov.wa.dpi.trelis.licence" default-lazy="false">
<!-- Licence Class Definition -->
<class name="Licence" table="MDL_LICENCES" optimistic-lock="version">
<!-- The primary key -->
<id name="objectIdentifier" type="java.lang.Long" column="MDLL_ROID">
<generator class="native">
<param name="sequence">ROID_SEQUENCE</param>
</generator>
</id>
<!-- inheritance disciminator -->
<discriminator column="MDL_LICENCE_TYPE" type="string"/>
<!-- The opt lock version field -->
<version name="objectUpdateLevel" type="java.lang.Long" column="UPDATE_LEVEL"/>
<!-- Simple properties -->
<property name="statusCode" column="MDL_STATUS_CODE">
<type name="au.gov.wa.dpi.trelis.EnumeratedUserType">
<param name="enumClass">au.gov.wa.dpi.trelis.licence.LicenceStatusCode</param>
</type>
</property>
<property name="expiryDate" type="java.util.Date" column="EXPIRY_DATE"/>
<property name="issueDate" type="java.util.Date" column="ISSUE_DATE"/>
<property name="statusReasonCode" type="java.lang.String" column="MDL_STATUS_REASON_CODE"/>
<property name="certifiedCopyCount" type="java.lang.Integer" column="CERTIFIED_COPY_COUNT"/>
<property name="duplicateCopyCount" type="java.lang.Integer" column="DUP_LICENCE_COUNT"/>
<property name="cardRequestType" type="java.lang.String" column="MDL_CARD_REQUEST_TYPE_CODE"/>
<property name="cardRequestDate" type="java.util.Date" column="CARD_REQUEST_DATE"/>
<component name="card" class="Card">
<property name="productionDate" type="date" column="PRODUCTION_DATE"/>
<property name="productionStatus" type="string" column="PRODUCTION_STATUS_CODE"/>
<property name="cardType" column="MDL_CARD_TYPE_CODE">
<type name="au.gov.wa.dpi.trelis.EnumeratedUserType">
<param name="enumClass">au.gov.wa.dpi.trelis.licence.LicenceCardType</param>
</type>
</property>
</component>
<many-to-one name="driver" column="MDLCD_ROID" not-null="true"/>
<set name="licenceConditions" outer-join="true" lazy="false">
<key column="MDLL_ROID" not-null="true"/>
<one-to-many class="LicenceCondition"/>
</set>
<set name="licenceClasses" outer-join="true" lazy="false">
<key column="MDLL_ROID" not-null="true"/>
<one-to-many class="LicenceClass"/>
</set>
<!-- STILL TO GO ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
private Set licenceClasses;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- subclasses -->
<subclass name="OrdinaryLicence" discriminator-value="O">
</subclass>
<subclass name="InstructorLicence" discriminator-value="I">
</subclass>
<subclass name="LearnersPermit" discriminator-value="L">
</subclass>
<subclass name="ExtraordinaryLicence" discriminator-value="E">
</subclass>
<subclass name="ProbationaryLicence" discriminator-value="P">
<property name="provisionalExpiryDate" column="PREV_EXPIRY_DATE"/>
</subclass>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<!-- The datasource - straight JDBC -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>*****************************</value>
</property>
<property name="username">
<value>***************************** </value>
</property>
<property name="password">
<value>*****************************</value>
</property>
</bean>
<!-- Hibernate session factory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingResources">
<list>
<value>au/gov/wa/dpi/trelis/licence/Licence.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/LicenceCondition.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/LicenceClass.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/StateRestriction.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/driver/Driver.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/driver/DriverCondition.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/driver/Offence.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/licence/Photograph.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/client/ClientSummary.hbm.xml</value>
<value>au/gov/wa/dpi/trelis/client/AddressSummary.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
</props>
</property>
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
<!-- Transaction manager - Spring managed -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
<!-- configure the DAOs -->
<bean id="au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryImpl" class="au.gov.wa.dpi.trelis.licence.repository.LicenceRepositoryImpl">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
</beans>
######################################################################################################################
Code Snippets
######################################################################################################################
TEST METHOD THAT IS FAILING...
public void testFindByLicenceNumber(){
Licence l = getLicence(1234);
LicenceRepositoryImpl.getInstance().findByLicenceNumber(l.getDriver().getLicenceNumber());
}
SNIPPETS FROM DAO CLASS...
public class LicenceRepositoryImpl extends HibernateDaoSupport implements LicenceRepository{
public Licence findByLicenceNumber(Long licenceNumber) {
List list = getHibernateTemplate().find("from Licence as lic where lic.driver.licenceNumber = ? ", new Object[]{licenceNumber});
if (list.size()==0){
return null;
}
return (Licence)list.get(0);
}
public Licence getLicence(Long objectIdentifier){
return (Licence)getHibernateTemplate().get(Licence.class, objectIdentifier);
}
protected void initDao() throws Exception {
super.initDao();
getHibernateTemplate().setAlwaysUseNewSession(true);
}
}
######################################################################################################################
The Logs
######################################################################################################################
log4j:ERROR Parsing error on line 23 and column 23
log4j:ERROR The content of element type "log4j:configuration" must match "(renderer*,appender*,(category|logger)*,root?,categoryFactory?)".
INFO [main] xml.XmlBeanDefinitionReader (XmlBeanDefinitionReader.java:132) - Loading XML bean definitions from class path resource [persistence-settings.xml]
INFO [main] support.AbstractBeanFactory (AbstractBeanFactory.java:219) - Creating shared instance of singleton bean 'transactionManager'
INFO [main] support.AbstractBeanFactory (AbstractBeanFactory.java:219) - Creating shared instance of singleton bean 'dataSource'
INFO [main] datasource.JdbcTransactionObjectSupport (JdbcTransactionObjectSupport.java:60) - JDBC 3.0 Savepoint class is available
Starting
org.apache.commons.logging.impl.Log4JLogger@2bd3a
false
INFO [main] support.AbstractBeanFactory (AbstractBeanFactory.java:219) - Creating shared instance of singleton bean 'sessionFactory'
INFO [main] cfg.Environment (Environment.java:464) - Hibernate 3.0.5
INFO [main] cfg.Environment (Environment.java:477) - hibernate.properties not found
INFO [main] cfg.Environment (Environment.java:510) - using CGLIB reflection optimizer
INFO [main] cfg.Environment (Environment.java:540) - using JDK 1.4 java.sql.Timestamp handling
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.Licence -> MDL_LICENCES
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLL_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: statusCode -> MDL_STATUS_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: expiryDate -> EXPIRY_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: statusReasonCode -> MDL_STATUS_REASON_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: certifiedCopyCount -> CERTIFIED_COPY_COUNT
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: duplicateCopyCount -> DUP_LICENCE_COUNT
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: cardRequestType -> MDL_CARD_REQUEST_TYPE_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: cardRequestDate -> CARD_REQUEST_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: productionDate -> PRODUCTION_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: productionStatus -> PRODUCTION_STATUS_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: cardType -> MDL_CARD_TYPE_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: card -> PRODUCTION_DATE, PRODUCTION_STATUS_CODE, MDL_CARD_TYPE_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: driver -> MDLCD_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: licenceConditions
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: licenceClasses
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.licence.OrdinaryLicence -> MDL_LICENCES
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.licence.InstructorLicence -> MDL_LICENCES
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.licence.LearnersPermit -> MDL_LICENCES
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.licence.ExtraordinaryLicence -> MDL_LICENCES
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.licence.ProbationaryLicence -> MDL_LICENCES
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: provisionalExpiryDate -> PREV_EXPIRY_DATE
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.LicenceCondition -> MDL_LICENCE_CONDITIONS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLLC_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: conditionCode -> MDL_CONDITION_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: expiryDate -> EXPIRY_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> ISSUE_DATE
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.LicenceClass -> MDL_LICENCE_ENTITLEMENTS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLLE_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: classCode -> MDL_ENTITLEMENT_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: transferIssueDate -> TRANSFER_ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: conditionCode -> MDL_CONDITION_CODE1
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: nationalRestriction1 -> MDL_CONDITION_CODE1
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: conditionCode -> MDL_CONDITION_CODE2
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: nationalRestriction2 -> MDL_CONDITION_CODE2
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: stateRestrictions
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: restrictions -> MDL_CONDITION_CODE1, MDL_CONDITION_CODE2
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.StateRestriction -> MDL_LICENCE_CLASS_RESTRICTIONS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLLCR_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: conditionCode -> MDL_CONDITION_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: expiryDate -> ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> EXPIRY_DATE
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.driver.Driver -> MDL_CLIENT_DETAILS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLCD_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: licenceNumber -> MDL_NUMBER
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: demeritPoints -> DEMERIT_POINTS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: nextDrivingTestDate -> NEXT_DRIVING_TEST_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: nextMedicalTestDate -> NEXT_MED_CERT_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: driverConditions
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: offences
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: personSummary -> C_ROID
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.driver.DriverCondition -> MDL_CLIENT_CONDITIONS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLCCON_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: conditionCode -> MDL_CONDITION_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: expiryDate -> EXPIRY_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: dueDate -> EFFECTIVE_DATE
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.driver.Offence -> MDL_OFFENCES
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> MDLO_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: infingementCode -> VEH_INFRINGEMENT_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: issueDate -> ISSUE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: offenceDate -> OFFENCE_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: statusCode -> MDL_OFFENCE_STATUS_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: demeritPoints -> DEMERIT_POINTS
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.licence.Photograph -> CLI_PHOTOS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> CLIP_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: portraitDate -> PORTRAIT_PHOTO_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: signatureDate -> SIGNATURE_PHOTO_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: signatureStatus -> SIGNATURE_FLAG
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: portraitStatus -> PORTRAIT_IND
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: qualityRejectReversal -> QUALITY_REJECT_REVERSAL_FLAG
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: refusalRejectReversal -> REFUSAL_REJECT_REVERSAL_FLAG
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.client.ClientSummary -> CLI_CLIENTS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> C_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectUpdateLevel -> UPDATE_LEVEL
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: postalAddress -> C_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: residentialAddress -> C_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: clientType -> CLIENT_TYPE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: statusCode -> CLIENT_STATUS
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.client.OrganisationSummary -> CLI_CLIENTS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: organisationName -> ORGANISATION_NAME
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.client.PersonSummary -> CLI_CLIENTS
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: surname -> SURNAME
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: firstGivenName -> FIRST_GIVEN_NAME
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: subsequentGivenNames -> SUBSEQUENT_GIVEN_NAMES
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: birthDate -> BIRTH_DATE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: deathDate -> DEATH_DATE
INFO [main] cfg.HbmBinder (HbmBinder.java:737) - Mapping subclass: au.gov.wa.dpi.trelis.client.TradingEntitySummary -> CLI_CLIENTS
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:42) - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
DEBUG [main] util.DTDEntityResolver (DTDEntityResolver.java:53) - found
http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
INFO [main] cfg.HbmBinder (HbmBinder.java:260) - Mapping class: au.gov.wa.dpi.trelis.client.AddressSummary -> CLI_ADDRESSES
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: objectIdentifier -> A_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: addressLine1 -> UNSTRUCTURED_ADDRESS_1
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: addressLine2 -> UNSTRUCTURED_ADDRESS_2
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: suburb -> SUBURB_LOCALITY
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: stateCode -> STATE_TERRITORY_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: postcode -> POSTCODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: countryCode -> COUNTRY_CODE
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: clientId -> C_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: toDate -> TO_DATETIME
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: fromDate -> FROM_DATETIME
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: dealingId -> D_ROID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: dpid -> DPID
DEBUG [main] cfg.HbmBinder (HbmBinder.java:1099) - Mapped property: type -> ADDRESS_TYPE_CODE
INFO [main] hibernate3.LocalSessionFactoryBean (LocalSessionFactoryBean.java:671) - Building new Hibernate SessionFactory
DEBUG [main] cfg.Configuration (Configuration.java:998) - Preparing to build session factory with filters : {}
INFO [main] cfg.Configuration (Configuration.java:875) - processing extends queue
INFO [main] cfg.Configuration (Configuration.java:879) - processing collection mappings
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2466) - Second pass for collection: au.gov.wa.dpi.trelis.licence.Licence.licenceConditions
INFO [main] cfg.HbmBinder (HbmBinder.java:2041) - Mapping collection: au.gov.wa.dpi.trelis.licence.Licence.licenceConditions -> MDL_LICENCE_CONDITIONS
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2482) - Mapped collection key: MDLL_ROID, one-to-many: au.gov.wa.dpi.trelis.licence.LicenceCondition
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2466) - Second pass for collection: au.gov.wa.dpi.trelis.licence.Licence.licenceClasses
INFO [main] cfg.HbmBinder (HbmBinder.java:2041) - Mapping collection: au.gov.wa.dpi.trelis.licence.Licence.licenceClasses -> MDL_LICENCE_ENTITLEMENTS
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2482) - Mapped collection key: MDLL_ROID, one-to-many: au.gov.wa.dpi.trelis.licence.LicenceClass
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2466) - Second pass for collection: au.gov.wa.dpi.trelis.licence.LicenceClass.au.gov.wa.dpi.trelis.licence.LicenceClass.restrictions.stateRestrictions
INFO [main] cfg.HbmBinder (HbmBinder.java:2041) - Mapping collection: au.gov.wa.dpi.trelis.licence.LicenceClass.au.gov.wa.dpi.trelis.licence.LicenceClass.restrictions.stateRestrictions -> MDL_LICENCE_CLASS_RESTRICTIONS
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2482) - Mapped collection key: MDLLE_ROID, one-to-many: au.gov.wa.dpi.trelis.licence.StateRestriction
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2466) - Second pass for collection: au.gov.wa.dpi.trelis.licence.driver.Driver.driverConditions
INFO [main] cfg.HbmBinder (HbmBinder.java:2041) - Mapping collection: au.gov.wa.dpi.trelis.licence.driver.Driver.driverConditions -> MDL_CLIENT_CONDITIONS
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2482) - Mapped collection key: MDLCD_ROID, one-to-many: au.gov.wa.dpi.trelis.licence.driver.DriverCondition
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2466) - Second pass for collection: au.gov.wa.dpi.trelis.licence.driver.Driver.offences
INFO [main] cfg.HbmBinder (HbmBinder.java:2041) - Mapping collection: au.gov.wa.dpi.trelis.licence.driver.Driver.offences -> MDL_OFFENCES
DEBUG [main] cfg.HbmBinder$SecondPass (HbmBinder.java:2482) - Mapped collection key: MDLCD_ROID, one-to-many: au.gov.wa.dpi.trelis.licence.driver.Offence
INFO [main] cfg.Configuration (Configuration.java:888) - processing association property references
INFO [main] cfg.Configuration (Configuration.java:917) - processing foreign key constraints
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.driver.Driver
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.client.ClientSummary
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.driver.Driver
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.LicenceClass
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.Licence
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.Licence
DEBUG [main] cfg.Configuration (Configuration.java:964) - resolving reference to class: au.gov.wa.dpi.trelis.licence.driver.Driver
INFO [main] connection.ConnectionProviderFactory (ConnectionProviderFactory.java:53) - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
DEBUG [main] cfg.SettingsFactory (SettingsFactory.java:295) - could not get database version from JDBC metadata
INFO [main] cfg.SettingsFactory (SettingsFactory.java:77) - RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
INFO [main] cfg.SettingsFactory (SettingsFactory.java:78) - JDBC driver: Oracle JDBC driver, version: 9.2.0.3.0
INFO [main] dialect.Dialect (Dialect.java:92) - Using dialect: org.hibernate.dialect.Oracle9Dialect
INFO [main] transaction.TransactionFactoryFactory (TransactionFactoryFactory.java:31) - Using default transaction strategy (direct JDBC transactions)
INFO [main] transaction.TransactionManagerLookupFactory (TransactionManagerLookupFactory.java:33) - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
INFO [main] cfg.SettingsFactory (SettingsFactory.java:125) - Automatic flush during beforeCompletion(): disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:129) - Automatic session close at end of transaction: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:136) - JDBC batch size: 15
INFO [main] cfg.SettingsFactory (SettingsFactory.java:139) - JDBC batch updates for versioned data: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:144) - Scrollable result sets: enabled
DEBUG [main] cfg.SettingsFactory (SettingsFactory.java:148) - Wrap result sets: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:152) - JDBC3 getGeneratedKeys(): disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:160) - Connection release mode: null
INFO [main] cfg.SettingsFactory (SettingsFactory.java:187) - Default batch fetch size: 1
INFO [main] cfg.SettingsFactory (SettingsFactory.java:191) - Generate SQL with comments: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:195) - Order SQL updates by primary key: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:334) - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO [main] ast.ASTQueryTranslatorFactory (ASTQueryTranslatorFactory.java:21) - Using ASTQueryTranslatorFactory
INFO [main] cfg.SettingsFactory (SettingsFactory.java:203) - Query language substitutions: {}
INFO [main] cfg.SettingsFactory (SettingsFactory.java:209) - Second-level cache: enabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:213) - Query cache: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:321) - Cache provider: org.hibernate.cache.EhCacheProvider
INFO [main] cfg.SettingsFactory (SettingsFactory.java:228) - Optimize cache for minimal puts: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:237) - Structured second-level cache entries: disabled
DEBUG [main] exception.SQLExceptionConverterFactory (SQLExceptionConverterFactory.java:52) - Using dialect defined converter
INFO [main] cfg.SettingsFactory (SettingsFactory.java:257) - Echoing all SQL to stdout
INFO [main] cfg.SettingsFactory (SettingsFactory.java:261) - Statistics: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:265) - Deleted entity synthetic identifier rollback: disabled
INFO [main] cfg.SettingsFactory (SettingsFactory.java:279) - Default entity-mode: pojo
INFO [main] impl.SessionFactoryImpl (SessionFactoryImpl.java:152) - building session factory
DEBUG [main] impl.SessionFactoryImpl (SessionFactoryImpl.java:161) - Session factory constructed with filter configurations : {}
DEBUG [main] impl.SessionFactoryImpl (SessionFactoryImpl.java:164) - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_08\jre\bin, java.vm.version=1.4.2_08-b03, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=AU, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\vsfz\str_mdl_batch\TrelisProjects\domain\core, java.runtime.version=1.4.2_08-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\j2sdk1.4.2_08\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\tdeboer\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=C:\j2sdk1.4.2_08\bin;.;C:\WINNT\system32;C:\WINNT;c:\j2sdk1.4.2_08\bin;c:\bin;C:\PROGRA~1\RATIONAL\RATION~1\NUTCROOT\mksnt;C:\orant\bin;C:\oracle\ora817\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\WINNT\system32\nls;C:\WINNT\system32\nls\ENGLISH;C:\Program Files\Apache Software Foundation\Maven 1.0.2\bin;C:\Program Files\Rational\ClearCase\bin;C:\Program Files\Rational\common;Z:.;C:\ORANTDOT\BIN;;, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\tdeboer, user.timezone=GMT+08:00, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, user.name=tdeboer, java.class.path=/c:/vsfz/eclipse/plugins/org.eclipse.jdt.junit_3.0.1/junitsupport.jar;/c:/vsfz/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\vsfz\str_mdl_batch\TrelisProjects\domain\core\target\test-classes;C:\vsfz\str_mdl_batch\TrelisProjects\domain\core\target\classes;C:\vsfz\maven\repository\junit\jars\junit-3.8.1.jar;C:\vsfz\maven\repository\commons-logging\jars\commons-logging-1.0.4.jar;C:\vsfz\maven\repository\commons-lang\jars\commons-lang-2.0.jar;C:\vsfz\maven\repository\commons-beanutils\jars\commons-beanutils-1.7.0.jar;C:\vsfz\maven\repository\commons-dbcp\jars\commons-dbcp-1.2.1.jar;C:\vsfz\maven\repository\commons-pool\jars\commons-pool-1.2.jar;C:\vsfz\maven\repository\commons-collections\jars\commons-collections-3.1.jar;C:\vsfz\maven\repository\hibernate\jars\hibernate-3.0.5.jar;C:\vsfz\maven\repository\hibernate\jars\antlr-2.7.5H3.jar;C:\vsfz\maven\repository\hibernate\jars\asm-h3.jar;C:\vsfz\maven\repository\hibernate\jars\asm-attrs-h3.jar;C:\vsfz\maven\repository\hibernate\jars\cglib-2.1.jar;C:\vsfz\maven\repository\hibernate\jars\dom4j-1.6.jar;C:\vsfz\maven\repository\hibernate\jars\ehcache-1.1.jar;C:\vsfz\maven\repository\springframework\jars\spring-1.2.1.jar;C:\vsfz\maven\repository\springframework\jars\spring-aop-1.2.1.jar;C:\vsfz\maven\repository\easymock\jars\easymock-1.1.jar;C:\vsfz\maven\repository\dbunit\jars\dbunit-2.1.jar;C:\vsfz\maven\repository\oracle\jars\ojdbc-1.4.jar;C:\vsfz\maven\repository\weblogic\jars\weblogic-8.1.jar;C:\vsfz\maven\repository\log4j\jars\log4j-1.2.8.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_08\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_08, java.ext.dirs=C:\j2sdk1.4.2_08\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_08\jre\lib\rt.jar;C:\j2sdk1.4.2_08\jre\lib\i18n.jar;C:\j2sdk1.4.2_08\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_08\jre\lib\jsse.jar;C:\j2sdk1.4.2_08\jre\lib\jce.jar;C:\j2sdk1.4.2_08\jre\lib\charsets.jar;C:\j2sdk1.4.2_08\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
WARN [main] config.Configurator (Configurator.java:126) - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/vsfz/maven/repository/hibernate/jars/ehcache-1.1.jar!/ehcache-failsafe.xml
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.LicenceCondition
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCE_CONDITIONS where MDLLC_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select licencecon_.MDLLC_ROID, licencecon_.UPDATE_LEVEL as UPDATE2_1_, licencecon_.MDL_CONDITION_CODE as MDL3_1_, licencecon_.EXPIRY_DATE as EXPIRY4_1_, licencecon_.ISSUE_DATE as ISSUE5_1_ from MDL_LICENCE_CONDITIONS licencecon_ where licencecon_.MDLLC_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_LICENCE_CONDITIONS (UPDATE_LEVEL, MDL_CONDITION_CODE, EXPIRY_DATE, ISSUE_DATE, MDLL_ROID, MDLLC_ROID) values (?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_LICENCE_CONDITIONS set UPDATE_LEVEL=?, MDL_CONDITION_CODE=?, EXPIRY_DATE=?, ISSUE_DATE=? where MDLLC_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_LICENCE_CONDITIONS where MDLLC_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.driver.DriverCondition
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_CLIENT_CONDITIONS where MDLCCON_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select drivercond_.MDLCCON_ROID, drivercond_.UPDATE_LEVEL as UPDATE2_5_, drivercond_.MDL_CONDITION_CODE as MDL3_5_, drivercond_.EXPIRY_DATE as EXPIRY4_5_, drivercond_.ISSUE_DATE as ISSUE5_5_, drivercond_.EFFECTIVE_DATE as EFFECTIVE6_5_ from MDL_CLIENT_CONDITIONS drivercond_ where drivercond_.MDLCCON_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_CLIENT_CONDITIONS (UPDATE_LEVEL, MDL_CONDITION_CODE, EXPIRY_DATE, ISSUE_DATE, EFFECTIVE_DATE, MDLCD_ROID, MDLCCON_ROID) values (?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_CLIENT_CONDITIONS set UPDATE_LEVEL=?, MDL_CONDITION_CODE=?, EXPIRY_DATE=?, ISSUE_DATE=?, EFFECTIVE_DATE=? where MDLCCON_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_CLIENT_CONDITIONS where MDLCCON_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.InstructorLicence, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.InstructorLicence
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCES where MDLL_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select instructor_.MDLL_ROID, instructor_.UPDATE_LEVEL as UPDATE3_0_, instructor_.MDL_STATUS_CODE as MDL4_0_, instructor_.EXPIRY_DATE as EXPIRY5_0_, instructor_.ISSUE_DATE as ISSUE6_0_, instructor_.MDL_STATUS_REASON_CODE as MDL7_0_, instructor_.CERTIFIED_COPY_COUNT as CERTIFIED8_0_, instructor_.DUP_LICENCE_COUNT as DUP9_0_, instructor_.MDL_CARD_REQUEST_TYPE_CODE as MDL10_0_, instructor_.CARD_REQUEST_DATE as CARD11_0_, instructor_.PRODUCTION_DATE as PRODUCTION12_0_, instructor_.PRODUCTION_STATUS_CODE as PRODUCTION13_0_, instructor_.MDL_CARD_TYPE_CODE as MDL14_0_, instructor_.MDLCD_ROID as MDLCD15_0_ from MDL_LICENCES instructor_ where instructor_.MDLL_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_LICENCES (UPDATE_LEVEL, MDL_STATUS_CODE, EXPIRY_DATE, ISSUE_DATE, MDL_STATUS_REASON_CODE, CERTIFIED_COPY_COUNT, DUP_LICENCE_COUNT, MDL_CARD_REQUEST_TYPE_CODE, CARD_REQUEST_DATE, PRODUCTION_DATE, PRODUCTION_STATUS_CODE, MDL_CARD_TYPE_CODE, MDLCD_ROID, MDL_LICENCE_TYPE, MDLL_ROID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'I', ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_LICENCES set UPDATE_LEVEL=?, MDL_STATUS_CODE=?, EXPIRY_DATE=?, ISSUE_DATE=?, MDL_STATUS_REASON_CODE=?, CERTIFIED_COPY_COUNT=?, DUP_LICENCE_COUNT=?, MDL_CARD_REQUEST_TYPE_CODE=?, CARD_REQUEST_DATE=?, PRODUCTION_DATE=?, PRODUCTION_STATUS_CODE=?, MDL_CARD_TYPE_CODE=?, MDLCD_ROID=? where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_LICENCES where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.LicenceClass
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCE_ENTITLEMENTS where MDLLE_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select licencecla_.MDLLE_ROID, licencecla_.UPDATE_LEVEL as UPDATE2_2_, licencecla_.MDL_ENTITLEMENT_CODE as MDL3_2_, licencecla_.ISSUE_DATE as ISSUE4_2_, licencecla_.TRANSFER_ISSUE_DATE as TRANSFER5_2_, licencecla_.MDL_CONDITION_CODE1 as MDL6_2_, licencecla_.MDL_CONDITION_CODE2 as MDL7_2_ from MDL_LICENCE_ENTITLEMENTS licencecla_ where licencecla_.MDLLE_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_LICENCE_ENTITLEMENTS (UPDATE_LEVEL, MDL_ENTITLEMENT_CODE, ISSUE_DATE, TRANSFER_ISSUE_DATE, MDL_CONDITION_CODE1, MDL_CONDITION_CODE2, MDLL_ROID, MDLLE_ROID) values (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_LICENCE_ENTITLEMENTS set UPDATE_LEVEL=?, MDL_ENTITLEMENT_CODE=?, ISSUE_DATE=?, TRANSFER_ISSUE_DATE=?, MDL_CONDITION_CODE1=?, MDL_CONDITION_CODE2=? where MDLLE_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_LICENCE_ENTITLEMENTS where MDLLE_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.driver.Offence
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_OFFENCES where MDLO_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select offence_.MDLO_ROID, offence_.UPDATE_LEVEL as UPDATE2_6_, offence_.VEH_INFRINGEMENT_CODE as VEH3_6_, offence_.ISSUE_DATE as ISSUE4_6_, offence_.OFFENCE_DATE as OFFENCE5_6_, offence_.MDL_OFFENCE_STATUS_CODE as MDL6_6_, offence_.DEMERIT_POINTS as DEMERIT7_6_ from MDL_OFFENCES offence_ where offence_.MDLO_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_OFFENCES (UPDATE_LEVEL, VEH_INFRINGEMENT_CODE, ISSUE_DATE, OFFENCE_DATE, MDL_OFFENCE_STATUS_CODE, DEMERIT_POINTS, MDLCD_ROID, MDLO_ROID) values (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_OFFENCES set UPDATE_LEVEL=?, VEH_INFRINGEMENT_CODE=?, ISSUE_DATE=?, OFFENCE_DATE=?, MDL_OFFENCE_STATUS_CODE=?, DEMERIT_POINTS=? where MDLO_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_OFFENCES where MDLO_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.OrdinaryLicence, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.OrdinaryLicence
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCES where MDLL_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select ordinaryli_.MDLL_ROID, ordinaryli_.UPDATE_LEVEL as UPDATE3_0_, ordinaryli_.MDL_STATUS_CODE as MDL4_0_, ordinaryli_.EXPIRY_DATE as EXPIRY5_0_, ordinaryli_.ISSUE_DATE as ISSUE6_0_, ordinaryli_.MDL_STATUS_REASON_CODE as MDL7_0_, ordinaryli_.CERTIFIED_COPY_COUNT as CERTIFIED8_0_, ordinaryli_.DUP_LICENCE_COUNT as DUP9_0_, ordinaryli_.MDL_CARD_REQUEST_TYPE_CODE as MDL10_0_, ordinaryli_.CARD_REQUEST_DATE as CARD11_0_, ordinaryli_.PRODUCTION_DATE as PRODUCTION12_0_, ordinaryli_.PRODUCTION_STATUS_CODE as PRODUCTION13_0_, ordinaryli_.MDL_CARD_TYPE_CODE as MDL14_0_, ordinaryli_.MDLCD_ROID as MDLCD15_0_ from MDL_LICENCES ordinaryli_ where ordinaryli_.MDLL_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_LICENCES (UPDATE_LEVEL, MDL_STATUS_CODE, EXPIRY_DATE, ISSUE_DATE, MDL_STATUS_REASON_CODE, CERTIFIED_COPY_COUNT, DUP_LICENCE_COUNT, MDL_CARD_REQUEST_TYPE_CODE, CARD_REQUEST_DATE, PRODUCTION_DATE, PRODUCTION_STATUS_CODE, MDL_CARD_TYPE_CODE, MDLCD_ROID, MDL_LICENCE_TYPE, MDLL_ROID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'O', ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_LICENCES set UPDATE_LEVEL=?, MDL_STATUS_CODE=?, EXPIRY_DATE=?, ISSUE_DATE=?, MDL_STATUS_REASON_CODE=?, CERTIFIED_COPY_COUNT=?, DUP_LICENCE_COUNT=?, MDL_CARD_REQUEST_TYPE_CODE=?, CARD_REQUEST_DATE=?, PRODUCTION_DATE=?, PRODUCTION_STATUS_CODE=?, MDL_CARD_TYPE_CODE=?, MDLCD_ROID=? where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_LICENCES where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.Licence, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.Licence
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCES where MDLL_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select licence_.MDLL_ROID, licence_.UPDATE_LEVEL as UPDATE3_0_, licence_.MDL_STATUS_CODE as MDL4_0_, licence_.EXPIRY_DATE as EXPIRY5_0_, licence_.ISSUE_DATE as ISSUE6_0_, licence_.MDL_STATUS_REASON_CODE as MDL7_0_, licence_.CERTIFIED_COPY_COUNT as CERTIFIED8_0_, licence_.DUP_LICENCE_COUNT as DUP9_0_, licence_.MDL_CARD_REQUEST_TYPE_CODE as MDL10_0_, licence_.CARD_REQUEST_DATE as CARD11_0_, licence_.PRODUCTION_DATE as PRODUCTION12_0_, licence_.PRODUCTION_STATUS_CODE as PRODUCTION13_0_, licence_.MDL_CARD_TYPE_CODE as MDL14_0_, licence_.MDLCD_ROID as MDLCD15_0_ from MDL_LICENCES licence_ where licence_.MDLL_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_LICENCES (UPDATE_LEVEL, MDL_STATUS_CODE, EXPIRY_DATE, ISSUE_DATE, MDL_STATUS_REASON_CODE, CERTIFIED_COPY_COUNT, DUP_LICENCE_COUNT, MDL_CARD_REQUEST_TYPE_CODE, CARD_REQUEST_DATE, PRODUCTION_DATE, PRODUCTION_STATUS_CODE, MDL_CARD_TYPE_CODE, MDLCD_ROID, MDL_LICENCE_TYPE, MDLL_ROID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'au.gov.wa.dpi.trelis.licence.Licence', ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_LICENCES set UPDATE_LEVEL=?, MDL_STATUS_CODE=?, EXPIRY_DATE=?, ISSUE_DATE=?, MDL_STATUS_REASON_CODE=?, CERTIFIED_COPY_COUNT=?, DUP_LICENCE_COUNT=?, MDL_CARD_REQUEST_TYPE_CODE=?, CARD_REQUEST_DATE=?, PRODUCTION_DATE=?, PRODUCTION_STATUS_CODE=?, MDL_CARD_TYPE_CODE=?, MDLCD_ROID=? where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_LICENCES where MDLL_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.driver.Driver, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.driver.Driver
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_CLIENT_DETAILS where MDLCD_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select driver_.MDLCD_ROID, driver_.UPDATE_LEVEL as UPDATE2_4_, driver_.MDL_NUMBER as MDL3_4_, driver_.DEMERIT_POINTS as DEMERIT4_4_, driver_.NEXT_DRIVING_TEST_DATE as NEXT5_4_, driver_.NEXT_MED_CERT_DATE as NEXT6_4_, driver_.C_ROID as C7_4_ from MDL_CLIENT_DETAILS driver_ where driver_.MDLCD_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into MDL_CLIENT_DETAILS (UPDATE_LEVEL, MDL_NUMBER, DEMERIT_POINTS, NEXT_DRIVING_TEST_DATE, NEXT_MED_CERT_DATE, C_ROID, MDLCD_ROID) values (?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update MDL_CLIENT_DETAILS set UPDATE_LEVEL=?, MDL_NUMBER=?, DEMERIT_POINTS=?, NEXT_DRIVING_TEST_DATE=?, NEXT_MED_CERT_DATE=?, C_ROID=? where MDLCD_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from MDL_CLIENT_DETAILS where MDLCD_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.Photograph, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.Photograph
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from CLI_PHOTOS where CLIP_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select photograph_.CLIP_ROID, photograph_.UPDATE_LEVEL as UPDATE2_7_, photograph_.PORTRAIT_PHOTO_DATE as PORTRAIT3_7_, photograph_.SIGNATURE_PHOTO_DATE as SIGNATURE4_7_, photograph_.SIGNATURE_FLAG as SIGNATURE5_7_, photograph_.PORTRAIT_IND as PORTRAIT6_7_, photograph_.QUALITY_REJECT_REVERSAL_FLAG as QUALITY7_7_, photograph_.REFUSAL_REJECT_REVERSAL_FLAG as REFUSAL8_7_ from CLI_PHOTOS photograph_ where photograph_.CLIP_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into CLI_PHOTOS (UPDATE_LEVEL, PORTRAIT_PHOTO_DATE, SIGNATURE_PHOTO_DATE, SIGNATURE_FLAG, PORTRAIT_IND, QUALITY_REJECT_REVERSAL_FLAG, REFUSAL_REJECT_REVERSAL_FLAG, CLIP_ROID) values (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update CLI_PHOTOS set UPDATE_LEVEL=?, PORTRAIT_PHOTO_DATE=?, SIGNATURE_PHOTO_DATE=?, SIGNATURE_FLAG=?, PORTRAIT_IND=?, QUALITY_REJECT_REVERSAL_FLAG=?, REFUSAL_REJECT_REVERSAL_FLAG=? where CLIP_ROID=? and UPDATE_LEVEL=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from CLI_PHOTOS where CLIP_ROID=? and UPDATE_LEVEL=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.client.AddressSummary, BulkBeanException: Property is private (property setToDate)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.client.AddressSummary
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select A_ROID from CLI_ADDRESSES where A_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select addresssum_.A_ROID, addresssum_.UNSTRUCTURED_ADDRESS_1 as UNSTRUCT2_9_, addresssum_.UNSTRUCTURED_ADDRESS_2 as UNSTRUCT3_9_, addresssum_.SUBURB_LOCALITY as SUBURB4_9_, addresssum_.STATE_TERRITORY_CODE as STATE5_9_, addresssum_.POSTCODE as POSTCODE9_, addresssum_.COUNTRY_CODE as COUNTRY7_9_, addresssum_.C_ROID as C8_9_, addresssum_.TO_DATETIME as TO9_9_, addresssum_.FROM_DATETIME as FROM10_9_, addresssum_.D_ROID as D11_9_, addresssum_.DPID as DPID9_ from CLI_ADDRESSES addresssum_ where addresssum_.A_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2225) - Insert 0: insert into CLI_ADDRESSES (UNSTRUCTURED_ADDRESS_1, UNSTRUCTURED_ADDRESS_2, SUBURB_LOCALITY, STATE_TERRITORY_CODE, POSTCODE, COUNTRY_CODE, C_ROID, TO_DATETIME, FROM_DATETIME, D_ROID, DPID, ADDRESS_TYPE_CODE, A_ROID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2226) - Update 0: update CLI_ADDRESSES set UNSTRUCTURED_ADDRESS_1=?, UNSTRUCTURED_ADDRESS_2=?, SUBURB_LOCALITY=?, STATE_TERRITORY_CODE=?, POSTCODE=?, COUNTRY_CODE=?, C_ROID=?, TO_DATETIME=?, FROM_DATETIME=?, D_ROID=?, DPID=? where A_ROID=?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2227) - Delete 0: delete from CLI_ADDRESSES where A_ROID=?
DEBUG [main] util.ReflectHelper (ReflectHelper.java:201) - reflection optimizer disabled for: au.gov.wa.dpi.trelis.licence.LearnersPermit, BulkBeanException: Property is private (property setObjectUpdateLevel)
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2220) - Static SQL for entity: au.gov.wa.dpi.trelis.licence.LearnersPermit
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2222) - Version select: select UPDATE_LEVEL from MDL_LICENCES where MDLL_ROID =?
DEBUG [main] entity.BasicEntityPersister (BasicEntityPersister.java:2223) - Snapshot select: select learnerspe_.MDLL_ROID, learnerspe_.UPDATE_LEVEL as UPDATE3_0_, learnerspe_.MDL_STATUS_CODE as MDL4_0_, learnerspe_.EXPIRY_DATE as EXPIRY5_0_, learnerspe_.ISSUE_DATE as ISSUE6_0_, learnerspe_.MDL_STATUS_REASON_CODE as MDL7_0_, learnerspe_.CERTIFIED_COPY_COUNT as CERTIFIED8_0_, learnerspe_.DUP_LICENCE_COUNT as DUP9_0_, learnerspe_.MDL_CARD_REQUEST_TYPE_CODE as MDL10_0_, learnerspe_.CARD_REQUEST_DATE as CARD11_0_, learnerspe_.PRODUCTION_DATE as PRODUCTION12_0_, learnerspe_.PRODUCTION_STATUS_CODE as PRODUCTION13_0_, learnerspe_.MDL_CARD_TYPE_CODE as MDL14_0_, learnerspe_.MDLCD_ROID as MDLCD15_0_ from MDL_LICENCES learnerspe_ where learnerspe_.MDLL_ROID=?
DEBUG [main] ent