Configure these properties on the Connection Pool tab:
Initial Pool Size The initial number of connections in the pool. EAServer preallocates and opens the specified number of connections at start-up time. The default value of initialPoolSize is zero.
Minimum Pool Size The minimum number of connections in the pool. When open connections are idle, the pool is pruned to this size. The configuration property name is minPoolSize, and the default value is zero.
If no minimum size is specified, connections are opened on an as-needed basis to fill the pool up to the maximum size.
Maximum Pool Size The maximum number of connections allocated to the pool for this data source. If the maximum is exceeded, and cannot be resolved by waiting; for example, if deadlock occurs, you may see “ResourceMonitorTimeoutException” in your log file, and some transactions may fail. A value of zero sets no limit to the connection pool size. The configuration property name is maxPoolSize.
Maximum Idle Time Specifies the number of seconds an idle connection remains in the pool before it is dropped. The default is 60 seconds. If the value is zero, idle connections remain in the pool until the server shuts down. The configuration property name is maxIdleTime.
Maximum Wait Time The maximum number of seconds to wait for a connection before the request is cancelled. The configuration property name is maxWaitTime., and the default value is 60.
Maximum Cached Statements The maximum number of JDBC prepared statements that can be cached for each connection by the JDBC driver. The value of this property is JDBC-driver specific. The configuration property name is maxStatements; the default is zero.
