Sorry, I didn't look at your mapping and code, it is late at night and I have to wake up early. But more as an FYI, Hypersonic is run in-memory, so when you shut down JBoss all the tables and data will be lost.
An In-Process Mode database is started from JDBC, with the database file path specified in the connection URL. For example, if the database name is testdb and its files are located in the same directory as where the command to run your application was issued, the following code is used for the connection:
Connection c = DriverManager.getConnection("jdbc:hsqldb:file:testdb", "sa", "");
none of this explains why nothing ends up in the DB though ;-) have you checked the file path ? perhaps try something without directories first ? have you turned on SQL logging in hibernate so you see what SQL statements are beeing sent to the DB ?
Joined: Aug 27, 2004
Thanks for the replies.
Mark, I think that "memory" tables (from the HSQLDB preperties) are saved to disk. That's how I interpret the HSQLDB manual (page 6).
Pascal, yes I am using file mode in the connection. Could the path be wrong ? I think it could but I don't get any error in the log. I do have the show SQL option on and the generated SQL looks all right to me based on other examples I have seen in sample projects.
But maybe the path is wrong. I am not very familiar with "relative" path coding. In the Eclipse java project, the HSQLDB jar is included in the classpath as an external jar. The jar is in a folder in C:\Program Files\hsqldb. Is the path is relative to the location of hsqldb.jar ?