How to Connect Multiple Spring Data JPA Repositories to Different Data Sources in Spring Boot?-javaTutorial-php.cn

How to Connect Multiple Spring Data JPA Repositories to Different Data Sources in Spring Boot?

Mary-Kate Olsen

Release： 2024-10-24 21:35:31

Original

954 people have browsed it

How to Connect Multiple Spring Data JPA Repositories to Different Data Sources in Spring Boot?

Spring Boot, Spring Data JPA with Multiple DataSources

Connecting multiple repositories to different data sources is possible using Spring Boot and Spring Data JPA. The referenced blog post provides a solution, but here's a more detailed approach:

Configuration:

Create separate configuration classes for each data source. Below are examples for two data sources:

CustomerDbConfig (First Data Source)

<code class="java">@Configuration
@EnableJpaRepositories(
        entityManagerFactoryRef = "customerEntityManager",
        transactionManagerRef = "customerTransactionManager",
        basePackages = {"com.mm.repository.customer"})
public class CustomerDbConfig {

    // Bean definitions for data source, entity manager factory, and transaction manager for first data source
}</code>

Copy after login

OrderDbConfig (Second Data Source)

<code class="java">@Configuration
@EnableJpaRepositories(
        entityManagerFactoryRef = "orderEntityManager",
        transactionManagerRef = "orderTransactionManager",
        basePackages = {"com.mm.repository.order"})
public class OrderDbConfig {

    // Bean definitions for data source, entity manager factory, and transaction manager for second data source
}</code>

Copy after login

Entities:

Define entities (models) for each data source, such as:

<code class="java">@Entity
@Table(name = "customer")
public class Customer {

    // ...
}

@Entity
@Table(name = "order")
public class Order {

    // ...
}</code>

Copy after login

Repositories:

Create repositories for each entity, such as:

<code class="java">public interface CustomerRepository extends JpaRepository<Customer, Integer> {}

public interface OrderRepository extends JpaRepository<Order, Integer> {}</code>

Copy after login

Application (Main Class):

In the main application class, ensure that all necessary beans are created and the Spring application context is set up.

<code class="java">@SpringBootApplication
public class Application {

    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}</code>

Copy after login

Properties:

Configure the two data sources in the application.properties file, including details such as URL, username, password, and driver class name.

<code class="properties"># Customer Data Source
spring.datasource.primary.url=...
spring.datasource.primary.username=...
spring.datasource.primary.password=...
spring.datasource.primary.driverClassName=...

# Order Data Source
spring.datasource.secondary.url=...
spring.datasource.secondary.username=...
spring.datasource.secondary.password=...
spring.datasource.secondary.driverClassName=...</code>

Copy after login

Troubleshooting:

If you encounter exceptions related to missing or duplicate beans, ensure that:

The bean definitions in the configuration classes are unique.
The base packages for each repository are correct.
The data source properties are configured properly in application.properties.
Each @Transactional annotation specifies the correct transaction manager for the respective data source.

The above is the detailed content of How to Connect Multiple Spring Data JPA Repositories to Different Data Sources in Spring Boot?. For more information, please follow other related articles on the PHP Chinese website!