Loading Properties from Database using Java Config with Spring Boot

Question

I created a FactoryBean<Properties> as

public final class SystemProperteisFactoryBean implements FactoryBean<Properties> {

    private static final String QUERY = "select * from tb_system_properties";

    private final NamedParameterJdbcTemplate jdbcTemplate;

    public SystemProperteisFactoryBean (DataSource datasource) {
        this.jdbcTemplate = new NamedParameterJdbcTemplate (datasource);
    }

    @Override
    public Properties getObject() {
        Properties result = new Properties();
        jdbcTemplate.query(QUERY,
            (ResultSet rs) -> result.setProperty(rs.getString(1), rs.getString(2));
        return result;
    }

    @Override
    public Class<?> getObjectType() {
        return Properties.class;
    }

    @Override
    public boolean isSingletone() {
        return true;
    }
}

This class worked fine using Spring with XML config, I get DataSource using a JNDI name, and then created proper properties, and then used propertiesPlaceHoldeConfigurer via XML tag.

Now I want to use the same thing in Spring Boot and Java Config.

When I define a ProprtySourcesPlaceHolderConfigurer as a bean (in a static method in a @Configuration class) Spring tries to create this bean before the datasource.

Is there any way to create the datasource before PRopertySourcesPlaceHolderConfigurer?

can you use @PostConstruct to instantiate it?

Ali Akbarpour
– Ali Akbarpour

2018-02-13 11:22:44 +00:00
Commented Feb 13, 2018 at 11:22 — Ali Akbarpour
– Ali Akbarpour, Commented Feb 13, 2018 at 11:22
can you show how you create datasource

yvoytovych
– yvoytovych

2018-02-13 11:37:31 +00:00
Commented Feb 13, 2018 at 11:37 — yvoytovych
– yvoytovych, Commented Feb 13, 2018 at 11:37

yvoytovych · Accepted Answer · 2018-02-13 11:45:07Z

0

Basically you need to take the dependency as a @Bean method parameter this way:

@Configuration
public static class AppConfig {
    @Bean
    public SystemPropertiesFactoryBean systemProperties(DataSource dataSource) {
      return new SystemPropertiesFactoryBean(dataSource);
    }

    @Bean
    public DataSource dataSource() {
      //  return new data source
    }
}

answered Feb 13, 2018 at 11:45

yvoytovych

8714 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Amir Pashazadeh Over a year ago

Could I use the default datasource created by Spring Boot? (the one configured in application.properties)?

yvoytovych Over a year ago

sure, spring will try to find bean by type DataSource here and construct it first, before SystemPropertiesFactoryBean

Amir Pashazadeh Over a year ago

I wanted to use Spring Boot's default DataSource (which is configurable to be JNDI based or created using a connection-pool provider). But it seems it is not possible using Java Config. Because Spring Boot tries to configure a ProprtySourcesPlaceHolderConfigurer before configuring most of the beans including the DataSource.

sujithramanathan · Accepted Answer · 2024-05-09 20:07:47Z

0

I have the similar type of requirement where the properties should get loaded from database and binded to the respective spring beans.

I written the example in the below github repository.

Load Properties from DB

answered May 9, 2024 at 20:07

sujithramanathan

1,26911 silver badges9 bronze badges

Collectives™ on Stack Overflow

Loading Properties from Database using Java Config with Spring Boot

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related