Presume that I have created a connection to DB, created Statement & execute the statement, result what I will get is ResultSet. Immediately after this part, if I close the connection will I be able to retrieve the data from ResultSet? [ September 16, 2005: Message edited by: Bear Bibeault ]
In the continuation of paul's answer, every execution of query create a cursor, and this cursor can be either server side of client side depending on driver's implementation.
Your resultset does not hold any record once query is executed it points to the cursor created and moves to next or previous row on calling resultset.next() or resultset .previous() once you close the connection resultset will loose link to cursor and you will not be able to fetch data from resultset.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious. Weird permutations like repeating your name twice are not allowed.