Subject Re: One PreparedStatment many ResultSet
Author Roman Rokytskyy
> Is next code is valid?
> PreparedStatment ps=connection.prepare("...........");
> ResultSet rs1,rs2;
> ps.setInt(1,1);
> rs1=ps.executeQuery();
> ps.setInt(1,2);
> rs2=ps.executeQuery();
> if(rs1.getInt(1)!=rs2.getInt(1))
> Is one PreparedStatment contanes many open ResultSet? This range of
> JDBC or FirBird

No, code is not valid. When you execute statement the second time,
first result set is closed.

Best regards,
Roman Rokytskyy