CODEWITHSUNDEEP
hsqldbtemporaryin-memory-database
cn1h
cn1h

Reputation: 1248

HSQLDB clear table data after restart

I want to save some temporary data in memory, which should be removed after server shuts down.

There is a temporary table in HSQLDB, but the data is removed immediately after transaction committed, which is too short for me. On the other side, the memory table keeps a script log file and resume the data when server new starts. It takes time and place to maintain such script logs, which are useless for my situation.

what I need is just a type of table, only the table structure is persistent in hard disk, the data and the data operations should only be performed in memory. Otherwise why do I need a in-memory DB instead of mysql?

Is there such type of table in HSQLDB?

thanks

Upvotes: 2

Views: 1034

Answers (1)

fredt
fredt

Reputation: 24352

Create the file: database, then create the tables. Perform SHUTDOWN. Edit the .properties file for the database, add the setting below and save.

files_readonly=true

When you perform your tests with this database, no data is written to disk.

Alternatively, with the latest versions of HSQLDB 2.2.x, you can can specify this property on the connection URL during the tests. For example

jdbc:hsqldb:file:myfilepath;files_readonly=true

Upvotes: 3

Related Questions