connection.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

    Statement statement;
    Statement statement2;
    ResultSet resultSet;

// Тестовые данные
    statement = connection.createStatement();
     try  {
      statement.execute("drop table TEST");
    }  catch  (SQLException e) {}
    statement.execute("create table TEST (ID number(9), VAL varchar2(32))");

    statement.executeUpdate("INSERT INTO TEST (ID, VAL) VALUES (1, 'a')");
    statement.executeUpdate("INSERT INTO TEST (ID, VAL) VALUES (2, 'b')");
    connection.commit();

// Выборка
//    statement2 = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
    statement2 = connection.createStatement();
    resultSet = statement2.executeQuery("SELECT ID, VAL FROM TEST");

// Фантом
    statement.executeUpdate("INSERT INTO TEST (ID, VAL) VALUES (3, 'c')");
    connection.commit();

// Бежим...
//    resultSet.beforeFirst();
     while  (resultSet.next()) {
       for  ( int  i =  1 ; i <= resultSet.getMetaData().getColumnCount(); ++i) {
        System.out.print(resultSet.getObject(i) + "   ");
      }
      System.out.println("");
    }

1   a   
2   b