Hibernate Community • View topic - Problem with HQL query (SOLVED)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem with HQL query (SOLVED)

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

wiji

Post subject: Problem with HQL query (SOLVED)

Posted: Fri Jun 11, 2010 3:20 am

Newbie

Joined: Wed Oct 07, 2009 7:34 am
Posts: 12

Hi!

I have something like this:

Code:

@Entity
@Table(name = "fp_Franquiciador")
public class Franquiciador extends com.fplus.portal.model.Entity implements Serializable {

......

   @OneToMany(mappedBy = "franquiciador", cascade = CascadeType.REMOVE, fetch = FetchType.LAZY)
   private List<SinonimoFranquiciador> sinonimosFranquiciador;
..........
}

And i'm tryin to use this hql query:

Select fran.id, fran.fecha, fran.sinonimosFranquiciador.size* From Franquiciador fran

I know fran.sinonimosFranquiciador.size* doesnt work... how can I do it??

Last edited by wiji on Fri Jun 11, 2010 5:33 am, edited 1 time in total.

Top

etwcn

Post subject: Re: Problem with HQL query

Posted: Fri Jun 11, 2010 4:02 am

Beginner

Joined: Thu Feb 08, 2007 10:40 am
Posts: 46

The function you need is documented here:
http://docs.jboss.org/hibernate/stable/ ... xpressions

The HQL for your example needs to look like this:

Code:

Select fran.id, fran.fecha, size(fran.sinonimosFranquiciador)  From Franquiciador fran

Top

wiji

Post subject: Re: Problem with HQL query

Posted: Fri Jun 11, 2010 5:25 am

Newbie

Joined: Wed Oct 07, 2009 7:34 am
Posts: 12

Thanks you very much, problem solved!!!
Finlly i use this:

"SELECT con.id,con.titular,SIZE(icons.id) FROM Contenido con

LEFT JOIN con.imagenesContenido icons GROUP BY con"

I need to gruop by con, because it only obtained 1 results if dont grouping

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum