Chanakya

[sreechanakya]

Hi Please tell me about the following terms

1.What is MaxPool Size,MinPoolSize.
2.Why We need Assing a Value to them
3.what Happened if we Assign min poolsize to 0

[amolchauhan]

Hi,

Excerpt from documentation:6-5_JDBC_Adapter_Users_Guide will clear all your doubts.

Run-Time Behavior of Connection Pools[FONT=Arial]

[FONT=Arial]When you enable a connection, the Integration Server itializes the connection pool,creating the number of connection instances you specified in the connection’s Minimum Pool Size field when you configured the connection. Whenever an adapter service needs a connection, the Integration Server provides a connection from the pool. If no connections are available in the pool, and the maximum pool size has not been reached, the server creates one or more new connections (according to the number specified in the Pool Increment Size field) and adds them to the connection pool. If the pool is full (as specified in Maximum Pool Size field), the requesting service will wait for the Integration Server to obtain a connection, up to the length of time specified in the Block Timeout field, until a connection becomes available. Periodically, the Integration Server inspects the pool and removes inactive connections that have exceeded the expiration period that you specified in the Expire Timeout field.

[/FONT][/FONT]

[FONT=Arial]Regards,

Amol.

[/FONT]