1. Where does the compiled preparedStatement stays?
2. When we are running thr the ResultSet i.e rs.next and the database connectivity is lost how the resultset work will it display the remaining records or it will start again?
Wrushu, 1) In Java's memory from the driver. Note there is also a database execution plan which is stored on the database. 2) Usually it will throw an exception forcing you to handle it. Most people handle it by starting over, but you could write some code for the re-query to start where you left off.