I'm attempting to configure an embedded HSQL database in a maven/hibernate project for unittesting. For "production mode", I have configured an Oracle database, with works fine (I can add, delete, etc.).
For unit testing, I first tried specifying in the spring config file:
schema.sql contains SQL for creating all of the tables and sequences. When running, I get errors saying the tables already exist. OK, I remove that line and have just:
When I run that, I get "user lacks privilege or object not found" when attempting to insert the data found in the "test-data.sql" file. I assume that the tables do exist (since I get the first error message) and I just don't have access. The information I've seen don't seem to imply security credentials are needed for the embedded databases, but I'm not sure about that. I attempted to change the configuration passing credentials like:
But I get the same "user lacks privilege or object not found".
If I remove the jdbc:initialize-database element completely, I get the same "user lacks privilege or object not found" error as the test case is attempting to create a JPA object.
Any idea what I'm doing wrong?
Joined: Mar 30, 2009
Never mind, I got it to work. I needed to add "if not exists" in the creation of the elements. Not sure why, maybe the script is being executed more than once? I don't know...
subject: HSQL embedded database giving "user lacks privilege or object not found"