I am facing a problem while writing a unit test case for a module. The mapping config of one of the object has a Version Property. In production we use Oracle database and the version number is created by a trigger in the database so i have to give generate = always and insert = false for this property as follows.
<version name="recordVersionNumber" column="RECORD_VERSION_NUMBER" generated="always" insert = "false" />
The problem I have is that now I can not write test cases for this object. When I try to save an object in my unit test case which is using the hsqldb hibernate fails to insert because record version number is empty. It is happening because there is no trigger in the hsql db that will generate the version number for us.
Now there are a few solutions that I can think of but I cant figure out how to implement them.
1. In the unit test cases we could set generate = never and insert = true programatically for this mapping. In that case hibernate will generate version number for us and our test cases will pass.
2. Add a trigger to the DB programatically.
3. make recordVersionNumber nullable. This will allow us to insert rows and we can then update the RVN and save the object.

I cant figure out any of the above solution. Any help will be highly appreciated