Test JDBC step

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Test the JDBC step before testing or publishing an action that contains the JDBC step.

    Avant de commencer

    Role required: admin

    Pourquoi et quand exécuter cette tâche

    It is mandatory that you test the JDBC step before testing the action. Testing ensures that the relevant complex object output schema is created from table columns, which can be used as data pills in subsequent steps.

    Procédure

    1. Navigate to All > Process Automation > Flow Designer.
    2. Create an action with a JDBC step.
    3. Click Test JDBC Step.
      The Test JDBC Step pop-up window is displayed.
    4. If the JDBC step takes an action input or output of the previous step as its input, provide required input values in theStep input pills field to test the JDBC step.
      Remarque :
      Input values in the Step input pills fields are not needed when records are updated, inserted, or deleted.
    5. Click Run Test.
      • When a SELECT query is executed, Sample Result is displayed in the Test JDBC Step pop-up window. Sample Result includes column names, columns types, and the values of the first row.
      • When an UPDATE, INSERT, or DELETE query is executed, a message is displayed mentioning the number of rows affected.
    6. To use the sample result as the JDBC step output, click Use Result.
      Remarque :
      Use Result is not displayed when records are updated, inserted, or deleted.
    7. To retrieve schema of a different table when a SELECT query is executed in the JDBC step, enter the required value in the Step input pills field and click Run Test.

    Résultats

    When a SELECT query is executed in the JDBC step, ResultSet is displayed under Outputs. The relevant complex object output is populated. To learn more about complex objects, see Complex data.

    Que faire ensuite

    Test and publish the action.