Examples of java.sql.ResultSet.clearWarnings()

java.sql.ResultSet.clearWarnings()
Clears all the warnings related to this ResultSet. @throws SQLException if a database error happens

            // is closed.
            int crsCount = 0;
            for (Iterator i = openRS.iterator(); i.hasNext();) {
                ResultSet crs = (ResultSet) i.next();
                try {
                    crs.clearWarnings();
                } catch (SQLException sqle) {
                }
                crsCount++;
            }
            System.out.println("After global transaction closed ResultSets " + crsCount);

View Full Code Here

      }
      
      // Send ResultSet warnings if there are any
      SQLWarning sqlw = (rs != null)? rs.getWarnings(): null;
      if (rs != null) {
        rs.clearWarnings();
      }


      // for updatable, insensitive result sets we signal the
      // row updated condition to the client via a warning to be 
      // popped by client onto its rowUpdated state, i.e. this

View Full Code Here


            pstmt2 = conn.prepareStatement("SELECT * FROM T_PRE_STMT_TEST ORDER BY 2", ResultSet.TYPE_SCROLL_SENSITIVE,
                                           ResultSet.CONCUR_UPDATABLE);
            rs = pstmt2.executeQuery();
            rs.getCursorName();
            rs.clearWarnings();
            rs.isBeforeFirst();
            rs.isAfterLast();
            rs.isFirst();
            rs.isLast();
            rs.setFetchDirection(rs.getFetchDirection());

View Full Code Here

          assertEquals(res.getString(3), res.getString(partitionedColumnName));
        }
        assertFalse("Last result value was not null", res.wasNull());
        assertNull("No warnings should be found on ResultSet", res
            .getWarnings());
        res.clearWarnings(); // verifying that method is supported


        // System.out.println(res.getString(1) + " " + res.getString(2));
        assertEquals(
            "getInt and getString don't align for the same result value",
            String.valueOf(res.getInt(1)), res.getString(1));

View Full Code Here

          assertEquals(res.getString(3), res.getString(partitionedColumnName));
        }
        assertFalse("Last result value was not null", res.wasNull());
        assertNull("No warnings should be found on ResultSet", res
            .getWarnings());
        res.clearWarnings(); // verifying that method is supported


        // System.out.println(res.getString(1) + " " + res.getString(2));
        assertEquals(
            "getInt and getString don't align for the same result value",
            String.valueOf(res.getInt(1)), res.getString(1));

View Full Code Here

        assertEquals(res.getString(1), res.getString("key"));
        assertEquals(res.getString(2), res.getString("value"));
        assertFalse("Last result value was not null", res.wasNull());
        assertNull("No warnings should be found on ResultSet", res
            .getWarnings());
        res.clearWarnings(); // verifying that method is supported


        // System.out.println(res.getString(1) + " " + res.getString(2));
        assertEquals(
            "getInt and getString don't align for the same result value",
            String.valueOf(res.getInt(1)), res.getString(1));

View Full Code Here

0 1 2 3 4 5 6 7 8

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.