Your out of memory error is likely due to a mysql bug outlined here:
http://bugs.mysql.com/bug.php?id=7698
Thanks for the article. My query executed in no time without any errors !!!
The MySQL drivers are horrible at dealing with large result sets - that
article gives you the workaround to
st leaking memory/resources somewhere. For example, ResultSet's
and other DB operations should typically be placed in a try/catch/FINALLY
block, where the finally block ensures all DB resources are
closed/released.
Otis
- Original Message
From: Rahil <[EMAIL PROTECTED]>
To: Luce
Subject
> > Please respond to Re: OutOfMemory and IOException
> > [EMAIL PROTECTED] Access Denied errors
> > apache.org
> >
> >
> >
> &
here the finally block ensures all DB resources are
closed/released.
Otis
----- Original Message
From: Rahil <[EMAIL PROTECTED]>
To: Lucene User Group
Sent: Friday, May 19, 2006 8:27:55 AM
Subject: OutOfMemory and IOException Access Denied errors
Hi
I am new to Lucene so am perhaps
are
closed/released.
Otis
- Original Message
From: Rahil <[EMAIL PROTECTED]>
To: Lucene User Group
Sent: Friday, May 19, 2006 8:27:55 AM
Subject: OutOfMemory and IOException Access Denied errors
Hi
I am new to Lucene so am perhaps missing something obvious. I have
included Lucene 1.
d/released.
Otis
- Original Message
From: Rahil <[EMAIL PROTECTED]>
To: Lucene User Group
Sent: Friday, May 19, 2006 8:27:55 AM
Subject: OutOfMemory and IOException Access Denied errors
Hi
I am new to Lucene so am perhaps missing something obvious. I have
included Lucene 1.9.1
Hi
I am new to Lucene so am perhaps missing something obvious. I have
included Lucene 1.9.1 in my classpath and am trying to integrate it with
MySQL.
I have a table which has near a million records in it. According to the
documentation on Lucene I have read so far, my understanding is that
Hi
I am new to Lucene so am perhaps missing something obvious. I have included
Lucene 1.9.1 in my classpath and am trying to integrate it with MySQL.
I have a table which has near a million records in it. According to the documentation on Lucene I have read so far, my understanding is that I ne