private String getViewDef (String newViewName, String viewDefQuery) { String result = null; ResultSet rs = null; Statement stmt = null; try { stmt = _session.getSQLConnection().createStatement(); rs = stmt.executeQuery(viewDefQuery); if (rs.next()) { result = rs.getString(1); int asIndex = result.toUpperCase().indexOf("AS"); if (asIndex != -1) { result = "CREATE VIEW " + newViewName + " AS " + result.substring(asIndex + 2); } } } catch (SQLException e) { s_log.error("getViewDef: unexpected exception - "+e.getMessage(), e); } finally { SQLUtilities.closeResultSet(rs); SQLUtilities.closeStatement(stmt); } return result; }
/** * This method provides unique column names. * Use a new instance of this class for * every meta data result set */ public String getColumnDef(String sColumnName, String sType, int columnSize, int decimalDigits) { sColumnName = makeColumnNameUnique(sColumnName); return SQLUtilities.createColumnDefinitionString(sColumnName, sType, columnSize, decimalDigits); }
private void _closeStatement() { try { SQLUtilities.closeStatement(_statement); } finally { _statement = null; } }
private int getRecordCount(Statement stmt, String tablename) throws SQLException { int recordCount = 0; ResultSet rs = null; try { rs = stmt.executeQuery("SELECT COUNT(*) FROM " + tablename); if (rs.next()) { recordCount = rs.getInt(1); } } finally { SQLUtilities.closeResultSet(rs); } return recordCount; }
private List<ITableInfo> getOrderedTables(final List<ITableInfo> tables) throws SQLException { if (tables.size() < 2) { // No point to ordering less than 2 tables return tables; } final SQLDatabaseMetaData md = _session.getSQLConnection().getSQLMetaData(); ProgressCallBack getOrderedTablesCallBack = progressCallBackFactory.create(customDialog, i18n.PROGRESS_DIALOG_ANALYZE_TITLE, tables.size()); getOrderedTablesCallBack.setLoadingPrefix(i18n.LOADING_PREFIX); // Now, get the drop order (same as delete) and update the dialog // status while doing so. final List<ITableInfo> result = SQLUtilities.getDeletionOrder(tables, md, getOrderedTablesCallBack); getOrderedTablesCallBack.setVisible(false); getOrderedTablesCallBack.dispose(); getOrderedTablesCallBack = null; return result; }
private void _closeStatement() { try { SQLUtilities.closeStatement(_statement); } finally { _statement = null; } }
SQLUtilities.closeResultSet(rs, true);
try orderedTables = SQLUtilities.getDeletionOrder(_tables, md, _cb);
public static String getHelpTextForObject(String objectName, Connection c) throws java.sql.SQLException { StringBuilder buf = new StringBuilder(); CallableStatement stmt = null; ResultSet helpText = null; try { stmt = c.prepareCall("{ call sp_helptext (?) }"); stmt.setString(1, objectName); helpText = stmt.executeQuery(); while (helpText.next()) { buf.append(helpText.getString(1)); } } catch (Exception e) { s_log.error("getHelpTextForObject: Unexpected exception - " + e.getMessage(), e); } finally { closeResultSet(helpText); closeStatement(stmt); } return buf.toString(); }
private void executeDdl() { if (listTargetColumns.getModel().getSize() < 1) { JOptionPane.showMessageDialog(this, i18n.ERROR_NO_TARGET_COLUMNS_SELECTED); listSourceColumns.requestFocusInWindow(); } if (tfName.getText().trim().length() == 0) { JOptionPane.showMessageDialog(this, i18n.ERROR_NO_INDEX_KEY_NAME); tfName.requestFocusInWindow(); } else { if (JOptionPane.showConfirmDialog(this, i18n.QUESTION_EXECUTE_DDL, "?", JOptionPane.YES_NO_OPTION) == JOptionPane.YES_OPTION) { Statement stmt = null; try { stmt = session.getSQLConnection().createStatement(); stmt.executeUpdate(taDdl.getText()); JOptionPane.showMessageDialog(this, i18n.INFO_SUCCESS_EXECUTE); } catch (SQLException e) { JOptionPane.showMessageDialog(this, i18n.ERROR_EXECUTE_DDL); log.error(e.getLocalizedMessage()); } finally { SQLUtilities.closeStatement(stmt); } } } }
SQLUtilities.closeResultSet(rs, true);
try orderedTables = SQLUtilities.getDeletionOrder(_tables, md, _cb);
columnDefinitionString = SQLUtilities.createColumnDefinitionString(columnName, typeName, colInfo.getColumnSize(), colInfo.getDecimalDigits());
private List<String> executeStringQuery(String sql) { ArrayList<String> result = new ArrayList<String>(); Statement stmt = null; ResultSet rs = null; try { stmt = _session.getSQLConnection().createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { String value = rs.getString(1); if (!rs.wasNull()) result.add(value); } } catch (SQLException e) { s_log.error("executeStringQuery: unexpected exception while executing query ( " + sql + " ): " + e.getMessage(), e); } finally { SQLUtilities.closeResultSet(rs); SQLUtilities.closeStatement(stmt); } return result; }
return false; } finally { SQLUtilities.closeStatement(stmt); return false; } finally { SQLUtilities.closeStatement(stmt);
public void load(ISession session, PreparedStatement stmt) { getTextArea().setText(""); ResultSet rs = null; try { rs = stmt.executeQuery(); StringBuffer buf = new StringBuffer(4096); while (rs.next()) { buf.append(rs.getString(1)); } getTextArea().setText(buf.toString()); getTextArea().setCaretPosition(0); } catch (SQLException ex) { session.showErrorMessage(ex); } finally { SQLUtilities.closeResultSet(rs); } }
SQLUtilities.closeResultSet(rs); SQLUtilities.closeStatement(stmt);
private void btCreateTableActionPerformed(java.awt.event.ActionEvent evt) { ISQLConnection con = _session.getSQLConnection(); String query = getQuery(); Statement stmt = null; try { stmt = con.createStatement(); stmt.execute(query); _session.getSessionInternalFrame().getObjectTreeAPI().refreshTree(); jd.setVisible(false); jd.dispose(); JOptionPane.showMessageDialog(null, // i18n[mysql.msgTableCreated=Table {0} created] s_stringMgr.getString("mysql.msgTableCreated", tfTableName.getText())); } catch (SQLException ex) { _session.showErrorMessage(ex); } finally { SQLUtilities.closeStatement(stmt); } }
public void load(ISession session, PreparedStatement stmt) { getTextArea().setText(""); ResultSet rs = null; try { rs = stmt.executeQuery(); StringBuffer buf = new StringBuffer(4096); while (rs.next()) { buf.append(rs.getString(1)); } getTextArea().setText(buf.toString()); getTextArea().setCaretPosition(0); } catch (SQLException ex) { session.showErrorMessage(ex); } finally { SQLUtilities.closeResultSet(rs); } }
SQLUtilities.closeResultSet(rs); SQLUtilities.closeStatement(pstmt);