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:[EMAIL PROTECTED] >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
