示例#1
0
 @Override
 public void setFetchDirection(int direction) throws SQLException {
   stat.setFetchDirection(direction);
 }
 @Test(expected = SQLFeatureNotSupportedException.class)
 public void assertSetFetchDirection() throws SQLException {
   actual.setFetchDirection(0);
 }
示例#3
0
  /**
   * DOCUMENT ME!
   *
   * @throws SQLException DOCUMENT ME!
   */
  public void testAccessorsAndMutators() throws SQLException {
    assertTrue(
        "Connection can not be null, and must be same connection", stmt.getConnection() == conn);

    // Set max rows, to exercise code in execute(), executeQuery() and executeUpdate()
    Statement accessorStmt = null;

    try {
      accessorStmt = conn.createStatement();
      accessorStmt.setMaxRows(1);
      accessorStmt.setMaxRows(0); // FIXME, test that this actually affects rows returned
      accessorStmt.setMaxFieldSize(255);
      assertTrue("Max field size should match what was set", accessorStmt.getMaxFieldSize() == 255);

      try {
        accessorStmt.setMaxFieldSize(Integer.MAX_VALUE);
        fail("Should not be able to set max field size > max_packet_size");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      accessorStmt.setCursorName("undef");
      accessorStmt.setEscapeProcessing(true);
      accessorStmt.setFetchDirection(java.sql.ResultSet.FETCH_FORWARD);

      int fetchDirection = accessorStmt.getFetchDirection();
      assertTrue(
          "Set fetch direction != get fetch direction",
          fetchDirection == java.sql.ResultSet.FETCH_FORWARD);

      try {
        accessorStmt.setFetchDirection(Integer.MAX_VALUE);
        fail("Should not be able to set fetch direction to invalid value");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      try {
        accessorStmt.setMaxRows(50000000 + 10);
        fail("Should not be able to set max rows > 50000000");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      try {
        accessorStmt.setMaxRows(Integer.MIN_VALUE);
        fail("Should not be able to set max rows < 0");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      int fetchSize = stmt.getFetchSize();

      try {
        accessorStmt.setMaxRows(4);
        accessorStmt.setFetchSize(Integer.MAX_VALUE);
        fail("Should not be able to set FetchSize > max rows");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      try {
        accessorStmt.setFetchSize(-2);
        fail("Should not be able to set FetchSize < 0");
      } /* ignore */ catch (SQLException sqlEx) {;
      }

      assertTrue(
          "Fetch size before invalid setFetchSize() calls should match fetch size now",
          fetchSize == stmt.getFetchSize());
    } finally {

      if (accessorStmt != null) {

        try {
          accessorStmt.close();
        } /* ignore */ catch (SQLException sqlEx) {;
        }

        accessorStmt = null;
      }
    }
  }