> On Jan 11, 2021, at 1:19 PM, Jerry Malcolm <[email protected]> wrote:
>
> I have a query that needs to access tables in two different databases on the
> same mysql instance. I see how that can be done with the JOIN syntax in
> mysql. But datasource pools reference a single database, correct? I really
> need to 'join' two datasources for one sql call. I found info on doing this
> by embedding TC in the Spring framework. But I was hoping to not have to do
> a major restructuring. Is there a way to get a connection that attaches to
> two separate databases?
>
>
If the databases are on the same MySQL instance, just adjust the grants for the
user to be able to access tables in both datasources.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
