convert sql query to critera query

Asked Aug 28 '15 at 19:48

Active Aug 28 '15 at 19:48

Viewed 53 times

Can some one help me convert this to criteria query . I am using Hibernate and when i used this in native query, it returned me an empty result set :(

 select * from Experiment e,launchman l,launchman_has_servergroups        ls,servergroup s 
where e.IDEXPERIMENT = l.EXPERIMENT_IDEXPERIMENT 
and l.idLaunchman = ls.LAUNCHMAN_IDLAUNCHMAN 
and ls.SERVERGROUP_IDSERVERGROUP=s.idservergroup 
and s.servergroupname = 'uatServers';

asked Aug 28 '15 at 19:48

Bhavana k

2

If this didn't work in "native query" mode, doesn't that mean that the SQL query itself is not working? – sstan Aug 28 '15 at 19:55
yes its supposed to be. when i checked in DB there is data . – Bhavana k Aug 31 '15 at 12:41
If at all i have to convert how would that look like ? – Bhavana k Aug 31 '15 at 12:42

convert sql query to critera query

0 Answers0