Issue 27922  —   SSP does not run in the same transaction as the Uniface component.

Status:   Solved in 10.2.01

Solution available in patch(es):      G102

Description:

 Summary:
 Database i/o that is done in a Server Stored Procedure (SSP) is not part of the
 main transaction.

 Environment:
 +Uniface: Version 8.4.02 (and higher)
 +Operating System: OS independent
 +Database: All databases that use transactions

 The documentation about SSPs contains the following information:

 "When the accessed entity is a Uniface Server, stored procedures are executed
 on the Uniface Server. This is because it must belong to the same transaction
 as the entity on the Uniface component".

 However, testing shows that database interaction in the SSP does not happen in
 the main transaction. This means for example commit in 4GL has no effect on the
 executed SSP.

Workaround:

 Add "commit" in the SSP.
 Without tranaction=true commit in Uniface component also commits actions SSP:
 One can see in log file no new path is opened for the SSP.

Notes: