public WarningEntry(Throwable throwable) { requireNonNull(throwable, "throwable is null"); assertTrue(throwable instanceof SQLWarning); SQLWarning warning = (SQLWarning) throwable; this.vendorCode = warning.getErrorCode(); this.sqlState = requireNonNull(warning.getSQLState(), "SQLState is null"); this.message = requireNonNull(warning.getMessage(), "message is null"); }
private void processWarnings(final boolean forced) throws SQLException { if (--warningCheckCounter == 0 || forced) { warningCheckCounter = CHECK_WARNINGS_AFTER_COUNT; for (SQLWarning w = connection().getWarnings(); w != null; w = w.getNextWarning()) { LOGGER.debug("Server-side message: '{}', state = {}, code = {}", w.getMessage(), w.getSQLState(), w.getErrorCode()); } } } };
logger.debug("SQLWarning ignored: SQL state '" + warningToLog.getSQLState() + "', error code '" + warningToLog.getErrorCode() + "', message [" + warningToLog.getMessage() + "]"); warningToLog = warningToLog.getNextWarning();
@Override public final void handleWarning(SQLWarning warning) { logWarning( "SQL Warning Code: " + warning.getErrorCode() + ", SQLState: " + warning.getSQLState(), warning.getMessage() ); }
public void run() { try { // TODO cross-check result against actual // number // of rows sent. ps.executeUpdate(); // Pump out any warnings and save them. SQLWarning warning = ps.getWarnings(); while ( warning != null ) { warnings.add( warning.getMessage() ); warning = warning.getNextWarning(); } } catch ( SQLException ex ) { this.ex = ex; } finally { try { data.db.closePreparedStatement( ps ); } catch ( KettleException ke ) { // not much we can do with this } finally { ps = null; } } }
private static void assertWarningsEqual(SQLWarning actual, SQLWarning expected) { assertEquals(actual.getMessage(), expected.getMessage()); assertEquals(actual.getSQLState(), expected.getSQLState()); assertEquals(actual.getErrorCode(), expected.getErrorCode()); }
/** * Throw an SQLWarningException if we're not ignoring warnings, * else log the warnings (at debug level). * @param stmt the current JDBC statement * @throws SQLWarningException if not ignoring warnings * @see org.springframework.jdbc.SQLWarningException */ protected void handleWarnings(Statement stmt) throws SQLException { if (isIgnoreWarnings()) { if (logger.isDebugEnabled()) { SQLWarning warningToLog = stmt.getWarnings(); while (warningToLog != null) { logger.debug("SQLWarning ignored: SQL state '" + warningToLog.getSQLState() + "', error code '" + warningToLog.getErrorCode() + "', message [" + warningToLog.getMessage() + "]"); warningToLog = warningToLog.getNextWarning(); } } } else { handleWarnings(stmt.getWarnings()); } }
sb.append(warning.getMessage());
SQLWarning warning = getWarnings(); if (warning != null) level = warning.getMessage();
/** * Throw a SQLWarningException if we're not ignoring warnings, else log the * warnings (at debug level). * * @param statement the current statement to obtain the warnings from, if there are any. * @throws SQLException if interaction with provided statement fails. * * @see org.springframework.jdbc.SQLWarningException */ protected void handleWarnings(Statement statement) throws SQLWarningException, SQLException { if (ignoreWarnings) { if (log.isDebugEnabled()) { SQLWarning warningToLog = statement.getWarnings(); while (warningToLog != null) { log.debug("SQLWarning ignored: SQL state '" + warningToLog.getSQLState() + "', error code '" + warningToLog.getErrorCode() + "', message [" + warningToLog.getMessage() + "]"); warningToLog = warningToLog.getNextWarning(); } } } else { SQLWarning warnings = statement.getWarnings(); if (warnings != null) { throw new SQLWarningException("Warning not ignored", warnings); } } }
new SQLWarning(warn.getMessage(), warn.getSQLState(), warn.getErrorCode()); SQLWarning nw = warn.getNextWarning(); while ( nw != null ) tw.setNextWarning(new SQLWarning(nw.getMessage(), nw.getSQLState(), nw.getErrorCode())); new SQLWarning(warn.getMessage(), warn.getSQLState(), warn.getErrorCode()));
if (warnings != null) if (!warnings.getMessage().startsWith("Can't drop database"))
private static void logSQLWarnings(final SQLWarning sqlWarning) { final Level level = Level.FINER; if (!LOGGER.isLoggable(level)) { return; } SQLWarning currentSqlWarning = sqlWarning; while (currentSqlWarning != null) { final String message = String.format("%s%nError code: %d, SQL state: %s", currentSqlWarning.getMessage(), currentSqlWarning.getErrorCode(), currentSqlWarning.getSQLState()); LOGGER.log(level, message, currentSqlWarning); currentSqlWarning = currentSqlWarning.getNextWarning(); } }
private static void logSQLWarnings(final SQLWarning sqlWarning) { final Level level = Level.FINER; if (!LOGGER.isLoggable(level)) { return; } SQLWarning currentSqlWarning = sqlWarning; while (currentSqlWarning != null) { final String message = String.format("%s%nError code: %d, SQL state: %s", currentSqlWarning.getMessage(), currentSqlWarning.getErrorCode(), currentSqlWarning.getSQLState()); LOGGER.log(level, message, currentSqlWarning); currentSqlWarning = currentSqlWarning.getNextWarning(); } }
public static void logAndClearWarnings(Connection con) throws SQLException { if (logger.isLoggable(MLevel.INFO)) { for(SQLWarning w = con.getWarnings(); w != null; w = w.getNextWarning()) logger.log(MLevel.INFO, w.getMessage(), w); } con.clearWarnings(); }
@Override public final void handleWarning(SQLWarning warning) { logWarning( "SQL Warning Code: " + warning.getErrorCode() + ", SQLState: " + warning.getSQLState(), warning.getMessage() ); }
public WarningEntry(Throwable throwable) { requireNonNull(throwable, "throwable is null"); assertTrue(throwable instanceof SQLWarning); SQLWarning warning = (SQLWarning) throwable; this.vendorCode = warning.getErrorCode(); this.sqlState = requireNonNull(warning.getSQLState(), "SQLState is null"); this.message = requireNonNull(warning.getMessage(), "message is null"); }
private static void assertWarningsEqual(SQLWarning actual, SQLWarning expected) { assertEquals(actual.getMessage(), expected.getMessage()); assertEquals(actual.getSQLState(), expected.getSQLState()); assertEquals(actual.getErrorCode(), expected.getErrorCode()); }
protected void logSQLWarnings(Statement stmt) { if (stmt != null && _log != null && _log.isTraceEnabled()) { try { SQLWarning warn = stmt.getWarnings(); while (warn != null) { _log.trace(_loc.get("sql-warning", warn.getMessage())); warn = warn.getNextWarning(); } } catch (SQLException e) {} } } }
protected void logSQLWarnings(Statement stmt) { if (stmt != null && _log != null && _log.isTraceEnabled()) { try { SQLWarning warn = stmt.getWarnings(); while (warn != null) { _log.trace(_loc.get("sql-warning", warn.getMessage())); warn = warn.getNextWarning(); } } catch (SQLException e) {} } } }