-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: OutOfMemory Error while using HSQLDB
PostPosted: Mon Jul 04, 2005 9:22 am 
Beginner
Beginner

Joined: Wed Jul 21, 2004 7:48 am
Posts: 21
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.