Need help on Jsps

Hi,
Let me explain this:
In my jsp application I have two jsp pages that work as a find dialog .One of
those shows the columns from rowset (an oracle object that provide the database
table/view for the application) and the other gets the values from first one,
makes the sql query and execute the query against the rowset and retrieve the
data. There is no pure servlet, both are jsp pages.
This application is deployed on Oracle Application Server9i.

Problem is : When this find dialog is working for a client. The other client
could not load that until the work for the first one be done. I mean only one
client could load and fire the sql statement via this jsp pages(find dialog) at
the same time. Which is not acceptable in web applications. Seems only one
instance of these pages creates . if I am right on this then

Question is : Why the Jsp engine doesn't create the number of instances based
on the number of clients that call these pages? Did I miss something? If the
Page directive isThreadSafe  work for this?

In my primary mind maybe the bottleneck is where the execution of sql statement
happens. Because that portion of code takes time to retrieve data form
rowSet(table). If this is the case then Is this problem goes away if I define a
thread for this portion of code?

I would appreciate to share me any idea that you may have.
Thanks.


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html