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


   <class name="vo.as400.CScontrinoVO" table="sdgtwb_dat.aynau00f" lazy="false" >

         <composite-id name="pk" class="vo.pk.CScontrinoPK">
              <key-property name="cbara" column="cbar$a" type="string"/>
              <key-property name="filia" column="fili$a" type="string"/>
              <key-property name="numta" column="numt$a" />
        </composite-id>





        <property name="staga"  column="stag$a" type="dao.hibernate.TrimmedString"/>
        <property name="modea"  column="mode$a" type="dao.hibernate.TrimmedString"/>
        <property name="matea"  column="mate$a" type="dao.hibernate.TrimmedString"/>
        <property name="coloa"  column="colo$a" type="dao.hibernate.TrimmedString"/>
        <property name="varia"  column="vari$a" type="dao.hibernate.TrimmedString"/>
        <property name="cdtga"  column="cdtg$a" type="dao.hibernate.TrimmedString"/>
        <property name="tgsia"  column="tgsi$a" type="dao.hibernate.TrimmedString"/>
        <property name="pvena"  column="pven$a" />
        <property name="pacqa"  column="pacq$a" />
        <property name="de20a"  column="de20$a" type="dao.hibernate.TrimmedString"/>
        <property name="dcola"  column="dcol$a" type="dao.hibernate.TrimmedString"/>
        <property name="dcmpa"  column="dcmp$a" type="dao.hibernate.TrimmedString"/>
        <property name="ggspa"  column="ggsp$a" />
        <property name="mmspa"  column="mmsp$a" />
        <property name="aaspa"  column="aasp$a" />
        <property name="ndoca"  column="ndoc$a" />


        <many-to-one name="spedizioni"  access="property"   lazy="false" update="false" insert="false">
      <column name="GGSP$A"/>
      <column name="MMSP$A"/>
      <column name="AASP$A"/>
      <formula>20</formula>
      <column name="NDOC$A"/>
      
      
      
   </many-to-one>

        </class>



a bit java code

  public void setNdoca(String ndoca) {
    int nr_ddt=0;
    if(!ndoca.equals(null))
    {
      nr_ddt=Integer.parseInt(ndoca.substring(0,8).trim());
    }
    this.ndoca =String.valueOf(nr_ddt);

  }



  public String getNdoca() {
    return ndoca;
  }





</hibernate-mapping>