Regular |
|
Joined: Thu Feb 24, 2005 2:34 pm Posts: 80
|
Hibernate version:3.1.2
Name and version of the database you are using: DB2/400
The generated SQL (show_sql=true):
I have a simple query that it would have only select some record, but Hibernate throw an update.....
Can you help me?pls
Devis
Code: Criteria crit = session.createCriteria(CCommesseriVO.class, "vo") .createAlias("consegne", "r") .add(Restrictions.ne("STREPG", new String("A"))) .add(Restrictions.eq("FECMPG", new String("N"))) .add(Restrictions.eq("AVANPG", new String("06"))) .add(Restrictions.eq("r.SOARWW", new Integer(0))) .add(Restrictions.eq("r.AAARWW", new Integer(year))) .add(Restrictions.in ("r.MMARWW",mesi)) .add(Restrictions.in ("r.GGARWW",giorni)) .setCacheable(true); System.out.println("Dal "+calendar.getTime().toString()+" Al "+calendar2.getTime().toString());
List list = crit.list(); CCommesseriVO[] vo = new CCommesseriVO[list.size()]; list.toArray(vo); session.flush(); AS400Session.closeSession(); return vo; }
This update is my problem Hibernate: /* update vo.as400.CCodiceAvanzamentoVO */ update sdgtwb_dat.arctb00f set DATITB=? where cdtbtb=? and cdeltb=?
Here the query Hibernate: /* criteria query */ select this_.STAGPG as STAGPG2_, this_.NUBPPG as NUBPPG2_, this_.SQBPPG as SQBPPG2_, this_.NRBPPG as NRBPPG2_, this_.NSBPPG as NSBPPG2_, this_.NUBTPG as NUBTPG2_, this_.STREPG as STREPG15_2_, this_.NRAZPG as NRAZPG15_2_, this_.DTUMPG as DTUMPG15_2_, this_.ORUMPG as ORUMPG15_2_, this_.BLREPG as BLREPG15_2_, this_.NULAPG as NULAPG15_2_, this_.GGLAPG as GGLAPG15_2_, this_.MMLAPG as MMLAPG15_2_, this_.AALAPG as AALAPG15_2_, this_.SOLAPG as SOLAPG15_2_, this_.NUORPG as NUORPG15_2_, this_.NURIPG as NURIPG15_2_, this_.NUSRPG as NUSRPG15_2_, this_.CDCLPG as CDCLPG15_2_, this_.GGCCPG as GGCCPG15_2_, this_.MMCCPG as MMCCPG15_2_, this_.AACCPG as AACCPG15_2_, this_.SOCCPG as SOCCPG15_2_, this_.MARCPG as MARCPG15_2_, this_.LINEPG as LINEPG15_2_, this_.SLINPG as SLINPG15_2_, this_.MARPPG as MARPPG15_2_, this_.LINPPG as LINPPG15_2_, this_.SLIPPG as SLIPPG15_2_, this_.MODPPG as MODPPG15_2_, this_.MATPPG as MATPPG15_2_, this_.COLPPG as COLPPG15_2_, this_.VARPPG as VARPPG15_2_, this_.CCAPPG as CCAPPG15_2_, this_.CETPPG as CETPPG15_2_, this_.DROPPG as DROPPG15_2_, this_.CCTPPG as CCTPPG15_2_, this_.MODFPG as MODFPG15_2_, this_.MATFPG as MATFPG15_2_, this_.COLFPG as COLFPG15_2_, this_.VARFPG as VARFPG15_2_, this_.CCAFPG as CCAFPG15_2_, this_.CETFPG as CETFPG15_2_, this_.DROFPG as DROFPG15_2_, this_.CCTFPG as CCTFPG15_2_, this_.MOEQPG as MOEQPG15_2_, this_.MOEFPG as MOEFPG15_2_, this_.MOEIPG as MOEIPG15_2_, this_.CDTGPG as CDTGPG15_2_, this_.QT01PG as QT51_15_2_, this_.QT02PG as QT52_15_2_, this_.QT03PG as QT53_15_2_, this_.QT04PG as QT54_15_2_, this_.QT05PG as QT55_15_2_, this_.QT06PG as QT56_15_2_, this_.QT07PG as QT57_15_2_, this_.QT08PG as QT58_15_2_, this_.QT09PG as QT59_15_2_, this_.QT10PG as QT60_15_2_, this_.QT11PG as QT61_15_2_, this_.QT12PG as QT62_15_2_, this_.QT13PG as QT63_15_2_, this_.QT14PG as QT64_15_2_, this_.QT15PG as QT65_15_2_, this_.QT16PG as QT66_15_2_, this_.QT17PG as QT67_15_2_, this_.QT18PG as QT68_15_2_, this_.QT19PG as QT69_15_2_, this_.QT20PG as QT70_15_2_, this_.QT21PG as QT71_15_2_, this_.QT22PG as QT72_15_2_, this_.QT23PG as QT73_15_2_, this_.QT24PG as QT74_15_2_, this_.QT25PG as QT75_15_2_, this_.QT26PG as QT76_15_2_, this_.QT27PG as QT77_15_2_, this_.QT28PG as QT78_15_2_, this_.QT29PG as QT79_15_2_, this_.QT30PG as QT80_15_2_, this_.QT31PG as QT81_15_2_, this_.QT32PG as QT82_15_2_, this_.QT33PG as QT83_15_2_, this_.QT34PG as QT84_15_2_, this_.QO01PG as QO85_15_2_, this_.QO02PG as QO86_15_2_, this_.QO03PG as QO87_15_2_, this_.QO04PG as QO88_15_2_, this_.QO05PG as QO89_15_2_, this_.QO06PG as QO90_15_2_, this_.QO07PG as QO91_15_2_, this_.QO08PG as QO92_15_2_, this_.QO09PG as QO93_15_2_, this_.QO10PG as QO94_15_2_, this_.QO11PG as QO95_15_2_, this_.QO12PG as QO96_15_2_, this_.QO13PG as QO97_15_2_, this_.QO14PG as QO98_15_2_, this_.QO15PG as QO99_15_2_, this_.QO16PG as QO100_15_2_, this_.QO17PG as QO101_15_2_, this_.QO18PG as QO102_15_2_, this_.QO19PG as QO103_15_2_, this_.QO20PG as QO104_15_2_, this_.QO21PG as QO105_15_2_, this_.QO22PG as QO106_15_2_, this_.QO23PG as QO107_15_2_, this_.QO24PG as QO108_15_2_, this_.QO25PG as QO109_15_2_, this_.QO26PG as QO110_15_2_, this_.QO27PG as QO111_15_2_, this_.QO28PG as QO112_15_2_, this_.QO29PG as QO113_15_2_, this_.QO30PG as QO114_15_2_, this_.QO31PG as QO115_15_2_, this_.QO32PG as QO116_15_2_, this_.QO33PG as QO117_15_2_, this_.QO34PG as QO118_15_2_, this_.QD01PG as QD119_15_2_, this_.QD02PG as QD120_15_2_, this_.QD03PG as QD121_15_2_, this_.QD04PG as QD122_15_2_, this_.QD05PG as QD123_15_2_, this_.QD06PG as QD124_15_2_, this_.QD07PG as QD125_15_2_, this_.QD08PG as QD126_15_2_, this_.QD09PG as QD127_15_2_, this_.QD10PG as QD128_15_2_, this_.QD11PG as QD129_15_2_, this_.QD12PG as QD130_15_2_, this_.QD13PG as QD131_15_2_, this_.QD14PG as QD132_15_2_, this_.QD15PG as QD133_15_2_, this_.QD16PG as QD134_15_2_, this_.QD17PG as QD135_15_2_, this_.QD18PG as QD136_15_2_, this_.QD19PG as QD137_15_2_, this_.QD20PG as QD138_15_2_, this_.QD21PG as QD139_15_2_, this_.QD22PG as QD140_15_2_, this_.QD23PG as QD141_15_2_, this_.QD24PG as QD142_15_2_, this_.QD25PG as QD143_15_2_, this_.QD26PG as QD144_15_2_, this_.QD27PG as QD145_15_2_, this_.QD28PG as QD146_15_2_, this_.QD29PG as QD147_15_2_, this_.QD30PG as QD148_15_2_, this_.QD31PG as QD149_15_2_, this_.QD32PG as QD150_15_2_, this_.QD33PG as QD151_15_2_, this_.QD34PG as QD152_15_2_, this_.QV01PG as QV153_15_2_, this_.QV02PG as QV154_15_2_, this_.QV03PG as QV155_15_2_, this_.QV04PG as QV156_15_2_, this_.QV05PG as QV157_15_2_, this_.QV06PG as QV158_15_2_, this_.QV07PG as QV159_15_2_, this_.QV08PG as QV160_15_2_, this_.QV09PG as QV161_15_2_, this_.QV10PG as QV162_15_2_, this_.QV11PG as QV163_15_2_, this_.QV12PG as QV164_15_2_, this_.QV13PG as QV165_15_2_, this_.QV14PG as QV166_15_2_, this_.QV15PG as QV167_15_2_, this_.QV16PG as QV168_15_2_, this_.QV17PG as QV169_15_2_, this_.QV18PG as QV170_15_2_, this_.QV19PG as QV171_15_2_, this_.QV20PG as QV172_15_2_, this_.QV21PG as QV173_15_2_, this_.QV22PG as QV174_15_2_, this_.QV23PG as QV175_15_2_, this_.QV24PG as QV176_15_2_, this_.QV25PG as QV177_15_2_, this_.QV26PG as QV178_15_2_, this_.QV27PG as QV179_15_2_, this_.QV28PG as QV180_15_2_, this_.QV29PG as QV181_15_2_, this_.QV30PG as QV182_15_2_, this_.QV31PG as QV183_15_2_, this_.QV32PG as QV184_15_2_, this_.QV33PG as QV185_15_2_, this_.QV34PG as QV186_15_2_, this_.QF01PG as QF187_15_2_, this_.QF02PG as QF188_15_2_, this_.QF03PG as QF189_15_2_, this_.QF04PG as QF190_15_2_, this_.QF05PG as QF191_15_2_, this_.QF06PG as QF192_15_2_, this_.QF07PG as QF193_15_2_, this_.QF08PG as QF194_15_2_, this_.QF09PG as QF195_15_2_, this_.QF10PG as QF196_15_2_, this_.QF11PG as QF197_15_2_, this_.QF12PG as QF198_15_2_, this_.QF13PG as QF199_15_2_, this_.QF14PG as QF200_15_2_, this_.QF15PG as QF201_15_2_, this_.QF16PG as QF202_15_2_, this_.QF17PG as QF203_15_2_, this_.QF18PG as QF204_15_2_, this_.QF19PG as QF205_15_2_, this_.QF20PG as QF206_15_2_, this_.QF21PG as QF207_15_2_, this_.QF22PG as QF208_15_2_, this_.QF23PG as QF209_15_2_, this_.QF24PG as QF210_15_2_, this_.QF25PG as QF211_15_2_, this_.QF26PG as QF212_15_2_, this_.QF27PG as QF213_15_2_, this_.QF28PG as QF214_15_2_, this_.QF29PG as QF215_15_2_, this_.QF30PG as QF216_15_2_, this_.QF31PG as QF217_15_2_, this_.QF32PG as QF218_15_2_, this_.QF33PG as QF219_15_2_, this_.QF34PG as QF220_15_2_, this_.QM01PG as QM221_15_2_, this_.QM02PG as QM222_15_2_, this_.QM03PG as QM223_15_2_, this_.QM04PG as QM224_15_2_, this_.QM05PG as QM225_15_2_, this_.QM06PG as QM226_15_2_, this_.QM07PG as QM227_15_2_, this_.QM08PG as QM228_15_2_, this_.QM09PG as QM229_15_2_, this_.QM10PG as QM230_15_2_, this_.QM11PG as QM231_15_2_, this_.QM12PG as QM232_15_2_, this_.QM13PG as QM233_15_2_, this_.QM14PG as QM234_15_2_, this_.QM15PG as QM235_15_2_, this_.QM16PG as QM236_15_2_, this_.QM17PG as QM237_15_2_, this_.QM18PG as QM238_15_2_, this_.QM19PG as QM239_15_2_, this_.QM20PG as QM240_15_2_, this_.QM21PG as QM241_15_2_, this_.QM22PG as QM242_15_2_, this_.QM23PG as QM243_15_2_, this_.QM24PG as QM244_15_2_, this_.QM25PG as QM245_15_2_, this_.QM26PG as QM246_15_2_, this_.QM27PG as QM247_15_2_, this_.QM28PG as QM248_15_2_, this_.QM29PG as QM249_15_2_, this_.QM30PG as QM250_15_2_, this_.QM31PG as QM251_15_2_, this_.QM32PG as QM252_15_2_, this_.QM33PG as QM253_15_2_, this_.QM34PG as QM254_15_2_, this_.TQTAPG as TQTAPG15_2_, this_.TQORPG as TQORPG15_2_, this_.TQDSPG as TQDSPG15_2_, this_.TQVAPG as TQVAPG15_2_, this_.TQDFPG as TQDFPG15_2_, this_.TQVEPG as TQVEPG15_2_, this_.AVANPG as AVANPG15_2_, this_.GGAVPG as GGAVPG15_2_, this_.MMAVPG as MMAVPG15_2_, this_.AAAVPG as AAAVPG15_2_, this_.SOAVPG as SOAVPG15_2_, this_.STAVPG as STAVPG15_2_, this_.LIPRPG as LIPRPG15_2_, this_.SRIBPG as SRIBPG15_2_, this_.FCOMPG as FCOMPG15_2_, this_.GSBPPG as GSBPPG15_2_, this_.FRCMPG as FRCMPG15_2_, this_.FECMPG as FECMPG15_2_, this_.FLA1PG as FLA273_15_2_, this_.FLA2PG as FLA274_15_2_, this_.FLA3PG as FLA275_15_2_, this_.FLA4PG as FLA276_15_2_, this_.FLA5PG as FLA277_15_2_, this_.FLA6PG as FLA278_15_2_, this_.FLA7PG as FLA279_15_2_, this_.FLA8PG as FLA280_15_2_, this_.FL10PG as FL281_15_2_, this_.FL20PG as FL282_15_2_, this_.FL30PG as FL283_15_2_, this_.STAGPG as STAGPG15_2_, this_.NUBPPG as NUBPPG15_2_, this_.SQBPPG as SQBPPG15_2_, this_.NRBPPG as NRBPPG15_2_, 'AVA' as formula7_2_, r1_.STAGWW as STAGWW0_, r1_.NUBPWW as NUBPWW0_, r1_.SQBPWW as SQBPWW0_, r1_.NRBPWW as NRBPWW0_, r1_.GGARWW as GGARWW16_0_, r1_.MMARWW as MMARWW16_0_, r1_.AAARWW as AAARWW16_0_, r1_.SOARWW as SOARWW16_0_, ccodiceava4_.cdtbtb as cdtbtb1_, ccodiceava4_.cdeltb as cdeltb1_, ccodiceava4_.DATITB as DATITB0_1_ from sdgtwb_dat.pbori00f this_ inner join sdgtwb_dat.PBODT$0F r1_ on this_.STAGPG=r1_.STAGWW and this_.NUBPPG=r1_.NUBPWW and this_.SQBPPG=r1_.SQBPWW and this_.NRBPPG=r1_.NRBPWW left outer join sdgtwb_dat.arctb00f ccodiceava4_ on 'AVA'=ccodiceava4_.cdtbtb and this_.AVANPG=ccodiceava4_.cdeltb where this_.STREPG<>? and this_.FECMPG=? and this_.AVANPG=? and r1_.SOARWW=? and r1_.AAARWW=? and r1_.MMARWW in (?, ?) and r1_.GGARWW in (?, ?) Hibernate: /* load vo.as400.CCodiceAvanzamentoVO */ select ccodiceava0_.cdtbtb as cdtbtb0_, ccodiceava0_.cdeltb as cdeltb0_, ccodiceava0_.DATITB as DATITB0_0_ from sdgtwb_dat.arctb00f ccodiceava0_ where ccodiceava0_.cdtbtb=? and ccodiceava0_.cdeltb=? and ccodiceava0_.CDTBTB IN('AVA') Hibernate: /* update vo.as400.CCodiceAvanzamentoVO */ update sdgtwb_dat.arctb00f set DATITB=? where cdtbtb=? and cdeltb=?
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" /> <property name="TQORPG" column="TQORPG" /> <property name="TQDSPG" column="TQDSPG" /> <property name="TQVAPG" column="TQVAPG" /> <property name="TQDFPG" column="TQDFPG" /> <property name="TQVEPG" column="TQVEPG" /> <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="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>
<many-to-one name="avanma" class="vo.as400.CCodiceAvanzamentoVO" lazy="false" update="false" insert="false" not-found="ignore"> <formula>'AVA'</formula> <column name="AVANPG"/> </many-to-one>
</class>
</hibernate-mapping>
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" > <hibernate-mapping>
<class name="vo.as400.CCodiceAvanzamentoVO" table="sdgtwb_dat.arctb00f" lazy="false" where="CDTBTB IN('AVA')">
<composite-id> <key-property name="tpo_tbl" column="cdtbtb"/> <key-property name="cdc_ava" column="cdeltb" /> </composite-id>
<property name="dsc_ava" column="DATITB" type="string" />
</class> </hibernate-mapping>
[/b]
|
|