multiple resultsets open

Hi there,

i'm wondering if is it possible keep more then one resultsets open at same time. They must come from a statement from a same connection.

Is it a jdbc driver limitation?

thanks in advance.

Fábio.

See the code sample:

 Connection c = DriverManager.getConnection("jdbc:oracle....", "user", "psw");
 Statement s1 = c.createStatement();
 ResultSet rs1 = s1.executeQuery("select * from table1");

 rs1.next();
 System.out.println("r1 " + rs1.getString("name"));  rs1.next();
 System.out.println("r1 " + rs1.getString("name"));

 Statement s2 = c.createStatement();
 ResultSet rs2 = s1.executeQuery("select * from table2");

 rs2.next();
 System.out.println("r2 " + rs2.getString("name"));  rs2.next();
 System.out.println("r2 " + rs2.getString("name"));

 // here i'd like the resultset rs1 be still open  rs1.next();
 System.out.println("r1 " + rs1.getString("name"));  rs1.next();
 System.out.println("r1 " + rs1.getString("name"));

 rs2.next();
 System.out.println("r2 " + rs2.getString("name"));  rs2.next();
 System.out.println("r2 " + rs2.getString("name")); Received on Wed Sep 03 2003 - 13:45:00 CDT