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(); }
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); } }
try final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); return rsds;
try final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); return rsds;
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); } }
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); } }
final ResultSetDataSet rsds = new ResultSetDataSet();
final ResultSetDataSet rsds = new ResultSetDataSet();
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; } }
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; } }