public List<TprchsSaleTrans> findTprchsSaleTrans()
{
  List<Object> l = null;
  TprchsSaleTrans prchsSaleTrans = null;
  List<TprchsSaleTrans> listReturn = new ArrayList<TprchsSaleTrans>();
try {
l = this.getHibernateTemplate().[B]findByNamedQuery[/B("tprchsSaleTransQuery");
for (Object list : l)
{
    Object[] element = (Object[]) list;
    prchsSaleTrans = new TprchsSaleTrans();
    prchsSaleTrans.setTprchssaletransID((Integer) element[0]);
      //dans la bd BranchCd = 199 et hibernate me sort seulement le 1 char
     [B]prchsSaleTrans.setBranchCd((String) element[1]);[/B]
listReturn.add(prchsSaleTrans);......
         }
      } catch (Exception e) {
         e.printStackTrace();
      }
      return listReturn;
   }
}

<hibernate-mapping>
    <class name="TprchsSaleTrans" table="tprchs_sale_trans">
         <id name="tprchssaletransID" type="java.lang.Integer">
            <column name="tprchs_sale_trans_ID" />
            <generator class="identity" />
        </id>
            <property name="accountCd" type="string">
                <column name="account_cd" length="5" />
            </property>
            [B]<property name="branchCd" type="string">
                <column name="branch_cd" length="3" />
            </property>[/B]....
</class>
    [B] <sql-query name="tprchsSaleTransQuery">
      <![CDATA[select tprchs_sale_trans_ID,branch_cd,account_cd,type_account_cd,chck_brch_acct_nbr, transaction_dt,currency_cd,sum(case when debit_credit_cd = 'C' then tran_total_amt * -1 else tran_total_amt  end) as net FROM tprchs_sale_trans where  CONVERT(varchar(20), transaction_dt,105 )   = CONVERT(varchar(20),GETDATE(),105) or (CONVERT(varchar(20), processing_dt,105 )   = CONVERT(varchar(20),GETDATE()-1,105) and  transaction_dt  <=   GETDATE() ) GROUP by branch_cd,account_cd,type_account_cd,chck_brch_acct_nbr,transaction_dt,currency_cd,tprchs_sale_trans_ID]]>
   </sql-query>[/B]
</hibernate-mapping>

private String branchCd;