Out of memory with Hypersonic?

[gfh99]

Hi,

we recently got some errors regarding being out of memory with jasper (when trying to recompile jsps). Now, after a reboot, the system stops at:


[JdbcProvider] Starting
[JdbcProvider] Started
[XADataSourceLoader] Starting
[InstantDS] XA Connection pool InstantDS bound to java:/InstantDB

[ typed from memory - the last line could be HypersonicDS instead of InstantDS ]

My feeling is that we'fve reached some sort of memory limit. Has anyone else had this problem?

Gary

[gregie]

I ran into the same kind of trouble. The trick is, the InstantDB uses a script (default.script?) to keep track of its state, and to be able to faithfully recreate the state after it was shut down. This script basically logs every SQL transaction. I once had it grow to 0.7 GB (or some such thing), which was all the free space I had left on the C: drive. Of course, going through the whole thing at startup again takes ages...

Hope this helps,
Gregor

[mattbishop]

Hypersonic can store it's tables on disk rather than using the script file. However, the tables have to be created to do so at the beginning with CREATE CACHED TABLE.

I'm looking for a way to configure this, any ideas?

[davidjencks]

The simplest thing to do would be to modify the code that generates the create table sql.

The next simplest thing to do would be to use a different db that supports standard syntax and the D in ACID at the same time.

[sarva]

> Hypersonic can store it's tables on disk rather than
> using the script file. However, the tables have to
> be created to do so at the beginning with CREATE
> CACHED TABLE.
>
> I'm looking for a way to configure this, any ideas?

I tried creating the table with the 'create cached' option, but still the data was not written to disk to .data files. has anybody successfully configured jboss-hypersonic(data written to disk).

I create the tables through a script file before the beans are deployed.

Thanks,