Refreshing a Node when Passing an Array to a Stored Procedure

The Oracle database node restart is needed when you plan to use a stored procedure which passes an array. This can be done before or after the user application is deployed.

Note that:

  • You can only pass arrays of primitive types.
  • Only Oracle and DB2 are supported.
  • Microsoft SQL Server has no notion of arrays.
  • For Postgres, the Connection.unwrapped method is not implemented by the driver, so, you cannot create the corresponding Postgres array type.

If the BPM primary database is Oracle, then you do not need to refresh the node to wire the new package.

If the BPM primary database is not Oracle, you need to use TIBCO Configuration Tool (TCT) to install the Oracle driver onto the target node. Then re-start the node.

Procedure

  1. Change directory to the BPM configuration directory you specified when you installed TIBCO Active Matrix BPM. For example, on Windows platforms, C:\ProgramData\amx-bpm\tibco\data\tibcohost\Admin-AMX BPM-AMX BPM Server\host\bin.
  2. execute "tibcohost startNodes -nodeName BPMNode -clean"
Next topic: Out of Sync SystemNode after Upgrade
Previous topic: Error When Configuring the ActiveMatrix Administrator Server