I hope someone here can help with this, this might be a little off-topic.

I currently have a library that is based on hibernate. I would like to write unit tests for this library and use an embedded database to hold data that is inserted/updated/deleted..etc during the tests. The production database that I use is postgres and I am using sequences to generate primary keys (this is one of the problems with embedded databases).

Does anyone know of an embedded database that I can use with hibernate that allows me to take my code as-is and get it to work with an embedded database?

Thanks