Ask Your Question

how to recover from java.lang.OutOfMemoryError

asked 2018-04-03 07:24:09 +0200

koolninja gravatar image

updated 2018-04-03 07:30:37 +0200

The connection to the data source "store" could not be established.

error in script file line: 117 \SSESIGSTORE-PC\Store\database\mydb java.lang.OutOfMemoryError: Java heap space in statement [SET TABLE PUBLIC."store" INDEX '281841 291945 0 0 5902']

After this error i can't get to open my database. how to recover my database as it has no backup.

windows 10

LibreOffice Version: (x64)

java-Version 8


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-20 06:03:10 +0200

koolninja gravatar image

updated 2018-04-20 06:05:35 +0200

found one solution on search to reduce size of database --- shutdown compact;

and combined to be used with micro. its also helps in loading data faster

Sub Backup (oEvent As Object) 'Button > Execute > event

Dim Context

Dim DB

Dim Conn

Dim Stmt

Dim Result

Dim sSQL As String

Context=CreateUnoService("") '< get the database context(This for odt form database name)

DB=Context.getByName("database name") '<- change database name

Conn=DB.getConnection("","") '<- username & password pair - HSQL default blank


sSQL = "shutdown compact"


End Sub

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-03 07:24:09 +0200

Seen: 43 times

Last updated: Apr 20 '18