Multiple Select Statement
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Navneet_Guy
Posted On:   Friday, August 9, 2002 03:43 AM

I am using 4 different type of Select * from table in a single JSP page.

Is this safe to do ? Does it make any problem to the buffer or server.
Regards,
Navneet

Re: Multiple Select Statement

Posted By:   Stephen_McConnell  
Posted On:   Friday, August 9, 2002 04:43 AM

This depends upon whether you are trying to keep open multiple result sets and process them. JDBC 2.0 doesn't allow this, but I think JDBC 3.0 does (We haven't implemented any 3.0 compliant drivers, yet).


I have had to get the information from the first result set, put it in a Collection. Close the result set AND the statement. Then, open a new statement and result set....


Anyone else have any other solutions?


Stephen McConnell

About | Sitemap | Contact