String sql = " from br.com.ag2.quatromais.vo.Compromisso as c where " +" c.dthInicioCompromisso >= " + dtInitial
+ " and c.dthFimCompromisso <= " + dtFinal
+" and  c.agenda.campanha.codCampanha = " + cod_campanha
+" order by c.dthInicioCompromisso asc";

Criteria criteria = session.createCriteria(Compromisso.class);
Date dtInitial = compromisso.getDthInicioCompromisso();
Date dtFinal = compromisso.getDthFimCompromisso();
criteria.add( Expression.ge("dthInicioCompromisso",dtInitial));
criteria.add( Expression.le("dthFimCompromisso",dtFinal));
criteria.add( Expression.eq("agenda.campanha.codCampanha",cod_campanha));
criteria.addOrder(Order.asc("dthInicioCompromisso"));

criteria.add( Expression.eq("agenda.campanha.codCampanha",cod_campanha));

   /** identifier field */
   private Integer codCompromisso;

   /** persistent field */
   private Date dthInicioCompromisso;

   /** persistent field */
   private String txtLocal;

   /** persistent field */
   private Date dthFimCompromisso;

   /** persistent field */
   private String txtCompromisso;

   /** persistent field */
   private String txtAssunto;

   /** nullable persistent field */
   private String txtObservacoes;

   /** nullable persistent field */
   private Integer indConfirmado;

   /** nullable persistent field */
   private String txtRelatorioReuniao;

   /** persistent field */
   private br.com.ag2.quatromais.vo.Agenda agenda;

   /** persistent field */
   private br.com.ag2.quatromais.vo.AreaGeografica areaGeografica;

   /** persistent field */
   private Set participants;

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
   
<hibernate-mapping>
<class
    name="br.com.ag2.quatromais.vo.Compromisso"
    table="compromisso"
>

    <id
        name="codCompromisso"
        type="java.lang.Integer"
        column="cod_compromisso"
    >
        <generator class="assigned" />
    </id>

    <property
        name="dthInicioCompromisso"
        type="java.sql.Date"
        column="dth_inicio_compromisso"
        not-null="true"
        length="4"
    />
    <property
        name="txtLocal"
        type="java.lang.String"
        column="txt_local"
        not-null="true"
        length="200"
    />
    <property
        name="dthFimCompromisso"
        type="java.sql.Date"
        column="dth_fim_compromisso"
        not-null="true"
        length="4"
    />
    <property
        name="txtCompromisso"
        type="java.lang.String"
        column="txt_compromisso"
        not-null="true"
        length="8000"
    />
    <property
        name="txtAssunto"
        type="java.lang.String"
        column="txt_assunto"
        not-null="true"
        length="100"
    />
    <property
        name="txtObservacoes"
        type="java.lang.String"
        column="txt_observacoes"
        length="8000"
    />
    <property
        name="indConfirmado"
        type="java.lang.Integer"
        column="ind_confirmado"
        length="4"
    />
    <property
        name="txtRelatorioReuniao"
        type="java.lang.String"
        column="txt_relatorio_reuniao"
        length="8000"
    />

    <!-- Associations -->
 
    <!-- bi-directional one-to-many association to Participant -->
    <set
        name="participants"
        lazy="true"
        inverse="true"
    >
        <key>
            <column name="cod_compromisso" />
        </key>
        <one-to-many
            class="br.com.ag2.quatromais.vo.Participant"
        />
    </set>
    <!-- bi-directional many-to-one association to Agenda -->
    <many-to-one
        name="agenda"
        class="br.com.ag2.quatromais.vo.Agenda"
        not-null="true"
    >
        <column name="cod_agenda" />
    </many-to-one>
    <!-- bi-directional many-to-one association to AreaGeografica -->
    <many-to-one
        name="areaGeografica"
        class="br.com.ag2.quatromais.vo.AreaGeografica"
        not-null="true"
    >
        <column name="cod_area" />
    </many-to-one>

</class>
</hibernate-mapping>