DB connection pool
This page contains the following information:
Configuring the DB Connection Pool for Adeptia Connect
You can configure Adeptia Connect to use any of the following DB connection pools available for Webrunner and Kernel:
- c3p0
- HIkari
- Universal Connectio Pool (UCP)
- The default DB connection pool is c3P0.
- UCP supports only the Oracle database.
To set the DB connection pool, you need to configure two system properties in Adeptia Connect. Follow the steps below to configure the properties:
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder.
- Open server-configure.properties file in the Text Editor.
- Under the Group, Webrunner Connection Pool, set the the value for the property, abpm.webrunner.connection.pool.profile. Refer to the image below.
- Under the Group Kernel Connection Pool, set the the value for the property, abpm.kernel.connection.pool.profile. Refer to the image below.
- Save the file.
You can choose to set any of the following three values.
- C3P0ConnectionPool
- UniversalConnectionPool
- HikariConnectionPool
You can have the same DB connection pool or a different one for the Webrunner and Kernel.
Log database connection pool
Following property can be configured to control the size of log database connection pool. It is set to 100 but can be increased if log connections are not available.
To change the connection pool size of log database, open server-configure.properties file from the …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder and change the value highlighted in the figure below:
Backend database connection pool
Following property can be configured to control the size of backend database connection pool. It is set to 50 but can be increased if backend connections are not available.
To change the connection pool size of backend database, open server-configure.properties file from the …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder and change the value highlighted in the figure below:
The number of objects and processes within the backend database governs the performance of the user interface. Therefore, when the backend database becomes large, you may need to increase the memory setting to this database:
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder.
- Open server-configure.properties file in the Text Editor.
- Increase the value of the property abpm.embedded.indigo.memory as per your requirement.
#Webrunner JVM parameters WB:JVM: -Xms128M -Xmx512M -Xrs -XX:PermSize=64M -XX:MaxPermSize=128M