Hi, I am calling a Oracle Stored Procedure which returns VARRAYS. I am
converting Oracle VARRYS into Java String ARRAYS and displaying the data on
the screen. But as the records may be in large number, i want to implement
paging.
I tried the following approach:
On the "NEXT" & "PREV" links, i am calling the same servlet with some
querystrings like pageStart, pageEnd, pageId etc. In the servlet i am checking
for the Querystring values, if there exists any value i am calling the display
METHOD inside the servlet. If there is no querystring value is passed i.e
means it is called for the first time from the HTML page and then i am calling
the method where it retrieves the data from the DATABASE.
But now the problem is whenever i call the servlet with "NEXT" or "PREV" link,
it is again initializing the servlet and then it looses all the data in the
ARRAYS, so it has a NULL value in them. So again i need to call the DATABASE.
Which i can't do.
Do i need to pass the whole data in SESSION and access that the next time???
Is it the right method??
Can i Pass the CallableStatment as a session variable and then retrieve the
data from it the next time???
Please Send a SAMPLE CODE, it is of great help to me.
Thanks in ADVANCE.
Nataraj
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
___________________________________________________________________________
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
