Hello,
I have some large table
wordforms(key INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
key_base INT,
name VARCHAR(50),
type VARCHAR(10),
isProcessed BOOLEAN )
with about 1 300 000 entries.
In my Java program I make query "SELECT key FROM wordforms" to get all
keys.
Executing query causes exception:
Exception in thread "Thread-7" java.lang.OutOfMemoryError: Java heap
space
at org.h2.value.Value.cache(Value.java:338)
at org.h2.value.ValueString.get(ValueString.java:91)
at org.h2.store.DataPage.readValue(DataPage.java:623)
at org.h2.table.TableData.readRow(TableData.java:620)
at org.h2.table.TableData.read(TableData.java:607)
at org.h2.store.DiskFile.getRecord(DiskFile.java:595)
at org.h2.store.Storage.getRecord(Storage.java:94)
at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:258)
at org.h2.index.ScanCursor.next(ScanCursor.java:71)
at org.h2.table.TableFilter.next(TableFilter.java:318)
at org.h2.command.dml.Select.queryFlat(Select.java:491)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:
559)
at org.h2.command.dml.Query.query(Query.java:233)
at org.h2.command.CommandContainer.query(CommandContainer.java:
81)
at org.h2.command.Command.executeQueryLocal(Command.java:141)
at org.h2.command.Command.executeQuery(Command.java:122)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:
75)
// NetBeans error message
I use h2.1.1.111 in embedded mode.
I tried different CACHE_SIZE from CACHE_SIZE=25000 to
CACHE_SIZE=200000
Database includes other tables and it is more than 1.5Gb
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
