Re: multiple resultsets open

Fabio Lopes wrote:

> 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:

The code seems fine (assuming you know when next() is going to return true or false... What exception do you get from that code? Joe Weinstein at BEA

>
>
> 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 - 15:02:10 CDT