-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
cdon
 Post subject: merge/saveOrUpdate problem
PostPosted: Thu Sep 21, 2006 1:04 pm 
Newbie

Joined: Fri Jul 21, 2006 6:27 am
Posts: 10
problem:
merge doesnt work - persisting the object with session.save works perfectly, but using merge, it doesnt (see exception).
this only happens when trying to save an object that contains another object(loading objects containing other objects works!).
what is the problem?
TIA, chris


Hibernate version:
hibernate 3
Mapping documents:
Code:
<?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>

Code between sessionFactory.openSession() and session.close():
Code:
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;
   }

Full stack trace of any exception that occurs:
Code:
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)

Name and version of the database you are using:
mysql 5.0.18
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
Code:
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_,


Top
 Profile  
 
pasha
 Post subject:
PostPosted: Fri Sep 22, 2006 2:40 am 
Senior
Senior

Joined: Sat Nov 27, 2004 4:13 am
Posts: 137
well your code seems complex...

but the root of problem is: you want to persist an Address object refereing to a Person object which has not a primary key.

You can set cascade="save-update" on the relationship to solve the problem.
----------------
don't forget credits.

_________________
don't forget to credit!

Amir Pashazadeh
Payeshgaran MT
پايشگران مديريت طرح
http://www.payeshgaran.co
http://www.payeshgaran.org
http://www.payeshgaran.net

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.