Hibernate- Sql query cast object

Question

I have Spring MVC Application alongside hibernate. I can cast hql queries to object but the same doesn't apply to SQL. I have the following query to cast to Jpassatempos Object:

List<Jpassatempos> list = (List<Jpassatempos>) 
session.createSQLQuery("select jpassatempos.* from jpassatempos 
left join jcodigos on jpassatempos.Id = jcodigos.PassatemposId 
where jpassatempos.Id in 
     (select jpassatempos_concorrentes.PassatemposId from jpassatempos_concorrentes  
       left join jpassatempos on jpassatempos_concorrentes.PassatemposId = jpassatempos.Id 
       where  jpassatempos_concorrentes.ConcorrentesId = ? and jpassatempos.DataFim > current_date group by jpassatempos_concorrentes.PassatemposId) 
or jpassatempos.Id in 
     (select  jmeuspassatempos.PassatemposId from jmeuspassatempos 
       where ConcorrentesId = ? group by jmeuspassatempos.PassatemposId) 
group by jpassatempos.Id order by sum(jcodigos.NumBolhasRestantes)").setParameter(0, id).setParameter(1, id).list();

Any advice?

hunter · Accepted Answer · 2015-08-03 17:18:59Z

2

use setResultTransformer( Transformers.aliasToBean(Jpassatempos.class))

answered Aug 3, 2015 at 17:18

hunter

4,2231 gold badge18 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Kunal Over a year ago

Should i use it like this: Criteria criteria = session.createCriteria(Jpassatempos.class); criteria.setResultTransformer( Transformers.aliasToBean(Jpassatempos.class)); It didn't do anything...

hunter Over a year ago

No, createSqlQuery returns a SQLQuery , so it has the method setResultTransformer. createSqlQuery('sql').setParameter().setResultTranformer().list()

Kunal Over a year ago

Thanks but i get another error: Could not find setter for TipoPassatemposId on class com.setelog.spring.model.Jpassatempos I supose it can't cast correctly because of related entities

hunter Over a year ago

try to use addEntity(Jpassatempos.class). ex:...... createSqlQuery('sql').setParameter().addEntity(passatempos.class)

Collectives™ on Stack Overflow

Hibernate- Sql query cast object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related