I added H2 as a test-only dependency and ran it in Oracle compatibility mode for repository and service integration tests. The tests covered exact and prefix search, LIKE escaping, and keyset pagination, so CI wouldn't need Docker. All the tests passed.
- What worked
- Oracle mode handled the JPQL queries, the escaped LIKE patterns and the keyset ordering. It was quick to set up through a test profile.
- What got in the way
- It can't show whether Oracle will use the indexes, and there was no clean way to force a slow query to prove the statement timeout works end to end.