Re: Paging for table...

[HK Santosh]

Ed,

   any URL(s) which might enlighten me further on resultset/cursor 
scrolling and the support provided by different databses in this regard.

Thanks,
Santosh
Ed Dowgiallo wrote:

If you are talking about an SQL database, this is exactly the concept of
cursor scrolling.  The JDBC standard calls the same thing result set
scrolling. The problem is that not all databases provide good support for
this.  In particular, the most popular database among corporations, Oracle,
does not support cursor scrolling at the database engine level.  Oracle does
support result set scrolling, but accomplishes it by buffering the query
result in the JDBC driver memory space on the client or application server.
The real difficulty with this concept for databases is the necessity to
support SQL operators like ORDER BY, GROUP BY, SELECT DISTINCT,
COUNT(DISTINCT, UNION, MINUS, DIFFER, etc. which often involve sorting.  The
final order of the rows is not known until the sort steps are completed.
Ed
----- Original Message ----- 
From: "Adolfo Miguelez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 04, 2004 10:41 AM
Subject: RE: Paging for table...

 

Hi,

I always wondered a question about this kind of server side paging:

THE PROBLEM:
I suppose it is based on getting all the results at once from the database
and storing them in session. Further on, data is extracted in slots from
   

the
 

session and thrown to a JSP for rendering.

Well, I guess that, if this session data is large, in clustered
environments, the data is balanced among the different servers causing a
high network traffic which becomes in a performance issue for the whole
system. Even worst, a lot of times just a small amount of data is browsed
from the client side, so there is not reason to catch MBs in session. Is
   

it
 

not a bad design pattern?

THE GUESSED SOLUTION:
Would not it be better to make a new query to the datasource (database
usually), in order to recover just a slot of data, store it in request
   

scope
 

and send to the JSP for rendering. Would not be this second approach save
machine resources?
In that way server would not be context aware, and would work just as
proxy/formatter among client and datasource. Is not better approach? Or
perhaps would depends on the data size to be fetched?
Thanks for your opinions,

Adolfo.



   

From: <[EMAIL PROTECTED]>
Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Paging for table...
Date: Sun, 4 Jan 2004 10:50:22 +0530
David,

Check for the details on
     

http://www.servletsuite.com/servlets/pagertag.htm
 

Rahul

-----Original Message-----
From: David Friedman [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 10:48 AM
To: Struts Users Mailing List
Subject: RE: Paging for table...
Rahul,

What is this paging taglib?  Do you have a url?

Curious,
David
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 12:15 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Paging for table...
Check for paging taglib available for struts which will meet your
requirements.
Rahul

-----Original Message-----
From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday,
     

January
 

03, 2004 8:57 PM
To: 'David Friedman'; 'Struts Users Mailing List'
Subject: RE: Paging for table...


.Can you please send across the sample code that you have developed???

-----Original Message-----
From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004
20:57
To: Struts Users Mailing List; [EMAIL PROTECTED]
Subject: RE: Paging for table...
I use displaytag, www.displaytag.org, for that.

Regards,
David
-----Original Message-----
From: vasudevrao gupta [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 03, 2004 7:40 AM
To: 'Struts Users Mailing List'
Subject: Paging for table...
Hi,

I have a requirement where in user executes a query and gets some x
number
of records.  I have to show the user 1-y records per page and when user
clicks "next" button, he should be be able to see next y number of
records.(Similar to yahoo site ).
Can any one pls tell me if struts frame work provides any inbuilt
framework
to do this kind of paging
Regards
VasudevRaoGupta
Confidentiality Notice

The information contained in this electronic message and any attachments
to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential
or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments
     

to
 

this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments
     

to
 

this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Confidentiality Notice

The information contained in this electronic message and any attachments
     

to
 

this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
     

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]