Criteria does not return Boolean field

Guevara · **Joined:** Sat Oct 03, 2009 1:51 pm **Posts:** 26

Hello!
I have the following class:

Code:

public class House {
private Long codHouse;
private Boolean destack;
private Date dateInclusion;
// getters e setters
}

And running a query using Criteria just want to get the code and the destack value (true or false):

Code:

public List<House> listDestacks() {
      return session.createCriteria(House.class)
      .add(Restrictions.isNotNull("destack"))
      .setProjection(Projections.projectionList()
      .add(Projections.property("codHouse").as("codHouse"))
      .add(Projections.property("destack").as("destack")))
      .addOrder(Order.desc("dateInclusion")).setMaxResults(10).list();      
   }

Except that the query is not working to get the field "destack":

Code:

Hibernate: 
    select
        this_.cod_house as y0_,
        this_.destack as y1_ 
    from
        House this_ 
    where
        y1_ is not null 
    order by
        this_.date_inclusion desc limit ?
16:39:40,668  WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42703
16:39:40,668 ERROR [JDBCExceptionReporter] ERRO: column "y1_" does not exist
  Position: 79

can anyone help?
Thanks!!

saltnlight5 · **Posted:** Sun Oct 10, 2010 9:21 am

Your "code and the destack" are just simple column fields, and no need to add "Projections". Remove those.

Guevara · **Joined:** Sat Oct 03, 2009 1:51 pm **Posts:** 26

but this is what I want, pick only those two columns, I have many others attributes in the class that I omitted, is 10, but I want to just those two... =/

saltnlight5 · **Posted:** Sun Oct 10, 2010 6:01 pm

Well, your method signature says returns List<House>, but if you are you add Projection, your returned list is not matching. Projection will give you List<Object[]>.

Perhaps you can display your hibernate-mapping file, and your full stacktrace.

Guevara · **Joined:** Sat Oct 03, 2009 1:51 pm **Posts:** 26

If i use this Criteria without projections, the Criteria works, but it load all the attributes that do not need, I do not know how to return the list of homes with only the code and boolean field. =/
The problem is not mapping, is how to load list of houses with code and destack only.
Regards.

CDillinger · **Joined:** Tue Oct 28, 2008 10:39 am **Posts:** 196

Try googling "resulttransformer".

Guevara · **Joined:** Sat Oct 03, 2009 1:51 pm **Posts:** 26

Thank you CDillinger, but it did not work, does not give error but the boolean field "destack" is going null. =/

Code:

public List<House> listDestack() {
      return session.createCriteria(House.class)
         .add(Restrictions.isNotNull("destack"))
         .setProjection(Projections.projectionList()
         .add(Projections.property("codHouse"))
         .add(Projections.property("destack")))
         .addOrder(Order.desc("dateInclusion"))
         .setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP)
         .setMaxResults(10).list(); 
   }    

Guevara · **Joined:** Sat Oct 03, 2009 1:51 pm **Posts:** 26

nobody??