Procedure to Configure a DbExecute Connection in the Content Engine Store- Configuring Java Custom Components

To set a DbExecute connection:

  1. 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

  1. Click New.
  2. 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.

See the link for a full description of an alternative JDBC DbExecute connection creation (on Page 51 of the document):

https://doi.org/10.13140/RG.2.2.16987.52008

“Importing Case Manager solution Auto Claims example into Case Manager 5.3.3 on RHEL 8.0” Document download:

ImportingCaseManagersolutionAutoClaimsexampleintoCaseManager5.3.3onRHEL8.0.docx

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *