Scrolling through cursors

Fredik

Here is some code which uses cursors

Dave

  public void testCursor()
  {
    Connection con = null;
    try {
      con = getConnection();

      // cursors work inside a transaction
      con.setAutoCommit(false);

      Statement stmt = con.createStatement();

      // sufficiently long select as to get us something we can scroll
through
      stmt.execute("declare cursorname cursor for select * from
pg_class");

      ResultSet rs = stmt.executeQuery("fetch 10 from cursorname");

      while (rs.next()){
        System.out.println(rs.getString(1));
      }
      rs.close();

      // close the cursor
      con.commit();

    }
    catch (Exception ex)
    {
      ex.printStackTrace();
    }
    finally
    {
      try {
        if ( con != null )
          con.close();
      }catch ( SQLException ex ) {}
    }

  }