I am getting this exception from the lines below
java.sql.SQLException: Operation not allowed after ResultSet closed
Basically I have to get data out of many different tables so I have to execute about 6 different sql statments. What I want to know is how I can execute these statements and get their results without haveing to close the database connection and the resultset each query.
Why is this happening what is the best/easiest way to remedy this.
Thanks again.
Ahhhhhhhh