ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zsolt" <zkoppanyl...@intland.com>
Subject RE: paginated list
Date Fri, 04 Nov 2005 11:52:03 GMT
I use mysql-connector-java-3.1.11-bin.jar but it does also work with
mysql-connector-java-3.0.14-production.

log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Connection=DEBUG

Zsolt

>-----Original Message-----
>From: Eugeny N Dzhurinsky [mailto:eugenydzh@jdevelop.com]
>Sent: Friday, November 04, 2005 8:45 AM
>To: user-java@ibatis.apache.org
>Subject: Re: paginated list
>
>On Fri, Nov 04, 2005 at 08:22:29AM +0100, Zsolt wrote:
>> The MySql driver loads everything into the memory (unless you use LIMIT),
>> thus if paginated list just skips records it seems to be use less. Its
>> functionality can be replaced with List.subList(int fromIndex, int
>toIndex).
>>
>> My log just show java.sql.ResultSet returned by ibatis, and that contains
>> only a page. Are you sure that paginated list just skips records? In this
>> case we have to replace it because we work also on huge lists and cannot
>> load a couple of 100,000 records into memory to display for example 20.
>
>How did you configure logging to show java.sql.RusultSet statements?
>I tried to play with this for about 2 month, and all what I found is I need
>to
>provide
>log4j.logger.java.sql=DEBUG
>
>which will return everything logged by prepared statements and result sets,
>but it will not log anything in case if I specify
>log4j.logger.java.sql.PreparedStatement=DEBUG
>
>I'm using log4j 1.2.9 and iBATIS_DBL-2.1.5.582
>
>--
>Eugene N Dzhurinsky


Mime
View raw message