HSQL OutOfMemoryError

OutOfMemoryError in HSQL

The question

i am using uPortal quick-start 2-3-5,

and the HSQL database that comes with it.

When, i launch HSQL i get the following error message.

hsql:
    [echo] Starting HSQL
    [java] java.lang.OutOfMemoryError

What can i do to make this error go away?

One possible reason can be found in the archive.

Basically, the uPortal.script for some reason fills up with things like

INSERT INTO UP_USER VALUES(0,'system',NULL,NULL,NULL,NULL)

Remove them and you should be fine.

Thanks are due to Anna Prodan for answering this question on the JASIG-PORTAL list.

Another option is to use SQL to delete these rows and reinsert one of them:

DELETE FROM UP_USER WHERE USER_NAME='system'
INSERT INTO UP_USER VALUES (0,'system',NULL,NULL,NULL,NULL)
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.