When not to use database connection pools

You should not use database connection pools to connect directly to the database of an application. To interact with an application database you should only use IBM WebSphere business integration adapters. Database connections should only be made to databases that do not support an application because adapters use the business logic provided by programming interfaces of the application. If you connect directly to an application database to perform a SQL update statement, for example, then you circumvent any related logic that the API would have performed in response to an update operation. This violates the integrity of the application and the business process.

If you have a need to retrieve information from an application, but do not want to use an adapter because of the impact on performance of sending a business object request to the application and receiving the response, you have several alternatives:

Copyright IBM Corp. 1997, 2004