svn commit: r1601437 - /manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java

[kwright]

Author: kwright
Date: Mon Jun  9 16:42:27 2014
New Revision: 1601437

URL: http://svn.apache.org/r1601437
Log:
Fix a broken query

Modified:
    
manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java

Modified: 
manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java
URL: 
http://svn.apache.org/viewvc/manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java?rev=1601437&r1=1601436&r2=1601437&view=diff
==============================================================================
--- 
manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java
 (original)
+++ 
manifoldcf/branches/CONNECTORS-946/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/Jobs.java
 Mon Jun  9 16:42:27 2014
@@ -569,7 +569,7 @@ public class Jobs extends org.apache.man
     List<String> transformationConnectionNames)
   {
     query.append("SELECT ").append(idField).append(",").append(statusField)
-      .append(" FROM ").append(getTableName()).append(" t1 WHERE(");
+      .append(" FROM ").append(getTableName()).append(" t1 WHERE EXISTS(");
     
pipelineManager.buildQueryClause(query,params,"t1."+idField,transformationConnectionNames);
     query.append(")");
   }