Chapter 25 Project Configuration for Backing Store : Setting JDBC Connection and Pool Properties

Setting JDBC Connection and Pool Properties
Add the following properties to the engine property file.
Specifying the JDBC Connection
To set the JDBC connection, add the property be.oracle.dburi.0 to your engine property file and provide the project path (that is path to the item in the design-time project) to the JDBC connection resource you configured (see Adding a JDBC Connection Resource). For example:

 
be.oracle.dburi.0 /SharedResources/JDBC Connection.sharedjdbc

 
Here is one way to get the correct URI value. Open the project and open the EAR resource. Open the Shared Archive resource and look at the Resources tab. All shared resources are listed there, using the correct path.
Setting Connection Pool Size
The connection pool settings are as follows (showing sample values):

 
be.oracle.dburi.pool.initial.0 2
be.oracle.dburi.pool.min.0 2
be.oracle.dburi.pool.max.0 5
be.oracle.dburi.pool.enforce.0 true
 

 
BusinessEvents performs backing store operations in bursts after each RTC. Monitor the database performance and adjust the pool size as needed.
Having more connections can also speed up recovery in the event of a failure.