conductor icon indicating copy to clipboard operation
conductor copied to clipboard

why jdbc doesn't work

Open Klay-Zh opened this issue 1 year ago • 0 comments

Running Conductor Using Docker and start workflow, but the status of jdbc task is SCHEDULED

workflow definition: { "ownerApp": null, "createTime": 1707025941567, "updateTime": 1707124459517, "createdBy": null, "updatedBy": null, "accessPolicy": {}, "name": "procure_approval", "description": "procure_approval_test", "version": 2, "tasks": [ { "name": "queryAmount", "taskReferenceName": "query", "description": null, "inputParameters": { "connectionId": "jdbc:mysql://[email protected]:32306/cnbmdb_train?user=root&password=Cnbm123456!", "statement": "SELECT price from purchase_order where code = ? and status = 0", "parameters": [ { "code": "${workflow.input.code}" } ], "type": "SELECT" }, "type": "JDBC", "dynamicTaskNameParam": null, "caseValueParam": null, "caseExpression": null, "scriptExpression": null, "dynamicForkJoinTasksParam": null, "dynamicForkTasksParam": null, "dynamicForkTasksInputParamName": null, "startDelay": 0, "subWorkflowParam": null, "sink": null, "optional": false, "taskDefinition": null, "rateLimited": null, "asyncComplete": false, "loopCondition": null, "retryCount": null, "evaluatorType": null, "expression": null }, { "name": "switch_task", "taskReferenceName": "is_warning", "description": null, "inputParameters": { "price": "${query.output.price}" }, "type": "SWITCH", "dynamicTaskNameParam": null, "caseValueParam": null, "caseExpression": null, "scriptExpression": null, "decisionCases": { "approval": [ { "name": "sendMessage", "taskReferenceName": "message", "description": null, "inputParameters": { "receiver": "${workflow.input.receiver}", "content": "${workflow.input.code}is warning!" }, "type": "SIMPLE", "dynamicTaskNameParam": null, "caseValueParam": null, "caseExpression": null, "scriptExpression": null, "dynamicForkJoinTasksParam": null, "dynamicForkTasksParam": null, "dynamicForkTasksInputParamName": null, "startDelay": 0, "subWorkflowParam": null, "sink": null, "optional": false, "taskDefinition": null, "rateLimited": null, "asyncComplete": false, "loopCondition": null, "retryCount": null, "evaluatorType": null, "expression": null } ] }, "dynamicForkJoinTasksParam": null, "dynamicForkTasksParam": null, "dynamicForkTasksInputParamName": null, "startDelay": 0, "subWorkflowParam": null, "sink": null, "optional": false, "taskDefinition": null, "rateLimited": null, "asyncComplete": false, "loopCondition": null, "retryCount": null, "evaluatorType": "javascript", "expression": "$.price> 1000 ? 'approval' : ''" } ], "inputParameters": [], "outputParameters": {}, "failureWorkflow": null, "schemaVersion": 2, "restartable": true, "workflowStatusListenerEnabled": false, "ownerEmail": "[email protected]", "timeoutPolicy": "ALERT_ONLY", "timeoutSeconds": 0, "variables": {}, "inputTemplate": {} }

Klay-Zh avatar Feb 05 '24 10:02 Klay-Zh