I need some way to maintain data from a ResultSet after closing the connection. In other words, I want something that can get the data from the database, close the connection, then return the results. If it helps, I'm using an Oracle 8 database. Any suggestions?
private ResultSet mymethod(String sql)
Connection conn = getConnection();
Statement stmt = conn.getStatement();
ResultSet rs = stmt.execute(sql);