"Pass" ResultSet to another JSP page
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Lee_KF
Posted On:   Tuesday, November 26, 2002 05:29 PM

I have a record with 200+ fields(in a ResultSet), and I want to dispaly it across multiple JSP pages(etc, 100 fields per page). How do i "pass" the Resulset from 1 JSP page to another ? I "get" the ResulSet(from a bean) in my 1st JSP page and display 100+ fields , and pass it to 2nd page to display the rest.

I only want to make one connection to database(in my 1st JSP page).




Thanks in advance

Report | Quote This | Send private message | Reply | Print

Re: "Pass" ResultSet to another JSP page

Posted By:   Alexander_Zynevich  
Posted On:   Friday, November 29, 2002 09:20 AM

I think it is bad idea to keep result set opened.
An opened result set means not commited transaction. Not comited transaction means table in DB to be totaly blocked (other users will probably never see result).



Alexander Zynevich

Brainbench MVP for Java 1

http://www.brainbench.com/
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact