private void _closeStatement() { try { SQLUtilities.closeStatement(_statement); } finally { _statement = null; } }
private void _closeStatement() { try { SQLUtilities.closeStatement(_statement); } finally { _statement = null; } }
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; }
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; }
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); } } } }
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(); }
SQLUtilities.closeStatement(stmt);
return false; } finally { SQLUtilities.closeStatement(stmt); return false; } finally { SQLUtilities.closeStatement(stmt);
SQLUtilities.closeStatement(pstmt);
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); } }
SQLUtilities.closeStatement(pstmt);
} finally { SQLUtilities.closeResultSet(res); SQLUtilities.closeStatement(stat);
@Override public void run() { while (!isStopped) { Statement stmt = null; try { stmt = sqlConn.createStatement(); if (s_log.isInfoEnabled()) { s_log.info("SessionConnectionKeepAlive ("+aliasName+") running SQL: "+sql); } stmt.executeQuery(sql); } catch (Throwable t) { s_log.error("run: unexpected exception while executing sql (" + sql + "): " + t.getMessage(), t); } finally { SQLUtilities.closeStatement(stmt); } // Always sleep at the end of the loop. In case we are stopped, we want to know that // immediately before executing the sql statement. Utilities.sleep(sleepMillis); } }
@Override public void run() { while (!isStopped) { Statement stmt = null; try { stmt = sqlConn.createStatement(); if (s_log.isInfoEnabled()) { s_log.info("SessionConnectionKeepAlive ("+aliasName+") running SQL: "+sql); } stmt.executeQuery(sql); } catch (Throwable t) { s_log.error("run: unexpected exception while executing sql (" + sql + "): " + t.getMessage(), t); } finally { SQLUtilities.closeStatement(stmt); } // Always sleep at the end of the loop. In case we are stopped, we want to know that // immediately before executing the sql statement. Utilities.sleep(sleepMillis); } }
private void getRecordCounts() { Statement stmt = null; try { stmt = session.getSQLConnection().createStatement(); for (int i = 0; i < tblResult.getRowCount() - 1; i++) { int records = getRecordCount(stmt, (String) tblResult.getValueAt(i, COL_TABLENAME)); tblResult.setValueAt(new Integer(records), i, COL_RECORDS); ((DefaultTableModel) tblResult.getModel()).fireTableDataChanged(); } stmt.close(); stmt = null; } catch (SQLException e) { log.error(e.getLocalizedMessage()); } finally { SQLUtilities.closeStatement(stmt); } }
} finally SQLUtilities.closeStatement(stmt);
protected void refreshComponent() { ISession session = getSession(); if (session == null) { throw new IllegalStateException("Null ISession"); } if(_comp == null){ _comp = createSourcePanel(); } try { PreparedStatement pstmt = createStatement(); try { _comp.load(getSession(), pstmt); } finally { SQLUtilities.closeStatement(pstmt); } } catch (SQLException ex) { s_log.error(ex); session.showErrorMessage(ex); } }
protected void refreshComponent() { ISession session = getSession(); if (session == null) { throw new IllegalStateException("Null ISession"); } if(_comp == null){ _comp = createSourcePanel(); } try { PreparedStatement pstmt = createStatement(); try { _comp.load(getSession(), pstmt); } finally { SQLUtilities.closeStatement(pstmt); } } catch (SQLException ex) { s_log.error(ex); session.showErrorMessage(ex); } }
SQLUtilities.closeStatement(stmt);