Examples of java.sql.Connection.clearWarnings()

java.sql.Connection.clearWarnings()
After this call, getWarnings returns null until a new warning is reported for this Connection. @exception SQLException if a database-access error occurs.

        s_f_r = createStatement(ResultSet.TYPE_FORWARD_ONLY,
                ResultSet.CONCUR_READ_ONLY);
        // We should have gotten no warnings and a read only forward only cursor
        JDBC.assertNoWarnings(conn.getWarnings());


        conn.clearWarnings();


        // Verify that setMaxRows(-1) fails
        try {
            s_f_r.setMaxRows(-1);
            // Should never get here

View Full Code Here

        ps_f_r = prepareStatement("select * from t",
                ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
        // We should have gotten no warnings and a read only forward only cursor
        JDBC.assertNoWarnings(conn.getWarnings());
        
        conn.clearWarnings();


        // Verify that result set from statement is
        // scroll insensitive and read only
        rs = ps_f_r.executeQuery();
        assertEquals(ResultSet.TYPE_FORWARD_ONLY, rs.getType());

View Full Code Here

        ResultSet rs;
        Statement s_f_r = createStatement(ResultSet.TYPE_FORWARD_ONLY,
                ResultSet.CONCUR_READ_ONLY);
        // We should have gotten no warnings and a read only forward only cursor
        JDBC.assertNoWarnings(conn.getWarnings());
        conn.clearWarnings();


        // Verify that setMaxRows(4) succeeds
        s_f_r.setMaxRows(5);
        assertEquals(5, s_f_r.getMaxRows());

View Full Code Here

                ResultSet.CONCUR_READ_ONLY);


        // We should have gotten a warning and a scroll insensitive cursor
        warning = conn.getWarnings();
        assertNotNull(warning);
        conn.clearWarnings();


        // Verify that result set from statement is
        // scroll insensitive and read only
        rs = s_s_r.executeQuery("select * from t");
        assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, rs.getType());

View Full Code Here

                ResultSet.CONCUR_UPDATABLE);
        // We should have gotten 1 warning and a updatable scroll
        // insensitive cursor.
        warning = conn.getWarnings();
        assertNotNull(warning);
        conn.clearWarnings();


        // Verify that result set from statement is
        // scroll insensitive and read only
        rs = s_s_u.executeQuery("select * from t");
        assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, rs.getType());

View Full Code Here


        // We should not have gotten any warnings
        // and should have gotten a scroll insensitive cursor
        JDBC.assertNoWarnings(conn.getWarnings());


        conn.clearWarnings();


        // run a query
        rs = s_i_r.executeQuery("select * from t");
        // verify scroll insensitive and read only
        assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, rs.getType());

View Full Code Here

                ResultSet.CONCUR_READ_ONLY);


        // We should not have gotten any warnings
        // and should have gotten a scroll insensitive cursor
        JDBC.assertNoWarnings(conn.getWarnings());
        conn.clearWarnings();


        // Verify that setMaxRows(-1) fails
        try {
            s_i_r.setMaxRows(-1);
            // Should never get here

View Full Code Here

        else
            assertEquals("01J10", warning.getSQLState());


        JDBC.assertNoWarnings(warning.getNextWarning());


        conn.clearWarnings();
        cs_s_r.close();


        cs_s_u = prepareCall("values cast (? as Integer)",
                ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

View Full Code Here

            assertEquals("01J02", warning.getSQLState());
        else
            assertEquals("01J10", warning.getSQLState());


        JDBC.assertNoWarnings(warning.getNextWarning());
        conn.clearWarnings();
        cs_s_u.close();


        cs_i_r = prepareCall("values cast (? as Integer)",
                ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

View Full Code Here

                ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);


        // We should have gotten 0 warnings
        JDBC.assertNoWarnings(conn.getWarnings());


        conn.clearWarnings();
        cs_i_r.close();


        cs_f_r = prepareCall("values cast (? as Integer)",
                ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);

View Full Code Here

0 1 2 3 4 5 6

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.