-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: outer-join dont' work
PostPosted: Mon Mar 06, 2006 11:26 am 
Regular
Regular

Joined: Thu Feb 24, 2005 2:34 pm
Posts: 80
Hibernate version:3.1
Hi i don't understand because Hibernate resolve my query with inner join
"inner join sdgtwb_dat.PBODT$0F"{<many-to-one name="consegne" class="vo.as400.CConsegneVO" ...}
when i have write outer-join="true" into hbm file.
Can you help me please
Devis

[code]
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>


<class name="vo.as400.CCommesseriVO" table="sdgtwb_dat.pbori00f" lazy="false">



<composite-id name="pk" class="vo.pk.CComesseriPK">
<key-property name="STAGPG" column="STAGPG" type="dao.hibernate.TrimmedString" />
<key-property name="NUBPPG" column="NUBPPG"/>
<key-property name="SQBPPG" column="SQBPPG"/>
<key-property name="NRBPPG" column="NRBPPG"/>
<key-property name="NSBPPG" column="NSBPPG"/>
<key-property name="NUBTPG" column="NUBTPG"/>
</composite-id>

<property name="STREPG" column="STREPG" type="dao.hibernate.TrimmedString" />
<property name="NRAZPG" column="NRAZPG" />
<property name="DTUMPG" column="DTUMPG" />
<property name="ORUMPG" column="ORUMPG" />
<property name="BLREPG" column="BLREPG" type="dao.hibernate.TrimmedString" />
<property name="NULAPG" column="NULAPG" />
<property name="GGLAPG" column="GGLAPG" />
<property name="MMLAPG" column="MMLAPG" />
<property name="AALAPG" column="AALAPG" />
<property name="SOLAPG" column="SOLAPG" />
<property name="NUORPG" column="NUORPG" />
<property name="NURIPG" column="NURIPG" />
<property name="NUSRPG" column="NUSRPG" />
<property name="CDCLPG" column="CDCLPG" type="dao.hibernate.TrimmedString" />
<property name="GGCCPG" column="GGCCPG" />
<property name="MMCCPG" column="MMCCPG" />
<property name="AACCPG" column="AACCPG" />
<property name="SOCCPG" column="SOCCPG" />
<property name="MARCPG" column="MARCPG" type="dao.hibernate.TrimmedString" />
<property name="LINEPG" column="LINEPG" type="dao.hibernate.TrimmedString" />
<property name="SLINPG" column="SLINPG" type="dao.hibernate.TrimmedString" />
<property name="MARPPG" column="MARPPG" type="dao.hibernate.TrimmedString" />
<property name="LINPPG" column="LINPPG" type="dao.hibernate.TrimmedString" />
<property name="SLIPPG" column="SLIPPG" type="dao.hibernate.TrimmedString" />
<property name="MODPPG" column="MODPPG" type="dao.hibernate.TrimmedString" />
<property name="MATPPG" column="MATPPG" type="dao.hibernate.TrimmedString" />
<property name="COLPPG" column="COLPPG" type="dao.hibernate.TrimmedString" />
<property name="VARPPG" column="VARPPG" type="dao.hibernate.TrimmedString" />
<property name="CCAPPG" column="CCAPPG" type="dao.hibernate.TrimmedString" />
<property name="CETPPG" column="CETPPG" type="dao.hibernate.TrimmedString" />
<property name="DROPPG" column="DROPPG" type="dao.hibernate.TrimmedString" />
<property name="CCTPPG" column="CCTPPG" type="dao.hibernate.TrimmedString" />
<property name="MODFPG" column="MODFPG" type="dao.hibernate.TrimmedString" />
<property name="MATFPG" column="MATFPG" type="dao.hibernate.TrimmedString" />
<property name="COLFPG" column="COLFPG" type="dao.hibernate.TrimmedString" />
<property name="VARFPG" column="VARFPG" type="dao.hibernate.TrimmedString" />
<property name="CCAFPG" column="CCAFPG" type="dao.hibernate.TrimmedString" />
<property name="CETFPG" column="CETFPG" type="dao.hibernate.TrimmedString" />
<property name="DROFPG" column="DROFPG" type="dao.hibernate.TrimmedString" />
<property name="CCTFPG" column="CCTFPG" type="dao.hibernate.TrimmedString" />
<property name="MOEQPG" column="MOEQPG" type="dao.hibernate.TrimmedString" />
<property name="MOEFPG" column="MOEFPG" type="dao.hibernate.TrimmedString" />
<property name="MOEIPG" column="MOEIPG" type="dao.hibernate.TrimmedString" />
<property name="CDTGPG" column="CDTGPG" type="dao.hibernate.TrimmedString" />
<property name="QT01PG" column="QT01PG" />
<property name="QT02PG" column="QT02PG" />
<property name="QT03PG" column="QT03PG" />
<property name="QT04PG" column="QT04PG" />
<property name="QT05PG" column="QT05PG" />
<property name="QT06PG" column="QT06PG" />
<property name="QT07PG" column="QT07PG" />
<property name="QT08PG" column="QT08PG" />
<property name="QT09PG" column="QT09PG" />
<property name="QT10PG" column="QT10PG" />
<property name="QT11PG" column="QT11PG" />
<property name="QT12PG" column="QT12PG" />
<property name="QT13PG" column="QT13PG" />
<property name="QT14PG" column="QT14PG" />
<property name="QT15PG" column="QT15PG" />
<property name="QT16PG" column="QT16PG" />
<property name="QT17PG" column="QT17PG" />
<property name="QT18PG" column="QT18PG" />
<property name="QT19PG" column="QT19PG" />
<property name="QT20PG" column="QT20PG" />
<property name="QT21PG" column="QT21PG" />
<property name="QT22PG" column="QT22PG" />
<property name="QT23PG" column="QT23PG" />
<property name="QT24PG" column="QT24PG" />
<property name="QT25PG" column="QT25PG" />
<property name="QT26PG" column="QT26PG" />
<property name="QT27PG" column="QT27PG" />
<property name="QT28PG" column="QT28PG" />
<property name="QT29PG" column="QT29PG" />
<property name="QT30PG" column="QT30PG" />
<property name="QT31PG" column="QT31PG" />
<property name="QT32PG" column="QT32PG" />
<property name="QT33PG" column="QT33PG" />
<property name="QT34PG" column="QT34PG" />
<property name="QO01PG" column="QO01PG" />
<property name="QO02PG" column="QO02PG" />
<property name="QO03PG" column="QO03PG" />
<property name="QO04PG" column="QO04PG" />
<property name="QO05PG" column="QO05PG" />
<property name="QO06PG" column="QO06PG" />
<property name="QO07PG" column="QO07PG" />
<property name="QO08PG" column="QO08PG" />
<property name="QO09PG" column="QO09PG" />
<property name="QO10PG" column="QO10PG" />
<property name="QO11PG" column="QO11PG" />
<property name="QO12PG" column="QO12PG" />
<property name="QO13PG" column="QO13PG" />
<property name="QO14PG" column="QO14PG" />
<property name="QO15PG" column="QO15PG" />
<property name="QO16PG" column="QO16PG" />
<property name="QO17PG" column="QO17PG" />
<property name="QO18PG" column="QO18PG" />
<property name="QO19PG" column="QO19PG" />
<property name="QO20PG" column="QO20PG" />
<property name="QO21PG" column="QO21PG" />
<property name="QO22PG" column="QO22PG" />
<property name="QO23PG" column="QO23PG" />
<property name="QO24PG" column="QO24PG" />
<property name="QO25PG" column="QO25PG" />
<property name="QO26PG" column="QO26PG" />
<property name="QO27PG" column="QO27PG" />
<property name="QO28PG" column="QO28PG" />
<property name="QO29PG" column="QO29PG" />
<property name="QO30PG" column="QO30PG" />
<property name="QO31PG" column="QO31PG" />
<property name="QO32PG" column="QO32PG" />
<property name="QO33PG" column="QO33PG" />
<property name="QO34PG" column="QO34PG" />
<property name="QD01PG" column="QD01PG" />
<property name="QD02PG" column="QD02PG" />
<property name="QD03PG" column="QD03PG" />
<property name="QD04PG" column="QD04PG" />
<property name="QD05PG" column="QD05PG" />
<property name="QD06PG" column="QD06PG" />
<property name="QD07PG" column="QD07PG" />
<property name="QD08PG" column="QD08PG" />
<property name="QD09PG" column="QD09PG" />
<property name="QD10PG" column="QD10PG" />
<property name="QD11PG" column="QD11PG" />
<property name="QD12PG" column="QD12PG" />
<property name="QD13PG" column="QD13PG" />
<property name="QD14PG" column="QD14PG" />
<property name="QD15PG" column="QD15PG" />
<property name="QD16PG" column="QD16PG" />
<property name="QD17PG" column="QD17PG" />
<property name="QD18PG" column="QD18PG" />
<property name="QD19PG" column="QD19PG" />
<property name="QD20PG" column="QD20PG" />
<property name="QD21PG" column="QD21PG" />
<property name="QD22PG" column="QD22PG" />
<property name="QD23PG" column="QD23PG" />
<property name="QD24PG" column="QD24PG" />
<property name="QD25PG" column="QD25PG" />
<property name="QD26PG" column="QD26PG" />
<property name="QD27PG" column="QD27PG" />
<property name="QD28PG" column="QD28PG" />
<property name="QD29PG" column="QD29PG" />
<property name="QD30PG" column="QD30PG" />
<property name="QD31PG" column="QD31PG" />
<property name="QD32PG" column="QD32PG" />
<property name="QD33PG" column="QD33PG" />
<property name="QD34PG" column="QD34PG" />
<property name="QV01PG" column="QV01PG" />
<property name="QV02PG" column="QV02PG" />
<property name="QV03PG" column="QV03PG" />
<property name="QV04PG" column="QV04PG" />
<property name="QV05PG" column="QV05PG" />
<property name="QV06PG" column="QV06PG" />
<property name="QV07PG" column="QV07PG" />
<property name="QV08PG" column="QV08PG" />
<property name="QV09PG" column="QV09PG" />
<property name="QV10PG" column="QV10PG" />
<property name="QV11PG" column="QV11PG" />
<property name="QV12PG" column="QV12PG" />
<property name="QV13PG" column="QV13PG" />
<property name="QV14PG" column="QV14PG" />
<property name="QV15PG" column="QV15PG" />
<property name="QV16PG" column="QV16PG" />
<property name="QV17PG" column="QV17PG" />
<property name="QV18PG" column="QV18PG" />
<property name="QV19PG" column="QV19PG" />
<property name="QV20PG" column="QV20PG" />
<property name="QV21PG" column="QV21PG" />
<property name="QV22PG" column="QV22PG" />
<property name="QV23PG" column="QV23PG" />
<property name="QV24PG" column="QV24PG" />
<property name="QV25PG" column="QV25PG" />
<property name="QV26PG" column="QV26PG" />
<property name="QV27PG" column="QV27PG" />
<property name="QV28PG" column="QV28PG" />
<property name="QV29PG" column="QV29PG" />
<property name="QV30PG" column="QV30PG" />
<property name="QV31PG" column="QV31PG" />
<property name="QV32PG" column="QV32PG" />
<property name="QV33PG" column="QV33PG" />
<property name="QV34PG" column="QV34PG" />
<property name="QF01PG" column="QF01PG" />
<property name="QF02PG" column="QF02PG" />
<property name="QF03PG" column="QF03PG" />
<property name="QF04PG" column="QF04PG" />
<property name="QF05PG" column="QF05PG" />
<property name="QF06PG" column="QF06PG" />
<property name="QF07PG" column="QF07PG" />
<property name="QF08PG" column="QF08PG" />
<property name="QF09PG" column="QF09PG" />
<property name="QF10PG" column="QF10PG" />
<property name="QF11PG" column="QF11PG" />
<property name="QF12PG" column="QF12PG" />
<property name="QF13PG" column="QF13PG" />
<property name="QF14PG" column="QF14PG" />
<property name="QF15PG" column="QF15PG" />
<property name="QF16PG" column="QF16PG" />
<property name="QF17PG" column="QF17PG" />
<property name="QF18PG" column="QF18PG" />
<property name="QF19PG" column="QF19PG" />
<property name="QF20PG" column="QF20PG" />
<property name="QF21PG" column="QF21PG" />
<property name="QF22PG" column="QF22PG" />
<property name="QF23PG" column="QF23PG" />
<property name="QF24PG" column="QF24PG" />
<property name="QF25PG" column="QF25PG" />
<property name="QF26PG" column="QF26PG" />
<property name="QF27PG" column="QF27PG" />
<property name="QF28PG" column="QF28PG" />
<property name="QF29PG" column="QF29PG" />
<property name="QF30PG" column="QF30PG" />
<property name="QF31PG" column="QF31PG" />
<property name="QF32PG" column="QF32PG" />
<property name="QF33PG" column="QF33PG" />
<property name="QF34PG" column="QF34PG" />
<property name="QM01PG" column="QM01PG" />
<property name="QM02PG" column="QM02PG" />
<property name="QM03PG" column="QM03PG" />
<property name="QM04PG" column="QM04PG" />
<property name="QM05PG" column="QM05PG" />
<property name="QM06PG" column="QM06PG" />
<property name="QM07PG" column="QM07PG" />
<property name="QM08PG" column="QM08PG" />
<property name="QM09PG" column="QM09PG" />
<property name="QM10PG" column="QM10PG" />
<property name="QM11PG" column="QM11PG" />
<property name="QM12PG" column="QM12PG" />
<property name="QM13PG" column="QM13PG" />
<property name="QM14PG" column="QM14PG" />
<property name="QM15PG" column="QM15PG" />
<property name="QM16PG" column="QM16PG" />
<property name="QM17PG" column="QM17PG" />
<property name="QM18PG" column="QM18PG" />
<property name="QM19PG" column="QM19PG" />
<property name="QM20PG" column="QM20PG" />
<property name="QM21PG" column="QM21PG" />
<property name="QM22PG" column="QM22PG" />
<property name="QM23PG" column="QM23PG" />
<property name="QM24PG" column="QM24PG" />
<property name="QM25PG" column="QM25PG" />
<property name="QM26PG" column="QM26PG" />
<property name="QM27PG" column="QM27PG" />
<property name="QM28PG" column="QM28PG" />
<property name="QM29PG" column="QM29PG" />
<property name="QM30PG" column="QM30PG" />
<property name="QM31PG" column="QM31PG" />
<property name="QM32PG" column="QM32PG" />
<property name="QM33PG" column="QM33PG" />
<property name="QM34PG" column="QM34PG" />
<property name="TQTAPG" column="TQTAPG" type="dao.hibernate.DoubleAS400" />
<property name="TQORPG" column="TQORPG" type="dao.hibernate.DoubleAS400" />
<property name="TQDSPG" column="TQDSPG" type="dao.hibernate.DoubleAS400" />
<property name="TQVAPG" column="TQVAPG" type="dao.hibernate.DoubleAS400" />
<property name="TQDFPG" column="TQDFPG" type="dao.hibernate.DoubleAS400" />
<property name="TQVEPG" column="TQVEPG" type="dao.hibernate.DoubleAS400" />
<property name="AVANPG" column="AVANPG" type="dao.hibernate.TrimmedString" />
<property name="GGAVPG" column="GGAVPG" />
<property name="MMAVPG" column="MMAVPG" />
<property name="AAAVPG" column="AAAVPG" />
<property name="SOAVPG" column="SOAVPG" />
<property name="STAVPG" column="STAVPG" type="dao.hibernate.TrimmedString" />
<property name="LIPRPG" column="LIPRPG" type="dao.hibernate.TrimmedString" />
<property name="SRIBPG" column="SRIBPG" type="dao.hibernate.TrimmedString" />
<property name="FCOMPG" column="FCOMPG" type="dao.hibernate.TrimmedString" />
<property name="GSBPPG" column="GSBPPG" type="dao.hibernate.TrimmedString" />
<property name="FRCMPG" column="FRCMPG" type="dao.hibernate.TrimmedString" />
<property name="FECMPG" column="FECMPG" type="dao.hibernate.TrimmedString" />
<property name="FLA1PG" column="FLA1PG" type="dao.hibernate.TrimmedString" />
<property name="FLA2PG" column="FLA2PG" type="dao.hibernate.TrimmedString" />
<property name="FLA3PG" column="FLA3PG" type="dao.hibernate.TrimmedString" />
<property name="FLA4PG" column="FLA4PG" type="dao.hibernate.TrimmedString" />
<property name="FLA5PG" column="FLA5PG" type="dao.hibernate.TrimmedString" />
<property name="FLA6PG" column="FLA6PG" type="dao.hibernate.TrimmedString" />
<property name="FLA7PG" column="FLA7PG" type="dao.hibernate.TrimmedString" />
<property name="FLA8PG" column="FLA8PG" type="dao.hibernate.TrimmedString" />
<property name="FL10PG" column="FL10PG" type="dao.hibernate.TrimmedString" />
<property name="FL20PG" column="FL20PG" type="dao.hibernate.TrimmedString" />
<property name="FL30PG" column="FL30PG" type="dao.hibernate.TrimmedString" />


<many-to-one name="prodotto" class="vo.as400.PfVO" lazy="false" update="false" insert="false" not-null="true" not-found="ignore" >
<column name="STAGPG"/>
<column name="MODPPG"/>
<column name="MATPPG"/>
</many-to-one>

<!--
<many-to-one name="laboratori" class="vo.as400.CLaboratoriVO" lazy="false" update="false" insert="false" >

<formula>'LPR'</formula>
<formula>(' '||LINEPG)</formula>
</many-to-one>
-->



<many-to-one name="consegne" class="vo.as400.CConsegneVO" lazy="false" update="false" insert="false" not-found="ignore" outer-join="true">
<column name="STAGPG"/>
<column name="NUBPPG"/>
<column name="SQBPPG"/>
<column name="NRBPPG"/>
</many-to-one>

<many-to-one name="avanma" class="vo.as400.CCodiceAvanzamentoVO" lazy="false" update="false" not-null="true" insert="false" not-found="ignore">
<formula>'AVA'</formula>
<column name="AVANPG"/>
</many-to-one>







<!--

<many-to-one name="listino" class="vo.as400.CClistinoVO" lazy="false" not-null="true" update="false" insert="false" not-found="ignore">
<column name="STAGPG"/>
<column name="MARCPG"/>
<column name="LINEPG"/>
<column name="SLINPG"/>
<column name="MODPPG"/>
<column name="MATPPG"/>
<column name="VARPPG"/>
</many-to-one>






<many-to-one name="ordine" class="vo.as400.COrdinirVO" lazy="false" update="false" insert="false" not-found="ignore">
<column name="STAGPG"/>
<column name="NUORPG"/>
<column name="NURIPG"/>
</many-to-one>

<
-->
</class>

</hibernate-mapping>
16:18:40,573 INFO HbmBinder:261 - Mapping class: vo.as400.CStagione -> sdgtwb_dat.arctb00f
985 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CStagione -> sdgtwb_dat.arctb00f
16:18:40,713 INFO Configuration:425 - Reading mappings from resource: db2400_laboratori.hbm.xml
1125 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_laboratori.hbm.xml
16:18:40,776 INFO HbmBinder:261 - Mapping class: vo.as400.CLaboratoriVO -> sdgtwb_dat.arctb00f
1188 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CLaboratoriVO -> sdgtwb_dat.arctb00f
16:18:40,791 INFO Configuration:425 - Reading mappings from resource: db2400_cmpf.hbm.xml
1203 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_cmpf.hbm.xml
16:18:40,854 INFO HbmBinder:261 - Mapping class: vo.as400.CCmpf -> sdgtwb_dat.arctb00f
1266 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCmpf -> sdgtwb_dat.arctb00f
16:18:40,870 INFO Configuration:425 - Reading mappings from resource: db2400_cfpf.hbm.xml
1282 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_cfpf.hbm.xml
16:18:40,901 INFO HbmBinder:261 - Mapping class: vo.as400.CCategoriFiscaleVO -> sdgtwb_dat.arctb00f
1313 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCategoriFiscaleVO -> sdgtwb_dat.arctb00f
16:18:40,901 INFO Configuration:425 - Reading mappings from resource: db2400_cmm.hbm.xml
1313 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_cmm.hbm.xml
16:18:40,948 INFO HbmBinder:261 - Mapping class: vo.as400.CCategoriaMaterialeVO -> sdgtwb_dat.arctb00f
1360 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCategoriaMaterialeVO -> sdgtwb_dat.arctb00f
16:18:40,948 INFO Configuration:425 - Reading mappings from resource: db2400_cfm.hbm.xml
1360 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_cfm.hbm.xml
16:18:40,963 INFO HbmBinder:261 - Mapping class: vo.as400.CCategoriaFiscaleMaterialeVO -> sdgtwb_dat.arctb00f
1375 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCategoriaFiscaleMaterialeVO -> sdgtwb_dat.arctb00f
16:18:40,979 INFO Configuration:425 - Reading mappings from resource: db2400_avanzamento.hbm.xml
1391 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_avanzamento.hbm.xml
16:18:41,010 INFO HbmBinder:261 - Mapping class: vo.as400.CCodiceAvanzamentoVO -> sdgtwb_dat.arctb00f
1422 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCodiceAvanzamentoVO -> sdgtwb_dat.arctb00f
16:18:41,010 INFO Configuration:425 - Reading mappings from resource: db2400_flash.hbm.xml
1422 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_flash.hbm.xml
16:18:41,057 INFO HbmBinder:261 - Mapping class: vo.as400.CFlashVO -> sdgtwb_dat.arctb00f
1469 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CFlashVO -> sdgtwb_dat.arctb00f
16:18:41,057 INFO Configuration:425 - Reading mappings from resource: db2400_tabellacolori.hbm.xml
1469 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_tabellacolori.hbm.xml
16:18:41,088 INFO HbmBinder:261 - Mapping class: vo.as400.CTabellaColoriVO -> sdgtwb_dat.arctb00f
1500 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CTabellaColoriVO -> sdgtwb_dat.arctb00f
16:18:41,088 INFO Configuration:425 - Reading mappings from resource: db2400_lavaggi.hbm.xml
1500 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_lavaggi.hbm.xml
16:18:41,120 INFO HbmBinder:261 - Mapping class: vo.as400.CLavaggiVO -> sdgtwb_dat.arctb00f
1532 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CLavaggiVO -> sdgtwb_dat.arctb00f
16:18:41,120 INFO Configuration:425 - Reading mappings from resource: db2400_misure.hbm.xml
1532 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_misure.hbm.xml
16:18:41,135 INFO HbmBinder:261 - Mapping class: vo.as400.CMisureVO -> sdgtwb_dat.arctb00f
1547 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CMisureVO -> sdgtwb_dat.arctb00f
16:18:41,151 INFO Configuration:425 - Reading mappings from resource: db2400_nazioni.hbm.xml
1563 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_nazioni.hbm.xml
16:18:41,182 INFO HbmBinder:261 - Mapping class: vo.acg.CNazioniVO -> sdgtwb_pdm.nazioni
1594 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.acg.CNazioniVO -> sdgtwb_pdm.nazioni
16:18:41,182 INFO Configuration:425 - Reading mappings from resource: db2400_anfor00f.hbm.xml
1594 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_anfor00f.hbm.xml
16:18:41,229 INFO HbmBinder:261 - Mapping class: vo.acg.CFornitoriVO -> sdgtwb_acg.anfor00f
1641 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.acg.CFornitoriVO -> sdgtwb_acg.anfor00f
16:18:41,229 INFO Configuration:425 - Reading mappings from resource: db2400_ancli00f.hbm.xml
1641 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_ancli00f.hbm.xml
16:18:41,291 INFO HbmBinder:261 - Mapping class: vo.as400.CClienteVO -> sdgtwb_acg.ancli00f
1703 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CClienteVO -> sdgtwb_acg.ancli00f
16:18:41,307 INFO Configuration:425 - Reading mappings from resource: db2400_arxpl01l.hbm.xml
1719 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arxpl01l.hbm.xml
16:18:41,338 INFO HbmBinder:261 - Mapping class: vo.as400.CIstrLavaVO -> sdgtwb_dat.arxpl01l
1750 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CIstrLavaVO -> sdgtwb_dat.arxpl01l
16:18:41,338 INFO Configuration:425 - Reading mappings from resource: db2400_arcpf00f.hbm.xml
1750 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arcpf00f.hbm.xml
16:18:41,416 INFO HbmBinder:261 - Mapping class: vo.as400.PfVO -> sdgtwb_dat.arcpf00f
1828 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.PfVO -> sdgtwb_dat.arcpf00f
16:18:41,463 INFO Configuration:425 - Reading mappings from resource: db2400_arcpf61l.hbm.xml
1875 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arcpf61l.hbm.xml
16:18:41,479 INFO HbmBinder:261 - Mapping class: vo.as400.CPfUltVO -> sdgtwb_dat.arcpf61l
1891 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CPfUltVO -> sdgtwb_dat.arcpf61l
16:18:41,494 INFO Configuration:425 - Reading mappings from resource: db2400_arcmo00f.hbm.xml
1906 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arcmo00f.hbm.xml
16:18:41,573 INFO HbmBinder:261 - Mapping class: vo.as400.ModeVO -> sdgtwb_dat.arcmo00f
1985 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.ModeVO -> sdgtwb_dat.arcmo00f
16:18:41,588 INFO Configuration:425 - Reading mappings from resource: db2400_arcpd00f.hbm.xml
2000 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arcpd00f.hbm.xml
16:18:41,604 INFO HbmBinder:261 - Mapping class: vo.as400.CColoriVO -> sdgtwb_dat.arcpd00f
2016 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CColoriVO -> sdgtwb_dat.arcpd00f
16:18:41,619 INFO Configuration:425 - Reading mappings from resource: db2400_arcma00f.hbm.xml
2031 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_arcma00f.hbm.xml
16:18:41,635 INFO HbmBinder:261 - Mapping class: vo.as400.CMaterialiVO -> sdgtwb_dat.arcma00f
2047 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CMaterialiVO -> sdgtwb_dat.arcma00f
16:18:41,682 INFO Configuration:425 - Reading mappings from resource: db2400_svilup00f.hbm.xml
2094 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_svilup00f.hbm.xml
16:18:41,698 INFO HbmBinder:261 - Mapping class: vo.as400.CTabellaSviluppoVO -> sdgtwb_pdm.svilup00f
2110 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CTabellaSviluppoVO -> sdgtwb_pdm.svilup00f
16:18:41,713 INFO Configuration:425 - Reading mappings from resource: db2400_cicmi00f.hbm.xml
2125 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_cicmi00f.hbm.xml
16:18:41,744 INFO HbmBinder:261 - Mapping class: vo.as400.CCicliMisureVO -> sdgtwb_dat.cicmi00f
2156 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCicliMisureVO -> sdgtwb_dat.cicmi00f
16:18:41,760 INFO Configuration:425 - Reading mappings from resource: db2400_aynau00f.hbm.xml
2172 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_aynau00f.hbm.xml
16:18:41,776 INFO HbmBinder:261 - Mapping class: vo.as400.CAynau00f -> sdgtwb_dat.aynau00f
2188 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CAynau00f -> sdgtwb_dat.aynau00f
16:18:41,791 INFO Configuration:425 - Reading mappings from resource: db2400_vendi00f.hbm.xml
2203 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_vendi00f.hbm.xml
16:18:41,807 INFO HbmBinder:261 - Mapping class: vo.as400.CVenditaVO -> sdgtwb_pdm.vendit00f
2219 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CVenditaVO -> sdgtwb_pdm.vendit00f
16:18:41,807 INFO Configuration:425 - Reading mappings from resource: db2400_bspte00f.hbm.xml
2219 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_bspte00f.hbm.xml
16:18:41,838 INFO HbmBinder:261 - Mapping class: vo.as400.CSpedizioniVO -> sdgtwb_dat.bspte00f
2250 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CSpedizioniVO -> sdgtwb_dat.bspte00f
16:18:41,854 INFO Configuration:425 - Reading mappings from resource: db2400_pbote00f.hbm.xml
2266 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_pbote00f.hbm.xml
16:18:41,885 INFO HbmBinder:261 - Mapping class: vo.as400.CCommesseVO -> sdgtwb_dat.pbote00f
2297 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCommesseVO -> sdgtwb_dat.pbote00f
16:18:41,901 INFO Configuration:425 - Reading mappings from resource: db2400_pbori00f.hbm.xml
2313 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_pbori00f.hbm.xml
16:18:41,963 INFO HbmBinder:261 - Mapping class: vo.as400.CCommesseriVO -> sdgtwb_dat.pbori00f
2375 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCommesseriVO -> sdgtwb_dat.pbori00f
16:18:42,057 INFO Configuration:425 - Reading mappings from resource: db2400_pbodt$0f.hbm.xml
2469 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_pbodt$0f.hbm.xml
16:18:42,088 INFO HbmBinder:261 - Mapping class: vo.as400.CConsegneVO -> sdgtwb_dat.PBODT$0F
2500 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CConsegneVO -> sdgtwb_dat.PBODT$0F
16:18:42,104 INFO Configuration:425 - Reading mappings from resource: db2400_lispf00f.hbm.xml
2516 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_lispf00f.hbm.xml
16:18:42,135 INFO HbmBinder:261 - Mapping class: vo.as400.CClistinoVO -> sdgtwb_dat.lispf00f
2547 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CClistinoVO -> sdgtwb_dat.lispf00f
16:18:42,135 INFO Configuration:425 - Reading mappings from resource: db2400_fattri00f.hbm.xml
2547 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_fattri00f.hbm.xml
16:18:42,198 INFO HbmBinder:261 - Mapping class: vo.as400.CFattriVO -> sdgtwb_dat.fatri00f
2610 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CFattriVO -> sdgtwb_dat.fatri00f
16:18:42,198 INFO Configuration:425 - Reading mappings from resource: db2400_fatno00f.hbm.xml
2610 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_fatno00f.hbm.xml
16:18:42,229 INFO HbmBinder:261 - Mapping class: vo.FattriNoteVO -> sdgtwb_dat.fatno00f
2641 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.FattriNoteVO -> sdgtwb_dat.fatno00f
16:18:42,244 INFO Configuration:425 - Reading mappings from resource: db2400_fatte00f.hbm.xml
2656 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_fatte00f.hbm.xml
16:18:42,307 INFO HbmBinder:261 - Mapping class: vo.as400.CFatteVO -> sdgtwb_dat.fatte00f
2719 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CFatteVO -> sdgtwb_dat.fatte00f
16:18:42,323 INFO Configuration:425 - Reading mappings from resource: db2400_corte00f.hbm.xml
2735 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_corte00f.hbm.xml
16:18:42,369 INFO HbmBinder:261 - Mapping class: vo.as400.COrdiniVO -> sdgtwb_dat.corte00f
2781 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.COrdiniVO -> sdgtwb_dat.corte00f
16:18:42,401 INFO Configuration:425 - Reading mappings from resource: db2400_corri00f.hbm.xml
2813 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_corri00f.hbm.xml
16:18:42,432 INFO HbmBinder:261 - Mapping class: vo.as400.COrdinirVO -> sdgtwb_dat.corri00f
2844 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.COrdinirVO -> sdgtwb_dat.corri00f
16:18:42,557 INFO Configuration:425 - Reading mappings from resource: db2400_pavmv00f.hbm.xml
2969 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_pavmv00f.hbm.xml
16:18:42,588 INFO HbmBinder:261 - Mapping class: vo.as400.CMovAvanzamentiVO -> sdgtwb_dat.pavmv00f
3000 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CMovAvanzamentiVO -> sdgtwb_dat.pavmv00f
16:18:42,604 INFO Configuration:425 - Reading mappings from resource: db2400_coste00f.hbm.xml
3016 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_coste00f.hbm.xml
16:18:42,619 INFO HbmBinder:261 - Mapping class: vo.as400.CCostiTestataVO -> sdgtwb_dat.coste00f
3031 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CCostiTestataVO -> sdgtwb_dat.coste00f
16:18:42,635 INFO Configuration:425 - Reading mappings from resource: db2400_schma00f.hbm.xml
3047 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_schma00f.hbm.xml
16:18:42,666 INFO HbmBinder:261 - Mapping class: vo.as400.CSchTecnicaVO -> sdgtwb_dat.schma00f
3078 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CSchTecnicaVO -> sdgtwb_dat.schma00f
16:18:42,666 INFO Configuration:425 - Reading mappings from resource: db2400_note00f.hbm.xml
3078 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_note00f.hbm.xml
16:18:42,698 INFO HbmBinder:261 - Mapping class: vo.as400.CNoteVO -> sdgtwb_dat.arcpn00f
3110 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CNoteVO -> sdgtwb_dat.arcpn00f
16:18:42,698 INFO Configuration:425 - Reading mappings from resource: db2400_stiro00f.hbm.xml
3110 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_stiro00f.hbm.xml
16:18:42,729 INFO HbmBinder:261 - Mapping class: vo.as400.CStiroVO -> sdgtwb_pdm.stiro00f
3141 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CStiroVO -> sdgtwb_pdm.stiro00f
16:18:42,729 INFO Configuration:425 - Reading mappings from resource: db2400_etich00f.hbm.xml
3141 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_etich00f.hbm.xml
16:18:42,744 INFO HbmBinder:261 - Mapping class: vo.as400.CEtichetteVO -> sdgtwb_pdm.etich00f
3156 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CEtichetteVO -> sdgtwb_pdm.etich00f
16:18:42,979 INFO Configuration:425 - Reading mappings from resource: db2400_filato00f.hbm.xml
3391 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_filato00f.hbm.xml
16:18:42,994 INFO HbmBinder:261 - Mapping class: vo.as400.CFilatoVO -> sdgtwb_pdm.filo00f
3406 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CFilatoVO -> sdgtwb_pdm.filo00f
16:18:42,994 INFO Configuration:425 - Reading mappings from resource: db2400_dbase00f.hbm.xml
3406 [Thread-7] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: db2400_dbase00f.hbm.xml
16:18:43,026 INFO HbmBinder:261 - Mapping class: vo.as400.CDdbaseVO -> sdgtwb_dat.dbase00f
3438 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping class: vo.as400.CDdbaseVO -> sdgtwb_dat.dbase00f
16:18:43,041 INFO Configuration:1188 - Configured SessionFactory: null
3453 [Thread-7] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
16:18:43,041 INFO Configuration:851 - processing extends queue
3453 [Thread-7] INFO org.hibernate.cfg.Configuration - processing extends queue
16:18:43,057 INFO Configuration:855 - processing collection mappings
3469 [Thread-7] INFO org.hibernate.cfg.Configuration - processing collection mappings
16:18:43,057 INFO HbmBinder:2114 - Mapping collection: vo.as400.ModeVO.materiali -> sdgtwb_dat.arcpf00f
3469 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping collection: vo.as400.ModeVO.materiali -> sdgtwb_dat.arcpf00f
16:18:43,057 INFO HbmBinder:2114 - Mapping collection: vo.as400.CFatteVO.righe -> sdgtwb_dat.fatri00f
3469 [Thread-7] INFO org.hibernate.cfg.HbmBinder - Mapping collection: vo.as400.CFatteVO.righe -> sdgtwb_dat.fatri00f
16:18:43,072 INFO Configuration:864 - processing association property references
3484 [Thread-7] INFO org.hibernate.cfg.Configuration - processing association property references
16:18:43,072 INFO Configuration:893 - processing foreign key constraints
3484 [Thread-7] INFO org.hibernate.cfg.Configuration - processing foreign key constraints
16:18:44,338 INFO NamingHelper:26 - JNDI InitialContext properties:{}
4750 [Thread-7] INFO org.hibernate.util.NamingHelper - JNDI InitialContext properties:{}
16:18:44,369 INFO DatasourceConnectionProvider:51 - Using datasource: java:comp/env/jdbc/as400
4781 [Thread-7] INFO org.hibernate.connection.DatasourceConnectionProvider - Using datasource: java:comp/env/jdbc/as400
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@1ba329b)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 300
16:18:45,650 INFO SettingsFactory:77 - RDBMS: DB2 UDB for AS/400, version: 05.01.0000 V5R1m0
6062 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - RDBMS: DB2 UDB for AS/400, version: 05.01.0000 V5R1m0
16:18:45,650 INFO SettingsFactory:78 - JDBC driver: AS/400 Toolbox for Java JDBC Driver, version: 5.0
6062 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: AS/400 Toolbox for Java JDBC Driver, version: 5.0
16:18:46,088 INFO Dialect:92 - Using dialect: org.hibernate.dialect.DB2400Dialect
6500 [Thread-7] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.DB2400Dialect
16:18:46,166 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
6578 [Thread-7] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
16:18:46,197 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
6609 [Thread-7] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
16:18:46,213 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
6625 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
16:18:46,213 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
6625 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
16:18:46,228 INFO SettingsFactory:144 - Scrollable result sets: enabled
6640 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
16:18:46,228 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
6640 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
16:18:46,244 INFO SettingsFactory:160 - Connection release mode: null
6656 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: null
16:18:46,260 INFO SettingsFactory:187 - Default batch fetch size: 1
6672 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
16:18:46,260 INFO SettingsFactory:191 - Generate SQL with comments: enabled
6672 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: enabled
16:18:46,260 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
6672 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
16:18:46,260 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
6672 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
16:18:46,307 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
6719 [Thread-7] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
16:18:46,307 INFO SettingsFactory:203 - Query language substitutions: {}
6719 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
16:18:46,307 INFO SettingsFactory:209 - Second-level cache: enabled
6719 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
16:18:46,322 INFO SettingsFactory:213 - Query cache: enabled
6734 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Query cache: enabled
16:18:46,322 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.EhCacheProvider
6734 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
16:18:46,353 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
6765 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
16:18:46,353 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
6765 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
16:18:46,353 INFO SettingsFactory:308 - Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
6765 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
16:18:46,432 INFO SettingsFactory:257 - Echoing all SQL to stdout
6844 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
16:18:46,447 INFO SettingsFactory:261 - Statistics: disabled
6859 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
16:18:46,447 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
6859 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
16:18:46,463 INFO SettingsFactory:279 - Default entity-mode: pojo
6875 [Thread-7] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
16:18:46,791 INFO SessionFactoryImpl:153 - building session factory
7203 [Thread-7] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
16:18:46,822 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/disco_devis/catalogo/JList/test/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
7234 [Thread-7] WARN net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/disco_devis/catalogo/JList/test/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
0
16:19:04,086 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
24498 [Thread-7] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
16:19:04,102 INFO UpdateTimestampsCache:43 - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
24514 [Thread-7] INFO org.hibernate.cache.UpdateTimestampsCache - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
16:19:04,102 WARN EhCacheProvider:97 - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
24514 [Thread-7] WARN org.hibernate.cache.EhCacheProvider - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
16:19:04,243 INFO StandardQueryCache:50 - starting query cache at region: org.hibernate.cache.StandardQueryCache
24655 [Thread-7] INFO org.hibernate.cache.StandardQueryCache - starting query cache at region: org.hibernate.cache.StandardQueryCache
16:19:04,243 WARN EhCacheProvider:97 - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
24655 [Thread-7] WARN org.hibernate.cache.EhCacheProvider - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
16:19:04,289 INFO SessionFactoryImpl:381 - Checking 0 named queries
24701 [Thread-7] INFO org.hibernate.impl.SessionFactoryImpl - Checking 0 named queries
Hibernate: /* criteria query */ select this_.STAGPG as STAGPG7_, this_.NUBPPG as NUBPPG7_, this_.SQBPPG as SQBPPG7_, this_.NRBPPG as NRBPPG7_, this_.NSBPPG as NSBPPG7_, this_.NUBTPG as NUBTPG7_, this_.STREPG as STREPG16_7_, this_.NRAZPG as NRAZPG16_7_, this_.DTUMPG as DTUMPG16_7_, this_.ORUMPG as ORUMPG16_7_, this_.BLREPG as BLREPG16_7_, this_.NULAPG as NULAPG16_7_, this_.GGLAPG as GGLAPG16_7_, this_.MMLAPG as MMLAPG16_7_, this_.AALAPG as AALAPG16_7_, this_.SOLAPG as SOLAPG16_7_, this_.NUORPG as NUORPG16_7_, this_.NURIPG as NURIPG16_7_, this_.NUSRPG as NUSRPG16_7_, this_.CDCLPG as CDCLPG16_7_, this_.GGCCPG as GGCCPG16_7_, this_.MMCCPG as MMCCPG16_7_, this_.AACCPG as AACCPG16_7_, this_.SOCCPG as SOCCPG16_7_, this_.MARCPG as MARCPG16_7_, this_.LINEPG as LINEPG16_7_, this_.SLINPG as SLINPG16_7_, this_.MARPPG as MARPPG16_7_, this_.LINPPG as LINPPG16_7_, this_.SLIPPG as SLIPPG16_7_, this_.MODPPG as MODPPG16_7_, this_.MATPPG as MATPPG16_7_, this_.COLPPG as COLPPG16_7_, this_.VARPPG as VARPPG16_7_, this_.CCAPPG as CCAPPG16_7_, this_.CETPPG as CETPPG16_7_, this_.DROPPG as DROPPG16_7_, this_.CCTPPG as CCTPPG16_7_, this_.MODFPG as MODFPG16_7_, this_.MATFPG as MATFPG16_7_, this_.COLFPG as COLFPG16_7_, this_.VARFPG as VARFPG16_7_, this_.CCAFPG as CCAFPG16_7_, this_.CETFPG as CETFPG16_7_, this_.DROFPG as DROFPG16_7_, this_.CCTFPG as CCTFPG16_7_, this_.MOEQPG as MOEQPG16_7_, this_.MOEFPG as MOEFPG16_7_, this_.MOEIPG as MOEIPG16_7_, this_.CDTGPG as CDTGPG16_7_, this_.QT01PG as QT51_16_7_, this_.QT02PG as QT52_16_7_, this_.QT03PG as QT53_16_7_, this_.QT04PG as QT54_16_7_, this_.QT05PG as QT55_16_7_, this_.QT06PG as QT56_16_7_, this_.QT07PG as QT57_16_7_, this_.QT08PG as QT58_16_7_, this_.QT09PG as QT59_16_7_, this_.QT10PG as QT60_16_7_, this_.QT11PG as QT61_16_7_, this_.QT12PG as QT62_16_7_, this_.QT13PG as QT63_16_7_, this_.QT14PG as QT64_16_7_, this_.QT15PG as QT65_16_7_, this_.QT16PG as QT66_16_7_, this_.QT17PG as QT67_16_7_, this_.QT18PG as QT68_16_7_, this_.QT19PG as QT69_16_7_, this_.QT20PG as QT70_16_7_, this_.QT21PG as QT71_16_7_, this_.QT22PG as QT72_16_7_, this_.QT23PG as QT73_16_7_, this_.QT24PG as QT74_16_7_, this_.QT25PG as QT75_16_7_, this_.QT26PG as QT76_16_7_, this_.QT27PG as QT77_16_7_, this_.QT28PG as QT78_16_7_, this_.QT29PG as QT79_16_7_, this_.QT30PG as QT80_16_7_, this_.QT31PG as QT81_16_7_, this_.QT32PG as QT82_16_7_, this_.QT33PG as QT83_16_7_, this_.QT34PG as QT84_16_7_, this_.QO01PG as QO85_16_7_, this_.QO02PG as QO86_16_7_, this_.QO03PG as QO87_16_7_, this_.QO04PG as QO88_16_7_, this_.QO05PG as QO89_16_7_, this_.QO06PG as QO90_16_7_, this_.QO07PG as QO91_16_7_, this_.QO08PG as QO92_16_7_, this_.QO09PG as QO93_16_7_, this_.QO10PG as QO94_16_7_, this_.QO11PG as QO95_16_7_, this_.QO12PG as QO96_16_7_, this_.QO13PG as QO97_16_7_, this_.QO14PG as QO98_16_7_, this_.QO15PG as QO99_16_7_, this_.QO16PG as QO100_16_7_, this_.QO17PG as QO101_16_7_, this_.QO18PG as QO102_16_7_, this_.QO19PG as QO103_16_7_, this_.QO20PG as QO104_16_7_, this_.QO21PG as QO105_16_7_, this_.QO22PG as QO106_16_7_, this_.QO23PG as QO107_16_7_, this_.QO24PG as QO108_16_7_, this_.QO25PG as QO109_16_7_, this_.QO26PG as QO110_16_7_, this_.QO27PG as QO111_16_7_, this_.QO28PG as QO112_16_7_, this_.QO29PG as QO113_16_7_, this_.QO30PG as QO114_16_7_, this_.QO31PG as QO115_16_7_, this_.QO32PG as QO116_16_7_, this_.QO33PG as QO117_16_7_, this_.QO34PG as QO118_16_7_, this_.QD01PG as QD119_16_7_, this_.QD02PG as QD120_16_7_, this_.QD03PG as QD121_16_7_, this_.QD04PG as QD122_16_7_, this_.QD05PG as QD123_16_7_, this_.QD06PG as QD124_16_7_, this_.QD07PG as QD125_16_7_, this_.QD08PG as QD126_16_7_, this_.QD09PG as QD127_16_7_, this_.QD10PG as QD128_16_7_, this_.QD11PG as QD129_16_7_, this_.QD12PG as QD130_16_7_, this_.QD13PG as QD131_16_7_, this_.QD14PG as QD132_16_7_, this_.QD15PG as QD133_16_7_, this_.QD16PG as QD134_16_7_, this_.QD17PG as QD135_16_7_, this_.QD18PG as QD136_16_7_, this_.QD19PG as QD137_16_7_, this_.QD20PG as QD138_16_7_, this_.QD21PG as QD139_16_7_, this_.QD22PG as QD140_16_7_, this_.QD23PG as QD141_16_7_, this_.QD24PG as QD142_16_7_, this_.QD25PG as QD143_16_7_, this_.QD26PG as QD144_16_7_, this_.QD27PG as QD145_16_7_, this_.QD28PG as QD146_16_7_, this_.QD29PG as QD147_16_7_, this_.QD30PG as QD148_16_7_, this_.QD31PG as QD149_16_7_, this_.QD32PG as QD150_16_7_, this_.QD33PG as QD151_16_7_, this_.QD34PG as QD152_16_7_, this_.QV01PG as QV153_16_7_, this_.QV02PG as QV154_16_7_, this_.QV03PG as QV155_16_7_, this_.QV04PG as QV156_16_7_, this_.QV05PG as QV157_16_7_, this_.QV06PG as QV158_16_7_, this_.QV07PG as QV159_16_7_, this_.QV08PG as QV160_16_7_, this_.QV09PG as QV161_16_7_, this_.QV10PG as QV162_16_7_, this_.QV11PG as QV163_16_7_, this_.QV12PG as QV164_16_7_, this_.QV13PG as QV165_16_7_, this_.QV14PG as QV166_16_7_, this_.QV15PG as QV167_16_7_, this_.QV16PG as QV168_16_7_, this_.QV17PG as QV169_16_7_, this_.QV18PG as QV170_16_7_, this_.QV19PG as QV171_16_7_, this_.QV20PG as QV172_16_7_, this_.QV21PG as QV173_16_7_, this_.QV22PG as QV174_16_7_, this_.QV23PG as QV175_16_7_, this_.QV24PG as QV176_16_7_, this_.QV25PG as QV177_16_7_, this_.QV26PG as QV178_16_7_, this_.QV27PG as QV179_16_7_, this_.QV28PG as QV180_16_7_, this_.QV29PG as QV181_16_7_, this_.QV30PG as QV182_16_7_, this_.QV31PG as QV183_16_7_, this_.QV32PG as QV184_16_7_, this_.QV33PG as QV185_16_7_, this_.QV34PG as QV186_16_7_, this_.QF01PG as QF187_16_7_, this_.QF02PG as QF188_16_7_, this_.QF03PG as QF189_16_7_, this_.QF04PG as QF190_16_7_, this_.QF05PG as QF191_16_7_, this_.QF06PG as QF192_16_7_, this_.QF07PG as QF193_16_7_, this_.QF08PG as QF194_16_7_, this_.QF09PG as QF195_16_7_, this_.QF10PG as QF196_16_7_, this_.QF11PG as QF197_16_7_, this_.QF12PG as QF198_16_7_, this_.QF13PG as QF199_16_7_, this_.QF14PG as QF200_16_7_, this_.QF15PG as QF201_16_7_, this_.QF16PG as QF202_16_7_, this_.QF17PG as QF203_16_7_, this_.QF18PG as QF204_16_7_, this_.QF19PG as QF205_16_7_, this_.QF20PG as QF206_16_7_, this_.QF21PG as QF207_16_7_, this_.QF22PG as QF208_16_7_, this_.QF23PG as QF209_16_7_, this_.QF24PG as QF210_16_7_, this_.QF25PG as QF211_16_7_, this_.QF26PG as QF212_16_7_, this_.QF27PG as QF213_16_7_, this_.QF28PG as QF214_16_7_, this_.QF29PG as QF215_16_7_, this_.QF30PG as QF216_16_7_, this_.QF31PG as QF217_16_7_, this_.QF32PG as QF218_16_7_, this_.QF33PG as QF219_16_7_, this_.QF34PG as QF220_16_7_, this_.QM01PG as QM221_16_7_, this_.QM02PG as QM222_16_7_, this_.QM03PG as QM223_16_7_, this_.QM04PG as QM224_16_7_, this_.QM05PG as QM225_16_7_, this_.QM06PG as QM226_16_7_, this_.QM07PG as QM227_16_7_, this_.QM08PG as QM228_16_7_, this_.QM09PG as QM229_16_7_, this_.QM10PG as QM230_16_7_, this_.QM11PG as QM231_16_7_, this_.QM12PG as QM232_16_7_, this_.QM13PG as QM233_16_7_, this_.QM14PG as QM234_16_7_, this_.QM15PG as QM235_16_7_, this_.QM16PG as QM236_16_7_, this_.QM17PG as QM237_16_7_, this_.QM18PG as QM238_16_7_, this_.QM19PG as QM239_16_7_, this_.QM20PG as QM240_16_7_, this_.QM21PG as QM241_16_7_, this_.QM22PG as QM242_16_7_, this_.QM23PG as QM243_16_7_, this_.QM24PG as QM244_16_7_, this_.QM25PG as QM245_16_7_, this_.QM26PG as QM246_16_7_, this_.QM27PG as QM247_16_7_, this_.QM28PG as QM248_16_7_, this_.QM29PG as QM249_16_7_, this_.QM30PG as QM250_16_7_, this_.QM31PG as QM251_16_7_, this_.QM32PG as QM252_16_7_, this_.QM33PG as QM253_16_7_, this_.QM34PG as QM254_16_7_, this_.TQTAPG as TQTAPG16_7_, this_.TQORPG as TQORPG16_7_, this_.TQDSPG as TQDSPG16_7_, this_.TQVAPG as TQVAPG16_7_, this_.TQDFPG as TQDFPG16_7_, this_.TQVEPG as TQVEPG16_7_, this_.AVANPG as AVANPG16_7_, this_.GGAVPG as GGAVPG16_7_, this_.MMAVPG as MMAVPG16_7_, this_.AAAVPG as AAAVPG16_7_, this_.SOAVPG as SOAVPG16_7_, this_.STAVPG as STAVPG16_7_, this_.LIPRPG as LIPRPG16_7_, this_.SRIBPG as SRIBPG16_7_, this_.FCOMPG as FCOMPG16_7_, this_.GSBPPG as GSBPPG16_7_, this_.FRCMPG as FRCMPG16_7_, this_.FECMPG as FECMPG16_7_, this_.FLA1PG as FLA273_16_7_, this_.FLA2PG as FLA274_16_7_, this_.FLA3PG as FLA275_16_7_, this_.FLA4PG as FLA276_16_7_, this_.FLA5PG as FLA277_16_7_, this_.FLA6PG as FLA278_16_7_, this_.FLA7PG as FLA279_16_7_, this_.FLA8PG as FLA280_16_7_, this_.FL10PG as FL281_16_7_, this_.FL20PG as FL282_16_7_, this_.FL30PG as FL283_16_7_, this_.STAGPG as STAGPG16_7_, this_.NUBPPG as NUBPPG16_7_, this_.SQBPPG as SQBPPG16_7_, this_.NRBPPG as NRBPPG16_7_, 'AVA' as formula7_7_, p2_.stagpf as stagpf0_, p2_.modepf as modepf0_, p2_.matepf as matepf0_, p2_.strepf as strepf5_0_, p2_.nrazpf as nrazpf5_0_, p2_.dtumpf as dtumpf5_0_, p2_.orumpf as orumpf5_0_, p2_.blrepf as blrepf5_0_, p2_.de50pf as de9_5_0_, p2_.cartpf as cartpf5_0_, p2_.marcpf as marcpf5_0_, p2_.linepf as linepf5_0_, p2_.slinpf as slinpf5_0_, p2_.cmp1pf as cmp14_5_0_, p2_.cmp2pf as cmp15_5_0_, p2_.cmp3pf as cmp16_5_0_, p2_.cdogpf as cdogpf5_0_, p2_.civapf as civapf5_0_, p2_.cnvepf as cnvepf5_0_, p2_.cnaqpf as cnaqpf5_0_, p2_.peunpf as peunpf5_0_, p2_.volupf as volupf5_0_, p2_.cma1pf as cma23_5_0_, p2_.cma2pf as cma24_5_0_, p2_.cma3pf as cma25_5_0_, p2_.cma4pf as cma26_5_0_, p2_.cma5pf as cma27_5_0_, p2_.qmxbpf as qmxbpf5_0_, p2_.scmnpf as scmnpf5_0_, p2_.ltripf as ltripf5_0_, p2_.coaqpf as coaqpf5_0_, p2_.coulpf as coulpf5_0_, p2_.ggcupf as ggcupf5_0_, p2_.mmcupf as mmcupf5_0_, p2_.aacupf as aacupf5_0_, p2_.socupf as socupf5_0_, p2_.ricopf as ricopf5_0_, p2_.ftcopf as ftcopf5_0_, p2_.flicpf as flicpf5_0_, p2_.fptgpf as fptgpf5_0_, p2_.fla1pf as fla41_5_0_, p2_.fla2pf as fla42_5_0_, p2_.fla3pf as fla43_5_0_, p2_.fla4pf as fla44_5_0_, p2_.fla6pf as fla45_5_0_, p2_.fla7pf as fla46_5_0_, p2_.fla8pf as fla47_5_0_, p2_.fl10pf as fl48_5_0_, p2_.fl20pf as fl49_5_0_, p2_.fl30pf as fl50_5_0_, p2_.ceaqpf as ceaqpf5_0_, p2_.ceulpf as ceulpf5_0_, p2_.fl31pf as fl53_5_0_, p2_.fl32pf as fl54_5_0_, p2_.fl33pf as fl55_5_0_,


Top
 Profile  
 
 Post subject: sorry
PostPosted: Mon Mar 06, 2006 11:28 am 
Regular
Regular

Joined: Thu Feb 24, 2005 2:34 pm
Posts: 80
sorry this's my query

Code:
          Session session = AS400Session.currentSession();
          Criteria crit = session.createCriteria(CCommesseriVO.class, "vo")
              .createAlias("consegne", "r")
              .createAlias("prodotto", "p")
              .createAlias("p.modevo", "m")
              .createAlias("m.cmpfmo", "z")
              .add(Restrictions.ne("STREPG", new String("A")))
              .add(Restrictions.eq("FECMPG", new String("N")))
              .add(Restrictions.eq("pk.STAGPG", new String(stagione)))
              .add(Restrictions.eq("pk.NUBPPG", new Double(numero)))
              .setCacheable(true);




Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 06, 2006 11:43 am 
Expert
Expert

Joined: Sat Jan 17, 2004 2:57 pm
Posts: 329
Location: In the basement in my underwear
Creating the aliases forces an Inner Join, this is a known 'feature' with the Criteria API.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 06, 2006 11:46 am 
Regular
Regular

Joined: Thu Feb 24, 2005 2:34 pm
Posts: 80
Sorry, but how can i resolve my problem please, i'm disperate!
Thank's in advance
Devis


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 06, 2006 12:37 pm 
Regular
Regular

Joined: Thu Feb 24, 2005 2:34 pm
Posts: 80
Sorry, but if you can see my code, with other relation hibernate use "left outer join", i don't understand.
But for my problem if i use "FetchMode.SELECT" hibernate use again "join" pls help me
Devis

Code:
          Session session = AS400Session.currentSession();
          Criteria crit = session.createCriteria(CCommesseriVO.class, "vo")
              .createAlias("consegne", "r")
              .setFetchMode("consegne",FetchMode.SELECT)
              .createAlias("prodotto", "p")
              .createAlias("p.modevo", "m")
              .createAlias("m.cmpfmo", "z")

              .add(Restrictions.ne("STREPG", new String("A")))
              .add(Restrictions.eq("FECMPG", new String("N")))
              .add(Restrictions.eq("pk.STAGPG", new String(stagione)))
              .add(Restrictions.eq("pk.NUBPPG", new Double(numero)))
              .setCacheable(true);
          List list = crit.list();

i have also change my hbm file!!!
.....
<many-to-one name="consegne" class="vo.as400.CConsegneVO"   lazy="false" update="false" insert="false" not-found="ignore" >
      <column name="STAGPG"/>
      <column name="NUBPPG"/>
      <column name="SQBPPG"/>
      <column name="NRBPPG"/>
</many-to-one>
.....


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

All times are UTC - 5 hours [ DST ]


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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.