Configuring Transactional Processing

You can either use the Begin and End Transaction Services in your business processes or you can enable transactions during the Business Process check-in.

There are two ways to enable transactions in Sterling B2B Integrator so that when a rollback occurs, no data is committed; data returns to its pre-process state.

Note: Within transactions, if a service is using data produced from a previous service (it may be internal to Sterling B2B Integrator) and the databasePool transaction was set to false (databasePool.transaction is defined in jdbc.properties), sometimes Sterling B2B Integrator appears locked. This lock situation is caused by the transaction isolation level setting in the database. For example, read_committed (default for DB2® and MySQL), because the transaction of the business process has not been committed, the database can not operate on the data outside the scope of the current transaction. To avoid this lock situation, use the Begin and End Transaction service in the business process and have the service that does not use transactional pool be excluded from the transaction.