Hibernate/Spring framework: path of the database in a configuration file

Question

I am trying to write a simple Hibernate application and I want the SQLite database location to be changed according to an application configuration file.

What I was trying to do was therefore retrieving the path of the database from a text file in the project and putting it inside dbLocation, then running the following piece of code:

Configuration config = new Configuration();
config.setProperty("hibernate.connection.url", "jdbc:sqlite:" + dbLocation);

Is there a better and more "standard" way to do so? I'm using Spring Boot for my application and I just realized there's afile called application.properties. May I use this one maybe? I'm pretty new to both Hibernate and the Spring framework.

Does this answer your question? [Database application.yml for Spring boot from applications.properties](https://stackoverflow.com/questions/33323837/database-application-yml-for-spring-boot-from-applications-properties) — Compass, Jan 13 '20 at 15:28
You can use either .props or .yml for your configuration. Spring Boot will also split between environments so you can potentially use local/dev/qa/prod files selected at start-up time. — Compass, Jan 13 '20 at 15:29

score 0 · Answer 1 · answered Jan 13 '20 at 15:23

In Spring Boot application properties you can externalize your application properties so they are configured/managed outside your application source code.

Once a property is defined in application.properties you can use SpringBoot built-in feature to access the values

@Configuration 
public class ApplicationProperty {

@Value("${prop}")
private String prop;

score 0 · Answer 2 · answered Jan 14 '20 at 00:34

With Spring Boot another way is to use @ConfigurationProperties.

Example from the documentation can be found here

A comparison between @ConfigurationProperties and @Value annotation from the documentation

Feature          @ConfigurationProperties   @Value

Relaxed binding      Yes                     No
Meta-data support    Yes                     No
SpEL evaluation      No                      Yes

Hibernate/Spring framework: path of the database in a configuration file

2 Answers2