how to empty a Result set

ms_lost
ms_lost used Ask the Experts™
on
how to empty a Result set ??
i'm validating the entered data..but it seems that the record set holds data of the first time ..
when i shut down Tom-cat..it's working ok..but what if i want to allow the user to go back to the data entry form to enter his details again..

in asp..there is something like set Recordset=nothing
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Java Developer
Top Expert 2010
Commented:
rs.close();

Commented:
could you explain what you are trying to do? the End result?

though what objects suggested.. closing the resultset and the connection should clean up everything.

CJ
Commented:
try this one, it may work
simply assign null value object;

ResultSet rs = .......
rs = null;
Distinguished Expert 2018

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Split points between objects and avadhesh

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

girionis
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial