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); } }
/** * @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); }
/** * @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); }
dest.show(conn.getSQLMetaData().getMetaDataSet()); files.add(tempFile); titles.add("Metadata"); dest.show(new ObjectArrayDataSet(md.getCatalogs())); files.add(tempFile); titles.add("Catalogs"); dest.show(new ObjectArrayDataSet(_session.getSchemaInfo().getSchemas())); files.add(tempFile); titles.add("Schemas"); dest.show(conn.getSQLMetaData().getTypesDataSet()); files.add(tempFile); titles.add("Data Types"); dest.show(new ObjectArrayDataSet(md.getTableTypes())); files.add(tempFile); titles.add("Table Types");
dest.show(conn.getSQLMetaData().getMetaDataSet()); files.add(tempFile); titles.add("Metadata"); dest.show(new ObjectArrayDataSet(md.getCatalogs())); files.add(tempFile); titles.add("Catalogs"); dest.show(new ObjectArrayDataSet(_session.getSchemaInfo().getSchemas())); files.add(tempFile); titles.add("Schemas"); dest.show(conn.getSQLMetaData().getTypesDataSet()); files.add(tempFile); titles.add("Data Types"); dest.show(new ObjectArrayDataSet(md.getTableTypes())); files.add(tempFile); titles.add("Table Types");
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); } }
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); } }
dest.show(new HashtableDataSet(System.getProperties())); files.add(tempFile);
dest.show(new HashtableDataSet(System.getProperties())); files.add(tempFile);