Hibernate Community • View topic - org.hibernate.HibernateException: collection was evicted

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

org.hibernate.HibernateException: collection was evicted

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

luc boudreau

Post subject: org.hibernate.HibernateException: collection was evicted

Posted: Fri Aug 04, 2006 3:35 pm

Newbie

Joined: Fri Aug 04, 2006 3:01 pm
Posts: 13

I have a Questionnaire POJO which contains a PersistentSet of Enquetes. The collection is Lazy and is initialized with the following command :

Code:

this.enquetes = new HashSet<Enquete>();

When I need to know if a Questionnaire can be modified, I need to check with it's owning Enquete.

To do this, I use the questionManager which must ask forst to it's DAO counterpart to resync the enquetes persistent set.

Code:

/* (non-Javadoc)
    * @see ca.uquebec.icope.data.dao.questionnaire.QuestionnaireDAO#reattachEnquetes(ca.uquebec.icope.data.model.questionnaire.Questionnaire)
    */
   public Questionnaire reattachEnquetes(Questionnaire q) 
   {
      if (!q.isTransient()) 
      { 
((PersistentSet)q.getEnquetes()).setCurrentSession((SessionImplementor)  getHibernateTemplate().getSessionFactory().getCurrentSession() );;

                     Hibernate.initialize(q.getEnquetes());
         
      }
      return q;
   }

I get an error :

Code:

Exception thrown executing [AnnotatedAction@11a0070 targetAction = ca.uquebec.icope.web.controller.elementQuestionnaire.QuestionFormAction@130bd0a, attributes = map[[empty]]] in state 'setupForm' of flow 'question'; nested exception is org.hibernate.HibernateException: collection was evicted

Hibernate version:
3.1

Mapping documents:

Code:

<hibernate-mapping package="ca.uquebec.icope.data.model.questionnaire">

   <class name="Questionnaire" table="QUESTIONNAIRE" abstract="true" proxy="Questionnaire" lazy="true">

      <id name="id" column="ID" type="long" access="field">
         <generator class="hilo" />
      </id>

      <discriminator column="QUESTIONNAIRE_TYPE" type="string" length="20" />
      
      <version name="_version" column="VERSION" access="field" />
            
      <property name="identifiant" column="IDENTIFIANT" type="java.lang.String" length="30" not-null="true"/>
      
      <property name="dateCreation" column="DATE_CREATION" type="java.util.Date"  not-null="true"/>
      
      <property name="typeEnquete" column="TYPE_ENQUETE" type="ca.uquebec.icope.data.hibernate.mappingType.custom.EnumTypeEnqueteUserType" not-null="true"/>
      
      <many-to-one name="questionnaireParent" column="QUEST_PARENT_ID" class="Questionnaire" not-null="false" lazy="proxy" access="field"/>
      
      <set name="usageElements" table="USAGE_ELEMENT" order-by="NO_TRI asc" inverse="true" lazy="false" cascade="all-delete-orphan" >
         <key column="QUESTIONNAIRE_ID" not-null="true" />
         <one-to-many class="UsageElement"/>
      </set>
      
      <set name="enquetes" table="ENQUETE" lazy="true" cascade="none">
         <key column="QUESTIONNAIRE_ID"/>
         <one-to-many class="ca.uquebec.icope.data.model.populationCible.Enquete" />
      </set>
      
      <subclass name="QuestionnaireModele" discriminator-value="M" lazy="true">
         <property name="estDesuet" column="EST_DESUET" type="boolean" />
      </subclass>
      
      <subclass name="QuestionnaireReel" discriminator-value="R" lazy="true">
         <property name="permetReponseIncomplete" column="PERMET_REP_INCOMPLETE" type="boolean" />
      </subclass>

   </class>

</hibernate-mapping>

Code:

<hibernate-mapping package="ca.uquebec.icope.data.model.populationCible">

   <class name="Enquete" table="ENQUETE" lazy="false">

      <id name="id" column="ID" type="long" access="field">
         <generator class="hilo" />
      </id>

      <version name="_version" column="VERSION" access="field" />

      <property name="libelle" type="java.lang.String"  not-null="true">
         <column name="LIBELLE" length="30"/>
      </property>
      
      <property name="dateDebut" column="DATE_DEBUT" type="java.sql.Timestamp" />
      
      <property name="dateFin" column="DATE_FIN" type="java.sql.Timestamp" />
      
      <property name="typeEnquete" column="TYPE_ENQUETE" type="ca.uquebec.icope.data.hibernate.mappingType.custom.EnumTypeEnqueteUserType" not-null="true"/>
      
<!--      <one-to-one name="population" class="ca.uquebec.icope.data.model.populationCible.Population" property-ref="enquete" cascade="delete, save-update" lazy="false"/>-->
      
      <many-to-one name="questionnaire" column="QUESTIONNAIRE_ID" class="ca.uquebec.icope.data.model.questionnaire.QuestionnaireReel" not-null="true" lazy="proxy"/>
      
      <set name="envois" table="ENVOI" cascade="all-delete-orphan" lazy="true" inverse="true">
         <key column="ENQUETE_ID" />
         <one-to-many class="Envoi" />
      </set>
      
      <set name="criteres" table="CRITERE_SELECTION" lazy="false" cascade="all-delete-orphan" inverse="true"> 
         <key column="ENQUETE_ID"/>
         <one-to-many class="ca.uquebec.icope.data.model.populationCible.CritereSelection" />
      </set>
      
      <set name="etudiants" table="ETUDIANT" lazy="true" cascade="all-delete-orphan" inverse="true"> <!--  cascade="save-update" -->
         <key column="ENQUETE_ID"/>
         <one-to-many class="ca.uquebec.icope.data.model.populationCible.Etudiant" />
      </set>
      
   </class>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

I use a proxy bean with the @Transactional annotation. The sessions are opened and closed correctly by the Spring implementation. Here's the code which gets called to initialize the collection

Full stack trace of any exception that occurs:









Name and version of the database you are using:

MySQL Ver 14.7 Distrib 4.1.13a, for Win32 (ia32)

The generated SQL (show_sql=true):

[code]
Hibernate: select question0_.QUESTION_ID as ID0_0_, question0_1_.VERSION as VERSION0_0_, question0_1_.NO_TRI as NO3_0_0_, question0_1_.QUESTION_ID as QUESTION4_0_0_, question0_.LIBELLE as LIBELLE1_0_, question0_.NUMERO_QUESTION as NUMERO3_1_0_, question0_.CLARIFICATION as CLARIFIC4_1_0_, question0_.TYPE_ENQUETE as TYPE5_1_0_, question0_.EST_DESUET as EST6_1_0_, question0_2_.EST_PREFIXE as EST2_3_0_, case when question0_2_.GR_QUESTION_ID is not null then 2 when question0_.QUESTION_ID is not null then 1 end as clazz_0_ from QUESTION question0_ inner join ELEMENT question0_1_ on question0_.QUESTION_ID=question0_1_.ID left outer join GROUPE_QUESTION question0_2_ on question0_.QUESTION_ID=question0_2_.GR_QUESTION_ID where question0_.QUESTION_ID=?
Hibernate: select associatio0_.QUESTION_ID as QUESTION4_1_, associatio0_.ID as ID1_, associatio0_.ID as ID25_0_, associatio0_.VERSION as VERSION25_0_, associatio0_.TRIMESTRE as TRIMESTRE25_0_, associatio0_.QUESTION_ID as QUESTION4_25_0_, associatio0_.PROFIL_ID as PROFIL5_25_0_ from ASSOCIATION_PROFIL_QUESTION associatio0_ where associatio0_.QUESTION_ID=?
Hibernate: select questionsd0_.QUESTION_ANCETRE_ID as QUESTION1_0_, questionsd0_.QUESTION_DESCENDANT_ID as QUESTION2_0_, questionsd0_.RAISON_REMPLACEMENT as RAISON3_0_ from QUESTION_ANCETRE_DESCENDANT questionsd0_ where questionsd0_.QUESTION_ANCETRE_ID=?
Hibernate: select elements0_.QUESTION_ID as QUESTION4_1_, elements0_.ID as ID1_, elements0_.ID as ID0_0_, elements0_.VERSION as VERSION0_0_, elements0_.NO_TRI as NO3_0_0_, elements0_.QUESTION_ID as QUESTION4_0_0_, elements0_1_.LIBELLE as LIBELLE1_0_, elements0_1_.NUMERO_QUESTION as NUMERO3_1_0_, elements0_1_.CLARIFICATION as CLARIFIC4_1_0_, elements0_1_.TYPE_ENQUETE as TYPE5_1_0_, elements0_1_.EST_DESUET as EST6_1_0_, elements0_2_.EST_PREFIXE as EST2_3_0_, elements0_3_.TYPE_TEXTE as TYPE2_4_0_, elements0_3_.HTML_TEXT as HTML3_4_0_, elements0_4_.NO_TRI as NO2_5_0_, elements0_4_.TITRE as TITRE5_0_, elements0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, elements0_4_.EST_MODELE as EST5_5_0_, elements0_4_.IDENTIFANT as IDENTIFANT5_0_, elements0_5_.NB_CARACTERE_MAX as NB2_6_0_, elements0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, elements0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, elements0_5_.TYPE_CHAMP as TYPE5_6_0_, elements0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, elements0_7_.VALEUR_MIN as VALEUR2_8_0_, elements0_7_.VALEUR_MAX as VALEUR3_8_0_, elements0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, elements0_7_.ORDRE as ORDRE8_0_, elements0_9_.DISPOSITION as DISPOSIT2_10_0_, elements0_10_.DISPOSITION as DISPOSIT2_11_0_, case when elements0_2_.GR_QUESTION_ID is not null then 2 when elements0_7_.CR_LISTE_INTER_ID is not null then 7 when elements0_8_.CR_LISTE_VAL_ID is not null then 8 when elements0_5_.CR_TEXTE_ID is not null then 5 when elements0_6_.CR_LISTE_ID is not null then 6 when elements0_9_.CR_CASE_ID is not null then 9 when elements0_10_.CR_RADIO_ID is not null then 10 when elements0_1_.QUESTION_ID is not null then 1 when elements0_3_.TEXTE_ID is not null then 3 when elements0_4_.CHOIX_REPONSE_ID is not null then 4 when elements0_.ID is not null then 0 end as clazz_0_ from ELEMENT elements0_ left outer join QUESTION elements0_1_ on elements0_.ID=elements0_1_.QUESTION_ID left outer join GROUPE_QUESTION elements0_2_ on elements0_.ID=elements0_2_.GR_QUESTION_ID left outer join TEXTE elements0_3_ on elements0_.ID=elements0_3_.TEXTE_ID left outer join CHOIX_REPONSE elements0_4_ on elements0_.ID=elements0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE elements0_5_ on elements0_.ID=elements0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE elements0_6_ on elements0_.ID=elements0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE elements0_7_ on elements0_.ID=elements0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR elements0_8_ on elements0_.ID=elements0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE elements0_9_ on elements0_.ID=elements0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO elements0_10_ on elements0_.ID=elements0_10_.CR_RADIO_ID where elements0_.QUESTION_ID=? order by elements0_.NO_TRI asc
Hibernate: select associatio0_.QUESTION_ID as QUESTION4_1_, associatio0_.ID as ID1_, associatio0_.ID as ID25_0_, associatio0_.VERSION as VERSION25_0_, associatio0_.TRIMESTRE as TRIMESTRE25_0_, associatio0_.QUESTION_ID as QUESTION4_25_0_, associatio0_.PROFIL_ID as PROFIL5_25_0_ from ASSOCIATION_PROFIL_QUESTION associatio0_ where associatio0_.QUESTION_ID=?
Hibernate: select questionsd0_.QUESTION_ANCETRE_ID as QUESTION1_0_, questionsd0_.QUESTION_DESCENDANT_ID as QUESTION2_0_, questionsd0_.RAISON_REMPLACEMENT as RAISON3_0_ from QUESTION_ANCETRE_DESCENDANT questionsd0_ where questionsd0_.QUESTION_ANCETRE_ID=?
Hibernate: select elements0_.QUESTION_ID as QUESTION4_1_, elements0_.ID as ID1_, elements0_.ID as ID0_0_, elements0_.VERSION as VERSION0_0_, elements0_.NO_TRI as NO3_0_0_, elements0_.QUESTION_ID as QUESTION4_0_0_, elements0_1_.LIBELLE as LIBELLE1_0_, elements0_1_.NUMERO_QUESTION as NUMERO3_1_0_, elements0_1_.CLARIFICATION as CLARIFIC4_1_0_, elements0_1_.TYPE_ENQUETE as TYPE5_1_0_, elements0_1_.EST_DESUET as EST6_1_0_, elements0_2_.EST_PREFIXE as EST2_3_0_, elements0_3_.TYPE_TEXTE as TYPE2_4_0_, elements0_3_.HTML_TEXT as HTML3_4_0_, elements0_4_.NO_TRI as NO2_5_0_, elements0_4_.TITRE as TITRE5_0_, elements0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, elements0_4_.EST_MODELE as EST5_5_0_, elements0_4_.IDENTIFANT as IDENTIFANT5_0_, elements0_5_.NB_CARACTERE_MAX as NB2_6_0_, elements0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, elements0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, elements0_5_.TYPE_CHAMP as TYPE5_6_0_, elements0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, elements0_7_.VALEUR_MIN as VALEUR2_8_0_, elements0_7_.VALEUR_MAX as VALEUR3_8_0_, elements0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, elements0_7_.ORDRE as ORDRE8_0_, elements0_9_.DISPOSITION as DISPOSIT2_10_0_, elements0_10_.DISPOSITION as DISPOSIT2_11_0_, case when elements0_2_.GR_QUESTION_ID is not null then 2 when elements0_7_.CR_LISTE_INTER_ID is not null then 7 when elements0_8_.CR_LISTE_VAL_ID is not null then 8 when elements0_5_.CR_TEXTE_ID is not null then 5 when elements0_6_.CR_LISTE_ID is not null then 6 when elements0_9_.CR_CASE_ID is not null then 9 when elements0_10_.CR_RADIO_ID is not null then 10 when elements0_1_.QUESTION_ID is not null then 1 when elements0_3_.TEXTE_ID is not null then 3 when elements0_4_.CHOIX_REPONSE_ID is not null then 4 when elements0_.ID is not null then 0 end as clazz_0_ from ELEMENT elements0_ left outer join QUESTION elements0_1_ on elements0_.ID=elements0_1_.QUESTION_ID left outer join GROUPE_QUESTION elements0_2_ on elements0_.ID=elements0_2_.GR_QUESTION_ID left outer join TEXTE elements0_3_ on elements0_.ID=elements0_3_.TEXTE_ID left outer join CHOIX_REPONSE elements0_4_ on elements0_.ID=elements0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE elements0_5_ on elements0_.ID=elements0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE elements0_6_ on elements0_.ID=elements0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE elements0_7_ on elements0_.ID=elements0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR elements0_8_ on elements0_.ID=elements0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE elements0_9_ on elements0_.ID=elements0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO elements0_10_ on elements0_.ID=elements0_10_.CR_RADIO_ID where elements0_.QUESTION_ID=? order by elements0_.NO_TRI asc
Hibernate: select reponses0_.CHOIX_REPONSE_ID as CHOIX8_1_, reponses0_.ID as ID1_, reponses0_.ID as ID12_0_, reponses0_.VERSION as VERSION12_0_, reponses0_.NO_TRI as NO4_12_0_, reponses0_.LIBELLE as LIBELLE12_0_, reponses0_.CLARIFICATION as CLARIFIC6_12_0_, reponses0_.PONDERATION as PONDERAT7_12_0_, reponses0_.CHOIX_REPONSE_ID as CHOIX8_12_0_, reponses0_.SAUT_QUESTION_ID as SAUT9_12_0_, reponses0_.IND_PRECISION as IND10_12_0_, reponses0_.NB_CARACTERE_MAX as NB11_12_0_, reponses0_.SUFFIXE_REP as SUFFIXE12_12_0_, reponses0_.TYPE_REP_ATTENDU as TYPE13_12_0_, reponses0_.REPONSE_TYPE as REPONSE2_12_0_ from REPONSE reponses0_ where reponses0_.CHOIX_REPONSE_ID=? order by reponses0_.NO_TRI asc
Hibernate: select usageeleme0_.ELEMENT_ID as ELEMENT6_1_, usageeleme0_.ID as ID1_, usageeleme0_.ID as ID30_0_, usageeleme0_.VERSION as VERSION30_0_, usageeleme0_.NO_TRI as NO3_30_0_, usageeleme0_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme0_.ELEMENT_ID as ELEMENT6_30_0_ from USAGE_ELEMENT usageeleme0_ where usageeleme0_.ELEMENT_ID=?
Hibernate: select usageeleme0_.ELEMENT_ID as ELEMENT6_1_, usageeleme0_.ID as ID1_, usageeleme0_.ID as ID30_0_, usageeleme0_.VERSION as VERSION30_0_, usageeleme0_.NO_TRI as NO3_30_0_, usageeleme0_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme0_.ELEMENT_ID as ELEMENT6_30_0_ from USAGE_ELEMENT usageeleme0_ where usageeleme0_.ELEMENT_ID=?
Hibernate: select associatio0_.QUESTION_ID as QUESTION4_1_, associatio0_.ID as ID1_, associatio0_.ID as ID25_0_, associatio0_.VERSION as VERSION25_0_, associatio0_.TRIMESTRE as TRIMESTRE25_0_, associatio0_.QUESTION_ID as QUESTION4_25_0_, associatio0_.PROFIL_ID as PROFIL5_25_0_ from ASSOCIATION_PROFIL_QUESTION associatio0_ where associatio0_.QUESTION_ID=?
Hibernate: select questionsd0_.QUESTION_ANCETRE_ID as QUESTION1_0_, questionsd0_.QUESTION_DESCENDANT_ID as QUESTION2_0_, questionsd0_.RAISON_REMPLACEMENT as RAISON3_0_ from QUESTION_ANCETRE_DESCENDANT questionsd0_ where questionsd0_.QUESTION_ANCETRE_ID=?
Hibernate: select elements0_.QUESTION_ID as QUESTION4_1_, elements0_.ID as ID1_, elements0_.ID as ID0_0_, elements0_.VERSION as VERSION0_0_, elements0_.NO_TRI as NO3_0_0_, elements0_.QUESTION_ID as QUESTION4_0_0_, elements0_1_.LIBELLE as LIBELLE1_0_, elements0_1_.NUMERO_QUESTION as NUMERO3_1_0_, elements0_1_.CLARIFICATION as CLARIFIC4_1_0_, elements0_1_.TYPE_ENQUETE as TYPE5_1_0_, elements0_1_.EST_DESUET as EST6_1_0_, elements0_2_.EST_PREFIXE as EST2_3_0_, elements0_3_.TYPE_TEXTE as TYPE2_4_0_, elements0_3_.HTML_TEXT as HTML3_4_0_, elements0_4_.NO_TRI as NO2_5_0_, elements0_4_.TITRE as TITRE5_0_, elements0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, elements0_4_.EST_MODELE as EST5_5_0_, elements0_4_.IDENTIFANT as IDENTIFANT5_0_, elements0_5_.NB_CARACTERE_MAX as NB2_6_0_, elements0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, elements0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, elements0_5_.TYPE_CHAMP as TYPE5_6_0_, elements0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, elements0_7_.VALEUR_MIN as VALEUR2_8_0_, elements0_7_.VALEUR_MAX as VALEUR3_8_0_, elements0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, elements0_7_.ORDRE as ORDRE8_0_, elements0_9_.DISPOSITION as DISPOSIT2_10_0_, elements0_10_.DISPOSITION as DISPOSIT2_11_0_, case when elements0_2_.GR_QUESTION_ID is not null then 2 when elements0_7_.CR_LISTE_INTER_ID is not null then 7 when elements0_8_.CR_LISTE_VAL_ID is not null then 8 when elements0_5_.CR_TEXTE_ID is not null then 5 when elements0_6_.CR_LISTE_ID is not null then 6 when elements0_9_.CR_CASE_ID is not null then 9 when elements0_10_.CR_RADIO_ID is not null then 10 when elements0_1_.QUESTION_ID is not null then 1 when elements0_3_.TEXTE_ID is not null then 3 when elements0_4_.CHOIX_REPONSE_ID is not null then 4 when elements0_.ID is not null then 0 end as clazz_0_ from ELEMENT elements0_ left outer join QUESTION elements0_1_ on elements0_.ID=elements0_1_.QUESTION_ID left outer join GROUPE_QUESTION elements0_2_ on elements0_.ID=elements0_2_.GR_QUESTION_ID left outer join TEXTE elements0_3_ on elements0_.ID=elements0_3_.TEXTE_ID left outer join CHOIX_REPONSE elements0_4_ on elements0_.ID=elements0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE elements0_5_ on elements0_.ID=elements0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE elements0_6_ on elements0_.ID=elements0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE elements0_7_ on elements0_.ID=elements0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR elements0_8_ on elements0_.ID=elements0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE elements0_9_ on elements0_.ID=elements0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO elements0_10_ on elements0_.ID=elements0_10_.CR_RADIO_ID where elements0_.QUESTION_ID=? order by elements0_.NO_TRI asc
Hibernate: select reponses0_.CHOIX_REPONSE_ID as CHOIX8_1_, reponses0_.ID as ID1_, reponses0_.ID as ID12_0_, reponses0_.VERSION as VERSION12_0_, reponses0_.NO_TRI as NO4_12_0_, reponses0_.LIBELLE as LIBELLE12_0_, reponses0_.CLARIFICATION as CLARIFIC6_12_0_, reponses0_.PONDERATION as PONDERAT7_12_0_, reponses0_.CHOIX_REPONSE_ID as CHOIX8_12_0_, reponses0_.SAUT_QUESTION_ID as SAUT9_12_0_, reponses0_.IND_PRECISION as IND10_12_0_, reponses0_.NB_CARACTERE_MAX as NB11_12_0_, reponses0_.SUFFIXE_REP as SUFFIXE12_12_0_, reponses0_.TYPE_REP_ATTENDU as TYPE13_12_0_, reponses0_.REPONSE_TYPE as REPONSE2_12_0_ from REPONSE reponses0_ where reponses0_.CHOIX_REPONSE_ID=? order by reponses0_.NO_TRI asc
Hibernate: select sautquesti0_.ID as ID13_0_, sautquesti0_.VERSION as VERSION13_0_, sautquesti0_.LIBELLE as LIBELLE13_0_ from SAUT_QUESTION sautquesti0_ where sautquesti0_.ID=?
Hibernate: select usageeleme0_.SAUT_QUESTION_ID as SAUT1_1_, usageeleme0_.USAGE_ELEMENT_ID as USAGE2_1_, usageeleme1_.ID as ID30_0_, usageeleme1_.VERSION as VERSION30_0_, usageeleme1_.NO_TRI as NO3_30_0_, usageeleme1_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme1_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme1_.ELEMENT_ID as ELEMENT6_30_0_ from ASSOCIATION_USAGE_SAUT usageeleme0_ left outer join USAGE_ELEMENT usageeleme1_ on usageeleme0_.USAGE_ELEMENT_ID=usageeleme1_.ID where usageeleme0_.SAUT_QUESTION_ID=?
Hibernate: select questionna0_.ID as ID29_0_, questionna0_.VERSION as VERSION29_0_, questionna0_.IDENTIFIANT as IDENTIFI4_29_0_, questionna0_.DATE_CREATION as DATE5_29_0_, questionna0_.TYPE_ENQUETE as TYPE6_29_0_, questionna0_.QUEST_PARENT_ID as QUEST7_29_0_, questionna0_.EST_DESUET as EST8_29_0_, questionna0_.PERMET_REP_INCOMPLETE as PERMET9_29_0_, questionna0_.QUESTIONNAIRE_TYPE as QUESTION2_29_0_ from QUESTIONNAIRE questionna0_ where questionna0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select sautsquest0_.USAGE_ELEMENT_ID as USAGE2_1_, sautsquest0_.SAUT_QUESTION_ID as SAUT1_1_, sautquesti1_.ID as ID13_0_, sautquesti1_.VERSION as VERSION13_0_, sautquesti1_.LIBELLE as LIBELLE13_0_ from ASSOCIATION_USAGE_SAUT sautsquest0_ left outer join SAUT_QUESTION sautquesti1_ on sautsquest0_.SAUT_QUESTION_ID=sautquesti1_.ID where sautsquest0_.USAGE_ELEMENT_ID=?
Hibernate: select associatio0_.QUESTION_ID as QUESTION4_1_, associatio0_.ID as ID1_, associatio0_.ID as ID25_0_, associatio0_.VERSION as VERSION25_0_, associatio0_.TRIMESTRE as TRIMESTRE25_0_, associatio0_.QUESTION_ID as QUESTION4_25_0_, associatio0_.PROFIL_ID as PROFIL5_25_0_ from ASSOCIATION_PROFIL_QUESTION associatio0_ where associatio0_.QUESTION_ID=?
Hibernate: select questionsd0_.QUESTION_ANCETRE_ID as QUESTION1_0_, questionsd0_.QUESTION_DESCENDANT_ID as QUESTION2_0_, questionsd0_.RAISON_REMPLACEMENT as RAISON3_0_ from QUESTION_ANCETRE_DESCENDANT questionsd0_ where questionsd0_.QUESTION_ANCETRE_ID=?
Hibernate: select elements0_.QUESTION_ID as QUESTION4_1_, elements0_.ID as ID1_, elements0_.ID as ID0_0_, elements0_.VERSION as VERSION0_0_, elements0_.NO_TRI as NO3_0_0_, elements0_.QUESTION_ID as QUESTION4_0_0_, elements0_1_.LIBELLE as LIBELLE1_0_, elements0_1_.NUMERO_QUESTION as NUMERO3_1_0_, elements0_1_.CLARIFICATION as CLARIFIC4_1_0_, elements0_1_.TYPE_ENQUETE as TYPE5_1_0_, elements0_1_.EST_DESUET as EST6_1_0_, elements0_2_.EST_PREFIXE as EST2_3_0_, elements0_3_.TYPE_TEXTE as TYPE2_4_0_, elements0_3_.HTML_TEXT as HTML3_4_0_, elements0_4_.NO_TRI as NO2_5_0_, elements0_4_.TITRE as TITRE5_0_, elements0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, elements0_4_.EST_MODELE as EST5_5_0_, elements0_4_.IDENTIFANT as IDENTIFANT5_0_, elements0_5_.NB_CARACTERE_MAX as NB2_6_0_, elements0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, elements0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, elements0_5_.TYPE_CHAMP as TYPE5_6_0_, elements0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, elements0_7_.VALEUR_MIN as VALEUR2_8_0_, elements0_7_.VALEUR_MAX as VALEUR3_8_0_, elements0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, elements0_7_.ORDRE as ORDRE8_0_, elements0_9_.DISPOSITION as DISPOSIT2_10_0_, elements0_10_.DISPOSITION as DISPOSIT2_11_0_, case when elements0_2_.GR_QUESTION_ID is not null then 2 when elements0_7_.CR_LISTE_INTER_ID is not null then 7 when elements0_8_.CR_LISTE_VAL_ID is not null then 8 when elements0_5_.CR_TEXTE_ID is not null then 5 when elements0_6_.CR_LISTE_ID is not null then 6 when elements0_9_.CR_CASE_ID is not null then 9 when elements0_10_.CR_RADIO_ID is not null then 10 when elements0_1_.QUESTION_ID is not null then 1 when elements0_3_.TEXTE_ID is not null then 3 when elements0_4_.CHOIX_REPONSE_ID is not null then 4 when elements0_.ID is not null then 0 end as clazz_0_ from ELEMENT elements0_ left outer join QUESTION elements0_1_ on elements0_.ID=elements0_1_.QUESTION_ID left outer join GROUPE_QUESTION elements0_2_ on elements0_.ID=elements0_2_.GR_QUESTION_ID left outer join TEXTE elements0_3_ on elements0_.ID=elements0_3_.TEXTE_ID left outer join CHOIX_REPONSE elements0_4_ on elements0_.ID=elements0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE elements0_5_ on elements0_.ID=elements0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE elements0_6_ on elements0_.ID=elements0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE elements0_7_ on elements0_.ID=elements0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR elements0_8_ on elements0_.ID=elements0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE elements0_9_ on elements0_.ID=elements0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO elements0_10_ on elements0_.ID=elements0_10_.CR_RADIO_ID where elements0_.QUESTION_ID=? order by elements0_.NO_TRI asc
Hibernate: select reponses0_.CHOIX_REPONSE_ID as CHOIX8_1_, reponses0_.ID as ID1_, reponses0_.ID as ID12_0_, reponses0_.VERSION as VERSION12_0_, reponses0_.NO_TRI as NO4_12_0_, reponses0_.LIBELLE as LIBELLE12_0_, reponses0_.CLARIFICATION as CLARIFIC6_12_0_, reponses0_.PONDERATION as PONDERAT7_12_0_, reponses0_.CHOIX_REPONSE_ID as CHOIX8_12_0_, reponses0_.SAUT_QUESTION_ID as SAUT9_12_0_, reponses0_.IND_PRECISION as IND10_12_0_, reponses0_.NB_CARACTERE_MAX as NB11_12_0_, reponses0_.SUFFIXE_REP as SUFFIXE12_12_0_, reponses0_.TYPE_REP_ATTENDU as TYPE13_12_0_, reponses0_.REPONSE_TYPE as REPONSE2_12_0_ from REPONSE reponses0_ where reponses0_.CHOIX_REPONSE_ID=? order by reponses0_.NO_TRI asc
Hibernate: select usageeleme0_.ELEMENT_ID as ELEMENT6_1_, usageeleme0_.ID as ID1_, usageeleme0_.ID as ID30_0_, usageeleme0_.VERSION as VERSION30_0_, usageeleme0_.NO_TRI as NO3_30_0_, usageeleme0_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme0_.ELEMENT_ID as ELEMENT6_30_0_ from USAGE_ELEMENT usageeleme0_ where usageeleme0_.ELEMENT_ID=?
Hibernate: select usageeleme0_.ELEMENT_ID as ELEMENT6_1_, usageeleme0_.ID as ID1_, usageeleme0_.ID as ID30_0_, usageeleme0_.VERSION as VERSION30_0_, usageeleme0_.NO_TRI as NO3_30_0_, usageeleme0_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme0_.ELEMENT_ID as ELEMENT6_30_0_ from USAGE_ELEMENT usageeleme0_ where usageeleme0_.ELEMENT_ID=?
Hibernate: select usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_1_, usageeleme0_.ID as ID1_, usageeleme0_.ID as ID30_0_, usageeleme0_.VERSION as VERSION30_0_, usageeleme0_.NO_TRI as NO3_30_0_, usageeleme0_.NUMERO_QUESTION as NUMERO4_30_0_, usageeleme0_.QUESTIONNAIRE_ID as QUESTION5_30_0_, usageeleme0_.ELEMENT_ID as ELEMENT6_30_0_ from USAGE_ELEMENT usageeleme0_ where usageeleme0_.QUESTIONNAIRE_ID=? order by usageeleme0_.NO_TRI asc
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null then 7 when element0_8_.CR_LISTE_VAL_ID is not null then 8 when element0_5_.CR_TEXTE_ID is not null then 5 when element0_6_.CR_LISTE_ID is not null then 6 when element0_9_.CR_CASE_ID is not null then 9 when element0_10_.CR_RADIO_ID is not null then 10 when element0_1_.QUESTION_ID is not null then 1 when element0_3_.TEXTE_ID is not null then 3 when element0_4_.CHOIX_REPONSE_ID is not null then 4 when element0_.ID is not null then 0 end as clazz_0_ from ELEMENT element0_ left outer join QUESTION element0_1_ on element0_.ID=element0_1_.QUESTION_ID left outer join GROUPE_QUESTION element0_2_ on element0_.ID=element0_2_.GR_QUESTION_ID left outer join TEXTE element0_3_ on element0_.ID=element0_3_.TEXTE_ID left outer join CHOIX_REPONSE element0_4_ on element0_.ID=element0_4_.CHOIX_REPONSE_ID left outer join CHOIX_REPONSE_TEXTE element0_5_ on element0_.ID=element0_5_.CR_TEXTE_ID left outer join CHOIX_REPONSE_LISTE element0_6_ on element0_.ID=element0_6_.CR_LISTE_ID left outer join CHOIX_REPONSE_LISTE_INTERVALLE element0_7_ on element0_.ID=element0_7_.CR_LISTE_INTER_ID left outer join CHOIX_REPONSE_LISTE_VALEUR element0_8_ on element0_.ID=element0_8_.CR_LISTE_VAL_ID left outer join CHOIX_REPONSE_CASE element0_9_ on element0_.ID=element0_9_.CR_CASE_ID left outer join CHOIX_REPONSE_RADIO element0_10_ on element0_.ID=element0_10_.CR_RADIO_ID where element0_.ID=?
Hibernate: select element0_.ID as ID0_0_, element0_.VERSION as VERSION0_0_, element0_.NO_TRI as NO3_0_0_, element0_.QUESTION_ID as QUESTION4_0_0_, element0_1_.LIBELLE as LIBELLE1_0_, element0_1_.NUMERO_QUESTION as NUMERO3_1_0_, element0_1_.CLARIFICATION as CLARIFIC4_1_0_, element0_1_.TYPE_ENQUETE as TYPE5_1_0_, element0_1_.EST_DESUET as EST6_1_0_, element0_2_.EST_PREFIXE as EST2_3_0_, element0_3_.TYPE_TEXTE as TYPE2_4_0_, element0_3_.HTML_TEXT as HTML3_4_0_, element0_4_.NO_TRI as NO2_5_0_, element0_4_.TITRE as TITRE5_0_, element0_4_.TITRE_EST_PREFIXE as TITRE4_5_0_, element0_4_.EST_MODELE as EST5_5_0_, element0_4_.IDENTIFANT as IDENTIFANT5_0_, element0_5_.NB_CARACTERE_MAX as NB2_6_0_, element0_5_.SUFFIXE_REP as SUFFIXE3_6_0_, element0_5_.TYPE_REP_ATTENDU as TYPE4_6_0_, element0_5_.TYPE_CHAMP as TYPE5_6_0_, element0_6_.SUFFIXE_REP as SUFFIXE2_7_0_, element0_7_.VALEUR_MIN as VALEUR2_8_0_, element0_7_.VALEUR_MAX as VALEUR3_8_0_, element0_7_.VALEUR_INCREMENT as VALEUR4_8_0_, element0_7_.ORDRE as ORDRE8_0_, element0_9_.DISPOSITION as DISPOSIT2_10_0_, element0_10_.DISPOSITION as DISPOSIT2_11_0_, case when element0_2_.GR_QUESTION_ID is not null then 2 when element0_7_.CR_LISTE_INTER_ID is not null the

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

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