protected IDataSet createDataSetFromResultSet(ResultSet rs) throws DataSetException { final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, DialectType.MYSQL); if (!_firstRowOnly) { return rsds; } final int columnCount = rsds.getColumnCount(); final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions(); final Map<String, Object> data = new HashMap<String, Object>(); if (rsds.next(null)) { for (int i = 0; i < columnCount; ++i) { data.put(colDefs[i].getColumnName(), rsds.get(i)); } } return new MapDataSet(data); } }
public void sqlExecutionCancelled() { if (rsds != null) { rsds.cancelProcessing(); } // i18n[SQLResultExecuterPanel.canceleRequested=Query execution cancel requested by user.] // String canc = // s_stringMgr.getString("SQLResultExecuterPanel.canceleRequested"); // getSession().getMessageHandler().showMessage(canc); }
private void onCloseStatementAndResultSet() { _rsds.closeStatementAndResultSet(); }
public void init(ResultSetDataSet rsds) { if(false == _overviewHolder.isEmpty()) { return; } List<Object[]> rows = rsds.getAllDataForReadOnly(); DataSetDefinition dataSetDefinition = rsds.getDataSetDefinition(); ColumnDisplayDefinition[] columnDefinitions = dataSetDefinition.getColumnDefinitions(); initScales(rows, columnDefinitions, false); }
/** * Create the <TT>IDataSet</TT> to be displayed in this tab. */ protected IDataSet createDataSet() throws DataSetException { final ISQLConnection conn = getSession().getSQLConnection(); final SQLDatabaseMetaData dmd = conn.getSQLMetaData(); ITableInfo ti = getTableInfo(); if (! "TABLE".equalsIgnoreCase(ti.getType())) { // Frontbase describes it's tables as "BASE TABLE". if (!DialectFactory.isFrontBase(dmd)) { return null; } } ResultSetDataSet rsds = dmd.getIndexInfo(getTableInfo(), indexIndices, true); rsds.next(null); String indexName = (String)rsds.get(1); if (indexName == null) { rsds.removeRow(0); } rsds.resetCursor(); return rsds; }
final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setContentsTabResultSet(rs, _dataSetUpdateableTableModel.getFullTableName(), DialectFactory.getDialectType(md)); rsds.getDataSetDefinition().getColumnDefinitions(); _dataSetUpdateableTableModel.setRowIDCol(rsds.getColumnCount() - 1);
try final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); return rsds;
public void sqlResultSetAvailable(ResultSetWrapper rs, SQLExecutionInfo info, IDataSetUpdateableTableModel model) throws DataSetException { // i18n[SQLResultExecuterPanel.outputStatus=Building output...] String outputStatus = s_stringMgr.getString("SQLResultExecuterPanel.outputStatus"); _cancelPanelCtrl.setStatusLabel(outputStatus); rsds = new ResultSetDataSet(); try { SessionProperties props = _session.getProperties(); ResultSetMetaDataDataSet rsmdds = null; if (props.getShowResultsMetaData()) { rsmdds = new ResultSetMetaDataDataSet(rs.getResultSet()); } DialectType dialectType = DialectFactory.getDialectType(_session.getMetaData()); // rsds.setContentsTabResultSet() reads the result set. So results processing on the DB is over // and this time is measured. None is interested in the time that it takes us to render Swing tables ... info.resultsProcessingComplete(rsds.setSqlExecutionTabResultSet(rs, null, dialectType)); _executionHandlerListener.addResultsTab(info, rsds, rsmdds, model, _resultTabToReplace); }finally{ /* * Make sure, that in any case, even when a exception occurs, the rsds is set to null, so that * the GC can clean them. */ rsds = null; } }
private void onMoreResultsHaveBeenRead() { try { TableState resultSortableTableState = getTableState(_dataSetViewerFindDecorator.getDataSetViewer()); _dataSetViewerFindDecorator.getDataSetViewer().show(_rsds, null); restoreTableState(resultSortableTableState, _dataSetViewerFindDecorator.getDataSetViewer()); _dataSetViewerFindDecorator.resetFind(); _currentSqlLblCtrl.reInit(_rsds.currentRowCount(), _rsds.areAllPossibleResultsOfSQLRead()); _queryInfoPanel.displayRowCount(_rsds.currentRowCount()); reInitOverview(); } catch (DataSetException e) { throw new RuntimeException(e); } }
protected void refreshComponent() { if (!_haveSession) { try { _conn = this.getSession().getSQLConnection().getConnection(); _whoStmt = _conn.prepareCall("{ call sp_who }"); _whoDataSet = new ResultSetDataSet(); _perfStmt = _conn.prepareStatement("SELECT * FROM master.dbo.sysperfinfo"); _perfDataSet = new ResultSetDataSet(); _monitorStmt = _conn.prepareCall("{ call sp_monitor }"); _haveSession = true; } catch (java.sql.SQLException ex) { s_log.error("Unexpected exception: "+ex.getMessage(), ex); } } refreshData(); }
private void refreshData() { ResultSet rs; try { _refreshDate = new Date(); rs = _whoStmt.executeQuery(); _whoDataSet.setResultSet(rs, DialectType.MSSQL); _whoViewer.show(_whoDataSet); rs = _perfStmt.executeQuery(); _perfDataSet.setResultSet(rs, DialectType.MSSQL); _perfViewer.show(_perfDataSet); } catch (java.sql.SQLException ex) { s_log.error("Unexpected exception: "+ex.getMessage(), ex); } catch (DataSetException dse) { s_log.error("Unexpected exception: "+dse.getMessage(), dse); } }
/** * Create the <TT>IDataSet</TT> to be displayed in this tab. */ protected IDataSet createDataSet() throws DataSetException { final ISQLConnection conn = getSession().getSQLConnection(); final SQLDatabaseMetaData dmd = conn.getSQLMetaData(); ITableInfo ti = getTableInfo(); if (! "TABLE".equalsIgnoreCase(ti.getType())) { // Frontbase describes it's tables as "BASE TABLE". if (!DialectFactory.isFrontBase(dmd)) { return null; } } ResultSetDataSet rsds = dmd.getIndexInfo(getTableInfo(), indexIndices, true); rsds.next(null); String indexName = (String)rsds.get(1); if (indexName == null) { rsds.removeRow(0); } rsds.resetCursor(); return rsds; }
final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setContentsTabResultSet(rs, _dataSetUpdateableTableModel.getFullTableName(), DialectFactory.getDialectType(md)); rsds.getDataSetDefinition().getColumnDefinitions(); _dataSetUpdateableTableModel.setRowIDCol(rsds.getColumnCount() - 1);
try final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); return rsds;
public void sqlResultSetAvailable(ResultSetWrapper rs, SQLExecutionInfo info, IDataSetUpdateableTableModel model) throws DataSetException { // i18n[SQLResultExecuterPanel.outputStatus=Building output...] String outputStatus = s_stringMgr.getString("SQLResultExecuterPanel.outputStatus"); _cancelPanelCtrl.setStatusLabel(outputStatus); rsds = new ResultSetDataSet(); try { SessionProperties props = _session.getProperties(); ResultSetMetaDataDataSet rsmdds = null; if (props.getShowResultsMetaData()) { rsmdds = new ResultSetMetaDataDataSet(rs.getResultSet()); } DialectType dialectType = DialectFactory.getDialectType(_session.getMetaData()); // rsds.setContentsTabResultSet() reads the result set. So results processing on the DB is over // and this time is measured. None is interested in the time that it takes us to render Swing tables ... info.resultsProcessingComplete(rsds.setSqlExecutionTabResultSet(rs, null, dialectType)); _executionHandlerListener.addResultsTab(info, rsds, rsmdds, model, _resultTabToReplace); }finally{ /* * Make sure, that in any case, even when a exception occurs, the rsds is set to null, so that * the GC can clean them. */ rsds = null; } }
private void onMoreResultsHaveBeenRead() { try { TableState resultSortableTableState = getTableState(_dataSetViewerFindDecorator.getDataSetViewer()); _dataSetViewerFindDecorator.getDataSetViewer().show(_rsds, null); restoreTableState(resultSortableTableState, _dataSetViewerFindDecorator.getDataSetViewer()); _dataSetViewerFindDecorator.resetFind(); _currentSqlLblCtrl.reInit(_rsds.currentRowCount(), _rsds.areAllPossibleResultsOfSQLRead()); _queryInfoPanel.displayRowCount(_rsds.currentRowCount()); reInitOverview(); } catch (DataSetException e) { throw new RuntimeException(e); } }
public void init(ResultSetDataSet rsds) { if(false == _overviewHolder.isEmpty()) { return; } List<Object[]> rows = rsds.getAllDataForReadOnly(); DataSetDefinition dataSetDefinition = rsds.getDataSetDefinition(); ColumnDisplayDefinition[] columnDefinitions = dataSetDefinition.getColumnDefinitions(); initScales(rows, columnDefinitions, false); }
protected IDataSet createDataSetFromResultSet(ResultSet rs) throws DataSetException { final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); if (!_firstRowOnly) { return rsds; } final int columnCount = rsds.getColumnCount(); final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions(); final Map<String, Object> data = new HashMap<String, Object>(); if (rsds.next(null)) { for (int i = 0; i < columnCount; ++i) { data.put(colDefs[i].getColumnName(), rsds.get(i)); } } return new MapDataSet(data); } }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.IResultTab#showResults(net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet, net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet, net.sourceforge.squirrel_sql.client.session.SQLExecutionInfo) */ public void showResults(ResultSetDataSet rsds, ResultSetMetaDataDataSet mdds, SQLExecutionInfo exInfo) throws DataSetException { _exInfo = exInfo; _sql = StringUtilities.cleanString(exInfo.getSQL()); _rsds = rsds; // Display the result set. _dataSetViewerFindDecorator.getDataSetViewer().show(rsds, null); initContinueReadChannel(_dataSetViewerFindDecorator); final int rowCount = _rsds.currentRowCount(); _currentSqlLblCtrl.setSql(_sql); _currentSqlLblCtrl.reInit(_rsds.currentRowCount(), _rsds.areAllPossibleResultsOfSQLRead()); // Display the result set metadata. if (mdds != null && _metaDataOutput != null) { _metaDataOutput.show(mdds, null); // Why null?? } _queryInfoPanel.load(rowCount, _exInfo); }