How to know underlying database name via Spring Data JPA

Question

I am connecting to multiple databases in my spring-boot app using Spring Data JPA by determining which database to connect at runtime. How can I check for validation on which database am I actually connected to on which my queries are running?

Answer 1

Try to get the URL from the Datasource, maybe will do it:

dataSource.getConnection().getMetaData().getURL();

Checkout DatabaseMetaData documentation for complete details.