Can i load username and password by file in spring boot + hibernate?

Question

I want to use spring boot, oracle db and hibernate. I want to load username and password for oracle db schema by two files( user.txt and password.txt). Can i use hibernate? I don't know how to load the username and the password from file in application.properties for hibernate. (spring.datasource.username = load from user.txt, spring.datasource.password = load from password.txt). User and password are encrypted in files.

Does anyone have an idea how i do that?

There are way better approaches to hide your passwords https://stackoverflow.com/questions/37404703/spring-boot-how-to-hide-passwords-in-properties-file — J-Alex, Feb 01 '19 at 11:22

score 2 · Accepted Answer · answered Feb 01 '19 at 11:13

2

There are several ways to do it but using property files, not txt files. If you are willing to follow this approach your options are:

@PorpertySources in your configuration class. An example is

@PropertySources({
        @PropertySource("/user.properties"),
        @PropertySource("/password.properties")
}). 
@Configuration
public configClass{
    @Value("{db.user}")
    private String user;
    @Value("{db.password}")
    private String password;
    ...
}

db.user and db.password must be defined in your config files. With these data you can define your data source (you will need the connection url as well )

If you are using hibernate configuration file you can find an example in this answer: How to read database configuration parameter using properties file in hibernate

answered Feb 01 '19 at 11:13

Jose Luis

254
2
11

Thanks, but user and password are encrypted in files, and i need two different files for user and password. – Alex Vasilescu Feb 01 '19 at 12:49
In that case I guess you will need to create your coustom proper source. You have to create a class extending PropertySource – Jose Luis Feb 01 '19 at 13:04
Thanks, i will try this! – Alex Vasilescu Feb 01 '19 at 13:09
Hope it helps. :) – Jose Luis Feb 01 '19 at 16:50

score 0 · Answer 2 · answered Feb 01 '19 at 11:09

Just add another application.properties outside of the .jar, which includes the database information. See spring docs -> https://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-external-config.html

Place your application.properties outside of your packaged jar file. Spring Boot will look in the same directory for properties and the values can be accessed as if the file was inside the classpath.

Can i load username and password by file in spring boot + hibernate?

2 Answers2