A system participant must be defined and assigned to the database service task. The system participant must be configured to identify the BPM runtime JDBC resource instance that defines the connection to the database.
Procedure
In Project Explorer, expand the
GetLoginName process and create a new participant in the process-level
Participants folder. Name the participant
DBConnection
and make sure its type is
System.
On the Properties view for the Participant, on the General tab, expand the
Shared Resource entry. Select the
Jdbc radio button.
In the
Instance
Name field, enter
BPMDatabaseConnection, which is the name of the BPM runtime JDBC resource instance that defines the connection to the database.
Leave the
Jdbc Profile Name
field blank. (See the
TIBCO Business Studio BPM Implementation guide for information on the use of this field.)
Assign the
DBConnection
participant to the
Get login name database service task.