Package it.eng.spago.dbaccess.sql.result

Examples of it.eng.spago.dbaccess.sql.result.ScrollableDataResult

344
345
346
347
348
349
350
351
352
353
354
355
356
        Connection conn = dsUtil.getConnection(requestContainer,datasource);
        dataConnection = dsUtil.getDataConnection(conn);

        sqlCommand = dataConnection.createSelectCommand(statement);
        dataResult = sqlCommand.execute();
        ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult
            .getDataObject();
        result = scrollableDataResult.getSourceBean();
      } finally {
        Utils.releaseResources(dataConnection, sqlCommand, dataResult);
      }
      return result;
    }
View Full Code Here
584
585
586
587
588
589
590
591
592
593
594
595
      DataSourceUtilities dsUtil = new DataSourceUtilities();
      Connection conn = dsUtil.getConnection(profile,dataSource);
      dataConnection = dsUtil.getDataConnection(conn);
      sqlCommand = dataConnection.createSelectCommand(statement, false);
      dataResult = sqlCommand.execute();
      ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult.getDataObject();
      SourceBean result = scrollableDataResult.getSourceBean();
      resStr = result.toXML(false);
      resStr = resStr.trim();
      if(resStr.startsWith("<?")) {
        resStr = resStr.substring(2);
        int indFirstTag = resStr.indexOf("<");
View Full Code Here
625
626
627
628
629
630
631
632
633
634
635
636
      DataSourceUtilities dsUtil = new DataSourceUtilities();
      Connection conn = dsUtil.getConnection(profile,dataSource);
      dataConnection = dsUtil.getDataConnection(conn);
      sqlCommand = dataConnection.createSelectCommand(statement, false);
      dataResult = sqlCommand.execute();
      ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult.getDataObject();
      result = scrollableDataResult.getSourceBean();
    } finally {
      Utils.releaseResources(dataConnection, sqlCommand, dataResult);
    }

    // START converting the SourceBean into a string and then into SourceBean again:
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
      Connection conn = dsUtil.getConnection(requestContainer,datasource);
      dataConnection = dsUtil.getDataConnection(conn);

      sqlCommand = dataConnection.createSelectCommand(statement, false);
      dataResult = sqlCommand.execute();
      ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult
          .getDataObject();
      List temp = Arrays.asList(scrollableDataResult.getColumnNames());
      columnsNames.addAll(temp);
      result = scrollableDataResult.getSourceBean();
    } finally {
      Utils.releaseResources(dataConnection, sqlCommand, dataResult);
    }
    return result;
  }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
      logger.debug("IN");
      DataStore dataStore;
      DataStoreMetaData dataStoreMeta;
      FieldMetadata fieldMeta;
     
      ScrollableDataResult scrollableDataResult;
      List columnsNames;
      SourceBean resultSB;
     
     
      try {
     
        scrollableDataResult = (ScrollableDataResult)data;
       
        dataStore = new DataStore();
        dataStoreMeta = new DataStoreMetaData();
       
        logger.debug("Reading dataStore metadata ...");
        columnsNames = Arrays.asList(scrollableDataResult.getColumnNames());
        for(int i = 0; i < columnsNames.size(); i++) {
          fieldMeta = new FieldMetadata();
          fieldMeta.setName( (String)columnsNames.get(i) );
          dataStoreMeta.addFiedMeta(fieldMeta);
          logger.debug("Field [" + (i+1) + "] name is equak to [" + fieldMeta.getName() + "]");
        }     
      dataStore.setMetaData(dataStoreMeta);
      logger.debug("dataStore metadata read succefully");
     
      try {
        resultSB = scrollableDataResult.getSourceBean();
      } catch(Throwable t ) {
        throw new RuntimeException("Impossible to extract xml data", t);
      } 
      if( resultSB != null) {
        List rows;
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
    // get CHECKED_QUERY statment
    String statement = getQueryStatement("CHECKED_QUERY", parameters);

    // exec CHECKED_QUERY
    ScrollableDataResult scrollableDataResult = null;
    SQLCommand sqlCommand = null;
    DataConnection dataConnection = null;
    DataResult dataResult = null;
    String pool = null;
    try {
      pool = (String) config.getAttribute("POOL");
      dataConnection = DataConnectionManager.getInstance().getConnection(
          pool);
      sqlCommand = dataConnection.createSelectCommand(statement);
      dataResult = sqlCommand.execute();
      scrollableDataResult = (ScrollableDataResult) dataResult
          .getDataObject();
      SourceBean chekedObjectsBean = scrollableDataResult.getSourceBean();
      List checkedObjectsList = chekedObjectsBean
          .getAttributeAsList("ROW");

      String tmpElements = (request.getAttribute("checkedElements")==null)?"":(String)request.getAttribute("checkedElements");
        String[] arrElements = tmpElements.split(",");
View Full Code Here
835
836
837
838
839
840
841
842
843
844
845
846
847
    try {
      dataConnectionManager = DataConnectionManager.getInstance();
      dataConnection = dataConnectionManager.getConnection(pool);
      sqlCommand = dataConnection.createSelectCommand(statement);
      dataResult = sqlCommand.execute();
      ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult
          .getDataObject();
      result = scrollableDataResult.getSourceBean();
    } catch (Exception ex) {
      TracerSingleton.log(Constants.NOME_MODULO,
          TracerSingleton.CRITICAL, "executeSelect:", ex);
    } finally {
      Utils.releaseResources(dataConnection, sqlCommand, dataResult);
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
    Session aSession = null;
    Transaction tx = null;
   
    // exec CHECKED_QUERY
    ScrollableDataResult scrollableDataResult = null;
    SQLCommand sqlCommand = null;
    DataConnection dataConnection = null;
    DataResult dataResult = null;
    try {
      aSession = HibernateUtil.currentSession();
      tx = aSession.beginTransaction();
      Connection jdbcConnection = aSession.connection();
      dataConnection = DelegatedHibernateConnectionListService.getDataConnection(jdbcConnection);
          sqlCommand = dataConnection.createSelectCommand(statement);
          dataResult = sqlCommand.execute();
          scrollableDataResult = (ScrollableDataResult) dataResult.getDataObject();
      SourceBean chekedObjectsBean = scrollableDataResult.getSourceBean();
      List checkedObjectsList = chekedObjectsBean
          .getAttributeAsList("ROW");
      for (int i = 0; i < checkedObjectsList.size(); i++) {
        SourceBean objects = (SourceBean) checkedObjectsList.get(i);
        String key = getObjectKey(objects);
View Full Code Here
266
267
268
269
270
271
272
273
274
275
276
277
278
            if ((inputParameters != null) && (inputParameters.size() != 0)) {
                dataResult = sqlCommand.execute(inputParameters);
            } else
                dataResult = sqlCommand.execute();
            if (type.equalsIgnoreCase("SELECT")) {
                ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult
                        .getDataObject();
                result = scrollableDataResult.getSourceBean();
            } // if (type.equalsIgnoreCase("SELECT"))
            else {
                InformationDataResult informationDataResult = (InformationDataResult) dataResult
                        .getDataObject();
                result = new Boolean(informationDataResult.getAffectedRows() > 0);
View Full Code Here
904
905
906
907
908
909
910
911
912
913
914
915
      DataSourceUtilities dsUtil = new DataSourceUtilities();
      Connection conn = dsUtil.getConnection(requestContainer,datasource);
      dataConnection = dsUtil.getDataConnection(conn);
      sqlCommand = dataConnection.createSelectCommand(statement);
      dataResult = sqlCommand.execute();
      ScrollableDataResult scrollableDataResult = (ScrollableDataResult) dataResult.getDataObject();
      result = scrollableDataResult.getSourceBean();
  } finally {
      Utils.releaseResources(dataConnection, sqlCommand, dataResult);
      logger.debug("OUT");
  }
  return result;
View Full Code Here
TOP

Related Classes of it.eng.spago.dbaccess.sql.result.ScrollableDataResult

  • it.eng.spagobi.analiticalmodel.execution.service.SelectParametersLookupModule
  • it.eng.spagobi.behaviouralmodel.lov.bo.QueryDetail
  • it.eng.spagobi.behaviouralmodel.lov.service.ListTestLovModule
  • it.eng.spagobi.commons.services.AbstractBasicCheckListModule
  • it.eng.spagobi.commons.services.AbstractHibernateConnectionCheckListModule
  • it.eng.spagobi.commons.services.DelegatedBasicListService
  • it.eng.spagobi.commons.services.DelegatedQueryExecutor
  • it.eng.spagobi.tools.dataset.common.datareader.JDBCDataReader
  • it.eng.spagobi.tools.scheduler.services.LovLookupAjaxModule
    • 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.