Join tables from different databases with tomcat datasource

[Jerry Malcolm]

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?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org