public void testSetNull_int_int() throws SQLException {
  PreparedStatement ps=null;
  try {
    String query="insert into type (BoolVal, IntVal) values ('true', ?);";
    ps=conn.prepareStatement(query);
    Statement st=null;
    try {
      ps.setNull(1,Types.INTEGER);
      ps.execute();
    }
  finally {
      try {
        ps.close();
      }
 catch (      Exception ee) {
      }
    }
    query="insert into type (BoolVal, LongVal) values ('true', ?);";
    ps=conn.prepareStatement(query);
    try {
      ps.setNull(1,Types.BIGINT);
      ps.execute();
    }
  finally {
      try {
        ps.close();
      }
 catch (      Exception ee) {
      }
    }
    query="insert into type (BoolVal, DecVal) values ('true', ?)";
    ps=conn.prepareStatement(query);
    try {
      ps.setNull(1,Types.DECIMAL);
      ps.execute();
    }
  finally {
      try {
        ps.close();
      }
 catch (      Exception ee) {
      }
    }
    query="insert into type (BoolVal, dateVal) values ('true', ?);";
    ps=conn.prepareStatement(query);
    try {
      ps.setNull(1,Types.DATE);
      ps.execute();
    }
  finally {
      try {
        ps.close();
      }
 catch (      Exception ee) {
      }
    }
    query="insert into type (BoolVal, BlobVal) values ('true', ?);";
    ps=conn.prepareStatement(query);
    try {
      ps.setNull(1,Types.BLOB);
      ps.execute();
    }
  finally {
      try {
        ps.close();
      }
 catch (      Exception ee) {
      }
    }
    query="insert into type (BoolVal, TextVal) values ('true', ?);";
    ps=conn.prepareStatement(query);
    ps.setNull(1,Types.CHAR);
    ps.execute();
  }
  finally {
    try {
      ps.close();
    }
 catch (    Exception ee) {
    }
  }
}

public void testSetNull_int_int ( ) throws SQLException { PreparedStatement ps = null ; try { String query = "insert into type (BoolVal, IntVal) values ('true', ?);" ; ps = conn . prepareStatement ( query ) ; Statement st = null ; try { ps . setNull ( 1 , Types . INTEGER ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } query = "insert into type (BoolVal, LongVal) values ('true', ?);" ; ps = conn . prepareStatement ( query ) ; try { ps . setNull ( 1 , Types . BIGINT ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } query = "insert into type (BoolVal, DecVal) values ('true', ?)" ; ps = conn . prepareStatement ( query ) ; try { ps . setNull ( 1 , Types . DECIMAL ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } query = "insert into type (BoolVal, dateVal) values ('true', ?);" ; ps = conn . prepareStatement ( query ) ; try { ps . setNull ( 1 , Types . DATE ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } query = "insert into type (BoolVal, BlobVal) values ('true', ?);" ; ps = conn . prepareStatement ( query ) ; try { ps . setNull ( 1 , Types . BLOB ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } query = "insert into type (BoolVal, TextVal) values ('true', ?);" ; ps = conn . prepareStatement ( query ) ; ps . setNull ( 1 , Types . CHAR ) ; ps . execute ( ) ; } finally { try { ps . close ( ) ; } catch ( Exception ee ) { } } }
this test doesn ' t pass on ri
