Examples of QueryServiceException

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

350
351
352
353
354
355
356
357
358
359
360
                bucket.addTerm(term);
                termBuckets.put(bucketName, bucket);
      }
      return new Vector<TermBucket>(termBuckets.values());
    }catch (Exception e) {
      throw new QueryServiceException("Failed to get term buckets for transaction id '" + transactionId + "' : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

395
396
397
398
399
400
401
402
403
404
405
      List<IngestReceipt> receipts = new Vector<IngestReceipt>();
      while (rs.next())
        receipts.add(new IngestReceipt(this.getTransactionIdFactory().createTransactionId(rs.getString("transaction_id")), DateUtils.toCalendar(rs.getString("transaction_date"), DateUtils.FormatType.LOCAL_FORMAT).getTime()));
      return receipts;
    }catch (Exception e) {
      throw new QueryServiceException("Failed to query Workflow Instances Database : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

427
428
429
430
431
432
433
434
435
436
437
      while (startIndex > index && rs.next()) index++;
      while (rs.next() && index++ <= endIndex)
        receipts.add(new IngestReceipt(this.getTransactionIdFactory().createTransactionId(rs.getString("transaction_id")), DateUtils.toCalendar(rs.getString("transaction_date"), DateUtils.FormatType.LOCAL_FORMAT).getTime()));
      return receipts;
    }catch (Exception e) {
      throw new QueryServiceException("Failed to query Workflow Instances Database : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

459
460
461
462
463
464
465
466
467
468
469
            while (rs.next())
              numTransactions = rs.getInt("numTransactions");
           
      return numTransactions;
    }catch (Exception e) {
      throw new QueryServiceException("Failed to get size of query : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
            } else if (cqe.getOperator().equals(ComparisonQueryExpression.Operator.LESS_THAN)) {
              operator = "<";
            } else if (cqe.getOperator().equals(ComparisonQueryExpression.Operator.LESS_THAN_EQUAL_TO)) {
              operator = "<=";
            } else {
                throw new QueryServiceException("Invalid ComparisonQueryExpression Operator '" + cqe.getOperator() + "'");
            }
           
            sqlQuery = "SELECT DISTINCT transaction_id FROM transaction_terms WHERE " + bucketNameFilter + " term_name = '" + cqe.getTerm().getName() + "' AND (";
          for (int i = 0; i < cqe.getTerm().getValues().size(); i++) {
            String value = cqe.getTerm().getValues().get(i);
                sqlQuery += "term_value " + operator + " '" + (this.useUTF8 ? URLEncoder.encode(value, "UTF-8") : value) + "'";
              if ((i + 1) < cqe.getTerm().getValues().size())
                sqlQuery += " OR ";
          }
          sqlQuery += ")";
        }else if (queryExpression instanceof NotQueryExpression) {
          NotQueryExpression nqe = (NotQueryExpression) queryExpression;
            sqlQuery = "SELECT DISTINCT transaction_id FROM transaction_terms WHERE " + bucketNameFilter + " NOT (" + this.getSqlQuery(nqe.getQueryExpression()) + ")";
        }else if (queryExpression instanceof StdQueryExpression) {
            sqlQuery = "SELECT DISTINCT transaction_id FROM transaction_terms " + bucketNameFilter;
        }else {
            throw new QueryServiceException("Invalid QueryExpression '" + queryExpression.getClass().getCanonicalName() + "'");
        }
        return sqlQuery;
    }
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

134
135
136
137
138
139
140
141
142
143
144
                String value = URLDecoder.decode(rs.getString("workflow_met_val"), "UTF-8");
                tb.addTerm(new Term(key, Collections.singletonList(value)));
            }
      return Collections.singletonList(tb);
    }catch (Exception e) {
      throw new QueryServiceException("Failed to get Workflow Instance Metadata for workflow id '" + transactionId + "' : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

173
174
175
176
177
178
179
180
181
182
183
      List<IngestReceipt> receipts = new Vector<IngestReceipt>();
      while (rs.next())
                receipts.add(new IngestReceipt(new LongTransactionIdFactory().createTransactionId(rs.getString("workflow_instance_id")), DateConvert.isoParse(rs.getString("start_date_time"))));
      return receipts;
    }catch (Exception e) {
      throw new QueryServiceException("Failed to query Workflow Instances Database : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

205
206
207
208
209
210
211
212
213
214
215
      while (startIndex > index && rs.next()) index++;
      while (rs.next() && index++ <= endIndex)
        receipts.add(new IngestReceipt(new LongTransactionIdFactory().createTransactionId(rs.getString("workflow_instance_id")), DateConvert.isoParse(rs.getString("start_date_time"))));
      return receipts;
    }catch (Exception e) {
      throw new QueryServiceException("Failed to query Workflow Instances Database : " + e.getMessage(), e);
    }finally {
      try {
        conn.close();
      }catch(Exception e) {}
      try {
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

237
238
239
240
241
242
243
244
245
246
247
      while (rs.next())
        numInstances = rs.getInt("numInstances");

      return numInstances;
    } catch (Exception e) {
      throw new QueryServiceException(
          "Failed to get size of query in Workflow Instances Database : "
              + e.getMessage(), e);
    } finally {
      try {
        conn.close();
View Full Code Here

Examples of org.apache.oodt.cas.catalog.exception.QueryServiceException

279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
            } else if (cqe.getOperator().equals(ComparisonQueryExpression.Operator.LESS_THAN)) {
              operator = "<";
            } else if (cqe.getOperator().equals(ComparisonQueryExpression.Operator.LESS_THAN_EQUAL_TO)) {
              operator = "<=";
            } else {
                throw new QueryServiceException("Invalid ComparisonQueryExpression Operator '" + cqe.getOperator() + "'");
            }
           
            sqlQuery = "SELECT DISTINCT workflow_instance_id FROM workflow_instance_metadata WHERE workflow_met_key = '" + cqe.getTerm().getName() + "' AND (";
          for (int i = 0; i < cqe.getTerm().getValues().size(); i++) {
            String value = cqe.getTerm().getValues().get(i);
                sqlQuery += "workflow_met_val " + operator + " '" + URLEncoder.encode(value, "UTF-8") + "'";
              if ((i + 1) < cqe.getTerm().getValues().size())
                sqlQuery += "OR";
          }
          sqlQuery += ")";
        }else if (queryExpression instanceof NotQueryExpression) {
          NotQueryExpression nqe = (NotQueryExpression) queryExpression;
            sqlQuery = "SELECT DISTINCT workflow_instance_id FROM workflow_instance_metadata WHERE NOT (" + this.getSqlQuery(nqe.getQueryExpression()) + ")";
        }else if (queryExpression instanceof StdQueryExpression) {
            sqlQuery = "SELECT DISTINCT workflow_instance_id FROM workflow_instance_metadata";
        }else {
            throw new QueryServiceException("Invalid QueryExpression '" + queryExpression.getClass().getCanonicalName() + "'");
        }
        return sqlQuery;
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.