Database Connection Pool Properties

Connection pools allow SAP Mobile Platform Server to reuse established connections to the database. Adjust the maximum number of connections that can be in the connection pool to ensure that adequate resources are allocated. Mobiliser uses its own connection pool. If you have enabled Mobiliser features, you can adjust the minimum and maximum number of connections for each connection pool partition.

Database Connection Pools

SAP Mobile Platform Server database connection properties are located in SMP_HOME\Server\config_master\connection_data\connection.properties.

To change the maximum number of concurrent connections that can be made to the database, add the following line:

com.sap.persistence.jdbc.connection.pool.max_active=new value

The default value is 8.

Note: Use caution when changing other properties in this file. Incorrect database connection property values can make the server unusable.

Restart the server after making any changes to database connection properties.

Mobiliser Database Connection Pools

Mobiliser connection pools support partitioning. Depending on the transaction being performed, SAP Mobile Platform Server requires multiple calls to the database to complete the transaction. A large number of connections are required for high volumes of concurrent transactions. The total number of database connections is the product of the number of partitions and the connections per partition. If there are no operating system or database restrictions, running a higher number of database connections than recommended does not negatively impact performance. The same is also true for the number of partitions.

The Mobiliser database connection properties are located in SMP_HOME\Server\config_master\com.sybase365.mobiliser.framework.persistence.jdbc.bonecp.pool\pool.properties.

Setting Name	Default Value	Modified Value
maxConnectionsPerPartition	10	16 * CPU cores
minConnectionsPerPartition	1	16 * CPU cores
partitionCount	2	N/A (default is recommended)

Note: Use caution when changing other properties in this file. Incorrect property values can make the server unusable.

Restart the server after making any changes to database connection properties.