From: <cl...@hy...> - 2009-01-09 18:04:26
|
Author: clee Date: 2009-01-09 10:04:15 -0800 (Fri, 09 Jan 2009) New Revision: 12203 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=12203 Modified: trunk/src/org/hyperic/hq/appdef/server/session/ServerDAO.java Log: Missed a couple of queries dealing with sortName Modified: trunk/src/org/hyperic/hq/appdef/server/session/ServerDAO.java =================================================================== --- trunk/src/org/hyperic/hq/appdef/server/session/ServerDAO.java 2009-01-09 18:02:48 UTC (rev 12202) +++ trunk/src/org/hyperic/hq/appdef/server/session/ServerDAO.java 2009-01-09 18:04:15 UTC (rev 12203) @@ -197,7 +197,7 @@ public Server findByName(Platform plat, String name) { String sql = "select s from Server s " + - "where s.platform = :plat and s.sortName=:name"; + "where s.platform = :plat and s.resource.sortName=:name"; return (Server)getSession().createQuery(sql) .setParameter("plat", plat) @@ -207,7 +207,7 @@ public List findByName(String name) { - String sql="from Server where sortName=?"; + String sql="from Server where resource.sortName=?"; return getSession().createQuery(sql) .setString(0, name.toUpperCase()) .list(); |