commit 6a6d93c3094a55c38f2bdcc736d179ce1e595093
author Min Chen <min.chen@citrix.com> Thu Jan 31 11:56:06 2013 -0800
committer Min Chen <min.chen@citrix.com> Thu Jan 31 11:56:48 2013 -0800
tree a201b4cc39273240ff5e8bda43607209fd74a247
parent 4f7bf192ceb80f558b41899281c2731c59da2701

Fix a bug in listStoragePools api where SQL exception is thrown when a
parameter is passed.

server/src/com/cloud/api/query/QueryManagerImpl.java

diff --git a/server/src/com/cloud/api/query/QueryManagerImpl.java b/server/src/com/cloud/api/query/QueryManagerImpl.java
index cf240b1..c607383 100644
--- a/server/src/com/cloud/api/query/QueryManagerImpl.java
+++ b/server/src/com/cloud/api/query/QueryManagerImpl.java
@@ -1893,23 +1893,23 @@
         }
 
         if (name != null) {
-            sc.setParameters("name", SearchCriteria.Op.LIKE, "%" + name + "%");
+            sc.setParameters("name", "%" + name + "%");
         }
 
         if (path != null) {
-            sc.setParameters("path", SearchCriteria.Op.EQ, path);
+            sc.setParameters("path", path);
         }
         if (zoneId != null) {
-            sc.setParameters("dataCenterId", SearchCriteria.Op.EQ, zoneId);
+            sc.setParameters("dataCenterId", zoneId);
         }
         if (pod != null) {
-            sc.setParameters("podId", SearchCriteria.Op.EQ, pod);
+            sc.setParameters("podId", pod);
         }
         if (address != null) {
-            sc.setParameters("hostAddress", SearchCriteria.Op.EQ, address);
+            sc.setParameters("hostAddress", address);
         }
         if (cluster != null) {
-            sc.setParameters("clusterId", SearchCriteria.Op.EQ, cluster);
+            sc.setParameters("clusterId", cluster);
         }
 
         // search Pool details by ids