[b]Hibernate version:[/b]
Hibernate 3.3.1GA
Hibernate Annotations 3.4.0GA
Hibernate EntityManager 3.4.0 GA

[b]Name and version of the database you are using:[/b]
Ingres 2006 9.0.4

Bonjour,

J’ai un problème sur certaine requête qui porte sur des critères de sélection autre que la clé primaire de la table, pour résumer Hibernate me retourne une instance invalide de l’objet. Ce critère de sélection est associé à un Index dans la table. J’ai remarqué que lorsque je supprime l’index Hibernate me retourne toujours la bonne instance d’objet. Si je crée un index sur la colonne du critère j’ai le problème (mauvaise instance)

J’ai un Objet B, C et D qui hérite de l’objet A (non abstrait) je fonctionne par « join » table.

J’ai analysé les traces Hibernate, il semble venir d’un problème dans la couche de mapping « pour retrouver » l’objet lors d’un héritage.

Quelqu’un pourrait-il m’aider ? Je ne sais pas s’il s’agit d’un BUG hibernate ou une erreur du driver JDBC Ingres.

Trace :
[code]
// LE NUMERO RSI 36200 CORRESPOND A UNE FONCTION

DEBUG CmCli - NotificationThread org.hibernate.impl.SessionImpl - opened session at timestamp: 12356446104
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - begin
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - opening JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - current autocommit status: false
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - rollback
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - rolled back JDBC Connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - begin
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - opening JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - current autocommit status: false
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.QueryTranslatorImpl - parse() - HQL: SELECT destinataire FROM Destinataire destinataire WHERE destinataire.numeroRsi = '36200'
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.AST - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'FROM'
| | \-[RANGE] 'RANGE'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[DOT] '.'
| | | | | | | | | +-[DOT] '.'
| | | | | | | | | | +-[IDENT] 'com'
| | | | | | | | | | \-[IDENT] 'thalesgroup'
| | | | | | | | | \-[IDENT] 'dlj'
| | | | | | | | \-[IDENT] 'fr'
| | | | | | | \-[IDENT] 'sat'
| | | | | | \-[IDENT] 'project'
| | | | | \-[IDENT] 'persistence'
| | | | \-[IDENT] 'schema'
| | | \-[IDENT] 'Destinataire'
| | \-[ALIAS] 'destinataire'
| \-[SELECT] 'SELECT'
| \-[IDENT] 'destinataire'
\-[WHERE] 'WHERE'
\-[EQ] '='
+-[DOT] '.'
| +-[IDENT] 'destinataire'
| \-[IDENT] 'numeroRsi'
\-[QUOTED_STRING] ''36200''

DEBUG CmCli - NotificationThread org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
DEBUG CmCli - NotificationThread org.hibernate.hql.antlr.HqlSqlBaseWalker - select << begin [level=1, statement=select]
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : Destinataire (destinataire) -> destinatai0_
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : destinataire -> destinatai0_.pnia
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : destinataire -> destinatai0_.pnia
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.tree.DotNode - getDataType() : numeroRsi -> org.hibernate.type.StringType@1de007d
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : destinataire.numeroRsi -> destinatai0_.numeroRsi
DEBUG CmCli - NotificationThread org.hibernate.hql.antlr.HqlSqlBaseWalker - select : finishing up [level=1, statement=select]
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.HqlSqlWalker - processQuery() : ( SELECT ( {select clause} destinatai0_.pnia ) ( FromClause{level=1} Destinataire destinatai0_ ) ( WHERE ( = ( destinatai0_.numeroRsi destinatai0_.pnia numeroRsi ) '36200' ) ) )
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.util.JoinProcessor - Using FROM fragment [Destinataire destinatai0_ left outer join Abonne destinatai0_1_ on destinatai0_.pnia=destinatai0_1_.pnia left outer join Fonction destinatai0_2_ on destinatai0_.pnia=destinatai0_2_.pnia left outer join Cabine destinatai0_3_ on destinatai0_.pnia=destinatai0_3_.pnia]
DEBUG CmCli - NotificationThread org.hibernate.hql.antlr.HqlSqlBaseWalker - select >> end [level=1, statement=select]
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.AST - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (Destinataire)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[ALIAS_REF] IdentNode: 'destinatai0_.pnia as pnia1_' {alias=destinataire, className=Destinataire, tableAlias=destinatai0_}
| \-[SQL_TOKEN] SqlFragment: 'destinatai0_.appelentrant as appelent2_1_, destinatai0_.appelsortant as appelsor3_1_, destinatai0_.catCnx_numCat as catCnx18_1_, destinatai0_.droitconf as droitconf1_, destinatai0_.droiteet as droiteet1_, destinatai0_.proteceet as proteceet1_, destinatai0_.enreg as enreg1_, destinatai0_.gfuList_gfuListNumber as gfuList19_1_, destinatai0_.gfuList_noeudOxe as gfuList20_1_, destinatai0_.gfuPreferentielIndex as gfuPrefe8_1_, destinatai0_.noeudOxe as noeudOxe1_, destinatai0_.nom as nom1_, destinatai0_.nombreTouche as nombreT11_1_, destinatai0_.numeroPosteG as numeroP12_1_, destinatai0_.numeroRsi as numeroRsi1_, destinatai0_.prefixaddon as prefixa14_1_, destinatai0_.prenom as prenom1_, destinatai0_.typePoste as typePoste1_, destinatai0_.typeTerminal as typeTer17_1_, destinatai0_1_.armer as armer2_, destinatai0_1_.cabine_pnia as cabine9_2_, destinatai0_1_.dateLastComAuto as dateLast2_2_, destinatai0_1_.fonction_pnia as fonction10_2_, destinatai0_1_.gfuAlerte as gfuAlerte2_, destinatai0_1_.ipAdress as ipAdress2_, destinatai0_1_.macAdress as macAdress2_, destinatai0_1_.numeroPosteD as numeroPo6_2_, destinatai0_1_.technicalId as technica7_2_, destinatai0_2_.numeroDebordement as numeroDe1_3_, destinatai0_3_.fonction_pnia as fonction3_4_, destinatai0_3_.numeroDebordement as numeroDe1_4_, case when destinatai0_1_.pnia is not null then 1 when destinatai0_2_.pnia is not null then 2 when destinatai0_3_.pnia is not null then 3 when destinatai0_.pnia is not null then 0 end as clazz_'
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[destinataire], fromElementByTableAlias=[destinatai0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'Destinataire destinatai0_ left outer join Abonne destinatai0_1_ on destinatai0_.pnia=destinatai0_1_.pnia left outer join Fonction destinatai0_2_ on destinatai0_.pnia=destinatai0_2_.pnia left outer join Cabine destinatai0_3_ on destinatai0_.pnia=destinatai0_3_.pnia' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=destinataire,role=null,tableName=Destinataire,tableAlias=destinatai0_,origin=null,colums={,className=Destinataire}}
\-[WHERE] SqlNode: 'WHERE'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'destinatai0_.numeroRsi' {propertyName=numeroRsi,dereferenceType=4,propertyPath=numeroRsi,path=destinataire.numeroRsi,tableAlias=destinatai0_,className=Destinataire,classAlias=destinataire}
| +-[ALIAS_REF] IdentNode: 'destinatai0_.pnia' {alias=destinataire, className=Destinataire, tableAlias=destinatai0_}
| \-[IDENT] IdentNode: 'numeroRsi' {originalText=numeroRsi}
\-[QUOTED_STRING] LiteralNode: ''36200''

// *********************************************
// LE NUMERO 36200 CORRESPOND A UNE FONCTION
// *********************************************

DEBUG CmCli - NotificationThread org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.QueryTranslatorImpl - HQL: SELECT destinataire FROM Destinataire destinataire WHERE destinataire.numeroRsi = '36200'
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select destinatai0_.pnia as pnia1_, destinatai0_.appelentrant as appelent2_1_, destinatai0_.appelsortant as appelsor3_1_, destinatai0_.catCnx_numCat as catCnx18_1_, destinatai0_.droitconf as droitconf1_, destinatai0_.droiteet as droiteet1_, destinatai0_.proteceet as proteceet1_, destinatai0_.enreg as enreg1_, destinatai0_.gfuList_gfuListNumber as gfuList19_1_, destinatai0_.gfuList_noeudOxe as gfuList20_1_, destinatai0_.gfuPreferentielIndex as gfuPrefe8_1_, destinatai0_.noeudOxe as noeudOxe1_, destinatai0_.nom as nom1_, destinatai0_.nombreTouche as nombreT11_1_, destinatai0_.numeroPosteG as numeroP12_1_, destinatai0_.numeroRsi as numeroRsi1_, destinatai0_.prefixaddon as prefixa14_1_, destinatai0_.prenom as prenom1_, destinatai0_.typePoste as typePoste1_, destinatai0_.typeTerminal as typeTer17_1_, destinatai0_1_.armer as armer2_, destinatai0_1_.cabine_pnia as cabine9_2_, destinatai0_1_.dateLastComAuto as dateLast2_2_, destinatai0_1_.fonction_pnia as fonction10_2_, destinatai0_1_.gfuAlerte as gfuAlerte2_, destinatai0_1_.ipAdress as ipAdress2_, destinatai0_1_.macAdress as macAdress2_, destinatai0_1_.numeroPosteD as numeroPo6_2_, destinatai0_1_.technicalId as technica7_2_, destinatai0_2_.numeroDebordement as numeroDe1_3_, destinatai0_3_.fonction_pnia as fonction3_4_, destinatai0_3_.numeroDebordement as numeroDe1_4_, case when destinatai0_1_.pnia is not null then 1 when destinatai0_2_.pnia is not null then 2 when destinatai0_3_.pnia is not null then 3 when destinatai0_.pnia is not null then 0 end as clazz_ from Destinataire destinatai0_ left outer join Abonne destinatai0_1_ on destinatai0_.pnia=destinatai0_1_.pnia left outer join Fonction destinatai0_2_ on destinatai0_.pnia=destinatai0_2_.pnia left outer join Cabine destinatai0_3_ on destinatai0_.pnia=destinatai0_3_.pnia where destinatai0_.numeroRsi='36200'
DEBUG CmCli - NotificationThread org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.SQL - select destinatai0_.pnia as pnia1_, destinatai0_.appelentrant as appelent2_1_, destinatai0_.appelsortant as appelsor3_1_, destinatai0_.catCnx_numCat as catCnx18_1_, destinatai0_.droitconf as droitconf1_, destinatai0_.droiteet as droiteet1_, destinatai0_.proteceet as proteceet1_, destinatai0_.enreg as enreg1_, destinatai0_.gfuList_gfuListNumber as gfuList19_1_, destinatai0_.gfuList_noeudOxe as gfuList20_1_, destinatai0_.gfuPreferentielIndex as gfuPrefe8_1_, destinatai0_.noeudOxe as noeudOxe1_, destinatai0_.nom as nom1_, destinatai0_.nombreTouche as nombreT11_1_, destinatai0_.numeroPosteG as numeroP12_1_, destinatai0_.numeroRsi as numeroRsi1_, destinatai0_.prefixaddon as prefixa14_1_, destinatai0_.prenom as prenom1_, destinatai0_.typePoste as typePoste1_, destinatai0_.typeTerminal as typeTer17_1_, destinatai0_1_.armer as armer2_, destinatai0_1_.cabine_pnia as cabine9_2_, destinatai0_1_.dateLastComAuto as dateLast2_2_, destinatai0_1_.fonction_pnia as fonction10_2_, destinatai0_1_.gfuAlerte as gfuAlerte2_, destinatai0_1_.ipAdress as ipAdress2_, destinatai0_1_.macAdress as macAdress2_, destinatai0_1_.numeroPosteD as numeroPo6_2_, destinatai0_1_.technicalId as technica7_2_, destinatai0_2_.numeroDebordement as numeroDe1_3_, destinatai0_3_.fonction_pnia as fonction3_4_, destinatai0_3_.numeroDebordement as numeroDe1_4_, case when destinatai0_1_.pnia is not null then 1 when destinatai0_2_.pnia is not null then 2 when destinatai0_3_.pnia is not null then 3 when destinatai0_.pnia is not null then 0 end as clazz_ from Destinataire destinatai0_ left outer join Abonne destinatai0_1_ on destinatai0_.pnia=destinatai0_1_.pnia left outer join Fonction destinatai0_2_ on destinatai0_.pnia=destinatai0_2_.pnia left outer join Cabine destinatai0_3_ on destinatai0_.pnia=destinatai0_3_.pnia where destinatai0_.numeroRsi='36200'
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - result row: EntityKey[Destinataire#8111006200]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - resolving associations for [Destinataire#8111006200]
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - loading entity: [CatCnx#3]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.SQL - select catcnx0_.numCat as numCat0_0_, catcnx0_.segmentCompatible as segmentC2_0_0_ from CatCnx catcnx0_ where catcnx0_.numCat=?
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - result row: EntityKey[CatCnx#3]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - resolving associations for [CatCnx#3]
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - done materializing entity [CatCnx#3]
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - done entity load
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - loading entity: [GfuList#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.SQL - select gfulist0_.gfuListNumber as gfuListN1_8_0_, gfulist0_.noeudOxe as noeudOxe8_0_ from GfuList gfulist0_ where gfulist0_.gfuListNumber=? and gfulist0_.noeudOxe=?
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - result row: EntityKey[GfuList#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - resolving associations for [GfuList#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}]
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - done materializing entity [GfuList#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}]
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - done entity load
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - done materializing entity [Destinataire#8111006200]
DEBUG CmCli - NotificationThread org.hibernate.engine.StatefulPersistenceContext - initializing non-lazy collections
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - commit
DEBUG CmCli - NotificationThread org.hibernate.event.def.AbstractFlushingEventListener - processing flush-time cascades
DEBUG CmCli - NotificationThread org.hibernate.event.def.AbstractFlushingEventListener - dirty checking collections



DEBUG CmCli - NotificationThread org.hibernate.engine.Collections - Collection found: [Destinataire.ceis#8111006200], was: [Destinataire.ceis#8111006200] (uninitialized)
DEBUG CmCli - NotificationThread org.hibernate.engine.Collections - Collection found: [Destinataire.onglet#8111006200], was: [Destinataire.onglet#8111006200] (uninitialized)

// *******************************************************************************************
// HIBERNATE trouve une instance de Destinataire alors qu'il s'agit d'un instance de Fonction
// *******************************************************************************************
DEBUG CmCli - NotificationThread org.hibernate.engine.Collections - Collection found: [GfuList.destinataire#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}], was: [GfuList.destinataire#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}] (uninitialized)
DEBUG CmCli - NotificationThread org.hibernate.engine.Collections - Collection found: [GfuList.gfu#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}], was: [GfuList.gfu#component[gfuListNumber,noeudOxe]{gfuListNumber=0, noeudOxe=TORCTI}] (uninitialized)




DEBUG CmCli - NotificationThread org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 0 insertions, 0 updates, 0 deletions to 3 objects
DEBUG CmCli - NotificationThread org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 4 collections
DEBUG CmCli - NotificationThread org.hibernate.pretty.Printer - listing entities:
DEBUG CmCli - NotificationThread org.hibernate.pretty.Printer - GfuList{destinataire=<uninitialized>, gfu=<uninitialized>}
DEBUG CmCli - NotificationThread org.hibernate.pretty.Printer - CatCnx{segmentCompatible=11111111111111111111111111111111, numCat=3}
DEBUG CmCli - NotificationThread org.hibernate.pretty.Printer - Destinataire{catCnx=CatCnx#3, droitAutorisationConference=true, gfuList=GfuList, prenom=null, nombreTouche=0, prefixDroitConference=811100623*3, enreg=null, numeroPniaRsi=8111006200, nom=cla1, onglet=<uninitialized>, ceis=<uninitialized>, accesEntrant=true, accesSortant=true, numeroPosteG=null, droitAutorisationEntreEnTier=true, droitProtectionContreEntreEnTier=true, noeudOxe=TORCTI, gfuPreferentielIndex=0, numeroRsi=36200, typeTerminal=null, typePoste=FCT_CLA}
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - committed JDBC Connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]

DEBUG CmCli - NotificationThread org.hibernate.impl.SessionImpl - opened session at timestamp: 12356446162
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - begin
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - opening JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - current autocommit status: false
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - rollback
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - rolled back JDBC Connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - begin
DEBUG CmCli - NotificationThread org.hibernate.jdbc.ConnectionManager - opening JDBC connection
DEBUG CmCli - NotificationThread org.hibernate.transaction.JDBCTransaction - current autocommit status: false
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.SQL - select destinatai0_.pnia as pnia1_, destinatai0_.appelentrant as appelent2_1_, destinatai0_.appelsortant as appelsor3_1_, destinatai0_.catCnx_numCat as catCnx18_1_, destinatai0_.droitconf as droitconf1_, destinatai0_.droiteet as droiteet1_, destinatai0_.proteceet as proteceet1_, destinatai0_.enreg as enreg1_, destinatai0_.gfuList_gfuListNumber as gfuList19_1_, destinatai0_.gfuList_noeudOxe as gfuList20_1_, destinatai0_.gfuPreferentielIndex as gfuPrefe8_1_, destinatai0_.noeudOxe as noeudOxe1_, destinatai0_.nom as nom1_, destinatai0_.nombreTouche as nombreT11_1_, destinatai0_.numeroPosteG as numeroP12_1_, destinatai0_.numeroRsi as numeroRsi1_, destinatai0_.prefixaddon as prefixa14_1_, destinatai0_.prenom as prenom1_, destinatai0_.typePoste as typePoste1_, destinatai0_.typeTerminal as typeTer17_1_, destinatai0_1_.armer as armer2_, destinatai0_1_.cabine_pnia as cabine9_2_, destinatai0_1_.dateLastComAuto as dateLast2_2_, destinatai0_1_.fonction_pnia as fonction10_2_, destinatai0_1_.gfuAlerte as gfuAlerte2_, destinatai0_1_.ipAdress as ipAdress2_, destinatai0_1_.macAdress as macAdress2_, destinatai0_1_.numeroPosteD as numeroPo6_2_, destinatai0_1_.technicalId as technica7_2_, destinatai0_2_.numeroDebordement as numeroDe1_3_, destinatai0_3_.fonction_pnia as fonction3_4_, destinatai0_3_.numeroDebordement as numeroDe1_4_, case when destinatai0_1_.pnia is not null then 1 when destinatai0_2_.pnia is not null then 2 when destinatai0_3_.pnia is not null then 3 when destinatai0_.pnia is not null then 0 end as clazz_ from Destinataire destinatai0_ left outer join Abonne destinatai0_1_ on destinatai0_.pnia=destinatai0_1_.pnia left outer join Fonction destinatai0_2_ on destinatai0_.pnia=destinatai0_2_.pnia left outer join Cabine destinatai0_3_ on destinatai0_.pnia=destinatai0_3_.pnia where destinatai0_.numeroRsi='36200'

DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG CmCli - NotificationThread org.hibernate.loader.Loader - result row: EntityKey[Destinataire#8111006200]
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG CmCli - NotificationThread org.hibernate.engine.TwoPhaseLoad - resolving associations for [Destinataire#8111006200]
[/code]

Cordialement,[/code]