<return alias="vlr" class="org.domain.myapp.entity.EntityWithEmbeddedId" >
   <return-property name="id" >      
      <return-column name="FIELD_1" />   
      <return-column name="FIELD_2"  />
      <return-column name="FIELD_3" />
       <return-column name="FIELD_4" />
   </return-property>
       ...

14:50:12,296 TRACE [org.hibernate.loader.Loader] (http-localhost/127.0.0.1:8080-4) Processing result set
14:50:12,297 DEBUG [org.hibernate.loader.Loader] (http-localhost/127.0.0.1:8080-4) Result set row: 0
14:50:12,298 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost/127.0.0.1:8080-4) Found [19] as column [FIELD_1]
14:50:12,300 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost/127.0.0.1:8080-4) Found [199] as column [FIELD_2]
14:50:12,301 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost/127.0.0.1:8080-4) Found [4] as column [FIELD_3]
14:50:12,302 TRACE [org.hibernate.type.descriptor.sql.BasicExtractor] (http-localhost/127.0.0.1:8080-4) Found [201504] as column [FIELD_4]
14:50:12,304 DEBUG [org.hibernate.loader.Loader] (http-localhost/127.0.0.1:8080-4) Result row: EntityKey[org.domain.myapp.entity.EntityWithEmbeddedId#component[FIELD_4,FIELD_1,FIELD_3,FIELD_2]{field4=19, field1=199, field2=201504, field3=4}]

@SuppressWarnings("serial")
@Embeddable
public class MyEmbeddedId implements java.io.Serializable {

   private Long field1;
   private Long field2;
   private Long field3;
   private Long field4;

   //Getters and Setters
}

   ......
   @EmbeddedId
   @AttributeOverrides({
         @AttributeOverride(name = "field1", column = @Column(name = "FIELD_1", nullable = false, scale = 0)),
         @AttributeOverride(name = "field2", column = @Column(name = "FIELD_2", nullable = false, scale = 0)),
         @AttributeOverride(name = "field3", column = @Column(name = "FIELD_3", nullable = false, scale = 0)),
         @AttributeOverride(name = "field4", column = @Column(name = "FIELD_4", nullable = false, scale = 0)) })
   @NotNull
   public MyEmbeddedId getId() {
      return this.id;
   }
   ......

statelessSession = ((Session) entityManager.getDelegate()).getSessionFactory().openStatelessSession();
ArrayList<EntityWithEmbeddedId> entities = (ArrayList<EntityWithEmbeddedId>) statelessSession
   .getNamedQuery("NamedQueryForEntityWithEmbeddedId")
   .setParameter("param1", param1)
   .list();

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
   <sql-query name="NamedQueryForEntityWithEmbeddedId">
      <return alias="vlr" class="org.domain.myapp.entity.EntityWithEmbeddedId" >
         <return-property name="id" >      
            <return-column name="FIELD_1" />   
            <return-column name="FIELD_2"  />
            <return-column name="FIELD_3" />
             <return-column name="FIELD_4" />
         </return-property>
      </return>
       <![CDATA[
      select vlr.ESTRUTURA_ID as FIELD_1,
           vlr.VARIAVEL_ID as FIELD_2,
           0 as FIELD_3,
           vlr.ANOMES as FIELD_4,
           str.INSTANCIA_ID as FIELD_5,
            vlr.ANO as FIELD_6,
            vlr.MES as FIELD_7,
            vlr.VALOR FIELD_8,
            vlr.OBS as FIELD_9 
        from SNJ_VALORES_DAS_VARIAVEIS vlr
          left join SNJ_ESTRUTURA str on str.ID = vlr.ESTRUTURA_ID
          left join SNJ_VARIAVEL  vrv on vrv.ID = vlr.VARIAVEL_ID
          left join SNJ_ARQUIVOS  arq on arq.ID = -1
       where vlr.ESTRUTURA_ID = :estruturaId
         and (:instanciaId = -1)
         and vlr.VARIAVEL_ID in ( select cmp.COMPONENTE_ID from SNJ_COMPONENTES cmp 
                                  where cmp.PRINCIPAL_ID = :principalId)             
         and ( vlr.ANOMES       = :periodo
               or
                vlr.ANOMES = ( select max(v.ANOMES) from SNJ_VLRS_VARIAVEL v
                               where v.GRUPO_ID = 0
                                 and v.ESTRUTURA_ID = vlr.ESTRUTURA_ID
                                 and v.VARIAVEL_ID = vlr.VARIAVEL_ID
                                 and v.ANOMES <= :periodo
                             )
               or
                 ( not exists( select * from SNJ_VLRS_VARIAVEL v
                                 where v.GRUPO_ID = 0
                                 and v.ESTRUTURA_ID = vlr.ESTRUTURA_ID
                                           and v.VARIAVEL_ID = vlr.VARIAVEL_ID
                                           and v.ANOMES <= :periodo)
                           and
                           vlr.ANOMES = ( select min(v.ANOMES) from SNJ_VLRS_VARIAVEL v
                                          where v.GRUPO_ID = 0
                                  and v.ESTRUTURA_ID = vlr.ESTRUTURA_ID
                                         and v.VARIAVEL_ID = vlr.VARIAVEL_ID
                                            and v.ANOMES >= :periodo)
                       )
           )
       order by vlr.VARIAVEL_ID ,
               vlr.ESTRUTURA_ID ,
               vlr.ANOMES
       ]]>
   </sql-query>
</hibernate-mapping>