Luis,
08:29:33,200 INFO [SettingsFactory] Use outer join fetching: true First query: 08:31:24,981 INFO [STDOUT] Hibernate: select this.ID as ID0_, this.INDI as INDI0_, this.ID_TIER as ID_TIER0_, this.ID_SITUFAMI as ID_SITUF4_0_, this.ID_NATI as ID_NATI0_, this.ID_PORT as ID_PORT0_, this.ID_ACTRLOCA as ID_ACTRL7_0_, this.ID_UNTEPAYS as ID_UNTEP8_0_, this.NOM_JFIL as NOM_JFIL0_, this.NOM as NOM0_, this.PREN as PREN0_, this.PREN2 as PREN20_, this.DATECREA as DATECREA0_, this.DATEMSAJ as DATEMSAJ0_, this.DATENAIS as DATENAIS0_, this.JOURNAIS as JOURNAIS0_, this.MOISNAIS as MOISNAIS0_, this.ANNENAIS as ANNENAIS0_, this.DATEDECE as DATEDECE0_, this.JOURDECE as JOURDECE0_, this.MOISDECE as MOISDECE0_, this.ANNEDECE as ANNEDECE0_, this.DECE as DECE0_, this.SEXE as SEXE0_, this.CIVI as CIVI0_, this.NOM_PREN as NOM_PREN0_, this.DATECALCINDILIES as DATECAL27_0_, this.VILL as VILL0_, this.NAISINCO as NAISINCO0_, this.ID_UNTOGEST as ID_UNTO30_0_, this.NUMEAVS asNUMEAVS0_, this.STAT as STAT0_, this.ID_LIEUORIG as ID_LIEU33_0_, this.ID_CANTORIG as ID_CANT34_0_, this.DATEENTRCANT as DATEENT35_0_, this.DATEENTRSUIS as DATEENT36_0_, this.ID_PERMSEJO as ID_PERM37_0_, this.ID_RELI as ID_RELI0_, this.ID_DEGRCONF as ID_DEGR39_0_, this.DATEVALIPERM as DATEVAL40_0_, this.ZONEINDI1 as ZONEINDI10_, this.ZONEINDI2 as ZONEINDI20_, this.ZONEINDI3 as ZONEINDI30_, this.DEBUSITUFAMI as DEBUSIT44_0_, this.USERCREA as USERCREA0_, this.USERMSAJ as USERMSAJ0_, this.NOM_CODE as NOM_CODE0_ from INDIVI this where lower(this.NOM) like ? Second query (first dependency query): 08:31:25,247 INFO [STDOUT] Hibernate: select indsocs0_.INDI as INDI__, indsocs0_.ID as ID__, indsocs0_.ID as ID5_, indsocs0_.INDS as INDS5_, indsocs0_.DSOC asDSOC5_, indsocs0_.INDI as INDI5_, indsocs0_.DATECREA as DATECREA5_, indsocs0_.DATEMSAJ as DATEMSAJ5_, indsocs0_.INDSPRIN as INDSPRIN5_, indsocs0_.ID_TYPEQUAL as ID_TYPEQ8_5_, indsocs0_.USERCREA as USERCREA5_, indsocs0_.USERMSAJ as USERMSAJ5_, dossocimpl1_.ID as ID0_, dossocimpl1_.DSOC as DSOC0_, dossocimpl1_.ID_PORT as ID_PORT0_, dossocimpl1_.ID_TYPEDOSS as ID_TYPED4_0_, dossocimpl1_.ID_PRESDSOC as ID_PRESD5_0_, dossocimpl1_.ID_ACTRLOCA as ID_ACTRL6_0_, dossocimpl1_.NATU as NATU0_, dossocimpl1_.DATECREA as DATECREA0_, dossocimpl1_.DATEMSAJ as DATEMSAJ0_, dossocimpl1_.DPREINDI as DPREINDI0_, dossocimpl1_.ID_DPRETIER as ID_DPRE11_0_,dossocimpl1_.ZONEDOSS1 as ZONEDOSS10_, dossocimpl1_.ZONEDOSS2 as ZONEDOSS20_, dossocimpl1_.ZONEDOSS3 as ZONEDOSS30_, dossocimpl1_.ZONEDOSS4 as ZONEDOSS40_, dossocimpl1 _.ZONEDOSS6 as ZONEDOSS60_, dossocimpl1_.ZONEDOSS7 as ZONEDOSS70_, dossocimpl1_.ZONEDOSS8 as ZONEDOSS80_, dossocimpl1_.ID_STAT as ID_STAT0_, dossocimpl1_.USERCREA as USERCREA0_, dossocimpl1_.USERMSAJ as USERMSAJ0_, dossocimpl1_.ZONEDOSS5 as ZONEDOSS50_, portefimpl2_.ID as ID1_, portefimpl2_.PORT as PORT1_, portefimpl2_.ID_ACTR as ID_ACTR1_, portefimpl2_.PORTNATF as PORTNATF1_, portefimpl2_.DATECREA as DATECREA1_, portefimpl2_.DATEMSAJ as DATEMSAJ1_, acteurimpl3_.ID asID2_, acteurimpl3_.ACTR as ACTR2_, acteurimpl3_.ID_UNTE as ID_UNTE2_, acteurimpl3_.ID_TIER as ID_TIER2_, acteurimpl3_.DATECREA as DATECREA2_, acteurimpl3_.DATEMSAJ as DATEMSAJ2_, acteurimpl3_.DATEDEBUEFFE as DATEDEBU7_2_, acteurimpl3_.DATEFIN_EFFE as DATEFIN_8_2_, acteurimpl3_.NOM as NOM2_, acteurimpl3_.PREN as PREN2_, acteurimpl3_.CIVI as CIVI2_, acteurimpl3_.TYPE as TYPE2_, acteurimpl3_.LIBL asLIBL2_, acteurimpl3_.DATEPASS as DATEPASS2_, acteurimpl3_.ID_BASE as ID_BASE2_,acteurimpl3_.ID_UTILORAC as ID_UTIL16_2 _, acteurimpl3_.ID_CATEACTR as ID_CATE17_2_, acteurimpl3_.NOM_PREN as NOM_PREN2_, acteurimpl3_.ADRE1 as ADRE12_, acteurimpl3_.ADRE2 as ADRE22_, acteurimpl3_.ADRE3 as ADRE32_, acteurimpl3_.CODEPOST as CODEPOST2_, acteurimpl3_.TELE as TELE2_, acteurimpl3_.FAX as FAX2_, acteurimpl3_.FONC as FONC2_, acteurimpl3_.CENTCOMP as CENTCOMP2_, acteurimpl3_.LANG as LANG2_, acteurimpl3_.ACTRWEB as ACTRWEB2_, acteurimpl3_.EMAIL as EMAIL2_, acteurimpl3_.MAXIOCCU as MAXIOCCU2_, acteurimpl3_.USERCREA as USERCREA2_, acteurimpl3_.USERMSAJ as USERMSAJ2_, acteurimpl3_.CPY_CPTA as CPY_CPTA2_, acteurimpl3_.NOM_CPTA as NOM_CPTA2_, acteurimpl3_.PWD_CPTA as PWD_CPTA2_, nomenc2imp4_.ID as ID3_, nomenc2imp4_.NOME as NOME3_, nomenc2imp4_.TYPO as TYPO3_, nomenc2imp4_.LIBL as LIBL3_, nomenc2imp4_.DATECREA as DATECREA3_, nomenc2imp4_.DATEMSAJ as DATEMSAJ3_, nomenc2imp4_.DATEDEBUEFFE as DATEDEBU7_3_, nomenc2imp4_.DATEFIN_EFFE as DATEFIN_8_3_, nomenc2imp4_.INTR as INTR3_, nomenc2imp4_.DSCR as DSCR3_, nomenc2i mp4_.PRODANIS as PRODANIS3_, nomencimpl5_.ID as ID4_, nomencimpl5_.NOME as NOME4_, nomencimpl5_.TYPO as TYPO4_, nomencimpl5_.LIBL as LIBL4_, nomencimpl5_.DATECREA as DATECREA4_, nomencimpl5_.DATEMSAJ as DATEMSAJ4_, nomencimpl5_.DATEDEBUEFFE as DATEDEBU7_4_, nomencimpl5_.DATEFIN_EFFE as DATEFIN_8_4_, nomencimpl5_.INTR as INTR4_, nomencimpl5_.DSCR as DSCR4_, nomencimpl5_.PRODANIS as PRODANIS4_ from INDSOC indsocs0_, DOSSOC dossocimpl1_, PORTEF portefimpl2_, ACTEUR acteurimpl3_, NOMENC2 nomenc2imp4_, NOMENC nomencimpl5_ where indsocs0_.INDI=? and indsocs0_.DSOC=dossocimpl1_.ID(+) and dossocimpl1_.ID_PORT=portefimpl2_.ID(+) and portefimpl2_.ID_ACTR=acteurimpl3_.ID(+) and dossocimpl1_.ID_STAT=nomenc2imp4_.ID(+) and indsocs0_.ID_TYPEQUAL=nomencimpl5_.ID(+) order by indsocs0_.INDI Thx. Ced. _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=1321#1321 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user