From my point of wiew, the idea of a PreparedStatement and the ResultSet itself, is to establish a way to gather data, keeping the connection and hiding the details.
But this data is gathered as needed, ie, you know nothing about the next data. Why? Because to know you need to retrieve it and that's not the idea.
Could be wrong, though, I'm not an expert on this issue.
The problem is like this, I have a stored procedure in MySQL which executes a number of SELECT statements. The stored procedure executes fine. The problem seems to be that when I try to obtain the ResultSet after execution I revceive the ResultSet for the SELECT statment in the stored procedure which executed first, when what I want is the ResultSet for the last executed SELECT statement in the stored procedure. Therefore I need to know when I hit the last ResultSet.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.