Sachin_Ajmani
asked on
how to call stored procure using hibernate
Procedure name:xydata_gespeed
In hibernate query
i am getting System.out.println("Listtt t " + list1.size());
list size zero what i am doing wrong please help me
BEGIN
SELECT * FROM xydata xy
WHERE xy.ObjectId = xy_objectId
AND xy.ClientId=xy_clientId
AND xy.GpsTime >= xy_gpstime
AND xy.GpsTime <= xy_gpstime1
AND xy.Speed >= xy_speed ORDER BY xy.GpsTime ASC;
END
In Entity class@Entity
@NamedNativeQuery(name = "xydatas",
resultClass = Xydata.class,
query = "{call xydata_gespeed(:objectId,:clientId,:gpsTime,:gpsTime,:speed)}",
hints = {
@QueryHint(name = "org.hibernate.callable", value = "true")
})
In hibernate query
List list1 = getSession().getNamedQuery("xydatas").setParameter("objectId", Objectid).setParameter("clientId", Integer.valueOf(id)).setParameter("gpsTime", from).setParameter("gpsTime", to).setParameter("speed", Integer.valueOf(speed)).list();
System.out.println("Listttt " + list1.size());
i am getting System.out.println("Listtt
list size zero what i am doing wrong please help me
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.