Mailing-List: contact commits-help@airavata.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@airavata.apache.org
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1394744 -
 /airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java
Date: Fri, 05 Oct 2012 19:33:25 -0000
To: commits@airavata.apache.org
From: lahiru@apache.org
Message-Id: <20121005193325.2783B23889C5@eris.apache.org>

Author: lahiru
Date: Fri Oct  5 19:33:24 2012
New Revision: 1394744

URL: http://svn.apache.org/viewvc?rev=1394744&view=rev
Log: (empty)

Modified:
    airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java

Modified: airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java
URL: http://svn.apache.org/viewvc/airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java?rev=1394744&r1=1394743&r2=1394744&view=diff
==============================================================================
--- airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java (original)
+++ airavata/trunk/modules/registry/airavata-jpa-registry/src/main/java/org/apache/airavata/persistance/registry/jpa/resources/ExperimentDataRetriever.java Fri Oct  5 19:33:24 2012
@@ -139,10 +139,11 @@ public class ExperimentDataRetriever {
             statement = connection.createStatement();
 
 //            String queryString = "SELECT experiment_ID FROM Experiment WHERE user_name ='" +  user + "'";
+            // FIXME : pass user ID as a regular expression
             String queryString = "SELECT ed.experiment_ID FROM Experiment_Data ed " +
                     "LEFT JOIN Experiment e " +
                     "ON ed.experiment_ID = e.experiment_ID " +
-                    "WHERE ed.username REGEXP '^" + user + "$'";
+                    "WHERE ed.username ='" + user + "'";
             rs = statement.executeQuery(queryString);
             if(rs != null){
                 while (rs.next()) {
@@ -357,6 +358,7 @@ public class ExperimentDataRetriever {
             Class.forName(Utils.getJDBCDriver()).newInstance();
             connection = DriverManager.getConnection(connectionURL, Utils.getJDBCUser(), Utils.getJDBCPassword());
             statement = connection.createStatement();
+            //FIXME : pass user ID as a regular expression
             String queryString = "SELECT e.experiment_ID, ed.name, ed.username, em.metadata, " +
                     "e.project_name, e.submitted_date " +
                     "FROM Experiment e " +
@@ -364,7 +366,7 @@ public class ExperimentDataRetriever {
                     "ON e.experiment_ID = ed.experiment_ID " +
                     "LEFT JOIN Experiment_Metadata em " +
                     "ON ed.experiment_ID = em.experiment_ID  " +
-                    "WHERE ed.username REGEXP '^" + user + "$'";
+                    "WHERE ed.username ='" + user + "'";
 
             rs = statement.executeQuery(queryString);
             if (rs != null){