Organizational Research By

Surprising Reserch Topic

reusing resultset


reusing resultset  using -'java,sql,jdbc,resultset'

I need to run several queries in a row

Statement st = cnx.createStatement();
ResultSet rs = st.executeQuery( "SELECT [good stuff]");
// do something smart with rs
rs = st.execute( "SELECT [better stuff]");
// do something smarter with rs
rs = st.execute( "SELECT [best stuff]");
// you got it
try{ rs.close();} catch( SQLException ignore){};
try{ st.close();} catch( SQLException ignore){};


Is this a problem that the first two ResultSet are not properly closed or is it implicitely done during garbage collection?
    
asked Oct 19, 2015 by tejas lakhani
0 votes
17 views



Related Hot Questions



Government Jobs Opening


...