private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
tokenizer = aTokenizer; TokenizerSessPropsInteractions tep = tokenizer.getTokenizerSessPropsInteractions(); _props.setSQLStatementSeparator(aTokenizer.getSQLStatementSeparator()); _props.setStartOfLineComment(aTokenizer.getLineCommentBegin()); _props.setRemoveMultiLineComment(aTokenizer.isRemoveMultiLineComment());
public void execute() throws BaseException { try { // Open connection to the webservice. WebServiceSession wss = new WebServiceSession(_prefs,_wsSessionProps); wss.open(); final WebServiceValidator val = new WebServiceValidator(wss, _wsSessionProps); final IQueryTokenizer qt = _session.getQueryTokenizer(); qt.setScriptToTokenize(_sql); final StringBuffer results = new StringBuffer(1024); while (qt.hasQuery()) { // TODO: When message are can have some text in red (error) // and some normal then put out errors in red. ValidatorResult rc = val.validate(qt.nextQuery()); results.append(rc.getData()); } _results = results.toString().trim(); } catch (Throwable th) { throw new BaseException(th); } } }
private void onRunHQL() { if (false == _runHQL.isEnabled()) { return; } String hql = _hqlEntryPanelManager.getEntryPanel().getSQLToBeExecuted(); if (null == hql || 0 == hql.trim().length()) { return; } final IQueryTokenizer queryTokenizer = _sess.getQueryTokenizer(); final String statementSeparator = queryTokenizer.getSQLStatementSeparator(); final String startOfLineComment = queryTokenizer.getLineCommentBegin(); QueryTokenizer qt = new QueryTokenizer(statementSeparator, startOfLineComment, true); qt.setScriptToTokenize(hql); while (qt.hasQuery()) { String hqlQuery = qt.nextQuery(); _hibernateTabController.displayObjects(_con, hqlQuery); } }
qt.setScriptToTokenize(script); if (false == qt.hasQuery()) { if(qt.getQueryCount() > 1){ String currentSQL = qt.nextQuery();
if(_tokenizer.getQueryCount() == 0) statementCount = _tokenizer.getQueryCount(); while (_tokenizer.hasQuery() && !_stopExecution) String querySql = _tokenizer.nextQuery(); if (querySql != null)
public SQLExecuterTask(ISession session, String sql, ISQLExecuterHandler handler, ISQLExecutionListener[] executionListeners) { if (sql == null) { if (s_log.isDebugEnabled()) { s_log.debug("init(): expected non-null sql"); return; } } _session = session; _schemaInfoUpdateCheck = new SchemaInfoUpdateCheck(_session); _sql = sql; _tokenizer = _session.getQueryTokenizer(); _tokenizer.setScriptToTokenize(_sql); _handler = handler; if (_handler == null) { _handler = new DefaultSQLExecuterHandler(session); } _executionListeners = executionListeners; _dataSetUpdateableTableModel = new DataSetUpdateableTableModelImpl(); _dataSetUpdateableTableModel.setSession(_session); }
/** * Returns the number of queries that the tokenizer found in _sql. * @return */ public int getQueryCount() { return _tokenizer.getQueryCount(); }
private void validateSQL() { final ISQLPanelAPI api = _session.getSessionInternalFrame().getSQLPanelAPI(); final String sql = api.getSQLScriptToBeExecuted(); if (sql != null && sql.trim().length() > 0) { final WebServiceSessionProperties wssProps = _plugin.getWebServiceSessionProperties(_session); final String stmtSep= _session.getQueryTokenizer().getSQLStatementSeparator(); final String solComment = _session.getQueryTokenizer().getLineCommentBegin(); final ValidationProps valProps = new ValidationProps(_prefs, wssProps, sql, stmtSep, solComment, _session); new Executor(_session.getApplication(), valProps, _session.getProperties()).execute(); } else { // i18n[sqlval.noSql=No SQL specified] _session.showErrorMessage(s_stringMgr.getString("sqlval.noSql")); } }
if(_tokenizer.getQueryCount() == 0) statementCount = _tokenizer.getQueryCount(); while (_tokenizer.hasQuery() && !_stopExecution) String querySql = _tokenizer.nextQuery(); if (querySql != null)
public SQLExecuterTask(ISession session, String sql, ISQLExecuterHandler handler, ISQLExecutionListener[] executionListeners) { if (sql == null) { if (s_log.isDebugEnabled()) { s_log.debug("init(): expected non-null sql"); return; } } _session = session; _schemaInfoUpdateCheck = new SchemaInfoUpdateCheck(_session); _sql = sql; _tokenizer = _session.getQueryTokenizer(); _tokenizer.setScriptToTokenize(_sql); _handler = handler; if (_handler == null) { _handler = new DefaultSQLExecuterHandler(session); } _executionListeners = executionListeners; _dataSetUpdateableTableModel = new DataSetUpdateableTableModelImpl(); _dataSetUpdateableTableModel.setSession(_session); }
/** * Returns the number of queries that the tokenizer found in _sql. * @return */ public int getQueryCount() { return _tokenizer.getQueryCount(); }
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
tokenizer = aTokenizer; TokenizerSessPropsInteractions tep = tokenizer.getTokenizerSessPropsInteractions(); _props.setSQLStatementSeparator(aTokenizer.getSQLStatementSeparator()); _props.setStartOfLineComment(aTokenizer.getLineCommentBegin()); _props.setRemoveMultiLineComment(aTokenizer.isRemoveMultiLineComment());
qt.setScriptToTokenize(script); if(false == qt.hasQuery()) String sql = qt.nextQuery(); ResultSet srcResult = stmt.executeQuery(sql);
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
TokenizerSessPropsInteractions qtp = queryTokenizer.getTokenizerSessPropsInteractions(); if(qtp.isTokenizerDefinesStatementSeparator()) _stmtSepField.setText(queryTokenizer.getSQLStatementSeparator()); _stmtSepField.setEditable(false); _solCommentField.setText(queryTokenizer.getLineCommentBegin()); _solCommentField.setEditable(false); _removeMultiLineComment.setSelected(queryTokenizer.isRemoveMultiLineComment()); _removeMultiLineComment.setEnabled(false);
qt.setScriptToTokenize(script); if(false == qt.hasQuery()) try String sql = qt.nextQuery();
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
TokenizerSessPropsInteractions qtp = queryTokenizer.getTokenizerSessPropsInteractions(); if(qtp.isTokenizerDefinesStatementSeparator()) _stmtSepField.setText(queryTokenizer.getSQLStatementSeparator()); _stmtSepField.setEditable(false); _solCommentField.setText(queryTokenizer.getLineCommentBegin()); _solCommentField.setEditable(false); _removeMultiLineComment.setSelected(queryTokenizer.isRemoveMultiLineComment()); _removeMultiLineComment.setEnabled(false);