Package org.saiku.web.rest.objects.resultset

Examples of org.saiku.web.rest.objects.resultset.QueryResult

460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
      olapQueryService.qm2mdx(queryName);

      if (olapQueryService.isMdxDrillthrough(queryName, mdx)) {
        Long start = (new Date()).getTime();
        ResultSet rs = olapQueryService.drillthrough(queryName, mdx);
        QueryResult rsc = RestUtil.convert(rs);
        Long runtime = (new Date()).getTime() - start;
        rsc.setRuntime(runtime.intValue());
        return rsc;
      }
      CellDataSet cs = olapQueryService.executeMdx(queryName, mdx, icf);
      return RestUtil.convert(cs, limit);
    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ") using mdx:\n" + mdx, e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      return new QueryResult(error);
    }
  }
View Full Code Here
490
491
492
493
494
495
496
497
    try {
      return executeMdx(queryName, null, mdx, limit);
    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ") using mdx:\n" + mdx, e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      return new QueryResult(error);
    }
  }
View Full Code Here
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
  @Path("/{queryname}/explain")
  public QueryResult getExplainPlan(@PathParam("queryname") String queryName) {
    if (LOG.isDebugEnabled()) {
      LOG.debug("TRACK\t" + "\t/query/" + queryName + "/explain\tGET");
    }
    QueryResult rsc;
    ResultSet rs = null;
    try {
      Long start = (new Date()).getTime();
      rs = olapQueryService.explain(queryName);
      rsc = RestUtil.convert(rs);
      Long runtime = (new Date()).getTime() - start;
      rsc.setRuntime(runtime.intValue());

    } catch (Exception e) {
      LOG.error("Cannot get explain plan for query (" + queryName + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      rsc = new QueryResult(error);

    }
    // no need to close resultset, its an EmptyResultset
    return rsc;
View Full Code Here
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
      @QueryParam("position") String position,
      @QueryParam("returns") String returns) {
    if (LOG.isDebugEnabled()) {
      LOG.debug("TRACK\t" + "\t/query/" + queryName + "/drillthrough\tGET");
    }
    QueryResult rsc;
    ResultSet rs = null;
    try {
      Long start = (new Date()).getTime();
      if (position == null) {
        rs = olapQueryService.drillthrough(queryName, maxrows, returns);
      } else {
        String[] positions = position.split(":");
        List<Integer> cellPosition = new ArrayList<Integer>();

        for (String p : positions) {
          Integer pInt = Integer.parseInt(p);
          cellPosition.add(pInt);
        }

        rs = olapQueryService.drillthrough(queryName, cellPosition, maxrows, returns);
      }
      rsc = RestUtil.convert(rs);
      Long runtime = (new Date()).getTime() - start;
      rsc.setRuntime(runtime.intValue());

    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      rsc = new QueryResult(error);

    } finally {
      if (rs != null) {
        Statement statement = null;
        Connection con = null;
View Full Code Here
704
705
706
707
708
709
710
711
      CellDataSet cs = olapQueryService.execute(queryName, formatter);
      return RestUtil.convert(cs, limit);
    } catch (Exception e) {
      LOG.error("Cannot execute query (" + queryName + ")", e);
      String error = ExceptionUtils.getRootCauseMessage(e);
      return new QueryResult(error);
    }
  }
View Full Code Here
TOP

Related Classes of org.saiku.web.rest.objects.resultset.QueryResult

  • org.saiku.web.rest.resources.ExporterResource
  • org.saiku.web.rest.resources.Query2Resource
  • org.saiku.web.rest.resources.QueryResource
  • org.saiku.web.rest.resources.QueryResourceTest
  • org.saiku.web.rest.util.RestUtil
    • Copyright © 2018 www.massapicom. 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.