Hibernate version:

1.7.2


Full stack trace of any exception that occurs:

[Server@ca0b6]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@ca0b6]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@ca0b6]: Startup sequence initiated from main() method
[Server@ca0b6]: Loaded properties from [D:\myMachine\STD-CDPOST\Software\bin\s
erver.properties]
[Server@ca0b6]: Initiating startup sequence...
[Server@ca0b6]: Server socket opened successfully in 63 ms.
[Server@ca0b6]: Database [index=0, id=0, db=file:stx, alias=stx] opened sucessfu
lly in 5750 ms.
[Server@ca0b6]: Startup sequence completed in 5828 ms.
[Server@ca0b6]: 2005-07-04 17:23:26.468 HSQLDB server 1.7.2 is online
[Server@ca0b6]: To close normally, connect and execute SHUTDOWN SQL
[Server@ca0b6]: From command line, use [Ctrl]+[C] to abort abruptly
Exception in thread "HSQLDB Connection @8ed465" java.lang.OutOfMemoryError: Java
heap space


Name and version of the database you are using:
HSQL DB 1.7.2


Code is basically a simple 'select...' statement. Number of records in the table from where data is being fetched is 32,000.

I found that all the tables we are using here are memory tables since we have used 'create table....' . If this is the problem 'create cached table...' would help in resolving this problem. We are using SchemaExport to create tables by reading the config files. So how can we create tables with cached enabled. If there is any other causes for this error please let me know.

Thanks in advance,
Mithun