Multiple DB connections and executor framework

Question

I am working a project where we fetch a list of users who are accessing a DB, we are having around 250 servers and DB count might be around 1000. I am planning to use a connection pool using DBCP and Executor framework for multi-threading. Kindly suggest

Thanks in advance

I am looking for the best possible solution for the above mentioned question in short i need to connect to 250 servers and 1000 odd DB Oracle and SQL to run a stored procedure in each database and fetch the accounts — Sabari Pradeep, Nov 03 '15 at 06:42

score 0 · Answer 1 · answered Nov 23 '15 at 12:02

0

This can be achieved by ExecutorCompletionService which will submit the tasks to a queue and use

ecs.take();

and process the result

answered Nov 23 '15 at 12:02

Sabari Pradeep

1
1

Multiple DB connections and executor framework

1 Answers1