public void close() { _dataSet.close(); _dataSet = null; _columnTypeTransformers = null; }
public void close() { _dataSet.close(); }
public void close() { _dataSet.close(); }
public void close() { if (_currentDataSet != null) { _log.debug("currentDataSet.close() and System.gc()"); _currentDataSet.close(); System.gc(); } _currentDataSet = null; _dataContext = null; _queryIterator = null; }
public void close() { if (_currentDataSet != null) { _log.debug("currentDataSet.close() and System.gc()"); _currentDataSet.close(); System.gc(); } _currentDataSet = null; _dataContext = null; _queryIterator = null; }
private void materialize() { if (_dataSet != null) { while (_dataSet.next()) { _materializedRows.add(_dataSet.getRow()); } _dataSet.close(); _dataSet = null; } }
/** * Converts the DataSet into a list of object arrays */ public List<Object[]> toObjectArrays() { List<Object[]> objects = new ArrayList<Object[]>(); while (next()) { Row row = getRow(); objects.add(row.getValues()); } close(); return objects; }
public boolean next() { boolean result; if (_currentDataSet == null) { result = false; } else { result = _currentDataSet.next(); } if (!result && _queryIterator.hasNext()) { if (_currentDataSet != null) { _log.debug("currentDataSet.close() and System.gc()"); _currentDataSet.close(); System.gc(); } Query q = _queryIterator.next(); _currentDataSet = _dataContext.executeQuery(q); if (_log.isDebugEnabled()) { _queryIndex++; _log.debug("Executing query #" + _queryIndex); } result = next(); } return result; } }
public boolean next() { boolean result; if (_currentDataSet == null) { result = false; } else { result = _currentDataSet.next(); } if (!result && _queryIterator.hasNext()) { if (_currentDataSet != null) { _log.debug("currentDataSet.close() and System.gc()"); _currentDataSet.close(); System.gc(); } Query q = _queryIterator.next(); _currentDataSet = _dataContext.executeQuery(q); if (_log.isDebugEnabled()) { _queryIndex++; _log.debug("Executing query #" + _queryIndex); } result = next(); } return result; } }
public static DataSet getFiltered(DataSet dataSet, FilterItem... filterItems) { List<Object[]> data = new ArrayList<Object[]>(); while (dataSet.next()) { Row row = dataSet.getRow(); boolean valid = true; for (FilterItem havingItem : filterItems) { if (!havingItem.evaluate(row)) { valid = false; break; } } if (valid) { data.add(row.getValues()); } } dataSet.close(); return new DataSet(dataSet.getSelectItems(), data); }
dataSet.close();
dataSet.close(); List<Object[]> resultData = new ArrayList<Object[]>();
public static DataSet getSelection(SelectItem[] selectItems, DataSet dataSet) { SelectItem[] dataSetSelectItems = dataSet.getSelectItems(); if (!ArrayUtils.isEquals(dataSetSelectItems, selectItems)) { List<Object[]> resultData = new ArrayList<Object[]>(); while (dataSet.next()) { Row row = dataSet.getRow(); Object[] resultRow = new Object[selectItems.length]; for (int i = 0; i < selectItems.length; i++) { SelectItem selectItem = selectItems[i]; if (selectItem.getSubQuerySelectItem() != null) { resultRow[i] = row.getValue(selectItem .getSubQuerySelectItem()); } else { resultRow[i] = row.getValue(selectItem); } } resultData.add(resultRow); } dataSet.close(); dataSet = new DataSet(selectItems, resultData); } return dataSet; }
/** * Executes a single row query, like "SELECT COUNT(*), MAX(SOME_COLUMN) FROM * MY_TABLE" or similar. * * @param dataContext * @param query * @return * @throws MetaModelException * if less or more than one Row is returned from the query */ public static Row executeSingleRowQuery(DataContext dataContext, Query query) throws MetaModelException { DataSet dataSet = dataContext.executeQuery(query); boolean next = dataSet.next(); if (!next) { throw new MetaModelException("No rows returned from query: " + query); } Row row = dataSet.getRow(); next = dataSet.next(); if (next) { throw new MetaModelException( "More than one row returned from query: " + query); } dataSet.close(); return row; }