we are using orcale 8i, maybe it is the time to migrate to MySQL??:P
thank you!
Navneet Karnani <[EMAIL PROTECTED]>
Sent by: news <[EMAIL PROTECTED]>
09/18/03 09:24 AM
Please respond to "Struts Users Mailing List"
To: [EMAIL PROTECTED]
cc:
Subject: Re: Multipage JDBC result
What database are you using ?
We use the MySQL database and have effectively used the limit clause to
work with a limited set of records.
we just store the query condition in the forms and work with that in
every page.
- Navneet
[EMAIL PROTECTED] said the following on 18/09/2003 1:56 AM:
> It seems that it pulled the whole JDBC resultset into the memory at one
> time(correct me if I am wrong at this point)
> since my data sets will be very huge, I don't think it is a good idea to
> pull down all the data to the session for paging.
> Any better solution /examples?
> very appreciated!!
>
> Julie
>
>
>
>
>
> "Andrew Kuzmin" <[EMAIL PROTECTED]>
> 09/16/03 09:12 AM
> Please respond to "Struts Users Mailing List"
>
>
> To: "Struts Users Mailing List"
<[EMAIL PROTECTED]>
> cc:
> Subject: Re: Multipage JDBC result
>
>
> Hi,
>
> see this link
> http://jakarta.apache.org/struts/faqs/newbie.html#pager
>
> --
> Andrew Kuzmin
> http://www.java201.com
>
> ----- Original Message -----
> From: "Jonathan Hawkins" <[EMAIL PROTECTED]>
> To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 16, 2003 3:39 PM
> Subject: Multipage JDBC result
>
>
>
>>Howdy,
>>Any tips as to where I can find code examples of how to break down a
>>large JDBC result
>>into say 25 rows per page?
>>
>>
>>Jon Hawkins
>>
>>
>>---------------------------------------------------------------------
>>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]
>
>
>
>
>
> = = = = = = = = = == = = = = = == = = = = = = = == = = = = = == = = = =
> This transmittal and any attachments may contain confidential,
privileged or sensitive information and is solely for the use of the
intended recipient. If you are not intended recipient, you are hereby
notified that you have received this transmittal and any such attachments
in error and any review, dissemination, distribution or copying thereof is
strictly prohibited. If you have received this transmittal and any
attachments in error please notify the sender and immediately destroy the
message and all its attachments. Any opinions herein expressed may be
those of the author and not necessarily of Mizuho Corporate Bank, Ltd (the
"Bank"). The Bank accepts no responsibility for the accuracy or
completeness of any information herein contained.
> = = = = = = = = = == = = = = = == = = = = = = = == = = = = = == = = = =
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
