Author: lahiru
Date: Fri Oct 5 19:17:55 2012
New Revision: 1394741
URL: http://svn.apache.org/viewvc?rev=1394741&view=rev
Log:
adding reg ex to select query
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=1394741&r1=1394740&r2=1394741&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:17:55 2012
@@ -127,7 +127,6 @@ public class ExperimentDataRetriever {
}
public List<String> getExperimentIdByUser(String user){
- System.out.println("#######User ####### " + user);
List<String> result=new ArrayList<String>();
String connectionURL = Utils.getJDBCURL();
Connection connection = null;
@@ -143,7 +142,7 @@ public class ExperimentDataRetriever {
String queryString = "SELECT ed.experiment_ID FROM Experiment_Data
ed " +
"LEFT JOIN Experiment e " +
"ON ed.experiment_ID = e.experiment_ID " +
- "WHERE ed.username ='" + user + "'";
+ "WHERE ed.username REGEXP '^" + user + "$'";
rs = statement.executeQuery(queryString);
if(rs != null){
while (rs.next()) {
@@ -365,7 +364,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 ='" + user + "'";
+ "WHERE ed.username REGEXP '^" + user + "$'";
rs = statement.executeQuery(queryString);
if (rs != null){
