Скачать или смотреть How to Access Two Data Sources in Spring Boot

Learn how to efficiently pull from two data sources in Spring Boot 2.6.6 and configure them separately for seamless database interactions.
---
This video is based on the question https://stackoverflow.com/q/73252233/ asked by the user 'Magitrix Alyxra' ( https://stackoverflow.com/u/12080774/ ) and on the answer https://stackoverflow.com/a/73252682/ provided by the user 'Kayaman' ( https://stackoverflow.com/u/2541560/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: In Spring Boot (v2.6.6), how can I pull from two data sources and have them separately accessible?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Pulling from Two Data Sources in Spring Boot 2.6.6

When working with Spring Boot applications, developers often encounter scenarios where they need to interact with multiple databases. This is particularly true in environments where different systems store data across separate databases. If you find yourself needing to access two data sources simultaneously in Spring Boot, especially when they run on an Oracle WebLogic server, you might run into some hurdles. This post will guide you through the process of configuring two data sources and utilizing them within your application.

Problem Overview

In your case, the challenge involves the following:

You have two databases accessible via JNDI.

You need to pull data from both at the same time.

You're encountering issues when trying to use -Qualifier to distinguish between the two data sources.

Errors like NoSuchBeanDefinitionException suggest that Spring is unable to find the correct beans you've defined.

Solution Steps

The solution to successfully access both data sources involves creating dedicated JdbcTemplate instances for each data source. This ensures that each data source can be accessed separately without Spring autowiring conflicts. Here are the steps to implement this:

Step 1: Define Your Data Sources

Start by configuring your two data sources in a configuration class. This will involve defining beans for each data source using JNDI.

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Create JdbcTemplate Instances

Next, create JdbcTemplate beans configured with the respective data sources. This will help you use the correct JdbcTemplate for each database interaction:

[[See Video to Reveal this Text or Code Snippet]]

Step 3: Injecting JdbcTemplates into Your Service

In your service class, you will now inject the correct JdbcTemplate using the -Qualifier annotation to differentiate between them.

[[See Video to Reveal this Text or Code Snippet]]

Key Takeaways

Each Database Needs a JdbcTemplate: By configuring separate JdbcTemplate instances for each data source, you can avoid conflicts caused by the -Primary annotation.

Use -Qualifier for Autowiring: The -Qualifier annotation is essential for indicating which bean to inject when there are multiple candidates.

Spring’s Autowiring Works Best with Proper Configuration: Ensure that your beans are correctly configured to allow Spring to manage them effectively.

Conclusion

Accessing multiple data sources in a Spring Boot application can be challenging, but with the right configuration, it’s entirely achievable. By defining separate DataSource and JdbcTemplate instances and utilizing -Qualifier for specific injection, you can successfully interact with different databases in your application.

With this guide, you're now equipped to handle multiple data sources efficiently in Spring Boot 2.6.6. Happy coding!