I wrote an Entity Bean using BMP and use Hypersonic as persistence store. I create a few records by calling create() method of the home interface. The trace results shows that the SQL is correct and I am able to retrieve the create records using findByPrimaryKey().
However, once I shutdown the server using Ctrl-C, and restart the server. I cannot find back any previous created records except the last one I created. I tried to check the db folder and found that the .script file seems to have something wrong that records a few identical INSERT lines. It seems all the records added are wrongly replaced by the last record added.
Anybody spot this issue? Any workaround way?
Hmmm.... Is HSQL supposed to write to disk? I thought it was a RAM resident database. Perhaps you could try MySQL.