What is meant by "Block time out" and "Expire time out” in jdbc adapter configuration?

Block timeout: 

Refers to how much time the IS should wait to get connection from connection pool before throwing exception.

Expire Timeout:

Refers to how much time the free connection stay as it is before it expires. 

2 comments:

  1. Block time out: Is the time a service waits to acquire a connection from the connection pool.

    Expire time out: Is the time after which an idle connection is removed from the pool.

    From SAG website: If the pool is full (as specified in Maximum Pool Size field), the requesting service waits for Integration Server to obtain a connection, up to the length of time specified in the Block Timeout field, until a connection becomes available. Periodically, Integration Server inspects the pool and removes inactive connections that have exceeded the expiration period that you specified in the Expire Timeout field.

    ReplyDelete