28Oct/100
Did the in-memory database integration testing work as expected?
On my previous post about integration testing with an in-memory database without hibernate I was in the process of finding out which frameworks to use and which in-memory databases to use.
We are now using h2database with Unitils and generated sql schemas for integration testing. H2Database was chosen because it supported most of the syntax and functions/procedures we have in our Firebird database.
The major challenges with this approach is maintainability with the sql schema. I haven't found a good solution for this yet, so we have to update the test schema every time there are changes in the database schema.
Further I will show you a short summary of the setup: