Java Code Examples for java.sql.Statement#clearWarnings()

/**
 * General purpose handling of warnings associated with a JDBC {@link Statement}.
 *
 * @param statement The JDBC statement potentially containing warnings
 * @param handler The handler for each individual warning in the stack.
 *
 * @see #walkWarnings
 */
@SuppressWarnings({"ThrowableResultOfMethodCallIgnored"})
public void handleAndClearWarnings(
		Statement statement,
		WarningHandler handler) {
	// See HHH-9174.  Statement#getWarnings can be an expensive call for many JDBC libs.  Don't do it unless
	// the log level would actually allow a warning to be logged.
	if ( logWarnings ) {
		try {
			walkWarnings( statement.getWarnings(), handler );
		}
		catch (SQLException sqlException) {
			// workaround for WebLogic
			LOG.debug( "could not log warnings", sqlException );
		}
	}
	try {
		// Sybase fail if we don't do that, sigh...
		statement.clearWarnings();
	}
	catch (SQLException sqle) {
		LOG.debug( "could not clear warnings", sqle );
	}
}
 

/**
	Print information about the SQL warnings for the Statement
	to the given PrintWriter.
	Walks the list of exceptions, if any.

	@param out the place to write to
	@param s the Statement that may have warnings on it
 */
static public void ShowWarnings(PrintWriter out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

static public void ShowWarnings(PrintStream out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

private void checkStatement(Connection con, Statement statement) throws Exception {
  assertEquals(con, statement.getConnection());

  assertNull(statement.getWarnings());
  statement.clearWarnings();
  assertNull(statement.getWarnings());

  assertEquals(ResultSet.TYPE_FORWARD_ONLY, statement.getResultSetType());
  assertEquals(ResultSet.CONCUR_READ_ONLY, statement.getResultSetConcurrency());

  assertEquals(ResultSet.FETCH_FORWARD, statement.getFetchDirection());
  statement.setFetchDirection(ResultSet.FETCH_FORWARD);
  assertEquals(ResultSet.FETCH_FORWARD, statement.getFetchDirection());

  assertEquals(0, statement.getFetchSize());
  statement.setFetchSize(0);
  assertEquals(0, statement.getFetchSize());
}
 

/**
	Print information about the SQL warnings for the Statement
	to the given PrintWriter.
	Walks the list of exceptions, if any.

	@param out the place to write to
	@param s the Statement that may have warnings on it
 */
static public void ShowWarnings(PrintWriter out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

static public void ShowWarnings(PrintStream out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

/**
 * Helper method available to all commands to dump any warnings
 * associated with a statement. The set of warnings is cleared
 * after display.
 * 
 * @param session The session to use for writing
 * @param statement The statement that may, or may not, contain warnings.
 */
static public void printWarnings(Session session, Statement statement) {
    
    try {
        
        SQLWarning w = statement.getWarnings();
        if (w != null) {
            
            printWarnings(session, w);
            statement.clearWarnings();
        }
    }
    catch (SQLException e) {
        
        /* IGNORED */
    }
}
 

/**
	Print information about the SQL warnings for the Statement
	to the given PrintWriter.
	Walks the list of exceptions, if any.

	@param out the place to write to
	@param s the Statement that may have warnings on it
 */
static public void ShowWarnings(PrintWriter out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

static public void ShowWarnings(PrintStream out, Statement s)
{
    try {
	// GET STATEMENT WARNINGS
	SQLWarning warning = null;

	if (s != null) {
		ShowWarnings(out, s.getWarnings());
	}

	if (s != null) {
		s.clearWarnings();
	}
    } catch (SQLException e) {
		ShowSQLException(out, e);
    }
}
 

@Override
public void clearWarnings() throws SQLException {
	for (Statement stmt : statements) {
		stmt.clearWarnings();
	}

}
 

@Test
public void assertClearWarnings() throws SQLException {
    for (Statement each : statements.values()) {
        each.clearWarnings();
    }
}
 

@Test
public void assertClearWarnings() throws SQLException {
    for (Statement each : statements.values()) {
        each.clearWarnings();
    }
}
 

@Test
public void testPreparedStatementConfig() throws SQLException {
    Statement statement = swConnection.createStatement();
    statement.cancel();
    statement.getUpdateCount();
    statement.setFetchDirection(1);
    statement.getFetchDirection();
    statement.getResultSetConcurrency();
    statement.getResultSetType();
    statement.isClosed();
    statement.setPoolable(false);
    statement.isPoolable();
    statement.getWarnings();
    statement.clearWarnings();
    statement.setCursorName("test");
    statement.setMaxFieldSize(11);
    statement.getMaxFieldSize();
    statement.setMaxRows(10);
    statement.getMaxRows();
    statement.setEscapeProcessing(true);
    statement.setFetchSize(1);
    statement.getFetchSize();
    statement.setQueryTimeout(1);
    statement.getQueryTimeout();
    Connection connection = statement.getConnection();

    statement.execute("SELECT * FROM test");
    statement.getMoreResults();
    statement.getMoreResults(1);
    statement.getResultSetHoldability();
    statement.getResultSet();

    statement.close();
    verify(mysqlStatement).getUpdateCount();
    verify(mysqlStatement).getMoreResults();
    verify(mysqlStatement).setFetchDirection(anyInt());
    verify(mysqlStatement).getFetchDirection();
    verify(mysqlStatement).getResultSetType();
    verify(mysqlStatement).isClosed();
    verify(mysqlStatement).setPoolable(anyBoolean());
    verify(mysqlStatement).getWarnings();
    verify(mysqlStatement).clearWarnings();
    verify(mysqlStatement).setCursorName(anyString());
    verify(mysqlStatement).setMaxFieldSize(anyInt());
    verify(mysqlStatement).getMaxFieldSize();
    verify(mysqlStatement).setMaxRows(anyInt());
    verify(mysqlStatement).getMaxRows();
    verify(mysqlStatement).setEscapeProcessing(anyBoolean());
    verify(mysqlStatement).getResultSetConcurrency();
    verify(mysqlStatement).getResultSetConcurrency();
    verify(mysqlStatement).getResultSetType();
    verify(mysqlStatement).getMoreResults(anyInt());
    verify(mysqlStatement).setFetchSize(anyInt());
    verify(mysqlStatement).getFetchSize();
    verify(mysqlStatement).getQueryTimeout();
    verify(mysqlStatement).setQueryTimeout(anyInt());
    verify(mysqlStatement).getResultSet();
    assertThat(connection, CoreMatchers.<Connection>is(swConnection));

    TraceSegment traceSegment = segmentStorage.getTraceSegments().get(0);
    List<AbstractTracingSpan> spans = SegmentHelper.getSpans(traceSegment);
    assertThat(spans.size(), is(1));
    assertDBSpan(spans.get(0), "Mysql/JDBI/Statement/execute", "SELECT * FROM test");
}