JDBC Connection Parameters?

Enable Connection Pooling: Enables the connection to use connection pooling.

Minimum Pool Size: If connection pooling is enabled, this field specifies the number of connections to create when the connection is enabled. The adapter will keep open the number of connections you configure here regardless of whether these connections become idle.

Maximum Pool Size: If connection pooling is enabled, this field specifies the maximum number of connections that can exist at one time in the connection pool.

Pool Increment Size: If connection pooling is enabled, this field specifies the number of connections by which the pool will be incremented if connections are needed, up to the maximum pool size.

Block Timeout: If connection pooling is enabled, this field specifies the number of milliseconds that the Integration Server will wait to obtain a connection with the database before it times out and returns an error.

Expire Timeout: If connection pooling is enabled, this field specifies the number of milliseconds that an inactive connection can remain in the pool before it is closed and removed from the pool.

Startup Retry Count (For Integration Server 6.1 only): The number of times that the system should attempt to initialize the connection pool at startup if the initial attempt fails. The default is 0.

Startup BackoffTimeout (For Integration Server 6.1 only): The number of seconds that the system should wait between attempts to initialize the connection pool.

4 comments:

  1. Thank you for sharing this wonderful blog. It will help to improve my knowledge about JAVA frameworks. This blog will know more about JAVA concepts. Also, it will improve my programming skill.
    Spring Training in Chennai | Spring framework Training | Spring framework Certification | Spring Hibernate Training in Chennai

    ReplyDelete
  2. Thanks for sharing your valuable information. Really its nice blog
    Java Software development company Frisco

    ReplyDelete
  3. Hi ....
    what is polling notification in Jdbc how to config the pooling notification

    ReplyDelete
  4. It is nice blog Thank you provide important information and I am searching for the same information to save my time Ruby on Rails Online Course India


    ReplyDelete