Connect to in memory Hsql (hypersonic) database wi

Question

I would like to connect to an in-memory HSQL database instance using the hsql DatabaseManager (or the swing version, it doesn't matter) while debugging tests in my IDE (Intellij IDEA 11.1.2).

I have tried as was suggested by this answer, but every time I do so the DatabaseManager process/thread (I don't know which) starts and freezes. If kill/force quit it, the debug session also dies.

How can I do this without the DatabaseManager freezing?

Answer 1

Your Spring/JUnit is starting the database in in-process mode.

Your options would be:

1. Either starting hsqldb in server mode
2. Or starting the DBmanager from your application
3. Or make your breakpoint stop only the current thread, then your databasemanager will not freeze

Answer 2

I think there are two answers to this question.

1. The answer given by Eugenio Cuevas in his comment if you would like to start DatabaseManager in a separate process/thread from your tests.
2. Adding the call to DatabaseManager.main() inside one of your tests if you are running in in-process mode. Make sure you pause execution (i.e., prompt for user input) right after the line where DatabaseManager.main() is called so that the test does not keep executing. See here for the code to start the DatabaseManager.

Answer 3

Please also check if your breakpoint halts all threads. Most debuggers have a setting for this. You can change this setting for this breakpoint to only halt the JUnit test. See also here:

Does a breakpoint halt all threads?