On Thu, 4 Mar 1999, Sreenivasa R V wrote:

Hi,

You might take advantage of servlet's session management - to store
results from user's requests within an temporary container, and retrieve
them later, within current session. Check out
HttpServletRequest.getSession() API calls an

You must also carefully consider some other issues, not quite trivial:

- Page handling/display problems.
  (page size, total rows, next/prev/first/last/goToPage.. buttons).

-  Caching the results using some sort of container within current session -
  before sending the first page of the report it's better to close
  the  JDBC statement and/or connection
  (or 'release' them if you use some sort of connection pooling -
   recomended).

  The reason for this is that your servlet has no means to find if your user
  leaved your report pages navigating else where - and the
  session will be closed only after a pretty long time.
  You don't want having dozens of sessions each keeping busy several
  database connections, for performance and/or licensing/economical
  reasons.


> Hi Buddies,
>     I have a small requirement.
>     Suppose i have a big resultset (for e.g. 200 records) retrieved from
> the database. I want to get only a part of the resultset data to the
> applet and store the remaining in the server for retieving in the
> future. I'm using Netscape Enterprise server with jrun2.2 for my servlet
> development.
>     I heard that NAS has some method to do the above storing on the
> server side. Is there a similar way to do it using Netscape Enterprise
> Server? Any other suggestions are welcome.
>
> Thanks in Advance,
> RVS
>
>
>


Cezar Totth                             email:  [EMAIL PROTECTED]
JApS Project Manager                    Fax:    (401) 220 33 95
Genesys Software Romania
http://japs.genesys.ro

___________________________________________________________________________
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

Reply via email to