Hi All

I use hibernate 3.2
I try to get list of object using createQuery()

"Query query = sess.createQuery("from GaTran g join fetch g.useridin join fetch g.useridout join fetch g.vhctype join fetch g.memberid join fetch g.priceid join fetch g.appparamid where g.vhctimein >= :startdate and g.vhctimeout <= :enddate and g.vehiclenum like :inputsearch").setCalendar("startdate", startdate).setCalendar("enddate", enddate).setString("inputsearch", inputsearch.toUpperCase());
List lst = query.list();"

How come when I iterate lst object I got empty List but when I remove the JOIN in query, lst contain object data.

Hi, maybe the problem is with your database dialect isn't understanding your join syntax, have you tried with another hql syntax? please, show the sql query generated