Tuning Data Source

You can use data source tuning to boost the performance of the relational data source in the server application. Allocating and deallocating resources for data sources is not so easy in terms of time and system resources. During the application startup, you can create a pool of database connections in advance and make these connections available to the application.

For TIBCO Order Management, you can configure the following properties for data source tuning as per your requirements. For description and more information about the properties, see the Tomcat JDBC Connection Pool documentation.

Microservice Property Description
AOPD catalogDsTestOnBorrow Enables connection validation before being borrowed from the pool
catalogDsValidationInterval Data source validation interval in milliseconds
catalogDsTestWhileIdle Enables connection validation while idle in the connection pool
catalogDsTimeBetweenEvictionRunsMillis Data source eviction interval in milliseconds
catalogDsMinEvictableIdleTimeMillis Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction
catalogDsNumTestsPerEvictionRun Data source tests per eviction run
catalogDsDefaultAutoCommit Default auto-commit state of connections created by this pool
catalogDsRollbackOnReturn Enables rollback of any pending transaction when a connection is returned to the pool
catalogDsCommitOnReturn Enables commit of any pending transaction when a connection is returned to the pool
catalogDsCustomProperty Database custom property
Orchestrator catalogDsInitializeSize Number of connections established when the connection pool starts
catalogDsMaxIdle Maximum number of connections to keep in the idle pool
catalogDsMaxActive Maximum number of active connections that can be allocated from this pool at the same time
catalogDsMaxWait Maximum time in milliseconds the pool will wait when there are no available connections
catalogDsTestOnBorrow Enables connection validation before being borrowed from the pool
catalogDsValidationInterval Data source validation interval in milliseconds
catalogDsTestWhileIdle Enables connection validation while idle in the connection pool
catalogDsTimeBetweenEvictionRunsMillis Data source eviction interval in milliseconds
catalogDsMinEvictableIdleTimeMillis Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction
catalogDsNumTestsPerEvictionRun Data source tests per eviction run
catalogDsDefaultAutoCommit Default auto-commit state of connections created by this pool
catalogDsRollbackOnReturn Enables rollback of any pending transaction when a connection is returned to the pool
catalogDsCommitOnReturn Enables commit of any pending transaction when a connection is returned to the pool
catalogDsCustomProperty Database custom property
Archival archivalHibernateShowSql Enables Hibernate to show queries
archivalDsInitialSize Number of connections established when the connection pool starts
archivalDsMaxWait Maximum time in milliseconds the pool waits for a connection to be returned before throwing an exception
archivalDsMaxActive Maximum number of active connections that can be allocated from this pool at the same time
archivalDsMaxIdle Maximum number of connections to keep in the idle pool
archivalDsMinIdle Minimum number of established connections to keep in the pool at all times
archivalDsTestOnBorrow Pooled data source test on borrow
archivalDsValidationInterval Pooled data source validation interval
Catalog catalogDsMaxIdle Maximum number of connections to keep in the idle pool
catalogDsMaxActive Maximum number of active connections that can be allocated from this pool at the same time
catalogDsMaxWait Maximum time in milliseconds the pool will wait when there are no available connections
catalogDsTestOnBorrow Enables connection validation before being borrowed from the pool
catalogDsValidationInterval Data source validation interval in milliseconds
catalogDsTestWhileIdle Enables connection validation while idle in the connection pool
catalogDsTimeBetweenEvictionRunsMillis Data source eviction interval in milliseconds
catalogDsMinEvictableIdleTimeMillis Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction
catalogDsNumTestsPerEvictionRun Data source tests per eviction run
catalogDsDefaultAutoCommit Default auto-commit state of connections created by this pool
catalogDsRollbackOnReturn Enables rollback of any pending transaction when a connection is returned to the pool
catalogDsCommitOnReturn Enables commit of any pending transaction when a connection is returned to the pool
catalogDsCustomProperty Database custom property