how can i use two databases with spring-boot

Question

I trying to use two databases in my project so i follow this link:

but just like example i create one Interface and extend CrudRepository

public interface UsuarioRepository extends CrudRepository<TbUsuario, Long>{}

so where i use?

@Bean
@Primary
@ConfigurationProperties(prefix="spring.datasource")
public DataSource primaryDataSource() {
    return DataSourceBuilder.create().build();
}

@Bean
@ConfigurationProperties(prefix="spring.secondDatasource")
public DataSource secondaryDataSource() {
    return DataSourceBuilder.create().build();
}

to specify my datasource??

Here is a good example on how to configure jpa repositories using different datasource and transaction manager — Eduardo Sanchez-Ros
– Eduardo Sanchez-Ros, Commented Jan 14, 2016 at 14:33

Alexandre · Accepted Answer · 2015-08-07 01:42:31Z

1

You need to configure two Datasources, two EntityManagerFactories, and two TransactionManagers. Have a look at section 67.7 Use Two EntityManagers in the Spring Boot docs and 4.1.2. Annotation based configuration in the Spring Data JPA docs. You also need to disable datasource auto configuration in the Application class. An example showing how to put all this stuff together can be found here. Good luck!

edited Aug 7, 2015 at 1:42

answered Jul 29, 2015 at 0:30

Alexandre

365 bronze badges

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

Collectives™ on Stack Overflow

how can i use two databases with spring-boot

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related