Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 68803 invoked from network); 16 Mar 2008 10:12:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Mar 2008 10:12:49 -0000 Received: (qmail 49277 invoked by uid 500); 16 Mar 2008 10:12:43 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 49256 invoked by uid 500); 16 Mar 2008 10:12:43 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 49241 invoked by uid 99); 16 Mar 2008 10:12:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 16 Mar 2008 03:12:43 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [68.142.207.201] (HELO web32408.mail.mud.yahoo.com) (68.142.207.201) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 16 Mar 2008 10:12:03 +0000 Received: (qmail 556 invoked by uid 60001); 16 Mar 2008 10:12:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=dWoPedX4nGVD5VKkQu9uW9ToNoWy0g+1ay9jHyTaCly5NARc7xuUcmFnsHA+4CVPVEKcVb7SzM/52Wwpq/wXVDDXnaRHU5v/YbLXzK+fUVSVTVHkv9CvHCPRmDo7nCYcY3p3zlh0aghDiz8EuSO1oefqOFagR3GZookIyf8Dl4Q=; X-YMail-OSG: QdJogKwVM1lfLDIIaSrgph49Pfcotmr5FyGPA1NyqOAj2NrDUAbAyHRXiJ31l.EN9Nmd2wynlmQqkhqi.wBveyM5JNth_9Plny.C Received: from [85.57.66.246] by web32408.mail.mud.yahoo.com via HTTP; Sun, 16 Mar 2008 03:12:12 PDT X-Mailer: YahooMailRC/902.35 YahooMailWebService/0.7.162 Date: Sun, 16 Mar 2008 03:12:12 -0700 (PDT) From: nch Subject: Re: select * causing " OutOfMemoryError: Java heap space" To: user-java@ibatis.apache.org MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-748427719-1205662332=:99664" Message-ID: <825957.99664.qm@web32408.mail.mud.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-748427719-1205662332=:99664 Content-Type: multipart/alternative; boundary="0-446887192-1205662332=:99664" --0-446887192-1205662332=:99664 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0ASure. Please, see attached.=0AI don't think the problem is in the RowHan= dler, though, because the OutOfMemoryError occurs before invoking RowHandle= #handleRow.=0A=0ACheers=0A=0A----- Original Message ----=0AFrom: Larry Mead= ors =0ATo: user-java@ibatis.apache.org=0ASent: Sun= day, March 16, 2008 3:13:27 AM=0ASubject: Re: select * causing " OutOfMemor= yError: Java heap space"=0A=0ACan you post the row handler you are using.= =0A=0ALarry=0A=0A=0AOn Sat, Mar 15, 2008 at 1:14 PM, nch wrote:=0A>=0A>=0A> Hi, Nathan.=0A> I did so, but I'm still having = the same issue. Perhaps I'm not using it=0A> correctly?=0A> See my last pos= t to this forum entry:=0A>=0A> http://forum.compass-project.org/thread.jspa= ?threadID=3D215278=0A>=0A> See the stack trace:=0A>=0A> MemoryError: Java h= eap space:=0A> java.lang.OutOfMemoryError: Java heap space=0A> at c= om.mysql.jdbc.Buffer.getBytes(Buffer.java:198)=0A> at com.mysql.jdb= c.Buffer.readLenByteArray(Buffer.java:318)=0A> at com.mysql.jdbc.My= sqlIO.nextRow(MysqlIO.java:1366)=0A> at com.mysql.jdbc.MysqlIO.read= SingleRowSet(MysqlIO.java:2333)=0A> at com.mysql.jdbc.MysqlIO.getRe= sultSet(MysqlIO.java:435)=0A> at=0A> com.mysql.jdbc.MysqlIO.readRes= ultsForQueryOrUpdate(MysqlIO.java:2040)=0A> at com.mysql.jdbc.Mysql= IO.readAllResults(MysqlIO.java:1443)=0A> at com.mysql.jdbc.MysqlIO.= sqlQueryDirect(MysqlIO.java:1777)=0A> at com.mysql.jdbc.Connection.= execSQL(Connection.java:3249)=0A> at=0A> com.mysql.jdbc.PreparedSta= tement.executeInternal(PreparedStatement.java:1268)=0A> at=0A> com.= mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:843)=0A> = at=0A> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delega= tingPreparedStatement.java:169)=0A> at=0A> org.apache.commons.dbcp.= DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)= =0A> at=0A> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQ= uery(SqlExecutor.java:186)=0A> at=0A> com.ibatis.sqlmap.engine.mapp= ing.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)= =0A> at=0A> com.ibatis.sqlmap.engine.mapping.statement.GeneralState= ment.executeQueryWithCallback(GeneralStatement.java:173)=0A> at=0A>= com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWi= thRowHandler(GeneralStatement.java:133)=0A> at=0A> com.ibatis.sqlma= p.engine.impl.SqlMapExecutorDelegate.queryWithRowHandler(SqlMapExecutorDele= gate.java:649)=0A> at=0A> com.ibatis.sqlmap.engine.impl.SqlMapSessi= onImpl.queryWithRowHandler(SqlMapSessionImpl.java:156)=0A> at=0A> o= rg.myorg.compass.SqlMapClientGpsDeviceWithRowHandler.doIndex(SqlMapClientGp= sDeviceWithRowHandler.java:33)=0A> at=0A> org.compass.gps.device.Ab= stractGpsDevice$1.doInCompassWithoutResult(AbstractGpsDevice.java:93)=0A> = at=0A> org.compass.core.CompassCallbackWithoutResult.doInCompass(Com= passCallbackWithoutResult.java:29)=0A> at=0A> org.compass.core.Comp= assTemplate.execute(CompassTemplate.java:132)=0A> at=0A> org.compas= s.gps.impl.SingleCompassGps.executeForIndex(SingleCompassGps.java:161)=0A> = at=0A> org.compass.gps.device.AbstractGpsDevice.index(AbstractGpsDe= vice.java:91)=0A> at=0A> org.compass.spring.device.SpringSyncTransa= ctionGpsDeviceWrapper$1.doInTransactionWithoutResult(SpringSyncTransactionG= psDeviceWrapper.java:98)=0A> at=0A> org.springframework.transaction= .support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallba= ckWithoutResult.java:33)=0A> at=0A> org.springframework.transaction= .support.TransactionTemplate.execute(TransactionTemplate.java:128)=0A> = at=0A> org.compass.spring.device.SpringSyncTransactionGpsDeviceWrapper.= index(SpringSyncTransactionGpsDeviceWrapper.java:96)=0A> at=0A> org= .compass.gps.impl.SingleCompassGps$1.buildIndexIfNeeded(SingleCompassGps.ja= va:133)=0A> at=0A> org.compass.core.lucene.engine.manager.DefaultLu= ceneSearchEngineIndexManager$8.firstStep(DefaultLuceneSearchEngineIndexMana= ger.java:233)=0A> at=0A> org.compass.core.lucene.engine.manager.Def= aultLuceneSearchEngineIndexManager.doOperate(DefaultLuceneSearchEngineIndex= Manager.java:182)=0A>=0A>=0A>=0A>=0A>=0A> ----- Original Message ----=0A> F= rom: Nathan Maves =0A> To: user-java@ibatis.apache.= org=0A>=0A> Sent: Saturday, March 15, 2008 5:43:04 PM=0A> Subject: Re: sele= ct * causing " OutOfMemoryError: Java heap space"=0A>=0A> this is only my = 2 cents but I would throw that class out. Write your own=0A> implementatio= n which uses a row handler. This is the type of situation in=0A> which a r= ow handler could really help. almost no memory would be used.=0A>=0A>=0A>= =0A> On Thu, Mar 13, 2008 at 4:57 PM, nch wrote:= =0A> >=0A> > Yes, I agree that dividing the query into several queries shou= ld do as=0A> long as none of them uses more memory than available. Gracias,= Carlos.=0A> >=0A> > Nevertheless, I looked into=0A> org.compass.gps.device= .ibatis.SqlMapClientGpsDevice#doIndex and,=0A> fundamentally, what it does = is a queryForPaginatedList and iterates through=0A> the resulting Paginated= List with nextPage()=0A> >=0A> > I guess that the reason why pages are kept= in memory after performing=0A> paginatedList.nextPage() is because a pagin= atedList.previousPage() can be=0A> issued but, should't it free pages if he= ap space is running out?=0A> >=0A> >=0A> > Carlos de Luna Saenz wrote:=0A> >=0A> > Since we have a similar trouble around = here i must say that you have lot=0A> of options when going to compass..=0A= > > The first one is to index "object by object" by hand, the second one is= to=0A> use the Gps wich will use the complete bunch of data and make subin= dexes=0A> (making parts of your "main index" with diferent "maps" for each = subindex in=0A> your gpsDriver.=0A> > if your indexing is as strong as ours= i should look forward for numer 1 or=0A> number 3 depending of your needs.= (More a Compass than iBatis issue)=0A> > Greetings=0A> > Carlos de Luna=0A= > >=0A> > ----- Mensaje original ----=0A> > De: nch=0A> >=0A> > Para: user-= java@ibatis.apache.org; larry.meadors@gmail.com=0A> > Enviado: jueves, 13 d= e marzo, 2008 9:37:04=0A> > Asunto: Re: select * causing " OutOfMemoryError= : Java heap space"=0A> >=0A> >=0A> > Sorry. Yes, I need all the data at one= time, because the Compass API seems=0A> to be meant in that way.=0A> >=0A>= > Larry Meadors wrote: OK, so the answer to the question is...[ yes, i nee= d=0A> all the data at=0A> >=0A> >=0A> >=0A> > one time | no, i do not need = all of the data at one time ].=0A> >=0A> > Larry=0A> >=0A> >=0A> > On Thu, = Mar 13, 2008 at 9:04 AM, nch wrote:=0A> > >=0A> > > Hi!=0A> > >=0A> > > I'm= doing tests both under tomcat and jetty. I set 1024MB of heap space=0A> in= =0A> > > both cases. I am using a profiler to look into what's happening du= ring=0A> > > execution of the indexing process and I can tell that's the ex= act amount=0A> it=0A> > > displays for the VM.=0A> > >=0A> > > As I describ= e in the Compass user forum (see link bellow), I'm indexing=0A> a=0A> > > W= ikipedia dump of about 650000-675000 records. That's sort of 1-1.5GB of=0A>= > > data.=0A> > >=0A> > > Hibernate can handle all that data, I guess it's= using some sort of=0A> > > pagination. iBatis seems to divide the select s= tatement into several=0A> select=0A> > > statements, but it also seems each= of such statements surpasses the=0A> limit of=0A> > > 1024MB when trying t= o index only 300000 of the database records.=0A> > >=0A> > > Thank you=0A> = > >=0A> > >=0A> > >=0A> > > Chris Lamey wrote:=0A> > > What is you JVM heap= size set to and how much data is returned by select=0A> *=0A> > > from tab= le?=0A> > >=0A> > > If you're trying to pull back 1G worth of data into a J= VM with a heap=0A> size=0A> > > set to 64M, you will hit the heap limit pre= tty quick.=0A> > >=0A> > >=0A> > > -----Original Message-----=0A> > > From:= nch [mailto:underscore_dot@yahoo..com]=0A> > > Sent: Thu 3/13/2008 8:03 AM= =0A> > > To: user-java@ibatis.apache.org=0A> > > Subject: select * causing = " OutOfMemoryError: Java heap space"=0A> > >=0A> > >=0A> > > Hi, everybody.= =0A> > > I'm testing the Compass search engine and, in particular, how to i= ndex a=0A> big=0A> > > set of documents from a table in a MySQL database. I= n order to do this I=0A> > > issue a "select * from table_name" using iBati= s, but this seems to be=0A> > > causing the application to use all heap spa= ce available.=0A> > > I added a new entry into Compass user forum with deta= ils:=0A> > > http://forum.compass-project.org/thread.jspa?threadID=3D215278= =0A> > >=0A> > > Can you figure out why is this happening?=0A> > >=0A> > > = Many thanks=0A> > >=0A> > >=0A> > > ---------------------------------=0A> >= > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try= =0A> it=0A> > > now.=0A> > >=0A> > >=0A> > >=0A> > >=0A> > > ______________= __________________=0A> > > Never miss a thing. Make Yahoo your homepage.=0A= > >=0A> >=0A> > Never miss a thing. Make Yahoo your homepage.=0A> >=0A> >= =0A> >=0A> >=0A> >=0A> >=0A> >=0A> ________________________________________= ____________________________________________=0A> > =A1Capacidad ilimitada d= e almacenamiento en tu correo!=0A> > No te preocupes m=E1s por el espacio d= e tu cuenta con Correo Yahoo!:=0A> > http://correo.espanol.yahoo.com/=0A> >= =0A> >=0A> >=0A> >=0A> >=0A> >=0A> >=0A> > ________________________________= =0A> Never miss a thing. Make Yahoo your homepage.=0A>=0A>=0A>=0A>=0A> ___= _____________________________=0A> Never miss a thing. Make Yahoo your homep= age.=0A=0A=0A=0A=0A=0A=0A ____________________________________________= ________________________________________=0ABe a better friend, newshound, a= nd =0Aknow-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com= /;_ylt=3DAhu06i62sR8HDtDypao8Wcj9tAcJ =0A --0-446887192-1205662332=:99664 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

Sure. Please, see attached.
I don't think th= e problem is in the RowHandler, though, because the OutOfMemoryError occurs= before invoking RowHandle#handleRow.

Cheers

----- Or= iginal Message ----
From: Larry Meadors <larry.meadors@gmail.com><= br>To: user-java@ibatis.apache.org
Sent: Sunday, March 16, 2008 3:13:27 = AM
Subject: Re: select * causing " OutOfMemoryError: Java heap space"
=0ACan =0Ayou =0Apost =0Athe =0Arow =0Ahandler =0Ayou =0Aare =0Ausing.=

Larry


On =0ASat, =0AMar =0A15, =0A2008 =0Aat =0A1:14 =0A= PM, =0Anch =0A<underscore_dot@yahoo.com> =0Awrote:>
>
> =0AHi, =0ANathan.
> =0AI =0Adid =0Aso, =0Abut = =0AI'm =0Astill =0Ahaving =0Athe =0Asame =0Aissue. =0APerhaps =0AI'm =0Anot= =0Ausing =0Ait
> =0Acorrectly?
> =0ASee =0Amy =0Alast =0Apost = =0Ato =0Athis =0Aforum =0Aentry:
>
> =0Ahttp:= //forum.compass-project.org/thread.jspa?threadID=3D215278
>
&g= t; =0ASee =0Athe =0Astack =0Atrace:
>
> =0AMemoryError: =0AJava= =0Aheap =0Aspace:
> =0Ajava.lang.OutOfMemoryError: =0AJava =0Aheap = =0Aspace
>  =0A  =0A  =0A  =0A =0Aat =0Acom.mysql= .jdbc.Buffer.getBytes(Buffer.java:198)
>  =0A  =0A  = =0A  =0A =0Aat =0Acom.mysql.jdbc.Buffer.readLenByteArray(Buffer.java:3= 18)
>  =0A  =0A  =0A  =0A =0Aat =0Acom.mysql.jdbc= .MysqlIO.nextRow(MysqlIO.java:1366)
>  =0A  =0A  =0A&n= bsp; =0A =0Aat =0Acom.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2333= )
>  =0A  =0A  =0A  =0A =0Aat =0Acom.mysql.jdbc.M= ysqlIO.getResultSet(MysqlIO.java:435)
>  =0A  =0A  =0A=   =0A =0Aat
> =0Acom.mysql.jdbc.MysqlIO.readResultsForQueryOrUpd= ate(MysqlIO.java:2040)
>  =0A  =0A  =0A  =0A =0Aa= t =0Acom.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1443)
> = =0A  =0A  =0A  =0A =0Aat =0Acom.mysql.jdbc.MysqlIO.sqlQuery= Direct(MysqlIO.java:1777)
>  =0A  =0A  =0A  =0A = =0Aat =0Acom.mysql.jdbc.Connection.execSQL(Connection.java:3249)
>&nb= sp; =0A  =0A  =0A  =0A =0Aat
> =0Acom.mysql.jdbc.Prepa= redStatement.executeInternal(PreparedStatement.java:1268)
>  =0A=   =0A  =0A  =0A =0Aat
> =0Acom.mysql.jdbc.PreparedStat= ement.execute(PreparedStatement.java:843)
>  =0A  =0A = =0A  =0A =0Aat
> =0Aorg.apache.commons.dbcp.DelegatingPreparedS= tatement.execute(DelegatingPreparedStatement.java:169)
>  =0A&nb= sp; =0A  =0A  =0A =0Aat
> =0Aorg.apache.commons.dbcp.Delega= tingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
>=   =0A  =0A  =0A  =0A =0Aat
> =0Acom.ibatis.sqlmap= .engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
>&nb= sp; =0A  =0A  =0A  =0A =0Aat
> =0Acom.ibatis.sqlmap.en= gine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.ja= va:205)
>  =0A  =0A  =0A  =0A =0Aat
> =0Aco= m.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithC= allback(GeneralStatement.java:173)
>  =0A  =0A  =0A&nb= sp; =0A =0Aat
> =0Acom.ibatis.sqlmap.engine.mapping.statement.General= Statement.executeQueryWithRowHandler(GeneralStatement.java:133)
>&nbs= p; =0A  =0A  =0A  =0A =0Aat
> =0Acom.ibatis.sqlmap.eng= ine.impl.SqlMapExecutorDelegate.queryWithRowHandler(SqlMapExecutorDelegate.= java:649)
>  =0A  =0A  =0A  =0A =0Aat
> =0A= com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryWithRowHandler(SqlMapS= essionImpl.java:156)
>  =0A  =0A  =0A  =0A =0Aat<= br>> =0Aorg.myorg.compass.SqlMapClientGpsDeviceWithRowHandler.doIndex(Sq= lMapClientGpsDeviceWithRowHandler.java:33)
>  =0A  =0A = ; =0A  =0A =0Aat
> =0Aorg.compass.gps.device.AbstractGpsDevice$1= .doInCompassWithoutResult(AbstractGpsDevice.java:93)
>  =0A = ; =0A  =0A  =0A =0Aat
> =0Aorg.compass.core.CompassCallback= WithoutResult.doInCompass(CompassCallbackWithoutResult.java:29)
>&nbs= p; =0A  =0A  =0A  =0A =0Aat
> =0Aorg.compass.core.Comp= assTemplate.execute(CompassTemplate.java:132)
>  =0A  =0A&n= bsp; =0A  =0A =0Aat
> =0Aorg.compass.gps.impl.SingleCompassGps.e= xecuteForIndex(SingleCompassGps.java:161)
>  =0A  =0A = =0A  =0A =0Aat
> =0Aorg.compass.gps.device.AbstractGpsDevice.in= dex(AbstractGpsDevice.java:91)
>  =0A  =0A  =0A  = =0A =0Aat
> =0Aorg.compass.spring.device.SpringSyncTransactionGpsDevi= ceWrapper$1.doInTransactionWithoutResult(SpringSyncTransactionGpsDeviceWrap= per.java:98)
>  =0A  =0A  =0A  =0A =0Aat
> = =0Aorg.springframework.transaction.support.TransactionCallbackWithoutResult= .doInTransaction(TransactionCallbackWithoutResult.java:33)
>  = =0A  =0A  =0A  =0A =0Aat
> =0Aorg.springframework.tran= saction.support.TransactionTemplate.execute(TransactionTemplate.java:128)>  =0A  =0A  =0A  =0A =0Aat
> =0Aorg.compass= .spring.device.SpringSyncTransactionGpsDeviceWrapper.index(SpringSyncTransa= ctionGpsDeviceWrapper.java:96)
>  =0A  =0A  =0A  = =0A =0Aat
> =0Aorg.compass.gps.impl.SingleCompassGps$1.buildIndexIfNe= eded(SingleCompassGps.java:133)
>  =0A  =0A  =0A = =0A =0Aat
> =0Aorg.compass.core.lucene.engine.manager.DefaultLuceneS= earchEngineIndexManager$8.firstStep(DefaultLuceneSearchEngineIndexManager.j= ava:233)
>  =0A  =0A  =0A  =0A =0Aat
> =0Ao= rg.compass.core.lucene.engine.manager.DefaultLuceneSearchEngineIndexManager= .doOperate(DefaultLuceneSearchEngineIndexManager.java:182)
>
><= br>>
>
>
> =0A----- =0AOriginal =0AMessage =0A----
= > =0AFrom: =0ANathan =0AMaves =0A<nathan.maves@gmail.com= >
> =0ATo: =0Auser-java@ibatis.apache.org>
> =0ASent: =0ASaturday, =0AMarch =0A15, =0A2008 =0A5:43:04 =0A= PM
> =0ASubject: =0ARe: =0Aselect =0A* =0Acausing =0A" =0AOutOfMemory= Error: =0AJava =0Aheap =0Aspace"
>
>  =0Athis =0Ais =0Aonl= y =0Amy =0A2 =0Acents =0Abut =0AI =0Awould =0Athrow =0Athat =0Aclass =0Aout= .  =0AWrite =0Ayour =0Aown
> =0Aimplementation =0Awhich =0Auses = =0Aa =0Arow =0Ahandler.  =0AThis =0Ais =0Athe =0Atype =0Aof =0Asituati= on =0Ain
> =0Awhich =0Aa =0Arow =0Ahandler =0Acould =0Areally =0Ahelp= .  =0Aalmost =0Ano =0Amemory =0Awould =0Abe =0Aused.
>
>>
> =0AOn =0AThu, =0AMar =0A13, =0A2008 =0Aat =0A4:57 =0APM, =0A= nch =0A<underscore_dot@yahoo.com> =0Awrote:
> = =0A>
> =0A> =0AYes, =0AI =0Aagree =0Athat =0Adividing =0Athe = =0Aquery =0Ainto =0Aseveral =0Aqueries =0Ashould =0Ado =0Aas
> =0Alon= g =0Aas =0Anone =0Aof =0Athem =0Auses =0Amore =0Amemory =0Athan =0Aavailabl= e. =0AGracias, =0ACarlos.
> =0A>
> =0A> =0ANevertheless, = =0AI =0Alooked =0Ainto
> =0Aorg.compass.gps.device.ibatis.SqlMapClien= tGpsDevice#doIndex =0Aand,
> =0Afundamentally, =0Awhat =0Ait =0Adoes = =0Ais =0Aa =0AqueryForPaginatedList =0Aand =0Aiterates =0Athrough
> = =0Athe =0Aresulting =0APaginatedList =0Awith =0AnextPage()
> =0A><= br>> =0A> =0AI =0Aguess =0Athat =0Athe =0Areason =0Awhy =0Apages =0Aa= re =0Akept =0Ain =0Amemory =0Aafter =0Aperforming
> =0ApaginatedList.= nextPage() =0Ais =0Abecause =0Aa =0ApaginatedList.previousPage() =0Acan =0A= be
> =0Aissued =0Abut, =0Ashould't =0Ait =0Afree =0Apages =0Aif =0Ahe= ap =0Aspace =0Ais =0Arunning =0Aout?
> =0A>
> =0A>
>= ; =0A> =0ACarlos =0Ade =0ALuna =0ASaenz =0A<cdelunasae= nz@yahoo.com.mx> =0Awrote:
> =0A>
> =0A> =0ASince = =0Awe =0Ahave =0Aa =0Asimilar =0Atrouble =0Aaround =0Ahere =0Ai =0Amust =0A= say =0Athat =0Ayou =0Ahave =0Alot
> =0Aof =0Aoptions =0Awhen =0Agoing= =0Ato =0Acompass..
> =0A> =0AThe =0Afirst =0Aone =0Ais =0Ato =0Ai= ndex =0A"object =0Aby =0Aobject" =0Aby =0Ahand, =0Athe =0Asecond =0Aone =0A= is =0Ato
> =0Ause =0Athe =0AGps =0Awich =0Awill =0Ause =0Athe =0Acomp= lete =0Abunch =0Aof =0Adata =0Aand =0Amake =0Asubindexes
> =0A(making= =0Aparts =0Aof =0Ayour =0A"main =0Aindex" =0Awith =0Adiferent =0A"maps" = =0Afor =0Aeach =0Asubindex =0Ain
> =0Ayour =0AgpsDriver.
> =0A&= gt; =0Aif =0Ayour =0Aindexing =0Ais =0Aas =0Astrong =0Aas =0Aours =0Ai =0As= hould =0Alook =0Aforward =0Afor =0Anumer =0A1 =0Aor
> =0Anumber =0A3 = =0Adepending =0Aof =0Ayour =0Aneeds. =0A(More =0Aa =0ACompass =0Athan =0AiB= atis =0Aissue)
> =0A> =0AGreetings
> =0A> =0ACarlos =0Ade= =0ALuna
> =0A>
> =0A> =0A----- =0AMensaje =0Aoriginal = =0A----
> =0A> =0ADe: =0Anch
> =0A>
> =0A> =0APa= ra: =0Auser-java@ibatis.apache.org; =0Ala= rry.meadors@gmail.com
> =0A> =0AEnviado: =0Ajueves, =0A13 =0Ad= e =0Amarzo, =0A2008 =0A9:37:04
> =0A> =0AAsunto: =0ARe: =0Aselect = =0A* =0Acausing =0A" =0AOutOfMemoryError: =0AJava =0Aheap =0Aspace"
>= =0A>
> =0A>
> =0A> =0ASorry. =0AYes, =0AI =0Aneed =0A= all =0Athe =0Adata =0Aat =0Aone =0Atime, =0Abecause =0Athe =0ACompass =0AAP= I =0Aseems
> =0Ato =0Abe =0Ameant =0Ain =0Athat =0Away.
> =0A&g= t;
> =0A> =0ALarry =0AMeadors =0Awrote: =0AOK, =0Aso =0Athe =0Aans= wer =0Ato =0Athe =0Aquestion =0Ais...[ =0Ayes, =0Ai =0Aneed
> =0Aall = =0Athe =0Adata =0Aat
> =0A>
> =0A>
> =0A>
>= ; =0A> =0Aone =0Atime =0A| =0Ano, =0Ai =0Ado =0Anot =0Aneed =0Aall =0Aof= =0Athe =0Adata =0Aat =0Aone =0Atime =0A].
> =0A>
> =0A> = =0ALarry
> =0A>
> =0A>
> =0A> =0AOn =0AThu, =0AM= ar =0A13, =0A2008 =0Aat =0A9:04 =0AAM, =0Anch =0Awrote:
> =0A> =0A= >
> =0A> =0A> =0AHi!
> =0A> =0A>
> =0A>= =0A> =0AI'm =0Adoing =0Atests =0Aboth =0Aunder =0Atomcat =0Aand =0Ajett= y. =0AI =0Aset =0A1024MB =0Aof =0Aheap =0Aspace
> =0Ain
> =0A&g= t; =0A> =0Aboth =0Acases. =0AI =0Aam =0Ausing =0Aa =0Aprofiler =0Ato =0A= look =0Ainto =0Awhat's =0Ahappening =0Aduring
> =0A> =0A> =0Aex= ecution =0Aof =0Athe =0Aindexing =0Aprocess =0Aand =0AI =0Acan =0Atell =0At= hat's =0Athe =0Aexact =0Aamount
> =0Ait
> =0A> =0A> =0Adi= splays =0Afor =0Athe =0AVM.
> =0A> =0A>
> =0A> =0A>= =0AAs =0AI =0Adescribe =0Ain =0Athe =0ACompass =0Auser =0Aforum =0A(see = =0Alink =0Abellow), =0AI'm =0Aindexing
> =0Aa
> =0A> =0A>= =0AWikipedia =0Adump =0Aof =0Aabout =0A650000-675000 =0Arecords. =0AThat's= =0Asort =0Aof =0A1-1.5GB =0Aof
> =0A> =0A> =0Adata.
> = =0A> =0A>
> =0A> =0A> =0AHibernate =0Acan =0Ahandle =0Aal= l =0Athat =0Adata, =0AI =0Aguess =0Ait's =0Ausing =0Asome =0Asort =0Aof
= > =0A> =0A> =0Apagination. =0AiBatis =0Aseems =0Ato =0Adivide =0At= he =0Aselect =0Astatement =0Ainto =0Aseveral
> =0Aselect
> =0A&= gt; =0A> =0Astatements, =0Abut =0Ait =0Aalso =0Aseems =0Aeach =0Aof =0As= uch =0Astatements =0Asurpasses =0Athe
> =0Alimit =0Aof
> =0A>= ; =0A> =0A1024MB =0Awhen =0Atrying =0Ato =0Aindex =0Aonly =0A300000 =0Ao= f =0Athe =0Adatabase =0Arecords.
> =0A> =0A>
> =0A> = =0A> =0AThank =0Ayou
> =0A> =0A>
> =0A> =0A>
= > =0A> =0A>
> =0A> =0A> =0AChris =0ALamey =0Awrote:> =0A> =0A> =0AWhat =0Ais =0Ayou =0AJVM =0Aheap =0Asize =0Aset = =0Ato =0Aand =0Ahow =0Amuch =0Adata =0Ais =0Areturned =0Aby =0Aselect
&g= t; =0A*
> =0A> =0A> =0Afrom =0Atable?
> =0A> =0A>> =0A> =0A> =0AIf =0Ayou're =0Atrying =0Ato =0Apull =0Aback =0A1= G =0Aworth =0Aof =0Adata =0Ainto =0Aa =0AJVM =0Awith =0Aa =0Aheap
> = =0Asize
> =0A> =0A> =0Aset =0Ato =0A64M, =0Ayou =0Awill =0Ahit = =0Athe =0Aheap =0Alimit =0Apretty =0Aquick.
> =0A> =0A>
>= =0A> =0A>
> =0A> =0A> =0A-----Original =0AMessage-----> =0A> =0A> =0AFrom: =0Anch =0A[mailto:underscore= _dot@yahoo..com]
> =0A> =0A> =0ASent: =0AThu =0A3/13/2008 = =0A8:03 =0AAM
> =0A> =0A> =0ATo: =0Auser-jav= a@ibatis.apache.org
> =0A> =0A> =0ASubject: =0Aselect =0A* = =0Acausing =0A" =0AOutOfMemoryError: =0AJava =0Aheap =0Aspace"
> =0A&= gt; =0A>
> =0A> =0A>
> =0A> =0A> =0AHi, =0Aevery= body.
> =0A> =0A> =0AI'm =0Atesting =0Athe =0ACompass =0Asearch= =0Aengine =0Aand, =0Ain =0Aparticular, =0Ahow =0Ato =0Aindex =0Aa
> = =0Abig
> =0A> =0A> =0Aset =0Aof =0Adocuments =0Afrom =0Aa =0Ata= ble =0Ain =0Aa =0AMySQL =0Adatabase. =0AIn =0Aorder =0Ato =0Ado =0Athis =0A= I
> =0A> =0A> =0Aissue =0Aa =0A"select =0A* =0Afrom =0Atable_na= me" =0Ausing =0AiBatis, =0Abut =0Athis =0Aseems =0Ato =0Abe
> =0A>= =0A> =0Acausing =0Athe =0Aapplication =0Ato =0Ause =0Aall =0Aheap =0Asp= ace =0Aavailable.
> =0A> =0A> =0AI =0Aadded =0Aa =0Anew =0Aentr= y =0Ainto =0ACompass =0Auser =0Aforum =0Awith =0Adetails:
> =0A> = =0A> =0Ahttp://forum.compass-project.org/thread.jspa?t= hreadID=3D215278
> =0A> =0A>
> =0A> =0A> =0ACan= =0Ayou =0Afigure =0Aout =0Awhy =0Ais =0Athis =0Ahappening?
> =0A>= =0A>
> =0A> =0A> =0AMany =0Athanks
> =0A> =0A><= br>> =0A> =0A>
> =0A> =0A> =0A------------------------= ---------
> =0A> =0A> =0ABe =0Aa =0Abetter =0Afriend, =0Anewsho= und, =0Aand =0Aknow-it-all =0Awith =0AYahoo! =0AMobile. =0ATry
> =0Ai= t
> =0A> =0A> =0Anow.
> =0A> =0A>
> =0A> = =0A>
> =0A> =0A>
> =0A> =0A>
> =0A> =0A= > =0A________________________________
> =0A> =0A> =0ANever = =0Amiss =0Aa =0Athing. =0AMake =0AYahoo =0Ayour =0Ahomepage.
> =0A>= ;
> =0A>
> =0A> =0ANever =0Amiss =0Aa =0Athing. =0AMake = =0AYahoo =0Ayour =0Ahomepage.
> =0A>
> =0A>
> =0A&g= t;
> =0A>
> =0A>
> =0A>
> =0A>
> = =0A________________________________________________________________________= ____________
> =0A> =0A=A1Capacidad =0Ailimitada =0Ade =0Aalmacena= miento =0Aen =0Atu =0Acorreo!
> =0A> =0ANo =0Ate =0Apreocupes =0Am= =E1s =0Apor =0Ael =0Aespacio =0Ade =0Atu =0Acuenta =0Acon =0ACorreo =0AYaho= o!:
> =0A> =0Ahttp://correo.espanol.yahoo.com/
> =0A>
> = =0A>
> =0A>
> =0A>
> =0A>
> =0A>
= > =0A>
> =0A> =0A________________________________
> = =0ANever =0Amiss =0Aa =0Athing. =0AMake =0AYahoo =0Ayour =0Ahomepage.
&g= t;
>
>
>
>  =0A_______________________________= _
> =0ANever =0Amiss =0Aa =0Athing. =0AMake =0AYahoo =0Ayour =0Ahomep= age.


=0A
Be a better friend,= newshound, and =0Aknow-it-all with Yahoo! Mobile. Try it now. --0-446887192-1205662332=:99664-- --0-748427719-1205662332=:99664 Content-Type: text/x-java; name="SqlMapClientGpsDeviceRowHandler.java" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="SqlMapClientGpsDeviceRowHandler.java" cGFja2FnZSBvcmcubXlvcmcuY29tcGFzczsNCg0KaW1wb3J0IG9yZy5hcGFj aGUuY29tbW9ucy5sb2dnaW5nLkxvZzsNCmltcG9ydCBvcmcuYXBhY2hlLmNv bW1vbnMubG9nZ2luZy5Mb2dGYWN0b3J5Ow0KaW1wb3J0IG9yZy5jb21wYXNz LmNvcmUuQ29tcGFzc1Nlc3Npb247DQoNCmltcG9ydCBjb20uaWJhdGlzLnNx bG1hcC5jbGllbnQuZXZlbnQuUm93SGFuZGxlcjsNCg0KcHVibGljIGNsYXNz IFNxbE1hcENsaWVudEdwc0RldmljZVJvd0hhbmRsZXIgaW1wbGVtZW50cyBS b3dIYW5kbGVyIHsNCglwcml2YXRlIHN0YXRpYyBmaW5hbCBMb2cgbG9nID0g TG9nRmFjdG9yeS5nZXRMb2coU3FsTWFwQ2xpZW50R3BzRGV2aWNlUm93SGFu ZGxlci5jbGFzcyk7DQoJcHJpdmF0ZSBDb21wYXNzU2Vzc2lvbiBzZXNzaW9u Ow0KCXByaXZhdGUgaW50IHBhZ2VTaXplOw0KCXByaXZhdGUgaW50IHBhZ2VD b3VudD0gMDsNCglwcml2YXRlIGludCBjdXJyZW50SXRlbT0gMTsNCgkNCglw dWJsaWMgU3FsTWFwQ2xpZW50R3BzRGV2aWNlUm93SGFuZGxlcihDb21wYXNz U2Vzc2lvbiBzZXNzaW9uLCBpbnQgcGFnZVNpemUpew0KCQl0aGlzLnNlc3Np b249IHNlc3Npb247DQoJCXRoaXMucGFnZVNpemU9IHBhZ2VTaXplOw0KCX0N CgkNCglwdWJsaWMgdm9pZCBoYW5kbGVSb3coT2JqZWN0IG8pIHsNCgkJc2Vz c2lvbi5jcmVhdGUobyk7DQoJCWlmKGN1cnJlbnRJdGVtPT0gcGFnZVNpemUp ew0KCSAgICAgICAgaWYgKGxvZy5pc0RlYnVnRW5hYmxlZCgpKSB7DQoJICAg ICAgICAgICAgbG9nLmRlYnVnKCJJbmRleGluZyBwYWdlIG51bWJlciBbIisg cGFnZUNvdW50KysgKyAiXSIpOw0KCSAgICAgICAgfQ0KCQkJc2Vzc2lvbi5l dmljdEFsbCgpOw0KCQl9DQoJCWN1cnJlbnRJdGVtPSAoY3VycmVudEl0ZW0l IHBhZ2VTaXplKSsgMTsgDQoJfQ0KDQp9DQoK --0-748427719-1205662332=:99664--