'In Spring Data Jpa, how can I run an SQL union query from two different datasources...?

I need to perform a SQL join of two entities and with different data sources. I have an entity A with datasource A and an entity B with datasource B, and I need to do something like this ...

"select new A(a,b) from A a, B b where a.id = b.id"

I'm using two databases and I have two datasources configuration, one for each

javaspring-boothibernatespring-data-jpa


Solution 1:[1]

You can use middleware like mycat2 to do this.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 cityblack

Related Questions