how to simulate sequence during DAO layer test

Question

I have spring+hibernate project, I want to write Unit test case for DAO layers, Currently I am using HSqldb's in memory DB to test it. (I referred this )

In project, IDs are provided by sequences, As I am using in-memory DB, during test sequence are not presents so it was falling, For workaround, I have created different set of hbm files without sequence(and put them test's resource folder). Is there any better way to handle this, as keeping duplicate hbm file does look good to me. Any suggestion would be appreciated

Answer 1

If you need a sequence in your test database, just create it.

Also, make sure you have the correct database dialect configured with Hibernate.

Consult the following related questions for details:

• Syntax issue with HSQL sequence: `NEXTVAL` instead of `NEXT VALUE`
• SequenceGenerator problem with unit testing in Hsqldb/H2
• "correct" way to select next sequence value in HSQLDB 2.0.0-rc8

Answer 2

Holding complete copies of the HBM files doesn't sound like a good idea (one of the principles I strongly believe in is the "DRY" principle). The solution I'd suggest (unless there's a better solution from the Hibernate side) is to edit the HBM file in the "@before" method, in order to change just the different bits. I'm more of a .Net guy, and I know that in In .Net there's a library called FluentNHibernate that allows the generate (and I assume that also edit existing) hbm at runtime. I'm not sure if there's something similar in Java, but you can also fallback for manipulating the hbm as an XML file.