Search code examples
javamysqljdbcoracle-sqldeveloperjdbc-odbc

JDBC program to create two different connections


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??


Solution

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