Thank you, that does force a write of the database files. And the database seems to stay at the same size so the space is indeed reused. Unfortunately the shutdown subsequently triggers failures on connections that are pulled out of my connection pool for the same database. So I need to shutdown the database and purge all connections for this database from the pool to force a database write. Is there any other way to force the writes without shutting down the database?
I have tried that approach using hsqldb.files_space=2 in the connection string. In that case the error does not occur but a very strange thing happens: during the first test-run a database.data file is created and the data is written to it. The second run succesfully retrieves the data, drops, recreates and repopulates the tables. But after that any subsequent run does no longer see the tables created during the previous runs. After the first run the database.data file is never touched again. It...
BTW: I am using 2.4.1 for this now.
Well, it has taken some time but I have managed to implement this. But now I get: Access is denied in statement [SET TABLE "PUBLIC"."DEMO" NEW SPACE] Any ideas?
I understand that NEW SPACE is a per table setting. I was just hoping for something...
I understand that NEW SPACE is a per table setting. I was just hoping for something...
Hello Fred. Thanks for the response. I have never compiled HyperSQL from source but...
Some closer observation revealed that database size does not grow linearly but exponentially...
I have finished my tests. HyperSQL can insert records at about 2.5 times the speed...
Some closer observation revealed that that database size does not grow linearly but...
Hello all, I am running some comparisons between HyperSQL (which we currently use...
Ok, clear enough. I will do it that way. Thank you very much for all the info. Cheers,...
Thank you for the explanation. So I should actively do the shutdown from the pool...
What are the consequences if databases are not closed and the server process is shutdown...
Excellent, thank you. Already downloading...
Thank you for the answers. I am very glad to hear this since the results I got so...
I have a couple of questions for which I need to provide some background information....
I have a couple of questions for which I need to provide some background information....
I have a couple of questions for which I need to provide some background information....
I have a couple of questions for which I need to privode some background information....
I have a couple of questions for which I need to privode some background information....
Hello Fred, I wrote the code and did some testing. At first sight things seem to...
That is excellent news Fred, thanks a lot! For now set/getString will do. I can make...
Thank you Fred. We need a way for a PreparedStatement ? parameter that matches a...
Thank you Fred. We need a way for a PreparedStatement ? parameter that matches a...
I know this has been discussed before and that UIDs can be stored using various existing...
Thank you very much! Could this be caused by the page being XML (actually polyglot...
Some additional info: it throws on da.attributesToStyles and when I leave that out...
Hello all, I just downloaded CSSBox 4.7 and the related libraries (JStyleParser,...
Hello all, I just downloaded CSSBox 4.7 and the related libraries (JStyleParser,...