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,the
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
session and thrown to a JSP for rendering.it
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
not a bad design pattern?scope
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
http://www.servletsuite.com/servlets/pagertag.htmand 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
JanuaryRahul
-----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,
to03, 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
tothis 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
tothis 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
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]