CachedRowSet

[kiran vuppla <ki...@yahoo.com>]

Can some one please let me know if there we can use CachedRowSet for pagination through IBatis as CachedRowSet api does give pagination�(previous(), next(), last() etc)�functionality. Thanks in advance.
�
Regards,
Kiran


      

Re: CachedRowSet

[kiran vuppla <ki...@yahoo.com>]

Thanks for the reply.
�
Through JDBC we can create a CachedRowSet object and get the pagination working. I would like to how to configure CachedRowSet functionality using IBatis <select> statements or something else so that I will retrieve the pagination.
�
Regards,
Kiran

--- On Mon, 8/25/08, Sundar Sankar <fa...@gmail.com> wrote:

From: Sundar Sankar <fa...@gmail.com>
Subject: Re: CachedRowSet
To: user-java@ibatis.apache.org, kirankumar_vuppla@yahoo.com
Date: Monday, August 25, 2008, 12:44 PM



Hi Kiran,
�������������� If� I remember right, isnt the previous and next of a cached rowset used to traverse through the cursor of the result set fetched. I think all cached rowset does if caches the resultset and gives the data to the user so that the there is no hard connection between the application and database after the result sets have been fetched.� 

I could be wrong too, the cached rowset I used was like 2 years ago and this is what previous and next was in the code that was available then. It was more a replacement of a rs.next() and rs.previous(). [ rs being an instance of a ResultSet object] 


Regards
Sundar


On Mon, Aug 25, 2008 at 10:19 AM, kiran vuppla <ki...@yahoo.com> wrote:






Can some one please let me know if there we can use CachedRowSet for pagination through IBatis as CachedRowSet api does give pagination�(previous(), next(), last() etc)�functionality. Thanks in advance.
�
Regards,
Kiran




      

Re: CachedRowSet

[Sundar Sankar <fa...@gmail.com>]

Hi Kiran,
               If  I remember right, isnt the previous and next of a cached
rowset used to traverse through the cursor of the result set fetched. I
think all cached rowset does if caches the resultset and gives the data to
the user so that the there is no hard connection between the application and
database after the result sets have been fetched.

I could be wrong too, the cached rowset I used was like 2 years ago and this
is what previous and next was in the code that was available then. It was
more a replacement of a rs.next() and rs.previous(). [ rs being an instance
of a ResultSet object]


Regards
Sundar

On Mon, Aug 25, 2008 at 10:19 AM, kiran vuppla
<ki...@yahoo.com>wrote:

> Can some one please let me know if there we can use CachedRowSet for
> pagination through IBatis as CachedRowSet api does give
> pagination (previous(), next(), last() etc) functionality. Thanks in
> advance.
>
> Regards,
> Kiran
>
>