[Resolved] Unwanted updates when retrieving list of objects

henryju · **Joined:** Tue Sep 18, 2007 11:24 am **Posts:** 9

Hi all,

I'm using Hibernate + Spring and I want to get a list of all objects from a table. It works fine, but after I took a look at the Hibernate log, I saw after the select there were unwanted updates for EACH retrieved object of the list: very inefficient!

Thanks for any help !

Hibernate version:
Hibernate 3.2.5

Mapping documents:

Code:

<class name="Card" table="CARD">
        <id name="id" access="field">
            <generator class="native">
                <param name="sequence">card_id_sequence</param>
            </generator>
        </id>
        <property name="title" length="50" not-null="true"/>
        <property name="creationDate" not-null="true"/>
        <many-to-one name="originator" class="ThalesEmployee" column="ORIGINATOR_SIA" not-null="true" />
        <property name="originatorService" length="3" not-null="true"/>
        <many-to-one name="costCenterResponsible" class="ThalesEmployee" column="COST_CENTER_RESP_SIA" not-null="true"/>
        <property name="draft"/>
        <property name="description" length="300"/>
        <set name="possibleFinancialSources" table="CARD_OUTSIDE_CUST" access="field">
            <key column="card_id"/>
            <many-to-many class="OutsideCustomer" column="CUSTOMER_ID"/>
        </set>
        <property name="moreFinancialSources" length="300"/>
        <property name="newIdea"/>
        <many-to-one name="primaryDomain" class="PrimaryDomain" column="PRIMARY_DOMAIN_ID"/>
        <set name="secondaryDomains" table="CARD_SECONDARY_DOMAIN" access="field">
            <key column="card_id"/>
            <many-to-many class="SecondaryDomain" column="DOMAIN_ID"/>
        </set>
        <many-to-one name="originatorPriority" class="OriginatorPriority" column="PRIORITY_ID"/>
        <property name="locationOrTraceabilityInARoadmap" column="LOCATION" length="300"/>
        <property name="justification" length="300"/>
        <property name="returnOnInvestment" length="300"/>
        <property name="linkWithOtherPrograms" length="300"/>
        <property name="linkWithOtherStudies" length="300"/>
        <property name="mainTechnicalObjectives" column="MAIN_TECH_OBJ" length="300"/>
        <property name="mainStudySteps" length="300"/>
        <property name="firstContact" length="200"/>
        <set name="studyOutputs" table="CARD_STUDY_OUTPUT" access="field">
            <key column="card_id"/>
            <many-to-many class="StudyOutput" column="OUTPUT_ID"/>
        </set>
        <many-to-one name="hierarchicalResp" class="ThalesEmployee" column="HIERARCHICAL_RESP_SIA"/>
        <set name="readers" table="CARD_READER" access="field">
            <key column="card_id"/>
            <many-to-many class="ThalesEmployee" column="READER_SIA"/>
        </set>
        <set name="modifiers" table="CARD_MODIFIER" access="field">
            <key column="card_id"/>
            <many-to-many class="ThalesEmployee" column="MODIFIER_SIA"/>
        </set>
        <component name="budget" class="Budget" access="field">
            <parent name="card"/><!--  access="field" when allowed HHH-1614 -->
            <property name="startDate" column="BUDGET_START_DATE" access="field" />
            <property name="predictedDurationYear" column="BUDGET_DURATION_Y" access="field" />
            <set name="yearDetails" table="BUDGET_YEAR_DETAIL" sort="natural" inverse="true" cascade="all-delete-orphan">
                <key foreign-key="id" column="CARD_ID"/>
                <one-to-many class="YearDetail"/>
            </set>
        </component>
        <property name="majorComments" length="300"/>
    </class>

Code between sessionFactory.openSession() and session.close():
I'm using Spring:

Code:

return hibernateTemplate.loadAll(Card.class);

Name and version of the database you are using:
Oracle 9i

The generated SQL (show_sql=true):

Code:

/* criteria query */ select
        this_.id as id6_0_,
        this_.title as title6_0_,
        this_.creationDate as creation3_6_0_,
        this_.ORIGINATOR_SIA as ORIGINATOR4_6_0_,
        this_.originatorService as originat5_6_0_,
        this_.COST_CENTER_RESP_SIA as COST6_6_0_,
        this_.draft as draft6_0_,
        this_.description as descript8_6_0_,
        this_.moreFinancialSources as moreFina9_6_0_,
        this_.newIdea as newIdea6_0_,
        this_.PRIMARY_DOMAIN_ID as PRIMARY11_6_0_,
        this_.PRIORITY_ID as PRIORITY12_6_0_,
        this_.LOCATION as LOCATION6_0_,
        this_.justification as justifi14_6_0_,
        this_.returnOnInvestment as returnO15_6_0_,
        this_.linkWithOtherPrograms as linkWit16_6_0_,
        this_.linkWithOtherStudies as linkWit17_6_0_,
        this_.MAIN_TECH_OBJ as MAIN18_6_0_,
        this_.mainStudySteps as mainStu19_6_0_,
        this_.firstContact as firstCo20_6_0_,
        this_.HIERARCHICAL_RESP_SIA as HIERARC21_6_0_,
        this_.BUDGET_START_DATE as BUDGET22_6_0_,
        this_.BUDGET_DURATION_Y as BUDGET23_6_0_,
        this_.majorComments as majorCo24_6_0_ 
    from
        CARD this_
/* update
        com.mycustomer.myappli.beans.Card */ update
            CARD 
        set
            title=?,
            creationDate=?,
            ORIGINATOR_SIA=?,
            originatorService=?,
            COST_CENTER_RESP_SIA=?,
            draft=?,
            description=?,
            moreFinancialSources=?,
            newIdea=?,
            PRIMARY_DOMAIN_ID=?,
            PRIORITY_ID=?,
            LOCATION=?,
            justification=?,
            returnOnInvestment=?,
            linkWithOtherPrograms=?,
            linkWithOtherStudies=?,
            MAIN_TECH_OBJ=?,
            mainStudySteps=?,
            firstContact=?,
            HIERARCHICAL_RESP_SIA=?,
            BUDGET_START_DATE=?,
            BUDGET_DURATION_Y=?,
            majorComments=? 
        where
            id=?

...
one update for each returned row

Debug level Hibernate log excerpt:
[quote]813 INFO [main] org.hibernate.cfg.Environment : Hibernate 3.2.5
829 INFO [main] org.hibernate.cfg.Environment : hibernate.properties not found
829 INFO [main] org.hibernate.cfg.Environment : Bytecode provider name : cglib
829 INFO [main] org.hibernate.cfg.Environment : using JDK 1.4 java.sql.Timestamp handling
923 INFO [main] org.hibernate.cfg.Configuration : configuring from url: file:/D:/Projets/Alcatel/myapp/target/classes/hibernate.cfg.xml
1001 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
1001 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1001 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.show_sql=true
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.format_sql=true
1048 DEBUG [main] org.hibernate.cfg.Configuration : use_sql_comments=true
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.hbm2ddl.auto=update
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.query.substitutions=true 1, false 0
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
1048 DEBUG [main] org.hibernate.cfg.Configuration : hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
1048 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@11e0c13 [Attribute: name resource value "Domain.hbm.xml"]
1048 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : Domain.hbm.xml
1048 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1048 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1048 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1205 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.Domain -> Domain
1220 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> DOMAIN_ID
1236 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: name -> name
1236 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Domain.readers -> DOMAIN_READERS
1252 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: readers
1252 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: visible -> visible
1299 INFO [main] org.hibernate.cfg.HbmBinder : Mapping union-subclass: com.mycustomer.myapp.beans.PrimaryDomain -> PRIMARY_DOMAIN
1299 INFO [main] org.hibernate.cfg.HbmBinder : Mapping union-subclass: com.mycustomer.myapp.beans.SecondaryDomain -> SECONDARY_DOMAIN
1299 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@e79839 [Attribute: name resource value "CustomerEmployee.hbm.xml"]
1299 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : CustomerEmployee.hbm.xml
1299 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1299 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1299 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1346 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.CustomerEmployee -> LAE_ANNUAIRE
1346 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: sia -> PER_SIA
1346 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: firstname -> PER_PNO
1346 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: lastname -> PER_NOM
1486 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: service -> CAN_COD
1486 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@542529 [Attribute: name resource value "Service.hbm.xml"]
1486 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : Service.hbm.xml
1502 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1502 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1502 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1549 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.Service -> RFG_CAN
1549 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: code -> CAN_COD
1549 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: costCenterResponsible -> PER_RSP
1549 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@f0b7f8 [Attribute: name resource value "Card.hbm.xml"]
1549 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : Card.hbm.xml
1549 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1549 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1549 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1612 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.Card -> CARD
1612 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> id
1612 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: title -> title
1612 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: creationDate -> creationDate
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: originator -> ORIGINATOR_SIA
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: originatorService -> originatorService
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: costCenterResponsible -> COST_CENTER_RESP_SIA
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: draft -> draft
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: description -> description
1627 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.possibleFinancialSources -> CARD_OUTSIDE_CUST
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: possibleFinancialSources
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: moreFinancialSources -> moreFinancialSources
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: newIdea -> newIdea
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: primaryDomain -> PRIMARY_DOMAIN_ID
1627 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.secondaryDomains -> CARD_SECONDARY_DOMAIN
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: secondaryDomains
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: originatorPriority -> PRIORITY_ID
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: locationOrTraceabilityInARoadmap -> LOCATION
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: justification -> justification
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: returnOnInvestment -> returnOnInvestment
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: linkWithOtherPrograms -> linkWithOtherPrograms
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: linkWithOtherStudies -> linkWithOtherStudies
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: mainTechnicalObjectives -> MAIN_TECH_OBJ
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: mainStudySteps -> mainStudySteps
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: firstContact -> firstContact
1627 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.studyOutputs -> CARD_STUDY_OUTPUT
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: studyOutputs
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: hierarchicalResp -> HIERARCHICAL_RESP_SIA
1627 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.readers -> CARD_READER
1627 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: readers
1627 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.modifiers -> CARD_MODIFIER
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: modifiers
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: startDate -> BUDGET_START_DATE
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: predictedDurationYear -> BUDGET_DURATION_Y
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: yearDetails
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: budget -> BUDGET_START_DATE, BUDGET_DURATION_Y
1643 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: majorComments -> majorComments
1643 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@13e754f [Attribute: name resource value "YearDetail.hbm.xml"]
1643 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : YearDetail.hbm.xml
1643 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1643 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1643 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1674 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.YearDetail -> YearDetail
1674 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> id
1674 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: year -> year
1674 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: parent -> card_id
1674 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: internalFundingBudget -> internalFundingBudget
1674 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: externalFinance -> externalFinance
1674 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@15f7107 [Attribute: name resource value "OutsideCustomer.hbm.xml"]
1674 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : OutsideCustomer.hbm.xml
1690 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1690 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1690 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1705 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.OutsideCustomer -> OUTSIDE_CUSTOMER
1705 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> CUSTOMER_ID
1705 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: name -> name
1705 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: visible -> visible
1705 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@b2c6a6 [Attribute: name resource value "OriginatorPriority.hbm.xml"]
1705 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : OriginatorPriority.hbm.xml
1705 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1705 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1705 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1799 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.OriginatorPriority -> ORIGINATOR_PRIORITY
1799 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> PRIORITY_ID
1799 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: name -> name
1799 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: visible -> visible
1815 DEBUG [main] org.hibernate.cfg.Configuration : null<-org.dom4j.tree.DefaultAttribute@48edb5 [Attribute: name resource value "StudyOutput.hbm.xml"]
1815 INFO [main] org.hibernate.cfg.Configuration : Reading mappings from resource : StudyOutput.hbm.xml
1815 DEBUG [main] org.hibernate.util.DTDEntityResolver : trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1815 DEBUG [main] org.hibernate.util.DTDEntityResolver : recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1815 DEBUG [main] org.hibernate.util.DTDEntityResolver : located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1846 INFO [main] org.hibernate.cfg.HbmBinder : Mapping class: com.mycustomer.myapp.beans.StudyOutput -> STUDY_OUTPUT
1846 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: id -> OUTPUT_ID
1846 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: name -> name
1846 DEBUG [main] org.hibernate.cfg.HbmBinder : Mapped property: visible -> visible
1846 INFO [main] org.hibernate.cfg.Configuration : Configured SessionFactory: null
1846 DEBUG [main] org.hibernate.cfg.Configuration : properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_09\jre\bin, java.vm.version=1.5.0_09-b03, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=FR, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\Projets\Alcatel\myapp, java.runtime.version=1.5.0_09-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_09\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\jhenry\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, use_sql_comments=true, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_09\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Fichiers communs\Accelrys\Accord 6\System\;c:\bea\jrockit81sp1_141_03\bin;D:\Oracle\XEClient\bin;D:\jhenry\javacc-4.0\bin;D:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Fichiers communs\GTK\2.0\bin;C:\PROGRA~1\WINCVS~1.3\CVSNT;d:\build\bin;D:\jhenry\maven-1.0.2\bin;D:\jhenry\maven-2.0.6\bin;C:\Program Files\Subversion\bin;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;C:\Program Files\apache-ant-1.6.5/bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\ESTsoft\ALZip\;C:\Program Files\Microsoft Visual Studio 8\VC\bin;C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\ESTsoft\ALZip\, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\jhenry, user.timezone=, hibernate.connection.release_mode=on_close, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.format_sql=true, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, user.name=jhenry, java.class.path=D:\Projets\Alcatel\myapp\target\test-classes;D:\Projets\Alcatel\myapp\target\classes;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-jdbc\2.0.6\spring-jdbc-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-core\3.0.17-SNAPSHOT\jfox-core-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\fop\fop\0.20.5\fop-0.20.5.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-httpclient\commons-httpclient\3.1-rc1\commons-httpclient-3.1-rc1.jar;C:\Documents and Settings\jhenry\.m2\repository\batik\batik-1.5-fop\0.20-5\batik-1.5-fop-0.20-5.jar;C:\Documents and Settings\jhenry\.m2\repository\asm\asm\1.5.3\asm-1.5.3.jar;C:\Documents and Settings\jhenry\.m2\repository\jaxen\jaxen\1.1-beta-6\jaxen-1.1-beta-6.jar;C:\Documents and Settings\jhenry\.m2\repository\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;C:\Documents and Settings\jhenry\.m2\repository\org\ccil\cowan\tagsoup\tagsoup\0.9.7\tagsoup-0.9.7.jar;C:\Documents and Settings\jhenry\.m2\repository\batik\batik-transcoder\1.6\batik-transcoder-1.6.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-hibernate3\2.0.6\spring-hibernate3-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-tools-passwordManager\3.0.17-SNAPSHOT\jfox-tools-passwordManager-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\xom\xom\1.0b3\xom-1.0b3.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-commons\3.0.17-SNAPSHOT\jfox-commons-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\log4j\log4j\1.2.13\log4j-1.2.13.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-beans\2.0.6\spring-beans-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\javax\transaction\jta\1.0.1B\jta-1.0.1B.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-core\2.0.6\spring-core-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\xalan\xalan\2.6.0\xalan-2.6.0.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-dao\2.0.6\spring-dao-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\org\hibernate\hibernate\3.2.5.ga\hibernate-3.2.5.ga.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-codec\commons-codec\1.2\commons-codec-1.2.jar;C:\Documents and Settings\jhenry\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\javax\jms\jms\1.1\jms-1.1.jar;C:\Documents and Settings\jhenry\.m2\repository\fr\w4\wfjlib\1.0\wfjlib-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-pool\commons-pool\1.2\commons-pool-1.2.jar;C:\Documents and Settings\jhenry\.m2\repository\xerces\xercesImpl\2.6.0\xercesImpl-2.6.0.jar;C:\Documents and Settings\jhenry\.m2\repository\net\sf\ehcache\ehcache\1.2.3\ehcache-1.2.3.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-dbcp\commons-dbcp\1.2.1\commons-dbcp-1.2.1.jar;C:\Documents and Settings\jhenry\.m2\repository\jdom\jdom\1.0\jdom-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-logging\commons-logging\1.0.4\commons-logging-1.0.4.jar;C:\Documents and Settings\jhenry\.m2\repository\lotus\notes\1.0\notes-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-web\2.0.6\spring-web-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\xerces\xmlParserAPIs\2.6.2\xmlParserAPIs-2.6.2.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-context\2.0.6\spring-context-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\asm\asm-attrs\1.5.3\asm-attrs-1.5.3.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-io\commons-io\1.3.1\commons-io-1.3.1.jar;C:\Documents and Settings\jhenry\.m2\repository\ojdbc\ojdbc\14\ojdbc-14.jar;C:\Documents and Settings\jhenry\.m2\repository\avalon\avalon-framework\4.1.4\avalon-framework-4.1.4.jar;C:\Documents and Settings\jhenry\.m2\repository\junit\junit\3.8.2\junit-3.8.2.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-collections\commons-collections\2.1.1\commons-collections-2.1.1.jar;C:\Documents and Settings\jhenry\.m2\repository\com\ibm\icu\icu4j\2.6.1\icu4j-2.6.1.jar;C:\Documents and Settings\jhenry\.m2\repository\com\mycustomer\ifged\ifged-java\1.0.0\ifged-java-1.0.0.jar;C:\Documents and Settings\jhenry\.m2\repository\antlr\antlr\2.7.6\antlr-2.7.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-log\3.0.17-SNAPSHOT\jfox-log-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\weblogic\weblogic\8.1\weblogic-8.1.jar;C:\Documents and Settings\jhenry\.m2\repository\org\directwebremoting\dwr\2.0.1\dwr-2.0.1.jar;C:\Documents and Settings\jhenry\.m2\repository\logkit\logkit\2.0\logkit-2.0.jar;C:\Documents and Settings\jhenry\.m2\repository\cglib\cglib\2.1_3\cglib-2.1_3.jar;/D:/jhenry/eclipse-3.3/configuration/org.eclipse.osgi/bundles/192/1/.cp/;/D:/jhenry/eclipse-3.3/configuration/org.eclipse.osgi/bundles/190/1/.cp/, hibernate.bytecode.use_reflection_optimizer=false, hibernate.query.substitutions=true 1, false 0, hibernate.use_sql_comments=true, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_09\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle10gDialect, user.language=fr, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.5.0_09, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_09\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_09\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_09\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.hbm2ddl.auto=update, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=}
1862 DEBUG [main] org.hibernate.cfg.Configuration : Preparing to build session factory with filters : {}
1862 DEBUG [main] org.hibernate.cfg.Configuration : processing extends queue
1862 DEBUG [main] org.hibernate.cfg.Configuration : processing collection mappings
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Domain.readers
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: domain_id, element: reader_sia
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.possibleFinancialSources
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: card_id, element: CUSTOMER_ID
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.secondaryDomains
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: card_id, element: DOMAIN_ID
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.studyOutputs
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: card_id, element: OUTPUT_ID
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.readers
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: card_id, element: READER_SIA
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.modifiers
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: card_id, element: MODIFIER_SIA
1862 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Second pass for collection: com.mycustomer.myapp.beans.Card.budget.yearDetails
1862 INFO [main] org.hibernate.cfg.HbmBinder : Mapping collection: com.mycustomer.myapp.beans.Card.budget.yearDetails -> YearDetail
1878 DEBUG [main] org.hibernate.cfg.CollectionSecondPass : Mapped collection key: CARD_ID, one-to-many: com.mycustomer.myapp.beans.YearDetail
1878 DEBUG [main] org.hibernate.cfg.Configuration : processing native query and ResultSetMapping mappings
1878 DEBUG [main] org.hibernate.cfg.Configuration : processing association property references
1878 DEBUG [main] org.hibernate.cfg.Configuration : processing foreign key constraints
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.OriginatorPriority
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.PrimaryDomain
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.OutsideCustomer
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.SecondaryDomain
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.StudyOutput
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Domain
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.CustomerEmployee
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Service
1878 DEBUG [main] org.hibernate.cfg.Configuration : resolving reference to class: com.mycustomer.myapp.beans.Card
1972 INFO [main] org.hibernate.connection.ConnectionProviderFactory : Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2535 INFO [main] org.hibernate.cfg.SettingsFactory : RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
2535 INFO [main] org.hibernate.cfg.SettingsFactory : JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
2566 INFO [main] org.hibernate.dialect.Dialect : Using dialect: org.hibernate.dialect.Oracle10gDialect
2566 INFO [main] org.hibernate.transaction.TransactionFactoryFactory : Using default transaction strategy (direct JDBC transactions)
2582 INFO [main] org.hibernate.transaction.TransactionManagerLookupFactory : No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Automatic flush during beforeCompletion(): disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Automatic session close at end of transaction: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : JDBC batch size: 15
2582 INFO [main] org.hibernate.cfg.SettingsFactory : JDBC batch updates for versioned data: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Scrollable result sets: enabled
2582 DEBUG [main] org.hibernate.cfg.SettingsFactory : Wrap result sets: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : JDBC3 getGeneratedKeys(): disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Connection release mode: on_close
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Default batch fetch size: 1
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Generate SQL with comments: enabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Order SQL updates by primary key: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Order SQL inserts for batching: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2582 INFO [main] org.hibernate.hql.ast.ASTQueryTranslatorFactory : Using ASTQueryTranslatorFactory
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Query language substitutions: {true=1, false=0}
2582 INFO [main] org.hibernate.cfg.SettingsFactory : JPA-QL strict compliance: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Second-level cache: enabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Query cache: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Cache provider: org.hibernate.cache.NoCacheProvider
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Optimize cache for minimal puts: disabled
2582 INFO [main] org.hibernate.cfg.SettingsFactory : Structured second-level cache entries: disabled
2582 DEBUG [main] org.hibernate.exception.SQLExceptionConverterFactory : Using dialect defined converter
2598 INFO [main] org.hibernate.cfg.SettingsFactory : Echoing all SQL to stdout
2598 INFO [main] org.hibernate.cfg.SettingsFactory : Statistics: disabled
2598 INFO [main] org.hibernate.cfg.SettingsFactory : Deleted entity synthetic identifier rollback: disabled
2598 INFO [main] org.hibernate.cfg.SettingsFactory : Default entity-mode: pojo
2598 INFO [main] org.hibernate.cfg.SettingsFactory : Named query checking : enabled
2644 INFO [main] org.hibernate.impl.SessionFactoryImpl : building session factory
2644 DEBUG [main] org.hibernate.impl.SessionFactoryImpl : Session factory constructed with filter configurations : {}
2644 DEBUG [main] org.hibernate.impl.SessionFactoryImpl : instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_09\jre\bin, java.vm.version=1.5.0_09-b03, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=FR, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\Projets\Alcatel\myapp, java.runtime.version=1.5.0_09-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_09\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\jhenry\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, use_sql_comments=true, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_09\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Fichiers communs\Accelrys\Accord 6\System\;c:\bea\jrockit81sp1_141_03\bin;D:\Oracle\XEClient\bin;D:\jhenry\javacc-4.0\bin;D:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Fichiers communs\GTK\2.0\bin;C:\PROGRA~1\WINCVS~1.3\CVSNT;d:\build\bin;D:\jhenry\maven-1.0.2\bin;D:\jhenry\maven-2.0.6\bin;C:\Program Files\Subversion\bin;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;C:\Program Files\apache-ant-1.6.5/bin;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\Program Files\ESTsoft\ALZip\;C:\Program Files\Microsoft Visual Studio 8\VC\bin;C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\ESTsoft\ALZip\, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\jhenry, user.timezone=, hibernate.connection.release_mode=on_close, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.format_sql=true, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, java.class.path=D:\Projets\Alcatel\myapp\target\test-classes;D:\Projets\Alcatel\myapp\target\classes;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-jdbc\2.0.6\spring-jdbc-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-core\3.0.17-SNAPSHOT\jfox-core-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\fop\fop\0.20.5\fop-0.20.5.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-httpclient\commons-httpclient\3.1-rc1\commons-httpclient-3.1-rc1.jar;C:\Documents and Settings\jhenry\.m2\repository\batik\batik-1.5-fop\0.20-5\batik-1.5-fop-0.20-5.jar;C:\Documents and Settings\jhenry\.m2\repository\asm\asm\1.5.3\asm-1.5.3.jar;C:\Documents and Settings\jhenry\.m2\repository\jaxen\jaxen\1.1-beta-6\jaxen-1.1-beta-6.jar;C:\Documents and Settings\jhenry\.m2\repository\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;C:\Documents and Settings\jhenry\.m2\repository\org\ccil\cowan\tagsoup\tagsoup\0.9.7\tagsoup-0.9.7.jar;C:\Documents and Settings\jhenry\.m2\repository\batik\batik-transcoder\1.6\batik-transcoder-1.6.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-hibernate3\2.0.6\spring-hibernate3-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-tools-passwordManager\3.0.17-SNAPSHOT\jfox-tools-passwordManager-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\xom\xom\1.0b3\xom-1.0b3.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-commons\3.0.17-SNAPSHOT\jfox-commons-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\log4j\log4j\1.2.13\log4j-1.2.13.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-beans\2.0.6\spring-beans-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\javax\transaction\jta\1.0.1B\jta-1.0.1B.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-core\2.0.6\spring-core-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\xalan\xalan\2.6.0\xalan-2.6.0.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-dao\2.0.6\spring-dao-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\org\hibernate\hibernate\3.2.5.ga\hibernate-3.2.5.ga.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-codec\commons-codec\1.2\commons-codec-1.2.jar;C:\Documents and Settings\jhenry\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\javax\jms\jms\1.1\jms-1.1.jar;C:\Documents and Settings\jhenry\.m2\repository\fr\w4\wfjlib\1.0\wfjlib-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-pool\commons-pool\1.2\commons-pool-1.2.jar;C:\Documents and Settings\jhenry\.m2\repository\xerces\xercesImpl\2.6.0\xercesImpl-2.6.0.jar;C:\Documents and Settings\jhenry\.m2\repository\net\sf\ehcache\ehcache\1.2.3\ehcache-1.2.3.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-dbcp\commons-dbcp\1.2.1\commons-dbcp-1.2.1.jar;C:\Documents and Settings\jhenry\.m2\repository\jdom\jdom\1.0\jdom-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-logging\commons-logging\1.0.4\commons-logging-1.0.4.jar;C:\Documents and Settings\jhenry\.m2\repository\lotus\notes\1.0\notes-1.0.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-web\2.0.6\spring-web-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\xerces\xmlParserAPIs\2.6.2\xmlParserAPIs-2.6.2.jar;C:\Documents and Settings\jhenry\.m2\repository\org\springframework\spring-context\2.0.6\spring-context-2.0.6.jar;C:\Documents and Settings\jhenry\.m2\repository\asm\asm-attrs\1.5.3\asm-attrs-1.5.3.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-io\commons-io\1.3.1\commons-io-1.3.1.jar;C:\Documents and Settings\jhenry\.m2\repository\ojdbc\ojdbc\14\ojdbc-14.jar;C:\Documents and Settings\jhenry\.m2\repository\avalon\avalon-framework\4.1.4\avalon-framework-4.1.4.jar;C:\Documents and Settings\jhenry\.m2\repository\junit\junit\3.8.2\junit-3.8.2.jar;C:\Documents and Settings\jhenry\.m2\repository\commons-collections\commons-collections\2.1.1\commons-collections-2.1.1.jar;C:\Documents and Settings\jhenry\.m2\repository\com\ibm\icu\icu4j\2.6.1\icu4j-2.6.1.jar;C:\Documents and Settings\jhenry\.m2\repository\com\mycustomer\ifged\ifged-java\1.0.0\ifged-java-1.0.0.jar;C:\Documents and Settings\jhenry\.m2\repository\antlr\antlr\2.7.6\antlr-2.7.6.jar;C:\Documents and Settings\jhenry\.m2\repository\com\capgemini\sud\jfox\jfox-log\3.0.17-SNAPSHOT\jfox-log-3.0.17-SNAPSHOT.jar;C:\Documents and Settings\jhenry\.m2\repository\weblogic\weblogic\8.1\weblogic-8.1.jar;C:\Documents and Settings\jhenry\.m2\repository\org\directwebremoting\dwr\2.0.1\dwr-2.0.1.jar;C:\Documents and Settings\jhenry\.m2\repository\logkit\logkit\2.0\logkit-2.0.jar;C:\Documents and Settings\jhenry\.m2\repository\cglib\cglib\2.1_3\cglib-2.1_3.jar;/D:/jhenry/eclipse-3.3/configuration/org.eclipse.osgi/bundles/192/1/.cp/;/D:/jhenry/eclipse-3.3/configuration/org.eclipse.osgi/bundles/190/1/.cp/, user.name=jhenry, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, hibernate.use_sql_comments=true, hibernate.query.substitutions=true 1, false 0, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jdk1.5.0_09\jre, hibernate.dialect=org.hibernate.dialect.Oracle10gDialect, java.specification.vendor=Sun Microsystems Inc., user.language=fr, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.5.0_09, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_09\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_09\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_09\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_09\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.hbm2ddl.auto=update, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=}
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.StudyOutput
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.StudyOutput */ select OUTPUT_ID from STUDY_OUTPUT where OUTPUT_ID =?
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.StudyOutput */ select studyoutpu_.OUTPUT_ID, studyoutpu_.name as name15_, studyoutpu_.visible as visible15_ from STUDY_OUTPUT studyoutpu_ where studyoutpu_.OUTPUT_ID=?
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.StudyOutput */ insert into STUDY_OUTPUT (name, visible, OUTPUT_ID) values (?, ?, ?)
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.StudyOutput */ update STUDY_OUTPUT set name=?, visible=? where OUTPUT_ID=?
3036 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.StudyOutput */ delete from STUDY_OUTPUT where OUTPUT_ID=?
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.OutsideCustomer
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.OutsideCustomer */ select CUSTOMER_ID from OUTSIDE_CUSTOMER where CUSTOMER_ID =?
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.OutsideCustomer */ select outsidecus_.CUSTOMER_ID, outsidecus_.name as name13_, outsidecus_.visible as visible13_ from OUTSIDE_CUSTOMER outsidecus_ where outsidecus_.CUSTOMER_ID=?
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.OutsideCustomer */ insert into OUTSIDE_CUSTOMER (name, visible, CUSTOMER_ID) values (?, ?, ?)
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.OutsideCustomer */ update OUTSIDE_CUSTOMER set name=?, visible=? where CUSTOMER_ID=?
3051 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.OutsideCustomer */ delete from OUTSIDE_CUSTOMER where CUSTOMER_ID=?
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.PrimaryDomain
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.PrimaryDomain */ select DOMAIN_ID from PRIMARY_DOMAIN where DOMAIN_ID =?
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.PrimaryDomain */ select primarydom_.DOMAIN_ID, primarydom_.name as name0_, primarydom_.visible as visible0_ from PRIMARY_DOMAIN primarydom_ where primarydom_.DOMAIN_ID=?
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.PrimaryDomain */ insert into PRIMARY_DOMAIN (name, visible, DOMAIN_ID) values (?, ?, ?)
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.PrimaryDomain */ update PRIMARY_DOMAIN set name=?, visible=? where DOMAIN_ID=?
3067 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.PrimaryDomain */ delete from PRIMARY_DOMAIN where DOMAIN_ID=?
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.OriginatorPriority
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.OriginatorPriority */ select PRIORITY_ID from ORIGINATOR_PRIORITY where PRIORITY_ID =?
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.OriginatorPriority */ select originator_.PRIORITY_ID, originator_.name as name14_, originator_.visible as visible14_ from ORIGINATOR_PRIORITY originator_ where originator_.PRIORITY_ID=?
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.OriginatorPriority */ insert into ORIGINATOR_PRIORITY (name, visible, PRIORITY_ID) values (?, ?, ?)
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.OriginatorPriority */ update ORIGINATOR_PRIORITY set name=?, visible=? where PRIORITY_ID=?
3083 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.OriginatorPriority */ delete from ORIGINATOR_PRIORITY where PRIORITY_ID=?
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.Card
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.Card */ select id from CARD where id =?
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.Card */ select card_.id, card_.title as title6_, card_.creationDate as creation3_6_, card_.ORIGINATOR_SIA as ORIGINATOR4_6_, card_.originatorService as originat5_6_, card_.COST_CENTER_RESP_SIA as COST6_6_, card_.draft as draft6_, card_.description as descript8_6_, card_.moreFinancialSources as moreFina9_6_, card_.newIdea as newIdea6_, card_.PRIMARY_DOMAIN_ID as PRIMARY11_6_, card_.PRIORITY_ID as PRIORITY12_6_, card_.LOCATION as LOCATION6_, card_.justification as justifi14_6_, card_.returnOnInvestment as returnO15_6_, card_.linkWithOtherPrograms as linkWit16_6_, card_.linkWithOtherStudies as linkWit17_6_, card_.MAIN_TECH_OBJ as MAIN18_6_, card_.mainStudySteps as mainStu19_6_, card_.firstContact as firstCo20_6_, card_.HIERARCHICAL_RESP_SIA as HIERARC21_6_, card_.BUDGET_START_DATE as BUDGET22_6_, card_.BUDGET_DURATION_Y as BUDGET23_6_, card_.majorComments as majorCo24_6_ from CARD card_ where card_.id=?
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.Card */ insert into CARD (title, creationDate, ORIGINATOR_SIA, originatorService, COST_CENTER_RESP_SIA, draft, description, moreFinancialSources, newIdea, PRIMARY_DOMAIN_ID, PRIORITY_ID, LOCATION, justification, returnOnInvestment, linkWithOtherPrograms, linkWithOtherStudies, MAIN_TECH_OBJ, mainStudySteps, firstContact, HIERARCHICAL_RESP_SIA, BUDGET_START_DATE, BUDGET_DURATION_Y, majorComments, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.Card */ update CARD set title=?, creationDate=?, ORIGINATOR_SIA=?, originatorService=?, COST_CENTER_RESP_SIA=?, draft=?, description=?, moreFinancialSources=?, newIdea=?, PRIMARY_DOMAIN_ID=?, PRIORITY_ID=?, LOCATION=?, justification=?, returnOnInvestment=?, linkWithOtherPrograms=?, linkWithOtherStudies=?, MAIN_TECH_OBJ=?, mainStudySteps=?, firstContact=?, HIERARCHICAL_RESP_SIA=?, BUDGET_START_DATE=?, BUDGET_DURATION_Y=?, majorComments=? where id=?
3224 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.Card */ delete from CARD where id=?
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.SecondaryDomain
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.SecondaryDomain */ select DOMAIN_ID from SECONDARY_DOMAIN where DOMAIN_ID =?
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.SecondaryDomain */ select secondaryd_.DOMAIN_ID, secondaryd_.name as name0_, secondaryd_.visible as visible0_ from SECONDARY_DOMAIN secondaryd_ where secondaryd_.DOMAIN_ID=?
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.SecondaryDomain */ insert into SECONDARY_DOMAIN (name, visible, DOMAIN_ID) values (?, ?, ?)
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.SecondaryDomain */ update SECONDARY_DOMAIN set name=?, visible=? where DOMAIN_ID=?
3239 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.SecondaryDomain */ delete from SECONDARY_DOMAIN where DOMAIN_ID=?
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.CustomerEmployee
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.CustomerEmployee */ select PER_SIA from LAE.LAE_ANNUAIRE where PER_SIA =?
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.CustomerEmployee */ select Customerempl_.PER_SIA, Customerempl_.PER_PNO as PER2_4_, Customerempl_.PER_NOM as PER3_4_, Customerempl_.CAN_COD as CAN4_4_ from LAE.LAE_ANNUAIRE Customerempl_ where Customerempl_.PER_SIA=?
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.CustomerEmployee */ insert into LAE.LAE_ANNUAIRE (PER_PNO, PER_NOM, CAN_COD, PER_SIA) values (?, ?, ?, ?)
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.CustomerEmployee */ update LAE.LAE_ANNUAIRE set PER_PNO=?, PER_NOM=?, CAN_COD=? where PER_SIA=?
3255 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.CustomerEmployee */ delete from LAE.LAE_ANNUAIRE where PER_SIA=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.YearDetail
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.YearDetail */ select id from YearDetail where id =?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.YearDetail */ select yeardetail_.id, yeardetail_.year as year12_, yeardetail_.card_id as card3_12_, yeardetail_.internalFundingBudget as internal4_12_, yeardetail_.externalFinance as external5_12_ from YearDetail yeardetail_ where yeardetail_.id=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.YearDetail */ insert into YearDetail (year, card_id, internalFundingBudget, externalFinance, id) values (?, ?, ?, ?, ?)
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.YearDetail */ update YearDetail set year=?, card_id=?, internalFundingBudget=?, externalFinance=? where id=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.YearDetail */ delete from YearDetail where id=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.Domain
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.Domain */ select DOMAIN_ID from Domain where DOMAIN_ID =?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.Domain */ select domain_.DOMAIN_ID, domain_.name as name0_, domain_.visible as visible0_ from ( select DOMAIN_ID, visible, name, 1 as clazz_ from PRIMARY_DOMAIN union all select DOMAIN_ID, visible, name, 2 as clazz_ from SECONDARY_DOMAIN ) domain_ where domain_.DOMAIN_ID=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.Domain */ insert into Domain (name, visible, DOMAIN_ID) values (?, ?, ?)
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.Domain */ update Domain set name=?, visible=? where DOMAIN_ID=?
3270 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.Domain */ delete from Domain where DOMAIN_ID=?
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Static SQL for entity: com.mycustomer.myapp.beans.Service
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Version select: /* get version com.mycustomer.myapp.beans.Service */ select CAN_COD from (
select T1.CAN_COD, T1.EXE_COD, T1.PER_RSP
from RFG.RFG_CAN T1
where T1.EXE_COD = (select MAX(T2.EXE_COD) from RFG.RFG_CAN T2 where T1.CAN_COD=T2.CAN_COD)
) where CAN_COD =?
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Snapshot select: /* get current state com.mycustomer.myapp.beans.Service */ select service_.CAN_COD, service_.PER_RSP as PER2_5_ from (
select T1.CAN_COD, T1.EXE_COD, T1.PER_RSP
from RFG.RFG_CAN T1
where T1.EXE_COD = (select MAX(T2.EXE_COD) from RFG.RFG_CAN T2 where T1.CAN_COD=T2.CAN_COD)
) service_ where service_.CAN_COD=?
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Insert 0: /* insert com.mycustomer.myapp.beans.Service */ insert into (
select T1.CAN_COD, T1.EXE_COD, T1.PER_RSP
from RFG.RFG_CAN T1
where T1.EXE_COD = (select MAX(T2.EXE_COD) from RFG.RFG_CAN T2 where T1.CAN_COD=T2.CAN_COD)
) (PER_RSP, CAN_COD) values (?, ?)
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Update 0: /* update com.mycustomer.myapp.beans.Service */ update (
select T1.CAN_COD, T1.EXE_COD, T1.PER_RSP
from RFG.RFG_CAN T1
where T1.EXE_COD = (select MAX(T2.EXE_COD) from RFG.RFG_CAN T2 where T1.CAN_COD=T2.CAN_COD)
) set PER_RSP=? where CAN_COD=?
3286 DEBUG [main] org.hibernate.persister.entity.AbstractEntityPersister : Delete 0: /* delete com.mycustomer.myapp.beans.Service */ delete from (
select T1.CAN_COD, T1.EXE_COD, T1.PER_RSP
from RFG.RFG_CAN T1
where T1.EXE_COD = (select MAX(T2.EXE_COD) from RFG.RFG_CAN T2 where T1.CAN_COD=T2.CAN_COD)
) where CAN_COD=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Static SQL for collection: com.mycustomer.myapp.beans.Domain.readers
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row insert: /* insert collection row com.mycustomer.myapp.beans.Domain.readers */ insert into DOMAIN_READERS (domain_id, reader_sia) values (?, ?)
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row update: /* update collection row com.mycustomer.myapp.beans.Domain.readers */ update DOMAIN_READERS set reader_sia=? where domain_id=? and reader_sia=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row delete: /* delete collection row com.mycustomer.myapp.beans.Domain.readers */ delete from DOMAIN_READERS where domain_id=? and reader_sia=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : One-shot delete: /* delete collection com.mycustomer.myapp.beans.Domain.readers */ delete from DOMAIN_READERS where domain_id=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Static SQL for collection: com.mycustomer.myapp.beans.Card.modifiers
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row insert: /* insert collection row com.mycustomer.myapp.beans.Card.modifiers */ insert into CARD_MODIFIER (card_id, MODIFIER_SIA) values (?, ?)
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row update: /* update collection row com.mycustomer.myapp.beans.Card.modifiers */ update CARD_MODIFIER set MODIFIER_SIA=? where card_id=? and MODIFIER_SIA=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : Row delete: /* delete collection row com.mycustomer.myapp.beans.Card.modifiers */ delete from CARD_MODIFIER where card_id=? and MODIFIER_SIA=?
3302 DEBUG [main] org.hibernate.persister.collection.AbstractCollectionPersister : One-shot delete: /* delete collection com.mycustomer.myapp.beans.Card.modifiers */ delete from CARD_MODIFIER where card_id=?
3302 DEBUG [main] org.hibernate.persister.collecti

shardul.bhatt · **Joined:** Fri Sep 08, 2006 7:29 am **Posts:** 36

Am thinking aloud...not sure if this would help...

Do you by any means modify the objects of the list....

Something like....

List list = hibernateDao.getList();

//Iterate over this list and edit the objects...
for (Iterator iter = list.iterator(); iter.hasNext();) {
type element = (type) iter.next();
element.setXYZ("xyz");
}

If done when the session is open....and if you have the auto update enabled....I think the update query is generated....

Shardul.

henryju · **Joined:** Tue Sep 18, 2007 11:24 am **Posts:** 9

Hi,

Thanks for your consideration. In fact, I have isolated the problem in a small JUnit test, and I don't do anything with the List.

Furthermore, Spring DAO automatically close the session, so it will raise a lazy initialization error instead.

Another idea? Could it be a Spring related problem instead of Hibernate one?

++

Julien

henryju · **Joined:** Tue Sep 18, 2007 11:24 am **Posts:** 9

Someone already had the same issue:
http://forum.springframework.org/showth ... p?p=142610

But no answer :(

henryju · **Joined:** Tue Sep 18, 2007 11:24 am **Posts:** 9

I got it !!!

In my POJO, I have:

Code:

public class Card {

...

    /**
     * @return the majorComments
     */
    public String getMajorComments() {
        return nvl(majorComments);
    }

...

   /**
     * Return "" instead of null
     * @param string
     * @return
     */
    private String nvl(String string) {
        return string==null?"":string;
    }

...
}

I suppose Hibernate check if there is some modification on the bean when the session is closed by calling the getter. Because the field was null and is now "", Hibernate think an update is required. And because Oracle doesn't distinguish null/"" the problem occurs each time.

As a workaround, I put access="field" on all properties where the getter uses the nvl function.

satsranchuser · **Posted:** Wed Sep 19, 2007 8:51 am

As far I know, there is def. some dirty object. Hibernate triggers a Update when there is a dirty object. Scan through the log again just to make sure there is no change in object data when you call the query. One tip is to search for "is dirty" in the log.

etienne1984 · **Joined:** Mon Apr 14, 2008 9:24 am **Posts:** 1

I had the same problem, but only with Enum having NULL value.

The problem was that the fr.cnes.sarsat.transverse.core.hibernate.EnumUserType.equals(Object, Object) method has the following code :

if (null == x || null == y) {
status = false;
} else {
status = x.equals(y) ;
}

that means if x == null and y == null return false. As ResultSet of DB query is NULL and object Enum value is logically NULL, it runs equals(null, null) which returns false -> hibernates thinks objects are differents and runs an update. You just have to add the case null and null returns true :

if (null == x && null == y) {
status = true;
}

Hope it will help someone...

looyo · **Joined:** Thu Dec 18, 2008 12:45 am **Posts:** 4

I have the same problem。but i have not call save or saveorUpete.

henryju wrote:

I got it !!!

In my POJO, I have:

Code:

public class Card {

...

    /**
     * @return the majorComments
     */
    public String getMajorComments() {
        return nvl(majorComments);
    }

...

   /**
     * Return "" instead of null
     * @param string
     * @return
     */
    private String nvl(String string) {
        return string==null?"":string;
    }

...
}

I suppose Hibernate check if there is some modification on the bean when the session is closed by calling the getter. Because the field was null and is now "", Hibernate think an update is required. And because Oracle doesn't distinguish null/"" the problem occurs each time.

As a workaround, I put access="field" on all properties where the getter uses the nvl function.

chrismarx · **Joined:** Thu Mar 03, 2011 3:24 pm **Posts:** 9

I had the same problem, only in my case, no mutation was occurring the the getter/setters, it was a custom data type (JGeometryType) that was triggering the change. So in my case, adding

@Access(AccessType.FIELD)

didn't do anything, I used:

@Column(name = "GEOM", insertable=false, updatable=false)

as a temporary fix until I find out exactly where that customdatatype is messing with things-