The cursor positions of a ResultSet must be set to the appropriate position (calling next or some other function defined by the API). Your code never does this on the rs3 variable.
Type: Posts; User: copeg
Re: multiple resultsets
The cursor positions of a ResultSet must be set to the appropriate position (calling next or some other function defined by the API). Your code never does this on the rs3 variable.
Re: multiple resultsets
I said no such thing. Read the API: one Statement is associated with a single ResultSet. So then, how would you then create more than a single ResultSet?
Re: multiple resultsets
Define 'not working'.
Read the API for Statement Statement (Java Platform SE 6). By default, only one ResultSet per Statement can be open at a single time .