Undefined constant "OCI_COMMIT_ON_SUCCESS" error

[Nazar Hrytsuniak]

Hi.

Thanks for the fusio)

I've got the following error "Undefined constant "OCI_COMMIT_ON_SUCCESS" error" while trying to create a connection to Oracle db.

I used docker compose configs from https://github.com/apioo/fusio-docker. Do I need to do some additional configuration to be able to connect?

-Nazar

[Christoph Kappestein]

Hi,

basically this means that the PHP oracle extension is not available, by default this is not configured please take a look at the PR s.

https://github.com/apioo/fusio-docker/pull/16/files

where a user has added oracle support. If there is a demand we could also embed the PHP oracle extension by default in our image but this also increases the complexity

of our image, so if you need oracle support by default please let me know. For the time being you can manually build the image with oracle support.

best regards

Christoph

[Nazar Hrytsuniak]

Thanks. Docker file that you sent is enough.

I was able to create Oracle connection, but when I tried to execute I've got another error: 

{ 

 "success": false, 

 "message": "An error occurred at the worker: Undefined constant 'OCI_NO_AUTO_COMMIT'" 

}

вівторок, 29 листопада 2022 р. о 20:41:56 UTC+2 christoph....@gmail.com пише:

[Christoph Kappestein]

Hi Nazar,

this is because the worker php client needs also the Oracle client, a user has here made also a PR to add this to the worker s.

https://github.com/apioo/fusio-worker-php/pull/2/files

In case you only want to connect to an Oracle database and dont want to install Fusio on an Oracle it is also enough to only

add the oracle client to the worker.

best regards

Christoph