merlinux opened a new issue, #65257: URL: https://github.com/apache/airflow/issues/65257
### Under which category would you file this issue? Providers ### Apache Airflow version 3.2.0 ### What happened and how to reproduce it? **Editing** the UI connection form, SCHEMA parameter is rejected when using Extra Fields (Oracle thick client 23.26) <img width="794" height="871" alt="Image" src="https://github.com/user-attachments/assets/0340e3d6-76ec-4f31-afeb-d67e5490ca43"; /> Previously, it accepts when **creating** connection, but malformed get_uri is recorded and schema field is set to None <img width="1839" height="514" alt="Image" src="https://github.com/user-attachments/assets/b538b9e6-e340-4970-9520-464c67802fb1"; /> Connection test fails. (venv-py312) [airflow@air3d01xdl ~]$ airflow connections test testing_ORA Retrieving connection: 'testing_ORA' Testing... Connection failed! ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Help: https://docs.oracle.com/error-help/db/ora-12504/ A closer look of get_uri field: oracle://user:password@HOST:PORT/?thick_mode=TRUE&thick_mode_lib_dir=%2Fairflow%2Finstantclient_23_26%2F It should be: oracle://user:password@HOST:PORT/**SCHEMA**?thick_mode=TRUE&thick_mode_lib_dir=%2Fairflow%2Finstantclient_23_26%2F ### What you think should happen instead? 1)It shoud save the SCHEMA and get a well formed get_uri field. Plus, schema field must contain schema ui input value 2) It should pass input validation when editing ### Operating System Red Hat Enterprise Linux release 9.6 (Plow) ### Deployment Virtualenv installation ### Apache Airflow Provider(s) oracle ### Versions of Apache Airflow Providers (venv-py312) [airflow@air3d01xdl ~]$ airflow providers list package_name | description | version =======================================+=================================================================================+======== apache-airflow-providers-celery | Celery https://docs.celeryq.dev/en/stable/ | 3.17.1 apache-airflow-providers-common-compat | Common Compatibility Provider - providing compatibility code for previous | 1.14.1 | Airflow versions | apache-airflow-providers-common-io | Common IO Provider | 1.7.1 apache-airflow-providers-common-sql | Common SQL Provider https://en.wikipedia.org/wiki/SQL | 1.33.0 apache-airflow-providers-fab | Flask App Builder https://flask-appbuilder.readthedocs.io/ | 3.5.0 apache-airflow-providers-oracle | Oracle https://www.oracle.com/database/technologies/ | 4.5.1 apache-airflow-providers-postgres | PostgreSQL https://www.postgresql.org/ | 6.6.1 apache-airflow-providers-sftp | SSH File Transfer Protocol (SFTP) | 5.5.0 | https://tools.ietf.org/wg/secsh/draft-ietf-secsh-filexfer/ | apache-airflow-providers-smtp | Simple Mail Transfer Protocol (SMTP) https://tools.ietf.org/html/rfc5321 | 2.4.3 apache-airflow-providers-ssh | Secure Shell (SSH) https://tools.ietf.org/html/rfc4251 | 4.3.2 apache-airflow-providers-standard | Airflow Standard Provider | 1.12.1 ### Official Helm Chart version Not Applicable ### Kubernetes Version _No response_ ### Helm Chart configuration _No response_ ### Docker Image customizations _No response_ ### Anything else? It was working fine on Airflow v2.5.x and ss Please see #62526 as reference Kind regards ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
