HSQLDB connection error OutOfMemory

Support
#1

i used: git clone GitHub - cuba-guides/cuba-petclinic-social-login: CUBA Petclinic example: Social Login & Autoregistration
just out of the box an i press run. i already increased the values tenfold in setenv.bat and .sh no change. i have this problem with all cuba project who i get from github. stating en new projects will go without problems.
‘’’
HSQLDB connection error
java.sql.SQLTransientConnectionException: connection exception: connection failure: java.lang.OutOfMemoryError: Java heap space
connection exception: connection failure: java.lang.OutOfMemoryError: Java heap space
‘’’

I also miss the app_home and hsqldb folder in de deploy folder

#2

Hi,
Can you please attach here the full IDE log file idea.log?
It can be found from the main menu: Help -> Show log in explorer.

#7

Had the same problem. As it turns out the OutOfMemoryError occured because the port 9001 was already taken (very unhelpful error message). Changing the hsqldb port solved the problem for me.

To change the port go to CUBA -> Main Data Store Settings.. change localhost to e.g. localhost:48152.

FWIW, Port 9001 is used by the Intel(R) Graphics Command Center Service on Windows.

For future reference, the exact exception message (idea.log) is as follows:

com.haulmont.studio.backend.exceptions.HsqlConnectionException: java.sql.SQLTransientConnectionException: connection exception: connection failure: java.lang.OutOfMemoryError: Java heap space
	at com.haulmont.studio.backend.ed.ddl.DbManager.dbExists(DbManager.java:257)
	at com.haulmont.studio.intellij.project.resolve.CubaProjectResolver$1.run(CubaProjectResolver.java:256)
	at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:935)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcessWithProgressAsync$5(CoreProgressManager.java:442)
	at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$3(ProgressRunner.java:235)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$2(CoreProgressManager.java:170)
	at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:629)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:581)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:60)
	at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:157)
	at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$4(ProgressRunner.java:235)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:668)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:665)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1.run(Executors.java:665)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransientConnectionException: connection exception: connection failure: java.lang.OutOfMemoryError: Java heap space
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
	at com.haulmont.studio.backend.ed.ddl.DbManager.openConnection(DbManager.java:286)
	at com.haulmont.studio.backend.ed.ddl.DbManager.dbExists(DbManager.java:239)
	... 18 more
Caused by: org.hsqldb.HsqlException: connection exception: connection failure: java.lang. : Java heap space
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ClientConnection.execute(Unknown Source)
	at org.hsqldb.ClientConnection.<init>(Unknown Source)
	... 25 more
#9

Thanks, for your feedback! We will improve the error message and add instructions to fix it.