CODEWITHSUNDEEP
javadatabase-connection
angelina
angelina

Reputation: 51

What architecture to follow to connect to multiple databases

Dear All, I'm building a core java application in which i have say 20 databases and want to connect to each of them depending upon from where request has come to access which database.

I want to connect to databases only once from where i can pick the connection and return; please suggest what type of architecture to follow.

Upvotes: 0

Views: 258

Answers (2)

Benoit Courtine
Benoit Courtine

Reputation: 7074

You have to keep a list of connection pools.

I would use a Map< String, ConnectionPool >, where the key is the connection id. When you need a connection, you take it from this map :

Connection connectionDbAccounts = connectionMap.get("accounts").getConnection();
// Use connectionDbAccounts...
connectionDbAccounts.close();

Upvotes: 2

ced
ced

Reputation: 73

Use a HashMap<Location, DatabaseConnection> ?

Upvotes: 0

Related Questions