Multiple database connections

[devi g]

How to connect to multiple databases (like SQL server, mysql, oracle) through Java code.

[N a v a n e e t h]

Nirmala G wrote:

SQL server

JDBC will do it.

Nirmala G wrote:

mysql

Look at JDBC Driver for MySQL

Nirmala G wrote:

oracle

Again JDBC can be used here. What do you mean by connecting multiple databases? Do you mean a method where you can change the underlying database with minimum code change? If yes, abstract the database calls behind well defined interfaces. So you can change the code without affecting interface users. :)

Navaneeth How to use google | Ask smart questions

[Ken Mazaika]

If you choose to use jdbc you'll have to download drivers for each specific database. I just wrote a post on how to dynamically load the database driver jar you need and connect to jdbc through it here[^].