Log do Hibernate

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
    <!-- Database connection settings -->
        <property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
        <property name="connection.url">jdbc:db2:DINFODE2</property>
        <property name="connection.username">db2admin</property>
        <property name="connection.password">dinfodev2</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.DB2Dialect</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>
        
        <property name="hibernate.jdbc.batch_size">30</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <property name="org.hibernate">true</property>
        
        <mapping resource="br/com/bb/sigov/sinergia8/RankingBean.hbm.xml"/>
        <mapping resource="br/com/bb/sigov/sinergia8/AtbBean.hbm.xml"/>
        <mapping resource="br/com/bb/sigov/sinergia8/FocoBean.hbm.xml"/>
        <mapping resource="br/com/bb/sigov/sinergia8/TotaisBean.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="br.com.bb.sigov.sinergia8.AtbBean" table="DB2ATB.ATB">
        <composite-id>
            <key-property name="cd_prf_depe"    column="CD_PRF_DEPE"/>
            <key-property name="aa_ref"         column="AA_REF"/>
            <key-property name="mm_ref"         column="MM_REF"/>
            <key-property name="prsp"           column="PRSP"/>
        </composite-id>
            <property name="pto_mm"             column="PTO_MM"/>
            <property name="pto_smt"            column="PTO_SMT"/>
            <property name="peso"               column="PESO"/>
            <property name="pto"                column="PTO"/>
    </class>
</hibernate-mapping>

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package br.com.bb.sigov.sinergia8;

import java.io.Serializable;

/**
 *
 * @author f9343091
 */
public class AtbBean implements Serializable
{
    private int cd_prf_depe;
    private int aa_ref;
    private int mm_ref;
    private String prsp;
    private int pto_mm;
    private int pto_smt;
    private int peso;
    private int pto;
    
    public AtbBean()
    {
    }

    public int getCd_prf_depe()
    {
        return cd_prf_depe;
    }

    public void setCd_prf_depe(int cd_prf_depe)
    {
        this.cd_prf_depe = cd_prf_depe;
    }

    public int getAa_ref()
    {
        return aa_ref;
    }

    public void setAa_ref(int aa_ref)
    {
        this.aa_ref = aa_ref;
    }

    public int getMm_ref()
    {
        return mm_ref;
    }

    public void setMm_ref(int mm_ref)
    {
        this.mm_ref = mm_ref;
    }

    public String getPrsp()
    {
        return prsp;
    }

    public void setPrsp(String prsp)
    {
        this.prsp = prsp;
    }

    public int getPto_mm()
    {
        return pto_mm;
    }

    public void setPto_mm(int pto_mm)
    {
        this.pto_mm = pto_mm;
    }

    public int getPto_smt()
    {
        return pto_smt;
    }

    public void setPto_smt(int pto_smt)
    {
        this.pto_smt = pto_smt;
    }

    public int getPeso()
    {
        return peso;
    }

    public void setPeso(int peso)
    {
        this.peso = peso;
    }

    public int getPto()
    {
        return pto;
    }

    public void setPto(int pto)
    {
        this.pto = pto;
    }
    
}

public AtbBean [] getAtbPerspectiva()
    {
        List<AtbBean> lst = new ArrayList();
        String sql = sqlAtbPerspectiva( false );
        
        try
        {
            Session sessao = HibernateUtil.getSessionFactory().getCurrentSession();
            sessao.beginTransaction();
            lst = sessao.createSQLQuery(sql).addEntity( AtbBean.class).list();
            sessao.getTransaction().commit();
        }
        catch(Exception e)
        {
            log.addLog("erro ao Processar os valores do Atb: " + e);
        }
        
        return formataAtb( (AtbBean[])lst.toArray( new AtbBean[0]) );
    }

private String sqlAtbPerspectiva( boolean todos )
    {
        String sql = "";
        sql += " select cd_prf_depe, aa_ref, mm_ref, prsp, pto_mm, pto_smt, pto from db2atb.atb ";
        sql += " where cd_prf_depe = "+depe+" and aa_ref = "+ano+" and mm_ref = "+mes+" ";
        if (todos == true)
            sql += " prsp like TOTAL ";
        
        log.addLog("Sql ATB: " + sql);
        return sql;
    }

Hibernate: 
    select
        cd_prf_depe,
        aa_ref,
        mm_ref,
        prsp,
        pto_mm,
        pto_smt,
        pto 
    from
        db2atb.atb  
    where
        cd_prf_depe = 8 
        and aa_ref = 2008 
        and mm_ref = 2

CREATE TABLE DB2ATB.ATB 
(
   CD_PRF_DEPE          INTEGER NOT NULL,
   AA_REF               INTEGER NOT NULL,
   MM_REF               INTEGER NOT NULL,
   PRSP                 VARCHAR(40) NOT NULL,
   PTO_MM               INTEGER,
   PTO_SMT              INTEGER,
   PESO                 INTEGER,
   PTO                  INTEGER
)
   IN ATB
;
ALTER TABLE DB2ATB.ATB
   ADD PRIMARY KEY (CD_PRF_DEPE, AA_REF, MM_REF, PRSP);