Configure @DataJpaTest's Embedded Datasource URL

[SingleShot]

This is a "quality of life" request...

Here's my use case: I want my app configured for Postgres, but I want to run @DataJpaTest tests against HSQLDB using Postgres compatibility mode. I've figured out how to do this by annotating my tests like so

@RunWith(SpringRunner.class)
@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)

And adding the following to src/test/resources/application.properties:

spring.datasource.url=jdbc:hsqldb:mem:mydatabase;sql.syntax_pgs=true

The important tidbit is the ;sql.syntax_pgs=true which turns on Postgres compatibility mode.

I would prefer to not have to add @AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE) to every test or to make a custom annotation, and instead, would like a property that allows me to tweak my embedded test database's connection url, for example spring.test.datasource.url=jdbc:hsqldb:mem:%s;sql.syntax_pgs=true

Thanks!

[snicoll]

There is spring.test.database.connection so I guess spring.test.database.url is doable.

[SingleShot]

Of course, right after posting this I discovered this (in src/test/resources/application.properties) produces what I want without having to add annotations anywhere:

spring.datasource.url=jdbc:hsqldb:mem:mydatabase;sql.syntax_pgs=true
spring.test.database.replace=none

So... feel free to close this ticket as "won't fix" - thanks for considering it!

[snicoll]

There's that, right. I wouldn't use application.properties though, you're potentially shadowing the application.properties you might have in your production resources for that module. But that's a detail.