Two questions about iBatis

[Daniele Bufarini <da...@ie-online.it>]

Hi all,
I'm thinking of using iBatis in my application and I've two questions 
about iBatis:
1) How the implementation of PaginatedList handles large result sets? 
Does it use cursors?
2) Why the unusual use of the ThreadLocal class in SqlMapClientImpl? Why 
localSqlMapSession isn't declared as static?

Thank you very much in advance!


                   Best regards,
                            Daniele Bufarini.

Re: Two questions about iBatis

[Clinton Begin <cl...@gmail.com>]

>> 1) How the implementation of PaginatedList handles large result sets?
>> Does it use cursors?

Depends on your database, your driver, your configuration and
attributes such as <select ... fetchSize="..." resultSetType="..."/>

>> 2) Why the unusual use of the ThreadLocal class in SqlMapClientImpl? 
>> Why localSqlMapSession isn't declared as static?

There is not necessarily one single SqlMapClientImpl instance in a
given application, so in order to ensure that sesisons don't collide
accross instances, it's an instance field.

It's not unusual, it's correct.

Cheers,
Clinton

On Wed, 16 Feb 2005 14:43:14 +0100, Daniele Bufarini
<da...@ie-online.it> wrote:
> Hi all,
> I'm thinking of using iBatis in my application and I've two questions
> about iBatis:
> 1) How the implementation of PaginatedList handles large result sets?
> Does it use cursors?
> 2) Why the unusual use of the ThreadLocal class in SqlMapClientImpl? Why
> localSqlMapSession isn't declared as static?
> 
> Thank you very much in advance!
> 
>                    Best regards,
>                             Daniele Bufarini.
> 
>