Re: Abator + Linux

2008-03-13 Thread Zach Visagie
On Wed, 2008-03-12 at 17:29 -0700, slaughter wrote: > Just to be sure that we are talking about the same thing, I talk about a > LINUX UBUNTU 7.10 Gusty installation with a clean Eclipse with spring IDE > and abator. I have been trying during 3 days on 4 different computers (at > job) without any s

Discriminator and Table per subclass

2008-03-13 Thread Eric Andres
Hello, I have a problem writing a polymorphic query. As I am new to iBatis, I started digging the list archive and stumbled upon the discriminator and submap tags, and I also found this in the archives: http://www.mail-archive.com/[email protected]/msg00070.html , my situation is p

Re: Abator + Linux

2008-03-13 Thread Darren Davison
I have to concur with those who don't have a problem. Using linux exclusively at home and work, I don't see this issue at all. Nor is there any reason why I would expect to. On Thu, Mar 13, 2008 at 09:20:25AM +0200, Zach Visagie wrote: > On Wed, 2008-03-12 at 17:29 -0700, slaughter wrote: > > J

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

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

2008-03-13 Thread Chris Lamey
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 [mailto:[EMAIL PROTECTED] Sent: Thu 3/13/

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 nch
Hi! I'm doing tests both under tomcat and jetty. I set 1024MB of heap space in both cases. I am using a profiler to look into what's happening during execution of the indexing process and I can tell that's the exact amount it displays for the VM. As I describe in the Compass user forum (see l

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

2008-03-13 Thread Larry Meadors
OK, so the answer to the question is...[ yes, i need all the data at one time | no, i do not need all of the data at one time ]. Larry On Thu, Mar 13, 2008 at 9:04 AM, nch <[EMAIL PROTECTED]> wrote: > > Hi! > > I'm doing tests both under tomcat and jetty. I set 1024MB of heap space in > both cas

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 nch
Sorry. Yes, I need all the data at one time, because the Compass API seems to be meant in that way. Larry Meadors <[EMAIL PROTECTED]> wrote: OK, so the answer to the question is...[ yes, i need all the data at one time | no, i do not need all of the data at one time ]. Larry On Thu, Mar 13,

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: [email protected] Hi! I'm doing tests both un

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

2008-03-13 Thread Carlos de Luna Saenz
Since we have a similar trouble around here i must say that you have lot of options when going to compass.. The first one is to index "object by object" by hand, the second one is to use the Gps wich will use the complete bunch of data and make subindexes (making parts of your "main index" with

Re: Discriminator and Table per subclass

2008-03-13 Thread Ryan Shelley
Could you use a nested select? Check out page 34, under "Complex Properties": http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf The idea is that one ResultMap contains a complex type that consists of the results from another select. So if tableA has a primary key, and tableB has a f

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

2008-03-13 Thread nch
Yes, I agree that dividing the query into several queries should do as long as none of them uses more memory than available. Gracias, Carlos. Nevertheless, I looked into org.compass.gps.device.ibatis.SqlMapClientGpsDevice#doIndex and, fundamentally, what it does is a queryForPaginatedList and