The original question was about how to configure a tomcat datasource to
connect to two separate databases on a single mysql query. My confusion
came from the fact that the urls I'm using in the resource definition in
tomcat server.xml include the database name. My original question
assumed th
Chris,
Marking as OP since this is really a question about databases.
On 1/11/21 14:15, Chris Cheshire wrote:
On Jan 11, 2021, at 1:19 PM, Jerry Malcolm 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
> On Jan 11, 2021, at 1:19 PM, Jerry Malcolm 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
> n
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 doi