Procedure to Configure a DbExecute Connection in the Content Engine Store- Configuring Java Custom Components
To set a DbExecute connection:
- Access the DbExecute Connections tab in the administration console:
a. In the domain navigation pane, select the object store.
b. In the object store navigation pane, click Administrative ➤ Workflow System.
c. In the details pane, click the DbExecute Connections tab.
Figure 2-198The DbExecute Connections in the Design Object Store
- Click New.
- Enter the connection information and database parameters.
Figure 2-199The AuditDB connection parameters are entered
Click Validate to test the database connection.
Figure 2-200The status of the AuditDb connection is shown
We can now see the AuditDb object we have successfully created in the DbExecute Connections tab.
Figure 2-201The AuditDb object is successfully created in the DbExecute Connections tab of OS1
The preceding steps were repeated for the OS2 Target Object Store.
Figure 2-202The AuditDB object is successfully created in the DbExecute Connections tab of OS2
We can now insert test rows into the AUDIT_DEPT table which is in the DB2 auditdb database.
Figure 2-203The IBM Data Studio is used to view and add test rows in the DB2 auditdb database
The DbExecute Stored Procedure SQL
Figure 2-204The Stored Procedure ADD_AUDIT_DEPT is edited in the file SetAddAudit_Stored_ProcedureV1.sql
The Stored Procedure, ADD_AUDIT_DEPT, listed in Figure 2-204, which we have developed, can be called by the DbExecute step to add a row to the DB2INST1.AUDIT_DEPT table in the auditdb database, using parameters passed for each column of the table.
Figure 2-205The stored procedure is created in the auditdb database, using the preceding db2 commands
Figure 2-206The install of the DB2INST1.AUDIT_DEPT stored procedure is successfully loaded into auditdb
See the following web page for the full DbExecute procedure steps:
www.ibm.com/docs/en/filenet-p8-platform/5.5.x?topic=activity-dbexecute-system-function
Configuring the Workflow for the DbExecute Step
We can now define the DbExecute system step for the workflow system using the installed Standalone Process Designer.
NoteTo create a new DbExecute connection, an XA and non-XA JDBC Datasource will need to be set up for the IBM FileNet WebSphere application server to enable access for the database.
https://doi.org/10.13140/RG.2.2.16987.52008
ImportingCaseManagersolutionAutoClaimsexampleintoCaseManager5.3.3onRHEL8.0.docx