How to organize connection pools?

1.	How to organize connection pools?
Answer» There should be two separate connections if you are using adapter notifications and adapter services. If not, you may receive strange ERRORS regarding transactions, etc. Moreover, don't share connection pools with different functional areas, even when they point to the same database. If you share connection pools with different functional areas then: Tuning or changing the SIZE of the pool can become quite challenging if you have different types of usage of the pool. It is ALSO difficult to change individual database settings without affecting the others. Having separate pools for each package generally seems to work fairly well (THOUGH not a hard and fast rule), since your packages are generally divided up ACCORDING to the functional area.

Answer»

There should be two separate connections if you are using adapter notifications and adapter services. If not, you may receive strange ERRORS regarding transactions, etc. Moreover, don't share connection pools with different functional areas, even when they point to the same database. If you share connection pools with different functional areas then:

Tuning or changing the SIZE of the pool can become quite challenging if you have different types of usage of the pool.
It is ALSO difficult to change individual database settings without affecting the others.

Having separate pools for each package generally seems to work fairly well (THOUGH not a hard and fast rule), since your packages are generally divided up ACCORDING to the functional area.

Discussion

No Comment Found

Related InterviewSolutions

What are the most common problems encountered when migrating a project?
What is the best way to change the logging date format for WebMethods Integration Server?
What effect does ACLs (Access Control List) have on locking?
Explain what is EAI (Enterprise application integration).
How to organize connection pools?
What do you mean by client groups?
An HTTP listener is assigned by default to which port on the webMethods Integration Server?
If we want to repeat an operation as long as a repeat condition is met, how do we set the count parameter?
Explain branch operation.
How will you use SEQUENCE as the Target of a BRANCH?