I cannot be the only person who has this problem, so I am looking for suggestions.
We run our applications on Oracle, but our integration tests use h2 for quick in-memory testing, and the database is created from DDL scripts at the beginning of testing.
The problem is that the use / syntax of some DDL commands is different between Oracle and h2 / hsqldb. For example, today I spent some time before I realized that "grant select on ..." works with sequences in Oracle, but only on tables in h2.
In the previous project, we had an adapter for deleting / translating such erroneous commands, which meant that our test database had a completely different code that we were implementing for prod. While everything has been very thoroughly tested, this means that some problems may not be noticed until very late in the dev loop.
In my last project, I feel that I am going the same way, so that, for sure, others also had to push it.
Any suggestions? We use java / maven, so welcome suitable tips!
source
share