Creating and Closing Database connections.

Document ID : KB000090047
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Creating and Closing Database connections.
Resolution:
Detailed Description and Symptoms

Q1. Does Applications Manager manage its connections? i.e Does it open and close connections as needed?

Q2. What determines when a new connection is opened?

Q3. What determines when a connection is closed?

Q4. Does at least one connection stay active on an agent at all times?


Solution

?A1. The AgentService process opens and closes connections as needed.

A2. We have a pool of connections which we use to connect to the database for each data requests or job submission. If those are all in use, a new connection would be opened.

A3. The connection is returned to the pool after the request or submission is complete.

A4. Yes, the agent will get a connection when the Agent starts up to ensure that it can connect to the DB. Each time we need a connection we get one from the pool and return it afterwards. If there are no available connections at the time  we are trying to connect to the database it will open a new connection, which will then be added to the pool of available connections.