package vo.as400;



public class CStagione implements java.io.Serializable {

  private String cdc_stag;
  private String dsc_stag;



  public String _remoteClass = "vo.as400.CStagione";
  public String getCdc_stag() {
    return cdc_stag;
  }

  public void setDsc_stag(String dsc_stag) {
    this.dsc_stag = dsc_stag;
  }

  public void setCdc_stag(String cdc_stag) {
    this.cdc_stag = cdc_stag;
  }


  public String getDsc_stag() {
    return dsc_stag;
  }


}

public CStagione[] getAllSeason_ok() throws DaoException {
    try
    {
      Connection conn=ConnectionFactory.getInstance().getConn();
      Session session = FirebirdSession.currentSession();

      PreparedStatement stmt = session.connection().prepareStatement("Select TRIM(CDELTB),SUBSTR(DATITB,1,30) from "arctb00f Where cdtbtb='STG' AND STRETB=''  Order by 1 ");
      ResultSet rset = stmt.executeQuery();
      ArrayList list = new ArrayList();
      CStagione season = null;
      for (; rset.next(); list.add(season))
      {
        season = new CStagione();
        season.setCdc_stag(rset.getString(1));
        season.setDsc_stag(rset.getString(2));
      }
      rset.close();
      stmt.close();
      FirebirdSession.currentSession();
      CStagione seasons[] = new CStagione[list.size()];
//      conn.close();
      list.toArray(seasons);
      return seasons;
    }
    catch (Exception ex) {
      ex.printStackTrace();
      throw new java.lang.UnsupportedOperationException("CStagioneDao getAllSeason "+ex.getMessage());
    }
  }

package vo.as400;



public class CStagione implements java.io.Serializable {

  private String cdc_stag;
  private String dsc_stag;



  public String _remoteClass = "vo.as400.CStagione";
  public String getCdc_stag() {
    return cdc_stag;
  }

  public void setDsc_stag(String dsc_stag) {
    this.dsc_stag = dsc_stag.substring(0,30);
  }

  public void setCdc_stag(String cdc_stag) {
    this.cdc_stag = cdc_stag;
  }


  public String getDsc_stag() {
    return dsc_stag;
  }

}





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


   <class name="vo.as400.CStagione" table="sdgtwb_dat.arctb00f" lazy="false">


     <id name="cdc_stag" column="cdeltb" >
             <generator class="assigned"/>
       </id>

<property name="dsc_stag"  column="DATITB" type="string" />



   <filter name="stagione" condition="CDTBTB IN (:tipo)"/>

        </class>

<filter-def name="stagione">
<filter-param name="tipo" type="string"/>
</filter-def>

</hibernate-mapping>





Emaple Dao

session.enableFilter("stagione").setParameter("tipo",new String("STG"));
Query q = session.createQuery("from CStagione as ay ");