JDBC program to create two different connections

Question

Is it possible to select the data from two different database management systems? Suppose I have one table in Oracle Database and other table in mySQL database and If I want to select the data from two different databases is possible? How the JDBC program looks like??

Of cause its possible. Did you try anything yet? any code? – Leviathan Nov 21 '13 at 17:48 — Leviathan, Nov 21 '13 at 17:48
"Actually it was my interview question" – Syed Nov 22 '13 at 14:28 — Syed, Nov 22 '13 at 14:28

score 1 · Accepted Answer · answered Nov 21 '13 at 17:47

1

You would need two different Jdbc drivers for oracle and mysql, and set up two separate connections.

answered Nov 21 '13 at 17:47

Michael

423
2
8

As this correct answer says… A JDBC connection to a database server is just a network connection, like any other. Just as your web browser can open multiple tabs or windows and make connections to multiple web servers, so can your Java app use its JDBC driver(s) to connect to multiple DB servers. – Basil Bourque Nov 21 '13 at 18:27
"Thank you for your answer. Actually I did the same by creating the two separate connections to the two different databases" – Syed Nov 22 '13 at 14:32

JDBC program to create two different connections

1 Answers1