Re: OutOfMemoryError

2009-03-11 Thread Sundar Sankar
I have had OOM, when there was too much of data being retrieved by Ibatis. with 2000+ statements, I see that as one of the possibility. My heap was holding up for X amount of data, and I had a hack to loop it when more than X was there. Increasing the heap helped me too. -Sundar On Wed, Mar 11, 2

Re: OutOfMemoryError

2009-03-11 Thread Kengkaj Sathianpantarit
Try to increase java heap space by using -Xmx option. Best Regards, Kengkaj email: kengkaj.s at gmail dot com On Tue, Mar 10, 2009 at 7:30 PM, Ben Shory wrote: > Hi, > I have ~2000 statements spread over a few hundreds of sqlmap.xml > As soon as I init the SqlMapClient I get: > > Exception in t

OutOfMemoryError

2009-03-10 Thread Ben Shory
Hi, I have ~2000 statements spread over a few hundreds of sqlmap.xml As soon as I init the SqlMapClient I get: Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOfRange(Arrays.java:3209) at java.lang.String.(String.java:216) at

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-18 Thread Christopher Lamey
!! > > Clinton, you've been really helpful. > Lots of thanks to you and all people in this mailing list. > > - Original Message > From: Clinton Begin <[EMAIL PROTECTED]> > To: user-java@ibatis.apache.org > Sent: Tuesday, March 18, 2008 6:45:28 PM > Subject

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-18 Thread Clinton Begin
> > > > > > Regarding your previous mail: > - I emptied the handleRow method and ran the test - same result. The > exception occurs before handleRow is invoked. > - I'm not configuring any caches. Is there a default one? Should I config one? >

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-18 Thread Leon Liu
(including you) have successfully made it with large amounts of data (I'm new to iBatis and Compass/Lucene) so I'm sure there's a solution. Lots of thanks. - Original Message From: Clinton Begin <[EMAIL PROTECTED]> To: user-java@ibatis.a

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-18 Thread nch
Yes, I am using the same driver. - Original Message From: Nathan Maves <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Tuesday, March 18, 2008 3:56:40 PM Subject: Re: select * causing " OutOfMemoryError: Java heap space" Are we absolutely positive that we ar

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-17 Thread Clinton Begin
nts > > by configuring what they call a GPS Device. You can do that through an ORM > > such as iBatis, Hibernate or JPA. > > > > Compass provides an implementation of such a GPS Device called > > SqlMapClientGpsDevice which uses iBatis queryForPaginatedList to get the >

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-17 Thread Clinton Begin
evice which uses iBatis queryForPaginatedList to get the > results of a query and, so, index them. The query is just a "select * from > articles_table". > > So I wired everything up and ran several tests with different amounts of > data to be indexed and JVM stack space size

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-17 Thread nch
e results of a query and, so, index them. The query is just a "select * from articles_table". So I wired everything up and ran several tests with different amounts of data to be indexed and JVM stack space sizes. The result was an "OutOfMemoryError: java heap space" error me

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-17 Thread Clinton Begin
:18:42 PM > Subject: Re: select * causing " OutOfMemoryError: Java heap space" > > > Well, I modified the mediumblob into a mediumtext and removed all other > fields except the id one. > > - Original Message > From: nch <[EMAIL PROTECTED]> > To: user-jav

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-16 Thread nch
Re: select * causing " OutOfMemoryError: Java heap space" Well, I modified the mediumblob into a mediumtext and removed all other fields except the id one. - Original Message From: nch <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Sunday, March 16, 2008 10:0

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-16 Thread nch
Well, I modified the mediumblob into a mediumtext and removed all other fields except the id one. - Original Message From: nch <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Sunday, March 16, 2008 10:06:34 PM Subject: Re: select * causing " OutOfMemoryError: Java

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-16 Thread nch
e From: Larry Meadors <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Sunday, March 16, 2008 4:19:43 PM Subject: Re: select * causing " OutOfMemoryError: Java heap space" Yeah, I just noticed that - it looks like it's failing in the jdbc driver when it tries to read a blob

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-16 Thread Larry Meadors
BC driver is failing when executing the query. Larry On Sun, Mar 16, 2008 at 4:12 AM, nch <[EMAIL PROTECTED]> wrote: > > > Sure. Please, see attached. > I don't think the problem is in the RowHandler, though, because the > OutOfMemoryError occurs before invoking RowHandle

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-16 Thread nch
Sure. Please, see attached. I don't think the problem is in the RowHandler, though, because the OutOfMemoryError occurs before invoking RowHandle#handleRow. Cheers - Original Message From: Larry Meadors <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Sunday, March

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-15 Thread Larry Meadors
rate(DefaultLuceneSearchEngineIndexManager.java:182) > > > > > > - Original Message > From: Nathan Maves <[EMAIL PROTECTED]> > To: user-java@ibatis.apache.org > > Sent: Saturday, March 15, 2008 5:43:04 PM > Subject: Re: select * causing " OutOfMem

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-15 Thread nch
batis.apache.org Sent: Saturday, March 15, 2008 5:43:04 PM Subject: Re: select * causing " OutOfMemoryError: Java heap space" this is only my 2 cents but I would throw that class out. Write your own implementation which uses a row handler. This is the type of situation in which a row

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-15 Thread Nathan Maves
depending of your needs. (More a Compass than iBatis issue) > Greetings > Carlos de Luna > > - Mensaje original > De: nch > Para: user-java@ibatis.apache.org; [EMAIL PROTECTED] > Enviado: jueves, 13 de marzo, 2008 9:37:04 > Asunto: Re: select * causing " OutOfMe

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread nch
je original De: nch Para: user-java@ibatis.apache.org; [EMAIL PROTECTED] Enviado: jueves, 13 de marzo, 2008 9:37:04 Asunto: Re: select * causing " OutOfMemoryError: Java heap space" Sorry. Yes, I need all the data at one time, because the Compass API seems to be meant in that w

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread Carlos de Luna Saenz
EMAIL PROTECTED]> Para: user-java@ibatis.apache.org; [EMAIL PROTECTED] Enviado: jueves, 13 de marzo, 2008 9:37:04 Asunto: Re: select * causing " OutOfMemoryError: Java heap space" Sorry. Yes, I need all the data at one time, because the Compass API seems to be meant in that way. Larry

RE: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread Chris McMahon
What does the actual SQL statement and corresponding ResultMap look like that you're trying to execute? Date: Thu, 13 Mar 2008 08:04:29 -0700 From: [EMAIL PROTECTED] Subject: RE: select * causing " OutOfMemoryError: Java heap space" To: user-java@ibatis.apache.org Hi! I

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread nch
; What is you JVM heap size set to and how much data is returned by select * > from table? > > If you're trying to pull back 1G worth of data into a JVM with a heap size > set to 64M, you will hit the heap limit pretty quick. > > > -Original Message- > From: nch [m

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread nch
So iBatis does't have any sort of pagination mechanism to avoid filling up the heap in this sort of situations? In such case I should try to implement my own pagination or try to use Hibernate only for this purpose. Thank you Larry Meadors <[EMAIL PROTECTED]> wrote: Do you need to have *all* o

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread Larry Meadors
gt; If you're trying to pull back 1G worth of data into a JVM with a heap size > set to 64M, you will hit the heap limit pretty quick. > > > -Original Message- > From: nch [mailto:[EMAIL PROTECTED] > Sent: Thu 3/13/2008 8:03 AM > To: user-java@ibatis.apache.org > S

RE: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread nch
to pull back 1G worth of data into a JVM with a heap size set to 64M, you will hit the heap limit pretty quick. -Original Message- From: nch [mailto:[EMAIL PROTECTED] Sent: Thu 3/13/2008 8:03 AM To: user-java@ibatis.apache.org Subject: select * causing " OutOfMemoryError: Java heap sp

Re: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread Larry Meadors
Do you need to have *all* of the rows in memory at one time? Larry On Thu, Mar 13, 2008 at 8:03 AM, nch <[EMAIL PROTECTED]> wrote: > > Hi, everybody. > I'm testing the Compass search engine and, in particular, how to index a big > set of documents from a table in a MySQL database. In order to do

RE: select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread Chris Lamey
3/13/2008 8:03 AM To: user-java@ibatis.apache.org Subject: select * causing " OutOfMemoryError: Java heap space" Hi, everybody. I'm testing the Compass search engine and, in particular, how to index a big set of documents from a table in a MySQL database. In order to do thi

select * causing " OutOfMemoryError: Java heap space"

2008-03-13 Thread nch
Hi, everybody. I'm testing the Compass search engine and, in particular, how to index a big set of documents from a table in a MySQL database. In order to do this I issue a "select * from table_name" using iBatis, but this seems to be causing the application to use all heap space available. I a