-->
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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 11 posts ] 
Author Message
 Post subject: composite-id mapping problem with a many-to-many property
PostPosted: Mon Apr 26, 2004 2:00 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15

I have a problem that I have not been able to resole. I have a
bean named Gabber. A Gabber has a Set of Addresses. This
is a simple relationship to map. But, the problem is that I have
a composite key on both the Gabber and on Address.

I have the beans mapped, but when I retrieve a Gabber the
addresses fail to load. Any help would be appreciated.




Hibernate Version: 2.1.2
Database: Oracle 8i

POJO for Gabber:
Code:
public class Gabber extends Versioned....
{

   private Collection addressesCollection;

   /**
    * @param addresses The addresses to set.
    */
   public void setAddressCollection(Collection addresses)
   {
      System.out.println("EXISTING address Collection: " + this.addressesCollection);
      System.out.println("In commiung address Collection: " + addresses);
      addressesCollection = addresses;
   }
   
   /**
    * @param addresses The addresses to set.
    */
   public Collection getAddressCollection()
   {

      System.out.println(this +" get address Collection: " + addressesCollection);

      return addressesCollection;
   }

}


The composite-id wrapper for Gabber:
Code:
...

import java.io.Serializable;

import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/**
* @author Matthew L. Wilson
* @version $Revision: 1.3 $ $Date: 2004/04/22 20:38:56 $
*/
public class VersionId implements Serializable
{
   /** The scp id. * */
   private String cnid;
   /** The number of this version * */
   private Integer versionNumber;

   /**
    * Default constructor.
    */
   private VersionId()
   {
   }

   /**
    * @param id The cnid.
    * @param version The version number.
    */
   public VersionId(String id, Integer version)
   {
      this.cnid = id;
      this.versionNumber = version;
   }

   /**
    * @return Returns the id.
    */
   public String getCnid()
   {
      return cnid;
   }

   /**
    * @param id The id to set.
    */
   public void setCnid(String id)
   {
      this.cnid = id;
   }

   /**
    * @return Returns the versionNumber.
    */
   public Integer getVersionNumber()
   {
      return versionNumber;
   }

   /**
    * @param versionNumber The versionNumber to set.
    */
   public void setVersionNumber(Integer versionNumber)
   {
      this.versionNumber = versionNumber;
   }

   /**
    * @see java.lang.Object#equals(java.lang.Object)
    */
   public boolean equals(Object obj)
   {
      // return (obj instanceof VersionId) ? obj.hashCode() == hashCode() : false;
      return (obj instanceof VersionId) ? (this.cnid == ((VersionId) obj).getCnid() && (this.versionNumber == ((VersionId) obj).getVersionNumber())) : false;
   }

   /**
    * @see java.lang.Object#hashCode()
    */
   public int hashCode()
   {
      return new HashCodeBuilder(17, 37).append(cnid).append(versionNumber).toHashCode();
   }

   /**
    * @see java.lang.Object#toString()
    */
   public String toString()
   {
      return new ToStringBuilder(this).append(versionNumber).append(cnid).toString();
   }

}



Mapping file for Gabber:
Code:
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

  <class name="x.y.Gabber" table="Gabber">
    <composite-id name="versionId" class="x.y.VersionId">
        <key-property name="cnid"          column="CNID" />
        <key-property name="versionNumber" column="VER_NUM" />
    </composite-id>    

    <property    name="versionDate"        column="VER_DATE" />    

    <set name="addressCollection" table="ADDRESS_LINK" >
      <key >
         <column name="GABBER_CNID" />
         <column name="GABBER_VER_NUM"/>
      </key>     
      <many-to-many class="x.y.Address">
         <column name="ADDRESS_CNID" />
         <column name="ADDRESS_VER_NUM"/>      
      </many-to-many>           
    </set>
   
  </class>

</hibernate-mapping>


Mapping file for Address:
Code:
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

  <class name="x.y.Address" table="V_ADDRESS">
    <composite-id name="versionId" class="x.y.VersionId">
        <key-property name="cnid"          column="ADDRESS_CNID" />
        <key-property name="versionNumber" column="VER_NUM" />
    </composite-id>    

    <property    name="address"                column="ADDRESS" />

  </class>

</hibernate-mapping>


Debug Log:
[code]
13:15:44,074 INFO Binder:169 - Mapping subclass: x.y.addinfo.GscsAddInfo -> ADDINFO
13:15:44,074 DEBUG Binder:462 - Mapped property: seqNumberi -> ISEQNUMBER, type: integer
13:15:44,074 DEBUG Binder:462 - Mapped property: seqNumbero -> OSEQNUMBER, type: integer
13:15:44,074 DEBUG Binder:462 - Mapped property: port -> PORT_NO, type: integer
13:15:44,074 DEBUG Binder:462 - Mapped property: gscsId -> GSCS_ID, type: string
13:15:44,074 DEBUG Binder:462 - Mapped property: address -> ADDRESS, type: string
13:15:44,074 DEBUG Binder:462 - Mapped property: timelinessIndex -> TIMELINESS_INDEX, type: integer
13:15:44,090 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,090 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,090 INFO Binder:169 - Mapping subclass: x.y.addinfo.GuiAddInfo -> ADDINFO
13:15:44,090 DEBUG Binder:462 - Mapped property: spaceHolder -> SPACE_HOLDER, type: string
13:15:44,105 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,105 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,121 INFO Binder:169 - Mapping subclass: x.y.addinfo.MlssplAddInfo -> ADDINFO
13:15:44,121 DEBUG Binder:462 - Mapped property: scanInterval -> SCAN_INTERVAL, type: integer
13:15:44,121 DEBUG Binder:462 - Mapped property: rootDevice -> ROOT_DEVICE, type: string
13:15:44,121 DEBUG Binder:462 - Mapped property: rootDirectory -> ROOT_DIRECTORY, type: string
13:15:44,121 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,121 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,137 INFO Binder:169 - Mapping subclass: x.y.addinfo.PickupAddInfo -> ADDINFO
13:15:44,137 DEBUG Binder:462 - Mapped property: location -> LOCATION, type: string
13:15:44,152 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,152 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,152 INFO Binder:169 - Mapping subclass: x.y.addinfo.PrinterAddInfo -> ADDINFO
13:15:44,168 DEBUG Binder:462 - Mapped property: location -> LOCATION, type: string
13:15:44,168 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,168 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,183 INFO Binder:169 - Mapping subclass: x.y.addinfo.RepositoryAddInfo -> ADDINFO
13:15:44,183 DEBUG Binder:462 - Mapped property: location -> LOCATION, type: string
13:15:44,183 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,183 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,199 INFO Binder:169 - Mapping subclass: x.y.addinfo.ScAddInfo -> ADDINFO
13:15:44,199 DEBUG Binder:462 - Mapped property: remoteHost -> HOST_NAME, type: string
13:15:44,199 DEBUG Binder:462 - Mapped property: localHost -> LOCAL_HOST, type: string
13:15:44,199 DEBUG Binder:462 - Mapped property: userName -> LOGIN_NAME, type: string
13:15:44,215 DEBUG Binder:462 - Mapped property: password -> PASSWORD, type: string
13:15:44,215 DEBUG Binder:462 - Mapped property: pickupDir -> DIRECTORY, type: string
13:15:44,215 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,215 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,230 INFO Binder:169 - Mapping subclass: x.y.addinfo.SmtpAddInfo -> ADDINFO
13:15:44,230 DEBUG Binder:462 - Mapped property: remoteHost -> HOST_NAME, type: string
13:15:44,230 DEBUG Binder:462 - Mapped property: defaultLocalUser -> LOGIN_NAME, type: string
13:15:44,230 DEBUG Binder:462 - Mapped property: formatString -> FORMAT_STRING, type: string
13:15:44,230 DEBUG Binder:462 - Mapped property: portNumber -> PORT_NO, type: integer
13:15:44,262 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,262 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,262 INFO Binder:169 - Mapping subclass: x.y.addinfo.SpcsAddInfo -> ADDINFO
13:15:44,262 DEBUG Binder:462 - Mapped property: seqNumberi -> ISEQNUMBER, type: integer
13:15:44,262 DEBUG Binder:462 - Mapped property: seqNumbero -> OSEQNUMBER, type: integer
13:15:44,277 DEBUG Binder:462 - Mapped property: port -> PORT_NO, type: integer
13:15:44,277 DEBUG Binder:462 - Mapped property: spcsId -> SPCS_ID, type: string
13:15:44,277 DEBUG Binder:462 - Mapped property: address -> ADDRESS, type: string
13:15:44,277 DEBUG Binder:462 - Mapped property: timelinessIndex -> TIMELINESS_INDEX, type: integer
13:15:44,277 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,293 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,293 INFO Binder:169 - Mapping subclass: x.y.addinfo.TaskAddInfo -> ADDINFO
13:15:44,293 DEBUG Binder:462 - Mapped property: portNum -> PORT_NO, type: integer
13:15:44,293 DEBUG Binder:462 - Mapped property: nodeName -> NODE_NAME, type: string
13:15:44,293 DEBUG Binder:462 - Mapped property: loginName -> LOGIN_NAME, type: string
13:15:44,293 DEBUG Binder:462 - Mapped property: password -> PASSWORD, type: string
13:15:44,293 DEBUG Binder:462 - Mapped property: maxConnections -> MAX_CONNECTIONS, type: integer
13:15:44,308 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,308 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,324 INFO Binder:169 - Mapping subclass: x.y.addinfo.TddsAddInfo -> ADDINFO
13:15:44,324 DEBUG Binder:462 - Mapped property: port -> PORT_NO, type: integer
13:15:44,324 DEBUG Binder:462 - Mapped property: address -> ADDRESS, type: string
13:15:44,324 DEBUG Binder:462 - Mapped property: sampleSize -> SAMPLE_SIZE, type: integer
13:15:44,324 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,324 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,340 INFO Binder:169 - Mapping subclass: x.y.addinfo.TTaskAddInfo -> ADDINFO
13:15:44,340 DEBUG Binder:462 - Mapped property: nodeName -> NODE_NAME, type: string
13:15:44,340 DEBUG Binder:462 - Mapped property: loginName -> LOGIN_NAME, type: string
13:15:44,340 DEBUG Binder:462 - Mapped property: password -> PASSWORD, type: string
13:15:44,340 DEBUG Binder:462 - Mapped property: task -> TASK_MSG, type: string
13:15:44,355 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
13:15:44,355 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
13:15:44,371 INFO Binder:169 - Mapping subclass: x.y.addinfo.VcpAddInfo -> ADDINFO
13:15:44,371 DEBUG Binder:462 - Mapped property: processId -> PROCESS_ID, type: long
13:15:44,371 DEBUG Binder:462 - Mapped property: vcpRi -> VCP_RI, type: string
13:15:44,371 DEBUG Binder:462 - Mapped property: vcpChanDes -> VCP_CHAN_DES, type: string
13:15:44,371 DEBUG Binder:462 - Mapped property: crypt -> CRYPT, type: integer
13:15:44,371 DEBUG Binder:462 - Mapped property: remoteHostAddr -> ADDRESS, type: string
13:15:44,387 INFO Configuration:595 - processing one-to-many association mappings
13:15:44,387 DEBUG Binder:1326 - Second pass for collection: com.bah.common.service.security.User.authorizationsCollection
13:15:44,387 INFO Binder:1154 - Mapping collection: com.bah.common.service.security.User.authorizationsCollection -> COMMON_AUTHORIZATION
13:15:44,387 DEBUG Binder:1341 - Mapped collection key: user_id, one-to-many: com.bah.common.service.security.Authorization
13:15:44,387 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.addressesCollection
13:15:44,387 INFO Binder:1154 - Mapping collection: x.y.SystemNode.addressesCollection -> ADDRESS
13:15:44,387 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.Address
13:15:44,387 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.profilesCollection
13:15:44,387 INFO Binder:1154 - Mapping collection: x.y.SystemNode.profilesCollection -> PROFILE
13:15:44,387 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.Profile
13:15:44,402 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.dataHandlersCollection
13:15:44,402 INFO Binder:1154 - Mapping collection: x.y.SystemNode.dataHandlersCollection -> DATAHANDLER
13:15:44,402 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.DataHandler
13:15:44,402 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.emailUsersCollection
13:15:44,402 INFO Binder:1154 - Mapping collection: x.y.SystemNode.emailUsersCollection -> EMAIL_USERS
13:15:44,402 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.EmailUser
13:15:44,402 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.projectCodewordsCollection
13:15:44,402 INFO Binder:1154 - Mapping collection: x.y.SystemNode.projectCodewordsCollection -> PROJECT_CODEWORD
13:15:44,402 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.ProjectCodeword
13:15:44,402 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.projectSubjectsCollection
13:15:44,418 INFO Binder:1154 - Mapping collection: x.y.SystemNode.projectSubjectsCollection -> PROJECT_SUBJECT
13:15:44,418 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.ProjectSubject
13:15:44,418 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.socommProjectsCollection
13:15:44,418 INFO Binder:1154 - Mapping collection: x.y.SystemNode.socommProjectsCollection -> SOCOMM_PROJECT_ID_LIST
13:15:44,418 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.SocommProject
13:15:44,418 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.socommAigsCollection
13:15:44,418 INFO Binder:1154 - Mapping collection: x.y.SystemNode.socommAigsCollection -> SOCOMM_AIG
13:15:44,418 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.SocommAig
13:15:44,418 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.GabbersCollection
13:15:44,418 INFO Binder:1154 - Mapping collection: x.y.SystemNode.GabbersCollection -> GENSER_AIG
13:15:44,418 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.Gabber
13:15:44,418 DEBUG Binder:1326 - Second pass for collection: x.y.SystemNode.dagsCollection
13:15:44,433 INFO Binder:1154 - Mapping collection: x.y.SystemNode.dagsCollection -> DAG
13:15:44,433 DEBUG Binder:1341 - Mapped collection key: SYSTEM_NODE_CNID, one-to-many: x.y.Dag
13:15:44,433 DEBUG Binder:1326 - Second pass for collection: x.y.Gabber.addressCollection
13:15:44,433 DEBUG Binder:1341 - Mapped collection key: GENSER_AIG_CNID, element: ADDRESS_CNID, type: x.y.Address
13:15:44,433 DEBUG Binder:1326 - Second pass for collection: x.y.SocommAig.addressCollection
13:15:44,433 DEBUG Binder:1341 - Mapped collection key: SOCOMM_AIG_CNID, element: ADDRESS_CNID, type: x.y.Address
13:15:44,433 DEBUG Binder:1326 - Second pass for collection: x.y.SocommAig.projectCodewordsCollection
13:15:44,433 DEBUG Binder:1341 - Mapped collection key: SOCOMM_AIG_CNID, element: PROJECT_CODEWORD_CNID, type: x.y.ProjectCodeword
13:15:44,433 DEBUG Binder:1326 - Second pass for collection: x.y.Dag.addressCollection
13:15:44,449 DEBUG Binder:1341 - Mapped collection key: DAG_CNID, element: ADDRESS_CNID, type: x.y.Address
13:15:44,449 DEBUG Binder:1326 - Second pass for collection: x.y.Profile.dataHandlersCollection
13:15:44,449 DEBUG Binder:1341 - Mapped collection key: PROFILE_CNID, element: DATAHANDLER_CNID, type: x.y.DataHandler
13:15:44,449 INFO Configuration:604 - processing one-to-one association property references
13:15:44,449 INFO Configuration:629 - processing foreign key constraints
13:15:44,449 DEBUG Configuration:639 - resolving reference to class: com.bah.common.service.security.Role
13:15:44,449 DEBUG Configuration:639 - resolving reference to class: com.bah.common.service.security.User
13:15:44,449 DEBUG Configuration:639 - resolving reference to class: x.y.addinfo.AddInfo
13:15:44,449 DEBUG Configuration:639 - resolving reference to class: x.y.S....
13:15:44,449 DEBUG Configuration:639 - resolving reference to class: x.y.S....
..............................................................................
13:15:44,496 DEBUG Configuration:639 - resolving reference to class: x.y.Address
..............................................................................
13:15:44,512 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.OracleDialect
13:15:44,512 INFO SettingsFactory:62 - Use outer join fetching: true
13:15:44,512 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:15:44,512 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
13:15:44,527 INFO DriverManagerConnectionProvider:71 - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@156.80.138.135:1521:fresnel
13:15:44,527 INFO DriverManagerConnectionProvider:72 - connection properties: {user=rccms, password=rccms}
13:15:44,527 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
13:15:44,527 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
13:15:44,527 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
13:15:44,574 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:oracle:thin:@156.80.138.135:1521:fresnel, Isolation Level: 2
13:15:44,574 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
13:15:44,574 INFO SettingsFactory:102 - Use scrollable result sets: true
13:15:44,574 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): false
13:15:44,590 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
13:15:44,590 INFO SettingsFactory:114 - echoing all SQL to stdout
13:15:44,590 INFO SettingsFactory:117 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
13:15:44,590 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
13:15:44,590 INFO Configuration:1080 - instantiating and configuring caches
13:15:44,590 INFO SessionFactoryImpl:119 - building session factory
13:15:44,590 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.connection.password=rccms, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=net.sf.ehcache.hibernate.Provider, sun.boot.library.path=c:\j2sdk1.4.1_01\jre\bin, java.vm.version=1.4.1_01-b01, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=rccms, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Projects\scp\rccms-eclipse2, java.runtime.version=1.4.1_01-b01, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=c:\j2sdk1.4.1_01\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\mwilson\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=c:\j2sdk1.4.1_01\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\cygwin\bin;c:\j2sdk1.4.1_01\bin;C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem, java.specification.name=Java Platform API Specification, java.class.version=48.0, hibernate.connection.pool_size=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, user.home=C:\Documents and Settings\mwilson, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, user.name=mwilson, java.class.path=/c:/Development/eclipse/3.0M6/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/Development/eclipse/3.0M6/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\Projects\scp\rccms-eclipse2\target\test-classes;C:\Projects\scp\rccms-eclipse2\e-target;C:\Documents and Settings\mwilson\.maven\repository\junit\jars\junit-3.8.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-beanutils\jars\commons-beanutils-1.6.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-lang\jars\commons-lang-1.0.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-logging\jars\commons-logging-1.0.3.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-collections\jars\commons-collections-2.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-pool\jars\commons-pool-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-dbcp\jars\commons-dbcp-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\dom4j\jars\dom4j-1.4-dev-7.jar;C:\Documents and Settings\mwilson\.maven\repository\struts\jars\struts-1.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-digester\jars\commons-digester-1.5.jar;C:\Documents and Settings\mwilson\.maven\repository\servletapi\jars\servletapi-2.3.jar;C:\Documents and Settings\mwilson\.maven\repository\hibernate\jars\hibernate-2.1.2.jar;C:\Documents and Settings\mwilson\.maven\repository\jta\jars\jta-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\odmg\jars\odmg-3.0.jar;C:\Documents and Settings\mwilson\.maven\repository\cglib\jars\cglib-2.0.jar;C:\Documents and Settings\mwilson\.maven\repository\ehcache\jars\ehcache-0.7.jar;C:\Documents and Settings\mwilson\.maven\repository\jdom\jars\jdom-b9.jar;C:\Documents and Settings\mwilson\.maven\repository\oracle-jdbc\jars\oracle9i-jdbc-12.jar;C:\Documents and Settings\mwilson\.maven\repository\hsqldb\jars\hsqldb-1.7.1.jar;C:\Documents and Settings\mwilson\.maven\repository\taglibs\jars\standard-1.0.4.jar;C:\Documents and Settings\mwilson\.maven\repository\taglibs\jars\input-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\jstl\jars\jstl-1.0.2.jar;C:\Documents and Settings\mwilson\.maven\repository\mlavwilson\jars\mlavwilson-vlh-1.1_a2.jar;C:\Documents and Settings\mwilson\.maven\repository\spring\jars\spring-1.0-M2.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-validator\jars\commons-validator-1.0.2.jar;C:\Documents and Settings\mwilson\.maven\repository\log4j\jars\log4j-1.2.8.jar;C:\Projects\scp\v3.0.0\target\test-classes;C:\Projects\scp\v3.0.0\e-target\classes;C:\Documents and Settings\mwilson\.maven\repository\mockobjects\jars\mockobjects-jdk1.4-j2ee1.2-0.09.jar;C:\Documents and Settings\mwilson\.maven\repository\mockobjects\jars\mockobjects-core-0.09.jar;C:\Documents and Settings\mwilson\.maven\repository\mockejb\jars\mockejb-0.5.jar;C:\Documents and Settings\mwilson\.maven\repository\quartz\jars\quartz-1.3.0.jar;C:\Documents and Settings\mwilson\.maven\repository\javasoft\jars\jce-1.2.2.jar;C:\Documents and Settings\mwilson\.maven\repository\ant\jars\ant-1.5.jar;C:\Documents and Settings\mwilson\.maven\repository\hibernate\jars\hibernate-2.1.1.jar;C:\Documents and Settings\mwilson\.maven\repository\ehcache\jars\ehcache-0.5.jar;C:\Documents and Settings\mwilson\.maven\repository\jboss\jars\jbossall-client-3.2.1.jar;C:\Documents and Settings\mwilson\.maven\repository\jboss\jars\jboss-j2ee-3.2.1.jar, hibernate.show_sql=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', java.vm.specification.version=1.0, java.home=c:\j2sdk1.4.1_01\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:oracle:thin:@156.80.138.135:1521:fresnel, hibernate.dialect=net.sf.hibernate.dialect.OracleDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.1_01, java.ext.dirs=c:\j2sdk1.4.1_01\jre\lib\ext, sun.boot.class.path=c:\j2sdk1.4.1_01\jre\lib\rt.jar;c:\j2sdk1.4.1_01\jre\lib\i18n.jar;c:\j2sdk1.4.1_01\jre\lib\sunrsasign.jar;c:\j2sdk1.4.1_01\jre\lib\jsse.jar;c:\j2sdk1.4.1_01\jre\lib\jce.jar;c:\j2sdk1.4.1_01\jre\lib\charsets.jar;c:\j2sdk1.4.1_01\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.statement_cache.size=25, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
13:15:44,605 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.Dag, BulkBeanException: Property is private (property setAddressCollection)
13:15:44,808 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.addinfo.AddInfo, InstantiationError: x.y.addinfo.AddInfo
13:15:44,824 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.SystemNode, BulkBeanException: Property is private (property setAddressesCollection)
dataHandlersCollection = []
13:15:45,637 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.SocommAig, BulkBeanException: Property is private (property setAddressCollection)
13:15:45,855 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
13:15:45,855 DEBUG SessionFactoryObjectFactory:76 - registered: 1cd00a07fc27d09e00fc27d0ad300000 (unnamed)
13:15:45,855 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
13:15:45,855 DEBUG SessionFactoryImpl:196 - instantiated session factory
13:15:45,855 INFO Configuration:595 - processing one-to-many association mappings
13:15:45,871 INFO Configuration:604 - processing one-to-one association property references
13:15:45,871 INFO Configuration:629 - processing foreign key constraints
13:15:45,871 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.OracleDialect
13:15:45,871 INFO SettingsFactory:62 - Use outer join fetching: true
13:15:45,871 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:15:45,871 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
13:15:45,871 INFO DriverManagerConnectionProvider:71 - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@156.80.138.135:1521:fresnel
13:15:45,871 INFO DriverManagerConnectionProvider:72 - connection properties: {user=rccms, password=rccms}
13:15:45,871 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
13:15:45,887 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
13:15:45,887 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
13:15:45,933 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:oracle:thin:@156.80.138.135:1521:fresnel, Isolation Level: 2
13:15:45,933 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
13:15:45,933 INFO SettingsFactory:102 - Use scrollable result sets: true
13:15:45,933 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): false
13:15:45,933 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
13:15:45,933 INFO SettingsFactory:114 - echoing all SQL to stdout
13:15:45,933 INFO SettingsFactory:117 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
13:15:45,949 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
13:15:45,949 INFO Configuration:1080 - instantiating and configuring caches
13:15:45,949 INFO SessionFactoryImpl:119 - building session factory
13:15:45,949 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.connection.password=rccms, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=net.sf.ehcache.hibernate.Provider, sun.boot.library.path=c:\j2sdk1.4.1_01\jre\bin, java.vm.version=1.4.1_01-b01, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=rccms, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Projects\scp\rccms-eclipse2, java.runtime.version=1.4.1_01-b01, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=c:\j2sdk1.4.1_01\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\mwilson\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=c:\j2sdk1.4.1_01\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\cygwin\bin;c:\j2sdk1.4.1_01\bin;C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem, java.specification.name=Java Platform API Specification, java.class.version=48.0, hibernate.connection.pool_size=1, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, user.home=C:\Documents and Settings\mwilson, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, user.name=mwilson, java.class.path=/c:/Development/eclipse/3.0M6/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/Development/eclipse/3.0M6/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\Projects\scp\rccms-eclipse2\target\test-classes;C:\Projects\scp\rccms-eclipse2\e-target;C:\Documents and Settings\mwilson\.maven\repository\junit\jars\junit-3.8.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-beanutils\jars\commons-beanutils-1.6.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-lang\jars\commons-lang-1.0.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-logging\jars\commons-logging-1.0.3.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-collections\jars\commons-collections-2.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-pool\jars\commons-pool-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-dbcp\jars\commons-dbcp-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\dom4j\jars\dom4j-1.4-dev-7.jar;C:\Documents and Settings\mwilson\.maven\repository\struts\jars\struts-1.1.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-digester\jars\commons-digester-1.5.jar;C:\Documents and Settings\mwilson\.maven\repository\servletapi\jars\servletapi-2.3.jar;C:\Documents and Settings\mwilson\.maven\repository\hibernate\jars\hibernate-2.1.2.jar;C:\Documents and Settings\mwilson\.maven\repository\jta\jars\jta-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\odmg\jars\odmg-3.0.jar;C:\Documents and Settings\mwilson\.maven\repository\cglib\jars\cglib-2.0.jar;C:\Documents and Settings\mwilson\.maven\repository\ehcache\jars\ehcache-0.7.jar;C:\Documents and Settings\mwilson\.maven\repository\jdom\jars\jdom-b9.jar;C:\Documents and Settings\mwilson\.maven\repository\oracle-jdbc\jars\oracle9i-jdbc-12.jar;C:\Documents and Settings\mwilson\.maven\repository\hsqldb\jars\hsqldb-1.7.1.jar;C:\Documents and Settings\mwilson\.maven\repository\taglibs\jars\standard-1.0.4.jar;C:\Documents and Settings\mwilson\.maven\repository\taglibs\jars\input-1.0.jar;C:\Documents and Settings\mwilson\.maven\repository\jstl\jars\jstl-1.0.2.jar;C:\Documents and Settings\mwilson\.maven\repository\mlavwilson\jars\mlavwilson-vlh-1.1_a2.jar;C:\Documents and Settings\mwilson\.maven\repository\spring\jars\spring-1.0-M2.jar;C:\Documents and Settings\mwilson\.maven\repository\commons-validator\jars\commons-validator-1.0.2.jar;C:\Documents and Settings\mwilson\.maven\repository\log4j\jars\log4j-1.2.8.jar;C:\Projects\scp\v3.0.0\target\test-classes;C:\Projects\scp\v3.0.0\e-target\classes;C:\Documents and Settings\mwilson\.maven\repository\mockobjects\jars\mockobjects-jdk1.4-j2ee1.2-0.09.jar;C:\Documents and Settings\mwilson\.maven\repository\mockobjects\jars\mockobjects-core-0.09.jar;C:\Documents and Settings\mwilson\.maven\repository\mockejb\jars\mockejb-0.5.jar;C:\Documents and Settings\mwilson\.maven\repository\quartz\jars\quartz-1.3.0.jar;C:\Documents and Settings\mwilson\.maven\repository\javasoft\jars\jce-1.2.2.jar;C:\Documents and Settings\mwilson\.maven\repository\ant\jars\ant-1.5.jar;C:\Documents and Settings\mwilson\.maven\repository\hibernate\jars\hibernate-2.1.1.jar;C:\Documents and Settings\mwilson\.maven\repository\ehcache\jars\ehcache-0.5.jar;C:\Documents and Settings\mwilson\.maven\repository\jboss\jars\jbossall-client-3.2.1.jar;C:\Documents and Settings\mwilson\.maven\repository\jboss\jars\jboss-j2ee-3.2.1.jar, hibernate.show_sql=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', java.vm.specification.version=1.0, java.home=c:\j2sdk1.4.1_01\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:oracle:thin:@156.80.138.135:1521:fresnel, hibernate.dialect=net.sf.hibernate.dialect.OracleDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, hibernate.jdbc.use_streams_for_binary=true, java.version=1.4.1_01, java.ext.dirs=c:\j2sdk1.4.1_01\jre\lib\ext, sun.boot.class.path=c:\j2sdk1.4.1_01\jre\lib\rt.jar;c:\j2sdk1.4.1_01\jre\lib\i18n.jar;c:\j2sdk1.4.1_01\jre\lib\sunrsasign.jar;c:\j2sdk1.4.1_01\jre\lib\jsse.jar;c:\j2sdk1.4.1_01\jre\lib\jce.jar;c:\j2sdk1.4.1_01\jre\lib\charsets.jar;c:\j2sdk1.4.1_01\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=0, file.separator=\, hibernate.query.imports=net.sf.hibernate.test, net.sf.hibernate.eg, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.statement_cache.size=25, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
13:15:45,980 DEBUG SessionFactoryObjectFactory:76 - registered: 1cd00a07fc27d09e00fc27d0adbc0001 (unnamed)
13:15:45,980 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
13:15:45,980 DEBUG SessionFactoryImpl:196 - instantiated session factory
13:15:46,058 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.SystemNode, BulkBeanException: Property is private (property setAddressesCollection)
13:15:46,090 INFO ReflectHelper:160 - reflection optimizer disabled for: x.y.SocommAig, BulkBeanException: Property is private (property setProjectCodewordsCollection)
13:15:46,152 DEBUG SessionFactoryObjectFactory:76 - registered: 1cd00a07fc27d09e00fc27d0ae680002 (unnamed)
13:15:46,152 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
13:15:46,152 DEBUG SessionFactoryImpl:196 - instantiated session factory
sessionFactory = net.sf.hibernate.impl.SessionFactoryImpl@1732ed2
13:15:46,215 DEBUG SessionImpl:531 - opened session
13:15:46,215 DEBUG SessionImpl:1497 - find: FROM Gabber as genser
13:15:46,230 DEBUG QueryParameters:108 - named parameters: {}
13:15:46,246 DEBUG QueryTranslator:147 - compiling query
13:15:46,387 DEBUG SessionImpl:2210 - flushing session
13:15:46,387 DEBUG SessionImpl:2403 - Flushing entities and processing referenced collections
13:15:46,387 DEBUG SessionImpl:2746 - Processing unreferenced collections
13:15:46,387 DEBUG SessionImpl:2760 - Scheduling collection removes/(re)creates/updates
13:15:46,387 DEBUG SessionImpl:2234 - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
13:15:46,387 DEBUG SessionImpl:2239 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
13:15:46,387 DEBUG SessionImpl:1782 - Dont need to execute flush
13:15:46,387 DEBUG QueryTranslator:199 - HQL: FROM x.y.Gabber as genser
13:15:46,387 DEBUG QueryTranslator:200 - SQL: select Gabber0_.GENSER_AIG_CNID as GENSER_A1_, Gabber0_.VER_NUM as VER_NUM, Gabber0_.SYSTEM_NODE_CNID as SYSTEM_N3_, Gabber0_.VER_DATE as VER_DATE, Gabber0_.EXECUTE_DATE as EXECUTE_5_, Gabber0_.DELETED as DELETED, Gabber0_.ID as ID, Gabber0_.G_AIG_NAME as G_AIG_NAME from V_GENSER_AIG Gabber0_
13:15:46,387 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
13:15:46,387 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
13:15:46,387 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
13:15:46,387 DEBUG SQL:237 - select Gabber0_.GENSER_AIG_CNID as GENSER_A1_, Gabber0_.VER_NUM as VER_NUM, Gabber0_.SYSTEM_NODE_CNID as SYSTEM_N3_, Gabber0_.VER_DATE as VER_DATE, Gabber0_.EXECUTE_DATE as EXECUTE_5_, Gabber0_.DELETED as DELETED, Gabber0_.ID as ID, Gabber0_.G_AIG_NAME as G_AIG_NAME from V_GENSER_AIG Gabber0_
Hibernate: select Gabber0_.GENSER_AIG_CNID as GENSER_A1_, Gabber0_.VER_NUM as VER_NUM, Gabber0_.SYSTEM_NODE_CNID as SYSTEM_N3_, Gabber0_.VER_DATE as VER_DATE, Gabber0_.EXECUTE_DATE as EXECUTE_5_, Gabber0_.DELETED as DELETED, Gabber0_.ID as ID, Gabber0_.G_AIG_NAME as G_AIG_NAME from V_GENSER_AIG Gabber0_
13:15:46,387 DEBUG BatcherImpl:241 - preparing statement
13:15:46,433 DEBUG Loader:197 - processing result set
13:15:46,480 DEBUG Loader:405 - result row: x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]
13:15:46,496 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]
13:15:46,496 DEBUG Loader:605 - Hydrating entity: x.y.Gabber#x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]
13:15:46,496 DEBUG Loader:405 - result row: x.y.VersionId@1f1cbf6[1,0000000000XX1DKKBW1K7GXJMIU6IAAG]
13:15:46,496 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@1f1cbf6[1,0000000000XX1DKKBW1K7GXJMIU6IAAG]
13:15:46,496 DEBUG Loader:605 - Hydrating entity: x.y.Gabber#x.y.VersionId@1f1cbf6[1,0000000000XX1DKKBW1K7GXJMIU6IAAG]
13:15:46,496 DEBUG Loader:405 - result row: x.y.VersionId@11a4bd4[1,0000000000O3YU7FF6GRRBUT14F366AS]
13:15:46,512 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@11a4bd4[1,0000000000O3YU7FF6GRRBUT14F366AS]
13:15:46,512 DEBUG Loader:605 - Hydrating entity: x.y.Gabber#x.y.VersionId@11a4bd4[1,0000000000O3YU7FF6GRRBUT14F366AS]
13:15:46,512 DEBUG Loader:405 - result row: x.y.VersionId@18adae2[1,0000000000IM7BVSR8W882B2NHM55ZTH]
13:15:46,512 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@18adae2[1,0000000000IM7BVSR8W882B2NHM55ZTH]
13:15:46,512 DEBUG Loader:605 - Hydrating entity: x.y.Gabber#x.y.VersionId@18adae2[1,0000000000IM7BVSR8W882B2NHM55ZTH]
13:15:46,512 DEBUG Loader:405 - result row: x.y.VersionId@1522de2[1,00000000005D3YDY1G1J7KGCDHLX1BYB]
13:15:46,512 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@1522de2[1,00000000005D3YDY1G1J7KGCDHLX1BYB]
13:15:46,512 DEBUG Loader:605 - Hydrating entity: x.y.Gabber#x.y.VersionId@1522de2[1,00000000005D3YDY1G1J7KGCDHLX1BYB]
13:15:46,512 DEBUG Loader:226 - done processing result set (5 rows)
13:15:46,512 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
13:15:46,512 DEBUG BatcherImpl:261 - closing statement
13:15:46,512 DEBUG Loader:239 - total objects hydrated: 5
13:15:46,527 DEBUG SessionImpl:2166 - resolving associations for [x.y.Gabber#x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,527 DEBUG SessionImpl:1950 - loading [x.y.SystemNode#SCP_SITE_A]
13:15:46,527 DEBUG SessionImpl:2047 - attempting to resolve [x.y.SystemNode#SCP_SITE_A]
13:15:46,527 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.SystemNode#SCP_SITE_A]
13:15:46,527 DEBUG EntityPersister:416 - Materializing entity: [x.y.SystemNode#SCP_SITE_A]
13:15:46,527 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
13:15:46,527 DEBUG SQL:237 - select systemnode0_.SYSTEM_NODE_CNID as SYSTEM_N1_0_, systemnode0_.name as name0_, systemnode0_.oracle_schema as oracle_s3_0_ from SYSTEM_NODE systemnode0_ where systemnode0_.SYSTEM_NODE_CNID=?
Hibernate: select systemnode0_.SYSTEM_NODE_CNID as SYSTEM_N1_0_, systemnode0_.name as name0_, systemnode0_.oracle_schema as oracle_s3_0_ from SYSTEM_NODE systemnode0_ where systemnode0_.SYSTEM_NODE_CNID=?
13:15:46,527 DEBUG BatcherImpl:241 - preparing statement
13:15:46,543 DEBUG Loader:197 - processing result set
13:15:46,543 DEBUG Loader:405 - result row: SCP_SITE_A
13:15:46,543 DEBUG Loader:536 - Initializing object from ResultSet: SCP_SITE_A
13:15:46,543 DEBUG Loader:605 - Hydrating entity: x.y.SystemNode#SCP_SITE_A
13:15:46,543 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,543 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
13:15:46,543 DEBUG BatcherImpl:261 - closing statement
13:15:46,543 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,543 DEBUG SessionImpl:2166 - resolving associations for [x.y.SystemNode#SCP_SITE_A]
Gabber = x.y.Gabber@467991
13:15:46,605 DEBUG SessionImpl:3218 - initializing collection [x.y.Gabber.addressCollection#x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,605 DEBUG SessionImpl:3219 - checking second-level cache
13:15:46,605 DEBUG SessionImpl:3225 - collection not cached
13:15:46,605 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
13:15:46,605 DEBUG SQL:237 - select addresscol0_.ADDRESS_CNID as ADDRESS_3___, addresscol0_.ADDRESS_VER_NUM as ADDRESS_4___, addresscol0_.GENSER_AIG_CNID as GENSER_A1___, addresscol0_.GENSER_AIG_VER_NUM as GENSER_A2___, address1_.ADDRESS_CNID as ADDRESS_1_0_, address1_.VER_NUM as VER_NUM0_, address1_.VER_DATE as VER_DATE0_, address1_.EXECUTE_DATE as EXECUTE_4_0_, address1_.DELETED as DELETED0_, address1_.ID as ID0_, address1_.ADDRESS as ADDRESS0_, address1_.MAX_PRECEDENCE as MAX_PREC8_0_, address1_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address1_.GENSER_PREFIX as GENSER_10_0_, address1_.GENSER_EXTRA as GENSER_11_0_, address1_.DSSCS_SPECIAL as DSSCS_S12_0_, address1_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address1_.INTER_INTRA_FLAG as INTER_I14_0_, address1_.MESSAGE_FORMAT as MESSAGE15_0_, address1_.CITE as CITE0_ from V_G_AIG_ADDRESS_LINK addresscol0_, V_ADDRESS address1_ where addresscol0_.GENSER_AIG_CNID=? and addresscol0_.GENSER_AIG_VER_NUM=? and addresscol0_.ADDRESS_CNID=address1_.ADDRESS_CNID and addresscol0_.ADDRESS_VER_NUM=address1_.VER_NUM
Hibernate: select addresscol0_.ADDRESS_CNID as ADDRESS_3___, addresscol0_.ADDRESS_VER_NUM as ADDRESS_4___, addresscol0_.GENSER_AIG_CNID as GENSER_A1___, addresscol0_.GENSER_AIG_VER_NUM as GENSER_A2___, address1_.ADDRESS_CNID as ADDRESS_1_0_, address1_.VER_NUM as VER_NUM0_, address1_.VER_DATE as VER_DATE0_, address1_.EXECUTE_DATE as EXECUTE_4_0_, address1_.DELETED as DELETED0_, address1_.ID as ID0_, address1_.ADDRESS as ADDRESS0_, address1_.MAX_PRECEDENCE as MAX_PREC8_0_, address1_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address1_.GENSER_PREFIX as GENSER_10_0_, address1_.GENSER_EXTRA as GENSER_11_0_, address1_.DSSCS_SPECIAL as DSSCS_S12_0_, address1_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address1_.INTER_INTRA_FLAG as INTER_I14_0_, address1_.MESSAGE_FORMAT as MESSAGE15_0_, address1_.CITE as CITE0_ from V_G_AIG_ADDRESS_LINK addresscol0_, V_ADDRESS address1_ where addresscol0_.GENSER_AIG_CNID=? and addresscol0_.GENSER_AIG_VER_NUM=? and addresscol0_.ADDRESS_CNID=address1_.ADDRESS_CNID and addresscol0_.ADDRESS_VER_NUM=address1_.VER_NUM
13:15:46,605 DEBUG BatcherImpl:241 - preparing statement
13:15:46,621 DEBUG Loader:327 - result set contains (possibly empty) collection: [x.y.Gabber.addressCollection#x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,621 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,621 DEBUG Loader:197 - processing result set
13:15:46,637 DEBUG Loader:405 - result row: x.y.VersionId@74cb02[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,637 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@74cb02[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,637 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@74cb02[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,637 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@89e2f1[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,637 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,637 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,637 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,637 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,637 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,637 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,637 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,652 DEBUG BatcherImpl:241 - preparing statement
13:15:46,668 DEBUG Loader:197 - processing result set
13:15:46,668 DEBUG Loader:405 - result row: x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,668 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,668 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]
13:15:46,668 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,668 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,668 DEBUG BatcherImpl:261 - closing statement
13:15:46,668 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,668 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,683 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,715 DEBUG Loader:405 - result row: x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@278e83[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,715 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,715 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,715 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,715 DEBUG BatcherImpl:241 - preparing statement
13:15:46,730 DEBUG Loader:197 - processing result set
13:15:46,730 DEBUG Loader:405 - result row: x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,730 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,730 DEBUG BatcherImpl:261 - closing statement
13:15:46,746 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,746 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,746 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,746 DEBUG Loader:405 - result row: x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@12696c2[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,746 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,746 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,762 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,762 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,762 DEBUG BatcherImpl:241 - preparing statement
13:15:46,762 DEBUG Loader:197 - processing result set
13:15:46,762 DEBUG Loader:405 - result row: x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,762 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,777 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,777 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,777 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,777 DEBUG BatcherImpl:261 - closing statement
13:15:46,777 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,777 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,777 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.V


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:07 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
do you see what is wrong in generated sql?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:24 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
The generated sql is correct. When I copy and execute it, replacing the prepared statement parameters, it returns what i expect!


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:31 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
My origial post got cut off. Please append this to the first post.
Code:
13:15:46,668 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,668 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,683 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@b31b77[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,715 DEBUG Loader:405 - result row: x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,715 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@278e83[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,715 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,715 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,715 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,715 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,715 DEBUG BatcherImpl:241 - preparing statement
13:15:46,730 DEBUG Loader:197 - processing result set
13:15:46,730 DEBUG Loader:405 - result row: x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]
13:15:46,730 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,730 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,730 DEBUG BatcherImpl:261 - closing statement
13:15:46,746 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,746 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,746 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@3228a1[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,746 DEBUG Loader:405 - result row: x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,746 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@12696c2[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,746 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,746 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,746 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,762 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,762 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,762 DEBUG BatcherImpl:241 - preparing statement
13:15:46,762 DEBUG Loader:197 - processing result set
13:15:46,762 DEBUG Loader:405 - result row: x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,762 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,777 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]
13:15:46,777 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,777 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,777 DEBUG BatcherImpl:261 - closing statement
13:15:46,777 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,777 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,777 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@113e9fd[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,777 DEBUG Loader:405 - result row: x.y.VersionId@3f4ebd[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,777 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@3f4ebd[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,777 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@3f4ebd[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,793 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@1de891b[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,793 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,793 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,793 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,793 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,793 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,793 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,793 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,793 DEBUG BatcherImpl:241 - preparing statement
13:15:46,808 DEBUG Loader:197 - processing result set
13:15:46,808 DEBUG Loader:405 - result row: x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,808 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,808 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]
13:15:46,808 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,808 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,824 DEBUG BatcherImpl:261 - closing statement
13:15:46,824 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,824 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,824 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@13a34af[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,824 DEBUG Loader:405 - result row: x.y.VersionId@13b5a3a[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,824 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@13b5a3a[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,824 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@13b5a3a[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,840 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@15c97e4[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,840 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,840 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,840 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,840 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,840 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,840 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,840 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,840 DEBUG BatcherImpl:241 - preparing statement
13:15:46,855 DEBUG Loader:197 - processing result set
13:15:46,855 DEBUG Loader:405 - result row: x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,855 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,855 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]
13:15:46,855 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,855 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,855 DEBUG BatcherImpl:261 - closing statement
13:15:46,871 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,871 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,871 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@1478a2d[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,871 DEBUG Loader:405 - result row: x.y.VersionId@1bc4ec8[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,871 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@1bc4ec8[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,871 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@1bc4ec8[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,871 DEBUG Loader:292 - found row of collection: [x.y.Gabber.addressCollection#x.y.VersionId@1647278[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,871 DEBUG SessionImpl:2996 - new collection: instantiating
13:15:46,871 DEBUG SessionImpl:1950 - loading [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,871 DEBUG SessionImpl:2047 - attempting to resolve [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,871 DEBUG SessionImpl:2080 - object not resolved in any cache [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,871 DEBUG EntityPersister:416 - Materializing entity: [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,871 DEBUG BatcherImpl:196 - about to open: 1 open PreparedStatements, 1 open ResultSets
13:15:46,871 DEBUG SQL:237 - select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
Hibernate: select address0_.ADDRESS_CNID as ADDRESS_1_0_, address0_.VER_NUM as VER_NUM0_, address0_.VER_DATE as VER_DATE0_, address0_.EXECUTE_DATE as EXECUTE_4_0_, address0_.DELETED as DELETED0_, address0_.ID as ID0_, address0_.ADDRESS as ADDRESS0_, address0_.MAX_PRECEDENCE as MAX_PREC8_0_, address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_, address0_.GENSER_PREFIX as GENSER_10_0_, address0_.GENSER_EXTRA as GENSER_11_0_, address0_.DSSCS_SPECIAL as DSSCS_S12_0_, address0_.DSSCS_DESCRIPTION as DSSCS_D13_0_, address0_.INTER_INTRA_FLAG as INTER_I14_0_, address0_.MESSAGE_FORMAT as MESSAGE15_0_, address0_.CITE as CITE0_ from V_ADDRESS address0_ where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?
13:15:46,871 DEBUG BatcherImpl:241 - preparing statement
13:15:46,887 DEBUG Loader:197 - processing result set
13:15:46,887 DEBUG Loader:405 - result row: x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,887 DEBUG Loader:536 - Initializing object from ResultSet: x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,887 DEBUG Loader:605 - Hydrating entity: x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]
13:15:46,887 DEBUG Loader:226 - done processing result set (1 rows)
13:15:46,887 DEBUG BatcherImpl:203 - done closing: 1 open PreparedStatements, 1 open ResultSets
13:15:46,902 DEBUG BatcherImpl:261 - closing statement
13:15:46,902 DEBUG Loader:239 - total objects hydrated: 1
13:15:46,902 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,902 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@102a0a5[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,902 DEBUG Loader:226 - done processing result set (6 rows)
13:15:46,902 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
13:15:46,902 DEBUG BatcherImpl:261 - closing statement
13:15:46,902 DEBUG Loader:239 - total objects hydrated: 6
13:15:46,902 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@74cb02[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,902 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@74cb02[1,00000000004EESEBKF9GZGUPC4AU33R6]]
13:15:46,902 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,918 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@129e5e9[1,00000000004GQNS1IDAB722SZH5UFVJD]]
13:15:46,918 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,918 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@20807c[1,0000000000HI5Y2L76JJOTVEMK4HYEP4]]
13:15:46,918 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@3f4ebd[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,918 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@3f4ebd[1,0000000000MZDIAFYTVYYAEYIWR88OHD]]
13:15:46,918 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@13b5a3a[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,918 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@13b5a3a[1,0000000000OTG9Z1D3OTBDW3C01N30IM]]
13:15:46,918 DEBUG SessionImpl:2166 - resolving associations for [x.y.Address#x.y.VersionId@1bc4ec8[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,918 DEBUG SessionImpl:2190 - done materializing entity [x.y.Address#x.y.VersionId@1bc4ec8[1,0000000000S6WX1XIUQD5MCUK5FPG2C7]]
13:15:46,918 DEBUG SessionImpl:3043 - 7 collections were found in result set
13:15:46,918 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@89e2f1[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,949 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@1647278[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,949 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@12696c2[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,949 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@278e83[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,949 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@15c97e4[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,949 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@145f939[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,965 DEBUG SessionImpl:3061 - collection fully initialized: [x.y.Gabber.addressCollection#x.y.VersionId@1de891b[1,0000000000XM1VYH8AR40NTDYORJ8TC7]]
13:15:46,965 DEBUG SessionImpl:3064 - 7 collections initialized
13:15:46,965 DEBUG SessionImpl:3082 - initializing non-lazy collections
13:15:46,965 DEBUG SessionImpl:3227 - collection initialized
genserAig.getAddressCollection() = []


The junit test case:
Code:
...
import java.net.URL;
import java.util.Properties;

import junit.framework.TestCase;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;

/**
* @author Matthew L. Wilson
* @version $Revision: 1.1 $ $Date: 2004/04/22 20:38:55 $
*/
public class VersionedGenserAigTest extends TestCase
{

   public void testRetrieve() throws Exception
   {
      Properties props = new Properties();
      URL url = ClassLoader.getSystemResource("hibernate.properties");
      props.load(url.openStream());

      Configuration configuration = new Configuration().setProperties(props);

      configuration.addInputStream(getClass().getClassLoader().getResourceAsStream("...
      ..."));

      SessionFactory sessionFactory = configuration.buildSessionFactory();

      System.out.println("sessionFactory = " + sessionFactory);

      Session session = sessionFactory.openSession();
      Query query = session.createQuery("FROM GenserAig as genser");
      GenserAig genserAig = (GenserAig) query.list().iterator().next();
      System.out.println("genserAig = " + genserAig);
      System.out.println("genserAig.getAddressCollection() = " + genserAig.getAddressCollection());
   }
}


While working this i have captured the following queries that are executed:

Select the Gabber:
Code:
select
  Gabber0_.GABBER_CNID as G_AIG_CNID_A1_,
  Gabber0_.VER_NUM as VER_NUM,
  Gabber0_.SYSTEM_NODE_CNID as SYSTEM_N3_,
  Gabber0_.VER_DATE as VER_DATE,
  Gabber0_.EXECUTE_DATE as EXECUTE_5_,
  Gabber0_.DELETED as DELETED,
  Gabber0_.ID as ID, Gabber0_.G_AIG_NAME as G_AIG_NAME
from V_GABBER Gabber0_


Select the Gabber.systemNode:
Code:
select
  systemnode0_.SYSTEM_NODE_CNID as SYSTEM_N1_0_,
  systemnode0_.name as name0_,
  systemnode0_.oracle_schema as oracle_s3_0_
from SYSTEM_NODE systemnode0_
where systemnode0_.SYSTEM_NODE_CNID=?


Select the Gabber.addresses: This query returns one address after I commented out the id in the where clause.
Code:
select
  addresscol0_.ADDRESS_CNID as ADDRESS_3___,
  addresscol0_.ADDRESS_VER_NUM as ADDRESS_4___,
  addresscol0_.GENSER_AIG_CNID as GENSER_A1___,
  addresscol0_.GENSER_AIG_VER_NUM as GENSER_A2___,
  address1_.ADDRESS_CNID as ADDRESS_1_0_,
  address1_.VER_NUM as VER_NUM0_,
  address1_.VER_DATE as VER_DATE0_,
  address1_.EXECUTE_DATE as EXECUTE_4_0_,
  address1_.DELETED as DELETED0_,
  address1_.ID as ID0_,
  address1_.ADDRESS as ADDRESS0_,
  address1_.MAX_PRECEDENCE as MAX_PREC8_0_,
  address1_.MAX_CLASSIFICATION as MAX_CLAS9_0_,
  address1_.GENSER_PREFIX as GENSER_10_0_,
  address1_.GENSER_EXTRA as GENSER_11_0_,
  address1_.DSSCS_SPECIAL as DSSCS_S12_0_,
  address1_.DSSCS_DESCRIPTION as DSSCS_D13_0_,
  address1_.INTER_INTRA_FLAG as INTER_I14_0_,
  address1_.MESSAGE_FORMAT as MESSAGE15_0_,
  address1_.CITE as CITE0_
from
  V_G_AIG_ADDRESS_LINK addresscol0_,
  V_ADDRESS address1_
where /*addresscol0_.GENSER_AIG_CNID=?
  and addresscol0_.GENSER_AIG_VER_NUM=?
  and */addresscol0_.ADDRESS_CNID=address1_.ADDRESS_CNID
  and addresscol0_.ADDRESS_VER_NUM=address1_.VER_NUM



This is called multiple (seven) times? I think this is pointing to the problem, but I have not found anything:(

Code:
select
  address0_.ADDRESS_CNID as ADDRESS_1_0_,
  address0_.VER_NUM as VER_NUM0_,
  address0_.VER_DATE as VER_DATE0_,
  address0_.EXECUTE_DATE as EXECUTE_4_0_,
  address0_.DELETED as DELETED0_,
  address0_.ID as ID0_,
  address0_.ADDRESS as ADDRESS0_,
  address0_.MAX_PRECEDENCE as MAX_PREC8_0_,
  address0_.MAX_CLASSIFICATION as MAX_CLAS9_0_,
  address0_.GFIX as GENSER_10_0_,
  address0_.GTRA as GENSER_11_0_,
  address0_.DSECIAL as DSSCS_S12_0_,
  address0_.DPTION as DSSCS_D13_0_,
  address0_.INTER_INTRA_FLAG as INTER_I14_0_,
  address0_.MESSAGE_FORMAT as MESSAGE15_0_,
  address0_.CITE as CITE0_
from V_ADDRESS address0_
where address0_.ADDRESS_CNID=? and address0_.VER_NUM=?


The last line of debug is:
Code:
genserAig.getAddressCollection() = []

This shows that the Set of Addresses is empty.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:32 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
Code:
public class Gabber extends Versioned....
{

   private Collection addressesCollection;

   /**
    * @param addresses The addresses to set.
    */
   public void setAddressCollection(Collection addresses)
   {
      System.out.println("EXISTING address Collection: " + this.addressesCollection);
      System.out.println("In commiung address Collection: " + addresses);
      addressesCollection = addresses;
   }
   
   /**
    * @param addresses The addresses to set.
    */
   public Collection getAddressCollection()
   {

      System.out.println(this +" get address Collection: " + addressesCollection);

      return addressesCollection;
   }

}



where is VersionId?


have you tried with a specific composite id class for Adress instead of using the same as Grabber?

It's just a debug idea..


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:47 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
In the first post search for "The composite-id wrapper for Gabber:". This composite-id class is used in both Gabber and Address. Shouldn't be a problem that both have the same class type as an composite-id , but let me try that:)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 2:51 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
Nope.

I created a AddressVersionId, and got the same results.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 3:00 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
You asked "where is VersionId?". Sorry I misread that. The class that Gabber extends is:
Code:
public abstract class VersionedItem
{
   /** The version date of this ci (if it is versioned). * */
   private Date versionDate;
   /** The version baseline of this ci (if it is versioned and baselined). * */
   private String baselineId;
   /** The version id of this ci (if it is versioned). * */
   private VersionId versionId;

   /**
    * @return Returns the baselineId.
    */
   public String getBaselineId()
   {
      return baselineId;
   }

   /**
    * @param baselineId The baselineId to set.
    */
   public void setBaselineId(String baselineId)
   {
      this.baselineId = baselineId;
   }

   /**
    * @return Returns the versionDate.
    */
   public Date getVersionDate()
   {
      return versionDate;
   }

   /**
    * @param versionDate The versionDate to set.
    */
   public void setVersionDate(Date versionDate)
   {
      this.versionDate = versionDate;
   }

   /**
    * @return Returns the versionId.
    */
   public VersionId getVersionId()
   {
      return versionId;
   }

   /**
    * @param versionId The versionId to set.
    */
   public void setVersionId(VersionId versionId)
   {
      this.cnid = versionId.getCnid();
      this.versionId = versionId;
   }

   /**
    * Is this instance a versioned CI.
    *
    * @return Is this instance a versioned CI.
    */
   public boolean isVersioned()
   {
      return (versionId != null);
   }


}


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 3:30 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
last idea, try without inherance from VersionedItem, but i really don't know this is not working... strange


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 3:59 pm 
Newbie

Joined: Thu Apr 22, 2004 3:21 pm
Posts: 15
Nope:(

It is very strange that this is not working.

Has anyone mapped a set wehre bot teh owner and the chile had composite-id(s)?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Apr 26, 2004 4:11 pm 
Pro
Pro

Joined: Tue Aug 26, 2003 1:24 pm
Posts: 213
Location: Richardson, TX
Code:
Has anyone mapped a set wehre bot teh owner and the chile had composite-id(s)?


Yep. I was autogenerating the classes with hbm2java, as well. I didn't have any many-to-many relationships, though all other types.


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

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.