infosys/camunda-connectors

The solution helps users to connect to various Databases & business applications like ERP's from the camunda business

camunda-connectors's Issues

[Feature] Add connection pool for postgres connector

The postgres connector currently seems to create a new connection for each request.
From a performance perspective, it would be great, if connection pooling would be utilized.

PostgreSQL and MySQL connectors not running

After building the package …

mvn clean package

… I changed the docker-compose.yaml file and added the line in the connectors section:

volumes:

• “/home/xyz/src/camunda-connectors/connector-postgresql/target/connector-postgresql-0.1.0-SNAPSHOT.jar:/opt/app/connector-postgresql-0.1.0-SNAPSHOT.jar”

When initializing the image container camunda/connectors-bundle:8.4.3, it is possible to find in the log:

2024-02-12T17:46:07.034Z INFO 1 — [main] i.c.z.s.c.jobhandling.JobWorkerManager : . Starting Zeebe worker: #ZeebeWorkerValue{type=‘com.infosys.camundaconnectors.db:postgresql:1’, name=‘PostgreSQL’, timeout=null, maxJobsActive=null, requestTimeout=null, pollInterval=null, autoComplete=true, fetchVariables=[databaseConnection, operation, data], enabled=null, methodInfo=null}

However, when executing the deployed BPMN, nothing happens, not even an error message.

The same with MySQL connector.

Any advice?

connector-postgresql not working with Camunda 8.3.1

Hi everyone,

I tried to run the postgres connector with my local Camunda 8.3.1 setup via docker-compose.
To do so, I mounted the built fatjar of the postgres connector into the classpath like this:

    volumes:
      - "./connector-postgresql-0.1.0-SNAPSHOT-with-dependencies.jar:/opt/app/connector-postgresql-0.1.0-SNAPSHOT-with-dependencies.jar"
      - "./connectors-home:/home/connectors"

The connectors container also shows the corresponding Worker has been started:

connectors     | 2023-11-03T08:27:45.779Z  INFO 1 --- [           main] i.c.z.s.c.jobhandling.JobWorkerManager   : . Starting Zeebe worker: ZeebeWorkerValue{type='com.infosys.camundaconnectors.db:postgresql:1', name='PostgreSQL', timeout=null, maxJobsActive=null, requestTimeout=null, pollInterval=null, autoComplete=true, fetchVariables=[databaseConnection, operation, data], enabled=null, methodInfo=null}

When I start a process with such connector, I can also see a corresponding log message:

connectors     | 2023-11-03T13:36:52.591Z  INFO 1 --- [pool-2-thread-5] i.c.c.r.c.outbound.ConnectorJobHandler   : Received job 2251799813685562

However, nothing happens after that. I can even misconfigure the Connector badly (e.g. writing "????" into host and port), and still nothing happens (I would expect some kind of Exception and/or Incident).

[Feature] Is the input "Body" (either text or html content type) template-aware.. can the mail-body receive for example process-variables as input ?

Is it possible to reference a process-variable and use it as the "Body" field ?
or
Can the "Body" field be a template (with refs to process-variables or other sources) ?

Is FEEL available in the "Body" field ?

[Feature] Add 'offset' parameter for postgres connector