<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<!--   Generated by Elver Store tools on Thu Sep 21 16:17:41 CEST 2006-->
<hibernate-mapping>
  <class entity-name="Address" abstract="false" lazy="false" discriminator-value="Address" table="`ADDRESS`">
    <id type="long">
      <generator class="native"/>
    </id>
    <discriminator column="`DTYPE`" type="string"/>
    <version name="vn" access="org.elver.store.hibernate.mapping.property.VersionPropertyHandler"/>
    <property name="street" type="java.lang.String" lazy="false" column="`STREET`" not-null="true" unique="false"/>
    <property name="postcode" type="java.lang.String" lazy="false" column="`POSTCODE`" not-null="true" unique="false"/>
    <property name="city" type="java.lang.String" lazy="false" column="`CITY`" not-null="true" unique="false"/>
    <property name="state" type="java.lang.String" lazy="false" column="`STATE`" not-null="false" unique="false"/>
    <property name="country" type="java.lang.String" lazy="false" column="`COUNTRY`" not-null="true" unique="false"/>
    <property name="phone" type="java.lang.String" lazy="false" column="`PHONE`" not-null="true" unique="false"/>
    <property name="fax" type="java.lang.String" lazy="false" column="`FAX`" not-null="true" unique="false"/>
    <property name="email" type="java.lang.String" lazy="false" column="`EMAIL`" not-null="true" unique="false"/>
    <property name="otheraddr" type="java.lang.String" lazy="false" column="`OTHERADDR`" not-null="false" unique="false"/>
  </class>
  <class entity-name="Affiliation" abstract="false" lazy="false" discriminator-value="Affiliation" table="`AFFILIATION`">
    <id name="id" type="java.lang.String" column="`ID`"/>
    <discriminator column="`DTYPE`" type="string"/>
    <version name="vn" access="org.elver.store.hibernate.mapping.property.VersionPropertyHandler"/>
    <property name="shortaffil" type="java.lang.String" lazy="false" column="`SHORTAFFIL`" not-null="false" unique="false"/>
    <property name="jobtitle" type="java.lang.String" lazy="false" column="`JOBTITLE`" not-null="true" unique="false"/>
    <property name="orgname" type="java.lang.String" lazy="false" column="`ORGNAME`" not-null="true" unique="false"/>
    <property name="orgdiv" type="java.lang.String" lazy="false" column="`ORGDIV`" not-null="false" unique="false"/>
    <component name="address" class="Address">
      <property name="street" type="java.lang.String" lazy="false" column="`ADDRESS_STREET`" not-null="true" unique="false"/>
      <property name="postcode" type="java.lang.String" lazy="false" column="`ADDRESS_POSTCODE`" not-null="true" unique="false"/>
      <property name="city" type="java.lang.String" lazy="false" column="`ADDRESS_CITY`" not-null="true" unique="false"/>
      <property name="state" type="java.lang.String" lazy="false" column="`ADDRESS_STATE`" not-null="false" unique="false"/>
      <property name="country" type="java.lang.String" lazy="false" column="`ADDRESS_COUNTRY`" not-null="true" unique="false"/>
      <property name="phone" type="java.lang.String" lazy="false" column="`ADDRESS_PHONE`" not-null="true" unique="false"/>
      <property name="fax" type="java.lang.String" lazy="false" column="`ADDRESS_FAX`" not-null="true" unique="false"/>
      <property name="email" type="java.lang.String" lazy="false" column="`ADDRESS_EMAIL`" not-null="true" unique="false"/>
      <property name="otheraddr" type="java.lang.String" lazy="false" column="`ADDRESS_OTHERADDR`" not-null="false" unique="false"/>
    </component>
    <property name="timestamp" type="date" lazy="false" column="`TIMESTAMP`" not-null="false" unique="false"/>
  </class>
  <class entity-name="Person" abstract="false" lazy="false" discriminator-value="Person" table="`PERSON`">
    <id name="id" type="java.lang.String" column="`ID`"/>
    <discriminator column="`DTYPE`" type="string"/>
    <version name="vn" access="org.elver.store.hibernate.mapping.property.VersionPropertyHandler"/>
    <property name="honorific" type="java.lang.String" lazy="false" column="`HONORIFIC`" not-null="false" unique="false"/>
    <property name="firstname" type="java.lang.String" lazy="false" column="`FIRSTNAME`" not-null="true" unique="false"/>
    <property name="surname" type="java.lang.String" lazy="false" column="`SURNAME`" not-null="true" unique="false"/>
    <property name="contrib" type="java.lang.String" lazy="false" column="`CONTRIB`" not-null="false" unique="false"/>
    <bag name="affiliation" lazy="true" cascade="all,delete-orphan">
      <key update="true">
        <column name="`AFFILIATION_ID`" not-null="false" unique="false"/>
      </key>
      <one-to-many entity-name="Affiliation"/>
    </bag>
    <property name="personblurb" type="java.lang.String" lazy="false" column="`PERSONBLURB`" not-null="false" unique="false"/>
    <property name="timestamp" type="date" lazy="false" column="`TIMESTAMP`" not-null="false" unique="false"/>
  </class>
</hibernate-mapping>

public boolean persistObject(String xml, String encoding) throws Exception{
      //load resource from string
      Resource resource = stringToResource(xml, encoding);

      //create Datastore
      HbDataStore hbds = getDataStore();
      
      // persist objects
      session = hbds.getSessionFactory().openSession();
      Transaction tx = session.getTransaction();
      tx.begin();
      try {

         // Validate the contents of the loaded resource.
         // and print to sysout
         // TODO change/remove before release!
         for (Iterator j = resource.getContents().iterator(); j.hasNext(); ) {
            EObject eObject = (EObject)j.next();
            //Diagnostic diagnostic = Diagnostician.INSTANCE.validate(eObject);
            System.out.println("success for: " + eObject.toString());
            System.out.println(eObject.eClass().getInstanceClassName());
            /*if (diagnostic.getSeverity() != Diagnostic.OK) {
               System.out.println(diagnostic.getMessage());
               //printDiagnostic(diagnostic, "");
            }*/
         }
         
         //store it!
         for (Iterator j = resource.getContents().iterator(); j.hasNext(); ) {
            EObject eObject = (EObject)j.next();
            
            session.merge(eObject); //<-- doesnt work when object already exists!
            //session.save(eObject);
            //session.saveOrUpdate(eObject);
         }
         
         tx.commit();
         
      }catch (Exception e) {
         e.printStackTrace();
         tx.rollback();
         throw e;
      }finally{
         session.close();
      }
      
      return true;
   }

org.hibernate.TransientObjectException: Person
   at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:216)
   at org.elver.store.hibernate.mapping.econtainer.EContainerUserType.getID(EContainerUserType.java:396)
   at org.elver.store.hibernate.mapping.econtainer.EContainerUserType.replace(EContainerUserType.java:387)
   at org.elver.store.hibernate.mapping.econtainer.EContainerUserType.replace(EContainerUserType.java:148)
   at org.hibernate.type.AbstractType.replace(AbstractType.java:153)
   at org.hibernate.type.TypeFactory.replace(TypeFactory.java:447)
   at org.hibernate.event.def.DefaultMergeEventListener.copyValues(DefaultMergeEventListener.java:302)
   at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:159)
   at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:103)
   at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
   at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
   at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
   at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
   at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
   at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
   at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
   at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
   at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
   at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
   at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
   at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
   at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
   at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:103)
   at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:52)
   at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:672)
   at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:656)
   at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:660)
   at jku.ce.scholion.authortool.dataaccess.DatabaseServices.persistObject(DatabaseServices.java:190)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.xmlrpc.server.PropertyHandlerMapping$1.execute(PropertyHandlerMapping.java:141)
   at org.apache.xmlrpc.server.XmlRpcServerWorker.execute(XmlRpcServerWorker.java:43)
   at org.apache.xmlrpc.server.XmlRpcServer.execute(XmlRpcServer.java:65)
   at org.apache.xmlrpc.server.XmlRpcStreamServer.execute(XmlRpcStreamServer.java:209)
   at org.apache.xmlrpc.webserver.Connection.run(Connection.java:168)
   at org.apache.xmlrpc.util.ThreadPool$MyThread.runTask(ThreadPool.java:71)
   at org.apache.xmlrpc.util.ThreadPool$MyThread.run(ThreadPool.java:87)

16:44:24,064 DEBUG EMFInstantiator:69 - Creating eobject instantiator for component eclass Address
16:44:24,068 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: Affiliation
16:44:24,069 DEBUG AbstractEntityPersister:2449 -  Version select: select vn from `AFFILIATION` where `ID` =?
16:44:24,070 DEBUG AbstractEntityPersister:2450 -  Snapshot select: select affiliatio_.`ID`, affiliatio_.vn as vn1_, affiliatio_.`SHORTAFFIL` as SHORTAFFIL4_1_, affiliatio_.`JOBTITLE` as JOBTITLE5_1_, affiliatio_.`ORGNAME` as ORGNAME6_1_, affiliatio_.`ORGDIV` as ORGDIV7_1_, affiliatio_.`ADDRESS_STREET` as ADDRESS8_1_, affiliatio_.`ADDRESS_POSTCODE` as ADDRESS9_1_, affiliatio_.`ADDRESS_CITY` as ADDRESS10_1_, affiliatio_.`ADDRESS_STATE` as ADDRESS11_1_, affiliatio_.`ADDRESS_COUNTRY` as ADDRESS12_1_, affiliatio_.`ADDRESS_PHONE` as ADDRESS13_1_, affiliatio_.`ADDRESS_FAX` as ADDRESS14_1_, affiliatio_.`ADDRESS_EMAIL` as ADDRESS15_1_, affiliatio_.`ADDRESS_OTHERADDR` as ADDRESS16_1_, affiliatio_.`TIMESTAMP` as TIMESTAMP17_1_, affiliatio_.econtainer_class as econtainer18_1_, affiliatio_.e_container as e19_1_, affiliatio_.e_container_featureid as e20_1_ from `AFFILIATION` affiliatio_ where affiliatio_.`ID`=?
16:44:24,071 DEBUG AbstractEntityPersister:2452 -  Insert 0: insert into `AFFILIATION` (vn, `SHORTAFFIL`, `JOBTITLE`, `ORGNAME`, `ORGDIV`, `ADDRESS_STREET`, `ADDRESS_POSTCODE`, `ADDRESS_CITY`, `ADDRESS_STATE`, `ADDRESS_COUNTRY`, `ADDRESS_PHONE`, `ADDRESS_FAX`, `ADDRESS_EMAIL`, `ADDRESS_OTHERADDR`, `TIMESTAMP`, econtainer_class, e_container, e_container_featureid, `DTYPE`, `ID`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'Affiliation', ?)
16:44:24,113 DEBUG AbstractEntityPersister:2453 -  Update 0: update `AFFILIATION` set vn=?, `SHORTAFFIL`=?, `JOBTITLE`=?, `ORGNAME`=?, `ORGDIV`=?, `ADDRESS_STREET`=?, `ADDRESS_POSTCODE`=?, `ADDRESS_CITY`=?, `ADDRESS_STATE`=?, `ADDRESS_COUNTRY`=?, `ADDRESS_PHONE`=?, `ADDRESS_FAX`=?, `ADDRESS_EMAIL`=?, `ADDRESS_OTHERADDR`=?, `TIMESTAMP`=?, econtainer_class=?, e_container=?, e_container_featureid=? where `ID`=? and vn=?
16:44:24,116 DEBUG AbstractEntityPersister:2454 -  Delete 0: delete from `AFFILIATION` where `ID`=? and vn=?
16:44:24,121 DEBUG HbUtil:70 - Creating property accessor for id/Person/id
16:44:24,122 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/id
16:44:24,124 DEBUG HbUtil:70 - Creating property accessor for id/Person/id
16:44:24,125 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/id
16:44:24,126 DEBUG HbUtil:70 - Creating property accessor for honorific/Person/honorific
16:44:24,128 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/honorific
16:44:24,129 DEBUG HbUtil:70 - Creating property accessor for honorific/Person/honorific
16:44:24,132 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/honorific
16:44:24,134 DEBUG HbUtil:70 - Creating property accessor for firstname/Person/firstname
16:44:24,135 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/firstname
16:44:24,136 DEBUG HbUtil:70 - Creating property accessor for firstname/Person/firstname
16:44:24,137 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/firstname
16:44:24,139 DEBUG HbUtil:70 - Creating property accessor for surname/Person/surname
16:44:24,140 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/surname
16:44:24,144 DEBUG HbUtil:70 - Creating property accessor for surname/Person/surname
16:44:24,145 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/surname
16:44:24,146 DEBUG HbUtil:70 - Creating property accessor for contrib/Person/contrib
16:44:24,147 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/contrib
16:44:24,149 DEBUG HbUtil:70 - Creating property accessor for contrib/Person/contrib
16:44:24,150 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/contrib
16:44:24,151 DEBUG HbUtil:70 - Creating property accessor for affiliation/Person/affiliation
16:44:24,157 DEBUG EListPropertyHandler:70 - Created getter/setter for Person/affiliation
16:44:24,159 DEBUG HbUtil:70 - Creating property accessor for affiliation/Person/affiliation
16:44:24,160 DEBUG EListPropertyHandler:70 - Created getter/setter for Person/affiliation
16:44:24,162 DEBUG HbUtil:70 - Creating property accessor for personblurb/Person/personblurb
16:44:24,163 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/personblurb
16:44:24,164 DEBUG HbUtil:70 - Creating property accessor for personblurb/Person/personblurb
16:44:24,165 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/personblurb
16:44:24,167 DEBUG HbUtil:70 - Creating property accessor for timestamp/Person/timestamp
16:44:24,170 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/timestamp
16:44:24,171 DEBUG HbUtil:70 - Creating property accessor for timestamp/Person/timestamp
16:44:24,212 DEBUG EAttributePropertyHandler:59 - Created getter/setter for Person/timestamp
16:44:24,214 DEBUG EMFInstantiator:59 - Creating eobject instantiator for Person and eclass Person
16:44:24,217 DEBUG AbstractEntityPersister:2447 - Static SQL for entity: Person
16:44:24,218 DEBUG AbstractEntityPersister:2449 -  Version select: select vn from `PERSON` where `ID` =?
16:44:24,219 DEBUG AbstractEntityPersister:2450 -  Snapshot select: select person_.`ID`, person_.vn as vn2_, person_.`HONORIFIC` as HONORIFIC4_2_, person_.`FIRSTNAME` as FIRSTNAME5_2_, person_.`SURNAME` as SURNAME6_2_, person_.`CONTRIB` as CONTRIB7_2_, person_.`PERSONBLURB` as PERSONBL8_2_, person_.`TIMESTAMP` as TIMESTAMP9_2_ from `PERSON` person_ where person_.`ID`=?
16:44:24,220 DEBUG AbstractEntityPersister:2452 -  Insert 0: insert into `PERSON` (vn, `HONORIFIC`, `FIRSTNAME`, `SURNAME`, `CONTRIB`, `PERSONBLURB`, `TIMESTAMP`, `DTYPE`, `ID`) values (?, ?, ?, ?, ?, ?, ?, 'Person', ?)
16:44:24,223 DEBUG AbstractEntityPersister:2453 -  Update 0: update `PERSON` set vn=?, `HONORIFIC`=?, `FIRSTNAME`=?, `SURNAME`=?, `CONTRIB`=?, `PERSONBLURB`=?, `TIMESTAMP`=? where `ID`=? and vn=?
16:44:24,224 DEBUG AbstractEntityPersister:2454 -  Delete 0: delete from `PERSON` where `ID`=? and vn=?
16:44:24,238 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: Person.affiliation
16:44:24,239 DEBUG AbstractCollectionPersister:512 -  Row insert: update `AFFILIATION` set `AFFILIATION_ID`=? where `ID`=?
16:44:24,240 DEBUG AbstractCollectionPersister:514 -  Row delete: update `AFFILIATION` set `AFFILIATION_ID`=null where `AFFILIATION_ID`=? and `ID`=?
16:44:24,241 DEBUG AbstractCollectionPersister:515 -  One-shot delete: update `AFFILIATION` set `AFFILIATION_ID`=null where `AFFILIATION_ID`=?
16:44:24,326 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?, ?)
16:44:24,329 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?)
16:44:24,331 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?)
16:44:24,540  INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:mysql://86.59.4.74:3306/test_cd2
16:44:24,543 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?)
16:44:24,546 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?)
16:44:24,547 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?)
16:44:24,549 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?)
16:44:24,550 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=?
16:44:24,552 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?, ?)
16:44:24,557 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?)
16:44:24,559 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?)
16:44:24,560 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?)
16:44:24,562 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?)
16:44:24,564 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?)
16:44:24,565 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?)
16:44:24,567 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=?
16:44:24,569 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?, ?) for update
16:44:24,571 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?) for update
16:44:24,616 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?) for update
16:44:24,617 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?) for update
16:44:24,619 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?) for update
16:44:24,621 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?) for update
16:44:24,625 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?) for update
16:44:24,626 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=? for update
16:44:24,628 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?, ?) for update
16:44:24,629 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?, ?) for update
16:44:24,631 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?, ?) for update
16:44:24,634 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?, ?) for update
16:44:24,635 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?, ?) for update
16:44:24,638 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?, ?) for update
16:44:24,640 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id in (?, ?) for update
16:44:24,641 DEBUG EntityLoader:79 - Static select for entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=? for update
16:44:24,660 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=?
16:44:24,664 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity Address: select address0_.id as id0_0_, address0_.vn as vn0_0_, address0_.`STREET` as STREET4_0_0_, address0_.`POSTCODE` as POSTCODE5_0_0_, address0_.`CITY` as CITY6_0_0_, address0_.`STATE` as STATE7_0_0_, address0_.`COUNTRY` as COUNTRY8_0_0_, address0_.`PHONE` as PHONE9_0_0_, address0_.`FAX` as FAX10_0_0_, address0_.`EMAIL` as EMAIL11_0_0_, address0_.`OTHERADDR` as OTHERADDR12_0_0_ from `ADDRESS` address0_ where address0_.id=?
16:44:24,666 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?, ?)
16:44:24,668 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?)
16:44:24,670 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?)
16:44:24,671 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?)
16:44:24,715 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?)
16:44:24,717 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?)
16:44:24,719 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?)
16:44:24,721 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID`=?
16:44:24,723 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?, ?)
16:44:24,726 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?)
16:44:24,728 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?)
16:44:24,729 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?)
16:44:24,731 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?)
16:44:24,733 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?)
16:44:24,737 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?)
16:44:24,738 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID`=?
16:44:24,741 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?, ?) for update
16:44:24,743 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?, ?) for update
16:44:24,745 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?, ?) for update
16:44:24,749 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?, ?) for update
16:44:24,751 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?, ?) for update
16:44:24,753 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?, ?) for update
16:44:24,754 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID` in (?, ?) for update
16:44:24,756 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_, affiliatio0_.`ADDRESS_PHONE` as ADDRESS13_1_0_, affiliatio0_.`ADDRESS_FAX` as ADDRESS14_1_0_, affiliatio0_.`ADDRESS_EMAIL` as ADDRESS15_1_0_, affiliatio0_.`ADDRESS_OTHERADDR` as ADDRESS16_1_0_, affiliatio0_.`TIMESTAMP` as TIMESTAMP17_1_0_, affiliatio0_.econtainer_class as econtainer18_1_0_, affiliatio0_.e_container as e19_1_0_, affiliatio0_.e_container_featureid as e20_1_0_ from `AFFILIATION` affiliatio0_ where affiliatio0_.`ID`=? for update
16:44:24,759 DEBUG EntityLoader:79 - Static select for entity Affiliation: select affiliatio0_.`ID` as ID1_1_0_, affiliatio0_.vn as vn1_0_, affiliatio0_.`SHORTAFFIL` as SHORTAFFIL4_1_0_, affiliatio0_.`JOBTITLE` as JOBTITLE5_1_0_, affiliatio0_.`ORGNAME` as ORGNAME6_1_0_, affiliatio0_.`ORGDIV` as ORGDIV7_1_0_, affiliatio0_.`ADDRESS_STREET` as ADDRESS8_1_0_, affiliatio0_.`ADDRESS_POSTCODE` as ADDRESS9_1_0_, affiliatio0_.`ADDRESS_CITY` as ADDRESS10_1_0_, affiliatio0_.`ADDRESS_STATE` as ADDRESS11_1_0_, affiliatio0_.`ADDRESS_COUNTRY` as ADDRESS12_1_0_,