single Query for two databases located in different machine

[ktuhin]

Hi,

I need to use 2 MySQL databases in 2 different machines.
How to connect both databases using JDBC and get the two results same time using a single Query.

Any hints or examples would be highly appreciated.

Regards,

[r035198x]

Hi,

I need to use 2 MySQL databases in 2 different machines.
How to connect both databases using JDBC and get the two results same time using a single Query.

Any hints or examples would be highly appreciated.

Regards,

Do you absolutely have to get the results using one query? You realize of course, that you need to have two connections set up with different connection strings? On which connection would you run the query then?

[ktuhin]

Do you absolutely have to get the results using one query? You realize of course, that you need to have two connections set up with different connection strings? On which connection would you run the query then?

hi. i need to query two databases in different server and display the result of both in one window.

In this case, I think I need one query if possible and run the query in 1st connection, right? Or if not possible, I can have two query at the same time.
please let me know your suggestion.

[r035198x]

hi. i need to query two databases in different server and display the result of both in one window.

In this case, I think I need one query if possible and run the query in 1st connection, right? Or if not possible, I can have two query at the same time.
please let me know your suggestion.

You can create a connection to the first database and get some results from there and store them into some structure, lists,map, or perhaps some user-defined datatype depending on the data that's returned. You then connect to the second database and do the same. You can then work on the results returned to come up with the desired output for your window.