It is my understanding that the resultset only persists as long as the connection to the db, is there any way to get around that? or do I need to create my own resulset class without this restriction and dump the data in there. or am I totally lost? thanks a lot in advance for any help jesse
Yes, the resultset will get close when you close the DB connection. There is no way other than to store the data you got from the resultset in some variables defined in your class.In your words , dump the data in your class.
Better use collection classes (Hashatable, Vector etc.) to store result set data in local memory for a faster retrieval. Even if u close connection, u can find out data in local memory using collection classes.