Setting the Maximum Number of Pool Connections

In Business Components for Java, you can specify a Java VM parameter (-D) or jboserver.properties property that sets the maximum number of connections in the pool. The default maximum number of connections is a very large number, so it is essentially the number of connections supported by your database driver.

To set the maximum pool size:

When you start the business logic tier's Java VM, include the following directive on the command line:

-Djbo.maxpoolsize=n

n is the number of connections allowed per pool, from 1 to 2,147,483,647 (the default). The number of connections is limited by the number of connections supported by your database driver. If view row spillover or application module state preservation is required, the maximum poolsize should be set to two times the expected number of active (connected) application modules.

Alternatively, you can enter a line in the jboserver.properties file, which is stored in \lib\jbomt.zip.

jbo.maxpoolsize=n

To set Java VM parameters through project properties:

  1. In the Workspace view of the Navigator, right-click a business component project and choose Properties.

  2. In the Run/Debug panel, type the parameters in the Java VM Parameters field.

  3. Click OK.

    The values are added to the jboserver.properties file, which is stored in \lib\jbomt.zip.


Related topics
Pooling Connections
Enabling and Disabling Connection Pooling
Setting the Initial Number of Pool Connections
Using a Custom Connection Pool Manager

About Connection Pooling