-->
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.  [ 4 posts ] 
Author Message
 Post subject: Hibernate update automatic with a select
PostPosted: Tue Feb 21, 2006 12:47 pm 
Regular
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]


Top
 Profile  
 
 Post subject:
PostPosted: Tue Feb 21, 2006 3:32 pm 
Newbie

Joined: Tue Jan 10, 2006 11:59 am
Posts: 17
Could you please attach the code of CCommesseriVO?

Esp. the code of method setDATITB or methods, that called such method from CCommesseriVO.

_________________
--
Sergey Vladimirov


Top
 Profile  
 
 Post subject:
PostPosted: Wed Feb 22, 2006 1:05 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX
The way in which you have implemented your TrimmedString type may also be the culprit... Post that code as well


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 23, 2006 7:02 am 
Regular
Regular

Joined: Thu Feb 24, 2005 2:34 pm
Posts: 80
Hi thank's for your rply, here there is my code.
Pls help me i'm disperate i have 4 table that are changed automatically becuase hibernate, or sure I, throw an update.
Devis
Code:

package vo.pk;

import java.io.Serializable;

/**
* <p>Title: JWeb Enterprise</p>
* <p>Description: Architecture J2EE </p>
* <p>Copyright: Copyright (c) 2005</p>
* <p>Company: Via del Corso S.p.A</p>
* @author Balsemin Devis
* @version 1.0
*/
import util.*;

public class CComesseriPK
    implements Serializable {

  private String STAGPG;
  private double NUBPPG;
  private double SQBPPG;
  private double NRBPPG;
  private double NSBPPG;
  private double NUBTPG;

  public void setNUBPPG(double NUBPPG) {
    this.NUBPPG = NUBPPG;
  }

  public double getNUBPPG() {
    return NUBPPG;
  }

  public void setSQBPPG(double SQBPPG) {
    this.SQBPPG = SQBPPG;
  }

  public double getSQBPPG() {
    return SQBPPG;
  }

  public void setNUBTPG(double NUBTPG) {
    this.NUBTPG = NUBTPG;
  }

  public double getNUBTPG() {
    return NUBTPG;
  }

  public void setNRBPPG(double NRBPPG) {
    this.NRBPPG = NRBPPG;
  }

  public double getNRBPPG() {
    return NRBPPG;
  }

  public void setNSBPPG(double NSBPPG) {
    this.NSBPPG = NSBPPG;
  }

  public double getNSBPPG() {
    return NSBPPG;
  }

  public void setSTAGPG(String STAGPG) {
    this.STAGPG = STAGPG;
  }

  public String getSTAGPG() {
    return STAGPG;
  }

  public CComesseriPK() {
  }

  public boolean equals(Object other) {
    if (this == other) {
      return true;
    }
    if (! (other instanceof CComessePK)) {
      return false;
    }
    CComesseriPK that = (CComesseriPK) other;
    return
        EqualsUtil.areEqual(this.STAGPG, that.STAGPG) &&
        EqualsUtil.areEqual(this.NUBPPG, that.NUBPPG) &&
        EqualsUtil.areEqual(this.SQBPPG, that.SQBPPG) &&
        EqualsUtil.areEqual(this.NRBPPG, that.NRBPPG) &&
        EqualsUtil.areEqual(this.NSBPPG, that.NSBPPG) &&
        EqualsUtil.areEqual(this.NUBTPG, that.NUBTPG) ;
  }

  public int hashCode() {
    int result = 14;
    result = 29 * result + getSTAGPG().hashCode();
    result = 29 * result + String.valueOf(getNUBPPG()).hashCode();
    result = 29 * result + String.valueOf(getSQBPPG()).hashCode();
    result = 29 * result + String.valueOf(getNRBPPG()).hashCode();
    result = 29 * result + String.valueOf(getNSBPPG()).hashCode();
    result = 29 * result + String.valueOf(getNUBTPG()).hashCode();
    return result;

  }

}



package vo.as400;

import vo.pk.*;
import java.util.*;
import java.io.Serializable;

/**
* <p>Title: JWeb Enterprise</p>
* <p>Description: Architecture J2EE </p>
* <p>Copyright: Copyright (c) 2005</p>
* <p>Company: Via del Corso S.p.A</p>
* @author Balsemin Devis
* @version 1.0
*/

public class CCommesseriVO
    implements Serializable {
  private CComesseriPK pk;
  private CConsegneVO consegne;
  private Set listino= new HashSet();
  private CCodiceAvanzamentoVO avanma;

  private PfVO prodotto;
  private double prezzo_ven;

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

  public void setSTREPG(String strepg)
  {
  this.STREPG=strepg;
  }
  public String getSTREPG()
  {
  return this.STREPG;
  }
  public void setNRAZPG(double nrazpg)
  {
  this.NRAZPG=nrazpg;
  }
  public double getNRAZPG()
  {
  return this.NRAZPG;
  }
  public void setDTUMPG(int dtumpg)
  {
  this.DTUMPG=dtumpg;
  }
  public int getDTUMPG()
  {
  return this.DTUMPG;
  }
  public void setORUMPG(int orumpg)
  {
  this.ORUMPG=orumpg;
  }
  public int getORUMPG()
  {
  return this.ORUMPG;
  }
  public void setBLREPG(String blrepg)
  {
  this.BLREPG=blrepg;
  }
  public String getBLREPG()
  {
  return this.BLREPG;
  }
  public void setNULAPG(double nulapg)
  {
  this.NULAPG=nulapg;
  }
  public double getNULAPG()
  {
  return this.NULAPG;
  }
  public void setGGLAPG(int gglapg)
  {
  this.GGLAPG=gglapg;
  }
  public int getGGLAPG()
  {
  return this.GGLAPG;
  }
  public void setMMLAPG(int mmlapg)
  {
  this.MMLAPG=mmlapg;
  }
  public int getMMLAPG()
  {
  return this.MMLAPG;
  }
  public void setAALAPG(int aalapg)
  {
  this.AALAPG=aalapg;
  }
  public int getAALAPG()
  {
  return this.AALAPG;
  }
  public void setSOLAPG(int solapg)
  {
  this.SOLAPG=solapg;
  }
  public int getSOLAPG()
  {
  return this.SOLAPG;
  }
  public void setNUORPG(int nuorpg)
  {
  this.NUORPG=nuorpg;
  }
  public int getNUORPG()
  {
  return this.NUORPG;
  }
  public void setNURIPG(int nuripg)
  {
  this.NURIPG=nuripg;
  }
  public int getNURIPG()
  {
  return this.NURIPG;
  }
  public void setNUSRPG(int nusrpg)
  {
  this.NUSRPG=nusrpg;
  }
  public int getNUSRPG()
  {
  return this.NUSRPG;
  }
  public void setCDCLPG(String cdclpg)
  {
  this.CDCLPG=cdclpg;
  }
  public String getCDCLPG()
  {
  return this.CDCLPG;
  }
  public void setGGCCPG(int ggccpg)
  {
  this.GGCCPG=ggccpg;
  }
  public int getGGCCPG()
  {
  return this.GGCCPG;
  }
  public void setMMCCPG(int mmccpg)
  {
  this.MMCCPG=mmccpg;
  }
  public int getMMCCPG()
  {
  return this.MMCCPG;
  }
  public void setAACCPG(int aaccpg)
  {
  this.AACCPG=aaccpg;
  }
  public int getAACCPG()
  {
  return this.AACCPG;
  }
  public void setSOCCPG(int soccpg)
  {
  this.SOCCPG=soccpg;
  }
  public int getSOCCPG()
  {
  return this.SOCCPG;
  }
  public void setMARCPG(String marcpg)
  {
  this.MARCPG=marcpg;
  }
  public String getMARCPG()
  {
  return this.MARCPG;
  }
  public void setLINEPG(String linepg)
  {
  this.LINEPG=linepg;
  }
  public String getLINEPG()
  {
  return this.LINEPG;
  }
  public void setSLINPG(String slinpg)
  {
  this.SLINPG=slinpg;
  }
  public String getSLINPG()
  {
  return this.SLINPG;
  }
  public void setMARPPG(String marppg)
  {
  this.MARPPG=marppg;
  }
  public String getMARPPG()
  {
  return this.MARPPG;
  }
  public void setLINPPG(String linppg)
  {
  this.LINPPG=linppg;
  }
  public String getLINPPG()
  {
  return this.LINPPG;
  }
  public void setSLIPPG(String slippg)
  {
  this.SLIPPG=slippg;
  }
  public String getSLIPPG()
  {
  return this.SLIPPG;
  }
  public void setMODPPG(String modppg)
  {
  this.MODPPG=modppg;
  }
  public String getMODPPG()
  {
  return this.MODPPG;
  }
  public void setMATPPG(String matppg)
  {
  this.MATPPG=matppg;
  }
  public String getMATPPG()
  {
  return this.MATPPG;
  }
  public void setCOLPPG(String colppg)
  {
  this.COLPPG=colppg;
  }
  public String getCOLPPG()
  {
  return this.COLPPG;
  }
  public void setVARPPG(String varppg)
  {
  this.VARPPG=varppg;
  }
  public String getVARPPG()
  {
  return this.VARPPG;
  }
  public void setCCAPPG(String ccappg)
  {
  this.CCAPPG=ccappg;
  }
  public String getCCAPPG()
  {
  return this.CCAPPG;
  }
  public void setCETPPG(String cetppg)
  {
  this.CETPPG=cetppg;
  }
  public String getCETPPG()
  {
  return this.CETPPG;
  }
  public void setDROPPG(String droppg)
  {
  this.DROPPG=droppg;
  }
  public String getDROPPG()
  {
  return this.DROPPG;
  }
  public void setCCTPPG(String cctppg)
  {
  this.CCTPPG=cctppg;
  }
  public String getCCTPPG()
  {
  return this.CCTPPG;
  }
  public void setMODFPG(String modfpg)
  {
  this.MODFPG=modfpg;
  }
  public String getMODFPG()
  {
  return this.MODFPG;
  }
  public void setMATFPG(String matfpg)
  {
  this.MATFPG=matfpg;
  }
  public String getMATFPG()
  {
  return this.MATFPG;
  }
  public void setCOLFPG(String colfpg)
  {
  this.COLFPG=colfpg;
  }
  public String getCOLFPG()
  {
  return this.COLFPG;
  }
  public void setVARFPG(String varfpg)
  {
  this.VARFPG=varfpg;
  }
  public String getVARFPG()
  {
  return this.VARFPG;
  }
  public void setCCAFPG(String ccafpg)
  {
  this.CCAFPG=ccafpg;
  }
  public String getCCAFPG()
  {
  return this.CCAFPG;
  }
  public void setCETFPG(String cetfpg)
  {
  this.CETFPG=cetfpg;
  }
  public String getCETFPG()
  {
  return this.CETFPG;
  }
  public void setDROFPG(String drofpg)
  {
  this.DROFPG=drofpg;
  }
  public String getDROFPG()
  {
  return this.DROFPG;
  }
  public void setCCTFPG(String cctfpg)
  {
  this.CCTFPG=cctfpg;
  }
  public String getCCTFPG()
  {
  return this.CCTFPG;
  }
  public void setMOEQPG(String moeqpg)
  {
  this.MOEQPG=moeqpg;
  }
  public String getMOEQPG()
  {
  return this.MOEQPG;
  }
  public void setMOEFPG(String moefpg)
  {
  this.MOEFPG=moefpg;
  }
  public String getMOEFPG()
  {
  return this.MOEFPG;
  }
  public void setMOEIPG(String moeipg)
  {
  this.MOEIPG=moeipg;
  }
  public String getMOEIPG()
  {
  return this.MOEIPG;
  }
  public void setCDTGPG(String cdtgpg)
  {
  this.CDTGPG=cdtgpg;
  }
  public String getCDTGPG()
  {
  return this.CDTGPG;
  }
  public void setQT01PG(double qt01pg)
  {
  this.QT01PG=qt01pg;
  }
  public double getQT01PG()
  {
  return this.QT01PG;
  }
  public void setQT02PG(double qt02pg)
  {
  this.QT02PG=qt02pg;
  }
  public double getQT02PG()
  {
  return this.QT02PG;
  }
  public void setQT03PG(double qt03pg)
  {
  this.QT03PG=qt03pg;
  }
  public double getQT03PG()
  {
  return this.QT03PG;
  }
  public void setQT04PG(double qt04pg)
  {
  this.QT04PG=qt04pg;
  }
  public double getQT04PG()
  {
  return this.QT04PG;
  }
  public void setQT05PG(double qt05pg)
  {
  this.QT05PG=qt05pg;
  }
  public double getQT05PG()
  {
  return this.QT05PG;
  }
  public void setQT06PG(double qt06pg)
  {
  this.QT06PG=qt06pg;
  }
  public double getQT06PG()
  {
  return this.QT06PG;
  }
  public void setQT07PG(double qt07pg)
  {
  this.QT07PG=qt07pg;
  }
  public double getQT07PG()
  {
  return this.QT07PG;
  }
  public void setQT08PG(double qt08pg)
  {
  this.QT08PG=qt08pg;
  }
  public double getQT08PG()
  {
  return this.QT08PG;
  }
  public void setQT09PG(double qt09pg)
  {
  this.QT09PG=qt09pg;
  }
  public double getQT09PG()
  {
  return this.QT09PG;
  }
  public void setQT10PG(double qt10pg)
  {
  this.QT10PG=qt10pg;
  }
  public double getQT10PG()
  {
  return this.QT10PG;
  }
  public void setQT11PG(double qt11pg)
  {
  this.QT11PG=qt11pg;
  }
  public double getQT11PG()
  {
  return this.QT11PG;
  }
  public void setQT12PG(double qt12pg)
  {
  this.QT12PG=qt12pg;
  }
  public double getQT12PG()
  {
  return this.QT12PG;
  }
  public void setQT13PG(double qt13pg)
  {
  this.QT13PG=qt13pg;
  }
  public double getQT13PG()
  {
  return this.QT13PG;
  }
  public void setQT14PG(double qt14pg)
  {
  this.QT14PG=qt14pg;
  }
  public double getQT14PG()
  {
  return this.QT14PG;
  }
  public void setQT15PG(double qt15pg)
  {
  this.QT15PG=qt15pg;
  }
  public double getQT15PG()
  {
  return this.QT15PG;
  }
  public void setQT16PG(double qt16pg)
  {
  this.QT16PG=qt16pg;
  }
  public double getQT16PG()
  {
  return this.QT16PG;
  }
  public void setQT17PG(double qt17pg)
  {
  this.QT17PG=qt17pg;
  }
  public double getQT17PG()
  {
  return this.QT17PG;
  }
  public void setQT18PG(double qt18pg)
  {
  this.QT18PG=qt18pg;
  }
  public double getQT18PG()
  {
  return this.QT18PG;
  }
  public void setQT19PG(double qt19pg)
  {
  this.QT19PG=qt19pg;
  }
  public double getQT19PG()
  {
  return this.QT19PG;
  }
  public void setQT20PG(double qt20pg)
  {
  this.QT20PG=qt20pg;
  }
  public double getQT20PG()
  {
  return this.QT20PG;
  }
  public void setQT21PG(double qt21pg)
  {
  this.QT21PG=qt21pg;
  }
  public double getQT21PG()
  {
  return this.QT21PG;
  }
  public void setQT22PG(double qt22pg)
  {
  this.QT22PG=qt22pg;
  }
  public double getQT22PG()
  {
  return this.QT22PG;
  }
  public void setQT23PG(double qt23pg)
  {
  this.QT23PG=qt23pg;
  }
  public double getQT23PG()
  {
  return this.QT23PG;
  }
  public void setQT24PG(double qt24pg)
  {
  this.QT24PG=qt24pg;
  }
  public double getQT24PG()
  {
  return this.QT24PG;
  }
  public void setQT25PG(double qt25pg)
  {
  this.QT25PG=qt25pg;
  }
  public double getQT25PG()
  {
  return this.QT25PG;
  }
  public void setQT26PG(double qt26pg)
  {
  this.QT26PG=qt26pg;
  }
  public double getQT26PG()
  {
  return this.QT26PG;
  }
  public void setQT27PG(double qt27pg)
  {
  this.QT27PG=qt27pg;
  }
  public double getQT27PG()
  {
  return this.QT27PG;
  }
  public void setQT28PG(double qt28pg)
  {
  this.QT28PG=qt28pg;
  }
  public double getQT28PG()
  {
  return this.QT28PG;
  }
  public void setQT29PG(double qt29pg)
  {
  this.QT29PG=qt29pg;
  }
  public double getQT29PG()
  {
  return this.QT29PG;
  }
  public void setQT30PG(double qt30pg)
  {
  this.QT30PG=qt30pg;
  }
  public double getQT30PG()
  {
  return this.QT30PG;
  }
  public void setQT31PG(double qt31pg)
  {
  this.QT31PG=qt31pg;
  }
  public double getQT31PG()
  {
  return this.QT31PG;
  }
  public void setQT32PG(double qt32pg)
  {
  this.QT32PG=qt32pg;
  }
  public double getQT32PG()
  {
  return this.QT32PG;
  }
  public void setQT33PG(double qt33pg)
  {
  this.QT33PG=qt33pg;
  }
  public double getQT33PG()
  {
  return this.QT33PG;
  }
  public void setQT34PG(double qt34pg)
  {
  this.QT34PG=qt34pg;
  }
  public double getQT34PG()
  {
  return this.QT34PG;
  }
  public void setQO01PG(double qo01pg)
  {
  this.QO01PG=qo01pg;
  }
  public double getQO01PG()
  {
  return this.QO01PG;
  }
  public void setQO02PG(double qo02pg)
  {
  this.QO02PG=qo02pg;
  }
  public double getQO02PG()
  {
  return this.QO02PG;
  }
  public void setQO03PG(double qo03pg)
  {
  this.QO03PG=qo03pg;
  }
  public double getQO03PG()
  {
  return this.QO03PG;
  }
  public void setQO04PG(double qo04pg)
  {
  this.QO04PG=qo04pg;
  }
  public double getQO04PG()
  {
  return this.QO04PG;
  }
  public void setQO05PG(double qo05pg)
  {
  this.QO05PG=qo05pg;
  }
  public double getQO05PG()
  {
  return this.QO05PG;
  }
  public void setQO06PG(double qo06pg)
  {
  this.QO06PG=qo06pg;
  }
  public double getQO06PG()
  {
  return this.QO06PG;
  }
  public void setQO07PG(double qo07pg)
  {
  this.QO07PG=qo07pg;
  }
  public double getQO07PG()
  {
  return this.QO07PG;
  }
  public void setQO08PG(double qo08pg)
  {
  this.QO08PG=qo08pg;
  }
  public double getQO08PG()
  {
  return this.QO08PG;
  }
  public void setQO09PG(double qo09pg)
  {
  this.QO09PG=qo09pg;
  }
  public double getQO09PG()
  {
  return this.QO09PG;
  }
  public void setQO10PG(double qo10pg)
  {
  this.QO10PG=qo10pg;
  }
  public double getQO10PG()
  {
  return this.QO10PG;
  }
  public void setQO11PG(double qo11pg)
  {
  this.QO11PG=qo11pg;
  }
  public double getQO11PG()
  {
  return this.QO11PG;
  }
  public void setQO12PG(double qo12pg)
  {
  this.QO12PG=qo12pg;
  }
  public double getQO12PG()
  {
  return this.QO12PG;
  }
  public void setQO13PG(double qo13pg)
  {
  this.QO13PG=qo13pg;
  }
  public double getQO13PG()
  {
  return this.QO13PG;
  }
  public void setQO14PG(double qo14pg)
  {
  this.QO14PG=qo14pg;
  }
  public double getQO14PG()
  {
  return this.QO14PG;
  }
  public void setQO15PG(double qo15pg)
  {
  this.QO15PG=qo15pg;
  }
  public double getQO15PG()
  {
  return this.QO15PG;
  }
  public void setQO16PG(double qo16pg)
  {
  this.QO16PG=qo16pg;
  }
  public double getQO16PG()
  {
  return this.QO16PG;
  }
  public void setQO17PG(double qo17pg)
  {
  this.QO17PG=qo17pg;
  }
  public double getQO17PG()
  {
  return this.QO17PG;
  }
  public void setQO18PG(double qo18pg)
  {
  this.QO18PG=qo18pg;
  }
  public double getQO18PG()
  {
  return this.QO18PG;
  }
  public void setQO19PG(double qo19pg)
  {
  this.QO19PG=qo19pg;
  }
  public double getQO19PG()
  {
  return this.QO19PG;
  }
  public void setQO20PG(double qo20pg)
  {
  this.QO20PG=qo20pg;
  }
  public double getQO20PG()
  {
  return this.QO20PG;
  }
  public void setQO21PG(double qo21pg)
  {
  this.QO21PG=qo21pg;
  }
  public double getQO21PG()
  {
  return this.QO21PG;
  }
  public void setQO22PG(double qo22pg)
  {
  this.QO22PG=qo22pg;
  }
  public double getQO22PG()
  {
  return this.QO22PG;
  }
  public void setQO23PG(double qo23pg)
  {
  this.QO23PG=qo23pg;
  }
  public double getQO23PG()
  {
  return this.QO23PG;
  }
  public void setQO24PG(double qo24pg)
  {
  this.QO24PG=qo24pg;
  }
  public double getQO24PG()
  {
  return this.QO24PG;
  }
  public void setQO25PG(double qo25pg)
  {
  this.QO25PG=qo25pg;
  }
  public double getQO25PG()
  {
  return this.QO25PG;
  }
  public void setQO26PG(double qo26pg)
  {
  this.QO26PG=qo26pg;
  }
  public double getQO26PG()
  {
  return this.QO26PG;
  }
  public void setQO27PG(double qo27pg)
  {
  this.QO27PG=qo27pg;
  }
  public double getQO27PG()
  {
  return this.QO27PG;
  }
  public void setQO28PG(double qo28pg)
  {
  this.QO28PG=qo28pg;
  }
  public double getQO28PG()
  {
  return this.QO28PG;
  }
  public void setQO29PG(double qo29pg)
  {
  this.QO29PG=qo29pg;
  }
  public double getQO29PG()
  {
  return this.QO29PG;
  }
  public void setQO30PG(double qo30pg)
  {
  this.QO30PG=qo30pg;
  }
  public double getQO30PG()
  {
  return this.QO30PG;
  }
  public void setQO31PG(double qo31pg)
  {
  this.QO31PG=qo31pg;
  }
  public double getQO31PG()
  {
  return this.QO31PG;
  }
  public void setQO32PG(double qo32pg)
  {
  this.QO32PG=qo32pg;
  }
  public double getQO32PG()
  {
  return this.QO32PG;
  }
  public void setQO33PG(double qo33pg)
  {
  this.QO33PG=qo33pg;
  }
  public double getQO33PG()
  {
  return this.QO33PG;
  }
  public void setQO34PG(double qo34pg)
  {
  this.QO34PG=qo34pg;
  }
  public double getQO34PG()
  {
  return this.QO34PG;
  }
  public void setQD01PG(double qd01pg)
  {
  this.QD01PG=qd01pg;
  }
  public double getQD01PG()
  {
  return this.QD01PG;
  }
  public void setQD02PG(double qd02pg)
  {
  this.QD02PG=qd02pg;
  }
  public double getQD02PG()
  {
  return this.QD02PG;
  }
  public void setQD03PG(double qd03pg)
  {
  this.QD03PG=qd03pg;
  }
  public double getQD03PG()
  {
  return this.QD03PG;
  }
  public void setQD04PG(double qd04pg)
  {
  this.QD04PG=qd04pg;
  }
  public double getQD04PG()
  {
  return this.QD04PG;
  }
  public void setQD05PG(double qd05pg)
  {
  this.QD05PG=qd05pg;
  }
  public double getQD05PG()
  {
  return this.QD05PG;
  }
  public void setQD06PG(double qd06pg)
  {
  this.QD06PG=qd06pg;
  }
  public double getQD06PG()
  {
  return this.QD06PG;
  }
  public void setQD07PG(double qd07pg)
  {
  this.QD07PG=qd07pg;
  }
  public double getQD07PG()
  {
  return this.QD07PG;
  }
  public void setQD08PG(double qd08pg)
  {
  this.QD08PG=qd08pg;
  }
  public double getQD08PG()
  {
  return this.QD08PG;
  }
  public void setQD09PG(double qd09pg)
  {
  this.QD09PG=qd09pg;
  }
  public double getQD09PG()
  {
  return this.QD09PG;
  }
  public void setQD10PG(double qd10pg)
  {
  this.QD10PG=qd10pg;
  }
  public double getQD10PG()
  {
  return this.QD10PG;
  }
  public void setQD11PG(double qd11pg)
  {
  this.QD11PG=qd11pg;
  }
  public double getQD11PG()
  {
  return this.QD11PG;
  }
  public void setQD12PG(double qd12pg)
  {
  this.QD12PG=qd12pg;
  }
  public double getQD12PG()
  {
  return this.QD12PG;
  }
  public void setQD13PG(double qd13pg)
  {
  this.QD13PG=qd13pg;
  }
  public double getQD13PG()
  {
  return this.QD13PG;
  }
  public void setQD14PG(double qd14pg)
  {
  this.QD14PG=qd14pg;
  }
  public double getQD14PG()
  {
  return this.QD14PG;
  }
  public void setQD15PG(double qd15pg)
  {
  this.QD15PG=qd15pg;
  }
  public double getQD15PG()
  {
  return this.QD15PG;
  }
  public void setQD16PG(double qd16pg)
  {
  this.QD16PG=qd16pg;
  }
  public double getQD16PG()
  {
  return this.QD16PG;
  }
  public void setQD17PG(double qd17pg)
  {
  this.QD17PG=qd17pg;
  }
  public double getQD17PG()
  {
  return this.QD17PG;
  }
  public void setQD18PG(double qd18pg)
  {
  this.QD18PG=qd18pg;
  }
  public double getQD18PG()
  {
  return this.QD18PG;
  }
  public void setQD19PG(double qd19pg)
  {
  this.QD19PG=qd19pg;
  }
  public double getQD19PG()
  {
  return this.QD19PG;
  }
  public void setQD20PG(double qd20pg)
  {
  this.QD20PG=qd20pg;
  }
  public double getQD20PG()
  {
  return this.QD20PG;
  }
  public void setQD21PG(double qd21pg)
  {
  this.QD21PG=qd21pg;
  }
  public double getQD21PG()
  {
  return this.QD21PG;
  }
  public void setQD22PG(double qd22pg)
  {
  this.QD22PG=qd22pg;
  }
  public double getQD22PG()
  {
  return this.QD22PG;
  }
  public void setQD23PG(double qd23pg)
  {
  this.QD23PG=qd23pg;
  }
  public double getQD23PG()
  {
  return this.QD23PG;
  }
  public void setQD24PG(double qd24pg)
  {
  this.QD24PG=qd24pg;
  }
  public double getQD24PG()
  {
  return this.QD24PG;
  }
  public void setQD25PG(double qd25pg)
  {
  this.QD25PG=qd25pg;
  }
  public double getQD25PG()
  {
  return this.QD25PG;
  }
  public void setQD26PG(double qd26pg)
  {
  this.QD26PG=qd26pg;
  }
  public double getQD26PG()
  {
  return this.QD26PG;
  }
  public void setQD27PG(double qd27pg)
  {
  this.QD27PG=qd27pg;
  }
  public double getQD27PG()
  {
  return this.QD27PG;
  }
  public void setQD28PG(double qd28pg)
  {
  this.QD28PG=qd28pg;
  }
  public double getQD28PG()
  {
  return this.QD28PG;
  }
  public void setQD29PG(double qd29pg)
  {
  this.QD29PG=qd29pg;
  }
  public double getQD29PG()
  {
  return this.QD29PG;
  }
  public void setQD30PG(double qd30pg)
  {
  this.QD30PG=qd30pg;
  }
  public double getQD30PG()
  {
  return this.QD30PG;
  }
  public void setQD31PG(double qd31pg)
  {
  this.QD31PG=qd31pg;
  }
  public double getQD31PG()
  {
  return this.QD31PG;
  }
  public void setQD32PG(double qd32pg)
  {
  this.QD32PG=qd32pg;
  }
  public double getQD32PG()
  {
  return this.QD32PG;
  }
  public void setQD33PG(double qd33pg)
  {
  this.QD33PG=qd33pg;
  }
  public double getQD33PG()
  {
  return this.QD33PG;
  }
  public void setQD34PG(double qd34pg)
  {
  this.QD34PG=qd34pg;
  }
  public double getQD34PG()
  {
  return this.QD34PG;
  }
  public void setQV01PG(double qv01pg)
  {
  this.QV01PG=qv01pg;
  }
  public double getQV01PG()
  {
  return this.QV01PG;
  }
  public void setQV02PG(double qv02pg)
  {
  this.QV02PG=qv02pg;
  }
  public double getQV02PG()
  {
  return this.QV02PG;
  }
  public void setQV03PG(double qv03pg)
  {
  this.QV03PG=qv03pg;
  }
  public double getQV03PG()
  {
  return this.QV03PG;
  }
  public void setQV04PG(double qv04pg)
  {
  this.QV04PG=qv04pg;
  }
  public double getQV04PG()
  {
  return this.QV04PG;
  }
  public void setQV05PG(double qv05pg)
  {
  this.QV05PG=qv05pg;
  }
  public double getQV05PG()
  {
  return this.QV05PG;
  }
  public void setQV06PG(double qv06pg)
  {
  this.QV06PG=qv06pg;
  }
  public double getQV06PG()
  {
  return this.QV06PG;
  }
  public void setQV07PG(double qv07pg)
  {
  this.QV07PG=qv07pg;
  }
  public double getQV07PG()
  {
  return this.QV07PG;
  }
  public void setQV08PG(double qv08pg)
  {
  this.QV08PG=qv08pg;
  }
  public double getQV08PG()
  {
  return this.QV08PG;
  }
  public void setQV09PG(double qv09pg)
  {
  this.QV09PG=qv09pg;
  }
  public double getQV09PG()
  {
  return this.QV09PG;
  }
  public void setQV10PG(double qv10pg)
  {
  this.QV10PG=qv10pg;
  }
  public double getQV10PG()
  {
  return this.QV10PG;
  }
  public void setQV11PG(double qv11pg)
  {
  this.QV11PG=qv11pg;
  }
  public double getQV11PG()
  {
  return this.QV11PG;
  }
  public void setQV12PG(double qv12pg)
  {
  this.QV12PG=qv12pg;
  }
  public double getQV12PG()
  {
  return this.QV12PG;
  }
  public void setQV13PG(double qv13pg)
  {
  this.QV13PG=qv13pg;
  }
  public double getQV13PG()
  {
  return this.QV13PG;
  }
  public void setQV14PG(double qv14pg)
  {
  this.QV14PG=qv14pg;
  }
  public double getQV14PG()
  {
  return this.QV14PG;
  }
  public void setQV15PG(double qv15pg)
  {
  this.QV15PG=qv15pg;
  }
  public double getQV15PG()
  {
  return this.QV15PG;
  }
  public void setQV16PG(double qv16pg)
  {
  this.QV16PG=qv16pg;
  }
  public double getQV16PG()
  {
  return this.QV16PG;
  }
  public void setQV17PG(double qv17pg)
  {
  this.QV17PG=qv17pg;
  }
  public double getQV17PG()
  {
  return this.QV17PG;
  }
  public void setQV18PG(double qv18pg)
  {
  this.QV18PG=qv18pg;
  }
  public double getQV18PG()
  {
  return this.QV18PG;
  }
  public void setQV19PG(double qv19pg)
  {
  this.QV19PG=qv19pg;
  }
  public double getQV19PG()
  {
  return this.QV19PG;
  }
  public void setQV20PG(double qv20pg)
  {
  this.QV20PG=qv20pg;
  }
  public double getQV20PG()
  {
  return this.QV20PG;
  }
  public void setQV21PG(double qv21pg)
  {
  this.QV21PG=qv21pg;
  }
  public double getQV21PG()
  {
  return this.QV21PG;
  }
  public void setQV22PG(double qv22pg)
  {
  this.QV22PG=qv22pg;
  }
  public double getQV22PG()
  {
  return this.QV22PG;
  }
  public void setQV23PG(double qv23pg)
  {
  this.QV23PG=qv23pg;
  }
  public double getQV23PG()
  {
  return this.QV23PG;
  }
  public void setQV24PG(double qv24pg)
  {
  this.QV24PG=qv24pg;
  }
  public double getQV24PG()
  {
  return this.QV24PG;
  }
  public void setQV25PG(double qv25pg)
  {
  this.QV25PG=qv25pg;
  }
  public double getQV25PG()
  {
  return this.QV25PG;
  }
  public void setQV26PG(double qv26pg)
  {
  this.QV26PG=qv26pg;
  }
  public double getQV26PG()
  {
  return this.QV26PG;
  }
  public void setQV27PG(double qv27pg)
  {
  this.QV27PG=qv27pg;
  }
  public double getQV27PG()
  {
  return this.QV27PG;
  }
  public void setQV28PG(double qv28pg)
  {
  this.QV28PG=qv28pg;
  }
  public double getQV28PG()
  {
  return this.QV28PG;
  }
  public void setQV29PG(double qv29pg)
  {
  this.QV29PG=qv29pg;
  }
  public double getQV29PG()
  {
  return this.QV29PG;
  }
  public void setQV30PG(double qv30pg)
  {
  this.QV30PG=qv30pg;
  }
  public double getQV30PG()
  {
  return this.QV30PG;
  }
  public void setQV31PG(double qv31pg)
  {
  this.QV31PG=qv31pg;
  }
  public double getQV31PG()
  {
  return this.QV31PG;
  }
  public void setQV32PG(double qv32pg)
  {
  this.QV32PG=qv32pg;
  }
  public double getQV32PG()
  {
  return this.QV32PG;
  }
  public void setQV33PG(double qv33pg)
  {
  this.QV33PG=qv33pg;
  }
  public double getQV33PG()
  {
  return this.QV33PG;
  }
  public void setQV34PG(double qv34pg)
  {
  this.QV34PG=qv34pg;
  }
  public double getQV34PG()
  {
  return this.QV34PG;
  }
  public void setQF01PG(double qf01pg)
  {
  this.QF01PG=qf01pg;
  }
  public double getQF01PG()
  {
  return this.QF01PG;
  }
  public void setQF02PG(double qf02pg)
  {
  this.QF02PG=qf02pg;
  }
  public double getQF02PG()
  {
  return this.QF02PG;
  }
  public void setQF03PG(double qf03pg)
  {
  this.QF03PG=qf03pg;
  }
  public double getQF03PG()
  {
  return this.QF03PG;
  }
  public void setQF04PG(double qf04pg)
  {
  this.QF04PG=qf04pg;
  }
  public double getQF04PG()
  {
  return this.QF04PG;
  }
  public void setQF05PG(double qf05pg)
  {
  this.QF05PG=qf05pg;
  }
  public double getQF05PG()
  {
  return this.QF05PG;
  }
  public void setQF06PG(double qf06pg)
  {
  this.QF06PG=qf06pg;
  }
  public double getQF06PG()
  {
  return this.QF06PG;
  }
  public void setQF07PG(double qf07pg)
  {
  this.QF07PG=qf07pg;
  }
  public double getQF07PG()
  {
  return this.QF07PG;
  }
  public void setQF08PG(double qf08pg)
  {
  this.QF08PG=qf08pg;
  }
  public double getQF08PG()
  {
  return this.QF08PG;
  }
  public void setQF09PG(double qf09pg)
  {
  this.QF09PG=qf09pg;
  }
  public double getQF09PG()
  {
  return this.QF09PG;
  }
  public void setQF10PG(double qf10pg)
  {
  this.QF10PG=qf10pg;
  }
  public double getQF10PG()
  {
  return this.QF10PG;
  }
  public void setQF11PG(double qf11pg)
  {
  this.QF11PG=qf11pg;
  }
  public double getQF11PG()
  {
  return this.QF11PG;
  }
  public void setQF12PG(double qf12pg)
  {
  this.QF12PG=qf12pg;
  }
  public double getQF12PG()
  {
  return this.QF12PG;
  }
  public void setQF13PG(double qf13pg)
  {
  this.QF13PG=qf13pg;
  }
  public double getQF13PG()
  {
  return this.QF13PG;
  }
  public void setQF14PG(double qf14pg)
  {
  this.QF14PG=qf14pg;
  }
  public double getQF14PG()
  {
  return this.QF14PG;
  }
  public void setQF15PG(double qf15pg)
  {
  this.QF15PG=qf15pg;
  }
  public double getQF15PG()
  {
  return this.QF15PG;
  }
  public void setQF16PG(double qf16pg)
  {
  this.QF16PG=qf16pg;
  }
  public double getQF16PG()
  {
  return this.QF16PG;
  }
  public void setQF17PG(double qf17pg)
  {
  this.QF17PG=qf17pg;
  }
  public double getQF17PG()
  {
  return this.QF17PG;
  }
  public void setQF18PG(double qf18pg)
  {
  this.QF18PG=qf18pg;
  }
  public double getQF18PG()
  {
  return this.QF18PG;
  }
  public void setQF19PG(double qf19pg)
  {
  this.QF19PG=qf19pg;
  }
  public double getQF19PG()
  {
  return this.QF19PG;
  }
  public void setQF20PG(double qf20pg)
  {
  this.QF20PG=qf20pg;
  }
  public double getQF20PG()
  {
  return this.QF20PG;
  }
  public void setQF21PG(double qf21pg)
  {
  this.QF21PG=qf21pg;
  }
  public double getQF21PG()
  {
  return this.QF21PG;
  }
  public void setQF22PG(double qf22pg)
  {
  this.QF22PG=qf22pg;
  }
  public double getQF22PG()
  {
  return this.QF22PG;
  }
  public void setQF23PG(double qf23pg)
  {
  this.QF23PG=qf23pg;
  }
  public double getQF23PG()
  {
  return this.QF23PG;
  }
  public void setQF24PG(double qf24pg)
  {
  this.QF24PG=qf24pg;
  }
  public double getQF24PG()
  {
  return this.QF24PG;
  }
  public void setQF25PG(double qf25pg)
  {
  this.QF25PG=qf25pg;
  }
  public double getQF25PG()
  {
  return this.QF25PG;
  }
  public void setQF26PG(double qf26pg)
  {
  this.QF26PG=qf26pg;
  }
  public double getQF26PG()
  {
  return this.QF26PG;
  }
  public void setQF27PG(double qf27pg)
  {
  this.QF27PG=qf27pg;
  }
  public double getQF27PG()
  {
  return this.QF27PG;
  }
  public void setQF28PG(double qf28pg)
  {
  this.QF28PG=qf28pg;
  }
  public double getQF28PG()
  {
  return this.QF28PG;
  }
  public void setQF29PG(double qf29pg)
  {
  this.QF29PG=qf29pg;
  }
  public double getQF29PG()
  {
  return this.QF29PG;
  }
  public void setQF30PG(double qf30pg)
  {
  this.QF30PG=qf30pg;
  }
  public double getQF30PG()
  {
  return this.QF30PG;
  }
  public void setQF31PG(double qf31pg)
  {
  this.QF31PG=qf31pg;
  }
  public double getQF31PG()
  {
  return this.QF31PG;
  }
  public void setQF32PG(double qf32pg)
  {
  this.QF32PG=qf32pg;
  }
  public double getQF32PG()
  {
  return this.QF32PG;
  }
  public void setQF33PG(double qf33pg)
  {
  this.QF33PG=qf33pg;
  }
  public double getQF33PG()
  {
  return this.QF33PG;
  }
  public void setQF34PG(double qf34pg)
  {
  this.QF34PG=qf34pg;
  }
  public double getQF34PG()
  {
  return this.QF34PG;
  }
  public void setQM01PG(double qm01pg)
  {
  this.QM01PG=qm01pg;
  }
  public double getQM01PG()
  {
  return this.QM01PG;
  }
  public void setQM02PG(double qm02pg)
  {
  this.QM02PG=qm02pg;
  }
  public double getQM02PG()
  {
  return this.QM02PG;
  }
  public void setQM03PG(double qm03pg)
  {
  this.QM03PG=qm03pg;
  }
  public double getQM03PG()
  {
  return this.QM03PG;
  }
  public void setQM04PG(double qm04pg)
  {
  this.QM04PG=qm04pg;
  }
  public double getQM04PG()
  {
  return this.QM04PG;
  }
  public void setQM05PG(double qm05pg)
  {
  this.QM05PG=qm05pg;
  }
  public double getQM05PG()
  {
  return this.QM05PG;
  }
  public void setQM06PG(double qm06pg)
  {
  this.QM06PG=qm06pg;
  }
  public double getQM06PG()
  {
  return this.QM06PG;
  }
  public void setQM07PG(double qm07pg)
  {
  this.QM07PG=qm07pg;
  }
  public double getQM07PG()
  {
  return this.QM07PG;
  }
  public void setQM08PG(double qm08pg)
  {
  this.QM08PG=qm08pg;
  }
  public double getQM08PG()
  {
  return this.QM08PG;
  }
  public void setQM09PG(double qm09pg)
  {
  this.QM09PG=qm09pg;
  }
  public double getQM09PG()
  {
  return this.QM09PG;
  }
  public void setQM10PG(double qm10pg)
  {
  this.QM10PG=qm10pg;
  }
  public double getQM10PG()
  {
  return this.QM10PG;
  }
  public void setQM11PG(double qm11pg)
  {
  this.QM11PG=qm11pg;
  }
  public double getQM11PG()
  {
  return this.QM11PG;
  }
  public void setQM12PG(double qm12pg)
  {
  this.QM12PG=qm12pg;
  }
  public double getQM12PG()
  {
  return this.QM12PG;
  }
  public void setQM13PG(double qm13pg)
  {
  this.QM13PG=qm13pg;
  }
  public double getQM13PG()
  {
  return this.QM13PG;
  }
  public void setQM14PG(double qm14pg)
  {
  this.QM14PG=qm14pg;
  }
  public double getQM14PG()
  {
  return this.QM14PG;
  }
  public void setQM15PG(double qm15pg)
  {
  this.QM15PG=qm15pg;
  }
  public double getQM15PG()
  {
  return this.QM15PG;
  }
  public void setQM16PG(double qm16pg)
  {
  this.QM16PG=qm16pg;
  }
  public double getQM16PG()
  {
  return this.QM16PG;
  }
  public void setQM17PG(double qm17pg)
  {
  this.QM17PG=qm17pg;
  }
  public double getQM17PG()
  {
  return this.QM17PG;
  }
  public void setQM18PG(double qm18pg)
  {
  this.QM18PG=qm18pg;
  }
  public double getQM18PG()
  {
  return this.QM18PG;
  }
  public void setQM19PG(double qm19pg)
  {
  this.QM19PG=qm19pg;
  }
  public double getQM19PG()
  {
  return this.QM19PG;
  }
  public void setQM20PG(double qm20pg)
  {
  this.QM20PG=qm20pg;
  }
  public double getQM20PG()
  {
  return this.QM20PG;
  }
  public void setQM21PG(double qm21pg)
  {
  this.QM21PG=qm21pg;
  }
  public double getQM21PG()
  {
  return this.QM21PG;
  }
  public void setQM22PG(double qm22pg)
  {
  this.QM22PG=qm22pg;
  }
  public double getQM22PG()
  {
  return this.QM22PG;
  }
  public void setQM23PG(double qm23pg)
  {
  this.QM23PG=qm23pg;
  }
  public double getQM23PG()
  {
  return this.QM23PG;
  }
  public void setQM24PG(double qm24pg)
  {
  this.QM24PG=qm24pg;
  }
  public double getQM24PG()
  {
  return this.QM24PG;
  }
  public void setQM25PG(double qm25pg)
  {
  this.QM25PG=qm25pg;
  }
  public double getQM25PG()
  {
  return this.QM25PG;
  }
  public void setQM26PG(double qm26pg)
  {
  this.QM26PG=qm26pg;
  }
  public double getQM26PG()
  {
  return this.QM26PG;
  }
  public void setQM27PG(double qm27pg)
  {
  this.QM27PG=qm27pg;
  }
  public double getQM27PG()
  {
  return this.QM27PG;
  }
  public void setQM28PG(double qm28pg)
  {
  this.QM28PG=qm28pg;
  }
  public double getQM28PG()
  {
  return this.QM28PG;
  }
  public void setQM29PG(double qm29pg)
  {
  this.QM29PG=qm29pg;
  }
  public double getQM29PG()
  {
  return this.QM29PG;
  }
  public void setQM30PG(double qm30pg)
  {
  this.QM30PG=qm30pg;
  }
  public double getQM30PG()
  {
  return this.QM30PG;
  }
  public void setQM31PG(double qm31pg)
  {
  this.QM31PG=qm31pg;
  }
  public double getQM31PG()
  {
  return this.QM31PG;
  }
  public void setQM32PG(double qm32pg)
  {
  this.QM32PG=qm32pg;
  }
  public double getQM32PG()
  {
  return this.QM32PG;
  }
  public void setQM33PG(double qm33pg)
  {
  this.QM33PG=qm33pg;
  }
  public double getQM33PG()
  {
  return this.QM33PG;
  }
  public void setQM34PG(double qm34pg)
  {
  this.QM34PG=qm34pg;
  }
  public double getQM34PG()
  {
  return this.QM34PG;
  }
  public void setTQTAPG(double tqtapg)
  {
  this.TQTAPG=tqtapg;
  }
  public double getTQTAPG()
  {
  return this.TQTAPG;
  }
  public void setTQORPG(double tqorpg)
  {
  this.TQORPG=tqorpg;
  }
  public double getTQORPG()
  {
  return this.TQORPG;
  }
  public void setTQDSPG(double tqdspg)
  {
  this.TQDSPG=tqdspg;
  }
  public double getTQDSPG()
  {
  return this.TQDSPG;
  }
  public void setTQVAPG(double tqvapg)
  {
  this.TQVAPG=tqvapg;
  }
  public double getTQVAPG()
  {
  return this.TQVAPG;
  }
  public void setTQDFPG(double tqdfpg)
  {
  this.TQDFPG=tqdfpg;
  }
  public double getTQDFPG()
  {
  return this.TQDFPG;
  }
  public void setTQVEPG(double tqvepg)
  {
  this.TQVEPG=tqvepg;
  }
  public double getTQVEPG()
  {
  return this.TQVEPG;
  }
  public void setAVANPG(String avanpg)
  {
  this.AVANPG=avanpg;
  }
  public String getAVANPG()
  {
  return this.AVANPG;
  }
  public void setGGAVPG(int ggavpg)
  {
  this.GGAVPG=ggavpg;
  }
  public int getGGAVPG()
  {
  return this.GGAVPG;
  }
  public void setMMAVPG(int mmavpg)
  {
  this.MMAVPG=mmavpg;
  }
  public int getMMAVPG()
  {
  return this.MMAVPG;
  }
  public void setAAAVPG(int aaavpg)
  {
  this.AAAVPG=aaavpg;
  }
  public int getAAAVPG()
  {
  return this.AAAVPG;
  }
  public void setSOAVPG(int soavpg)
  {
  this.SOAVPG=soavpg;
  }
  public int getSOAVPG()
  {
  return this.SOAVPG;
  }
  public void setSTAVPG(String stavpg)
  {
  this.STAVPG=stavpg;
  }
  public String getSTAVPG()
  {
  return this.STAVPG;
  }
  public void setLIPRPG(String liprpg)
  {
  this.LIPRPG=liprpg;
  }
  public String getLIPRPG()
  {
  return this.LIPRPG;
  }
  public void setSRIBPG(String sribpg)
  {
  this.SRIBPG=sribpg;
  }
  public String getSRIBPG()
  {
  return this.SRIBPG;
  }
  public void setFCOMPG(String fcompg)
  {
  this.FCOMPG=fcompg;
  }
  public String getFCOMPG()
  {
  return this.FCOMPG;
  }
  public void setGSBPPG(String gsbppg)
  {
  this.GSBPPG=gsbppg;
  }
  public String getGSBPPG()
  {
  return this.GSBPPG;
  }
  public void setFRCMPG(String frcmpg)
  {
  this.FRCMPG=frcmpg;
  }
  public String getFRCMPG()
  {
  return this.FRCMPG;
  }
  public void setFECMPG(String fecmpg)
  {
  this.FECMPG=fecmpg;
  }
  public String getFECMPG()
  {
  return this.FECMPG;
  }
  public void setFLA1PG(String fla1pg)
  {
  this.FLA1PG=fla1pg;
  }
  public String getFLA1PG()
  {
  return this.FLA1PG;
  }
  public void setFLA2PG(String fla2pg)
  {
  this.FLA2PG=fla2pg;
  }
  public String getFLA2PG()
  {
  return this.FLA2PG;
  }
  public void setFLA3PG(String fla3pg)
  {
  this.FLA3PG=fla3pg;
  }
  public String getFLA3PG()
  {
  return this.FLA3PG;
  }
  public void setFLA4PG(String fla4pg)
  {
  this.FLA4PG=fla4pg;
  }
  public String getFLA4PG()
  {
  return this.FLA4PG;
  }
  public void setFLA5PG(String fla5pg)
  {
  this.FLA5PG=fla5pg;
  }
  public String getFLA5PG()
  {
  return this.FLA5PG;
  }
  public void setFLA6PG(String fla6pg)
  {
  this.FLA6PG=fla6pg;
  }
  public String getFLA6PG()
  {
  return this.FLA6PG;
  }
  public void setFLA7PG(String fla7pg)
  {
  this.FLA7PG=fla7pg;
  }
  public String getFLA7PG()
  {
  return this.FLA7PG;
  }
  public void setFLA8PG(String fla8pg)
  {
  this.FLA8PG=fla8pg;
  }
  public String getFLA8PG()
  {
  return this.FLA8PG;
  }
  public void setFL10PG(String fl10pg)
  {
  this.FL10PG=fl10pg;
  }
  public String getFL10PG()
  {
  return this.FL10PG;
  }
  public void setFL20PG(String fl20pg)
  {
  this.FL20PG=fl20pg;
  }
  public String getFL20PG()
  {
  return this.FL20PG;
  }
  public void setFL30PG(String fl30pg)
  {
  this.FL30PG=fl30pg;
  }
  public String getFL30PG()
  {
  return this.FL30PG;
  }


  public CComesseriPK getPk() {
    return pk;
  }

  public void setConsegne(CConsegneVO consegne) {
    this.consegne = consegne;
  }

  public void setPk(CComesseriPK pk) {
    this.pk = pk;
  }


  public void setProdotto(PfVO prodotto) {
    this.prodotto = prodotto;
  }

  public void setPrezzo_ven(double prezzo_ven) {
    this.prezzo_ven = prezzo_ven;
  }

  public void setListino(Set listino) {
    this.listino = listino;
  }

  public void setAvanma(CCodiceAvanzamentoVO avanma) {
    this.avanma = avanma;
  }

  public CConsegneVO getConsegne() {
    return consegne;
  }


  public PfVO getProdotto() {
    return prodotto;
  }

  public double getPrezzo_ven() {
    return prezzo_ven;
  }

  public Set getListino() {
    return listino;
  }

  public CCodiceAvanzamentoVO getAvanma() {
    return avanma;
  }

}









package dao.hibernate;



import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import org.hibernate.*;
import org.hibernate.usertype.*;
import java.io.Serializable;
/**
* @author Colin Hawkett
*/
public class TrimmedString implements UserType,Serializable
{
    public TrimmedString() {
        super();
    }

    public int[] sqlTypes() {
        return new int[] { Types.VARCHAR };
    }

    public Class returnedClass() {
        return String.class;
    }

    public boolean equals(Object x, Object y) throws HibernateException {
        return (x == y) || (x != null && y != null && (x.equals(y)));
    }

    public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws HibernateException, SQLException {

        String val = rs.getString(names[0]);

        return val != null ? val.trim() : "";
    }

    public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, SQLException {

      if(value == null)
        value = "";
      else if(value.equals("undefined"))//per flex che i valori nulli li passa "undefined"
         value="";

      st.setString(index, (String)value);
    }

    public Object deepCopy(Object value) throws HibernateException {
        if (value == null) return "";
        return new String((String)value);
    }

    public boolean isMutable() {
        return false;
    }


public int hashCode(Object x) throws HibernateException {
return x.hashCode();
}

public Object assemble(Serializable cached, Object owner)
throws HibernateException {
return cached;
}

public Serializable disassemble(Object value) throws HibernateException {
return (Serializable) value;
}

public Object replace(Object original, Object target, Object owner)
throws HibernateException {
return original;
}


}


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 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.