You could try running H2 in server mode, and then connect to that using
your import program. That way it shouldn't use any extra memory in your
"client" program. Then you can tell if it is H2 or something in the
import program that is causing the issue. It will be a bit slower, but
might be helpful for debugging.
Ryan
On 10/06/2011 10:55 PM, Noel Grandin wrote:
Are you sure the problem is H2?
Maybe try using the NetBeans memory profiler
Or the Eclipse Memory Profilter
(both free)
to find out where the memory is going.
-- Noel.
vsaji wrote:
Hi Noel,
The issue I am trying to explain here is, the loading process is
failing even on 1GB heap size.
So is this an expected behavior with file mode, If the H2 is
configured for file mode, ideally the data is getting written into the
file, so the memory usage should be less.
What my programme does.
1) Fetching records from Oracle Data base
2) Inserting into H2 DB in batch mode, batch size is 500.
3) End of every batch I commit the transaction.
Please clarify,
Saji
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
