Databricks Community

austinoyoung

Dear All,I am trying to use jdbc driver to connect to an oracle database and append a new record to a table. The table has a column needs to be populated with a sequence number. I've been trying to use select `<sequence_name>.nextval` to get the sequ...

austinoyoung · 06-18-2025

Hi! I've been trying to create an external connection to oracle but getting the following error message "Detailed error message: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found" I searched online and found some...

austinoyoung

Thank you, Louis, for the information!I really like the identity column solution, but I have to reach out to our dba for implementation.爛Thanks again!

austinoyoung · 06-23-2025

Thank you, TheOC, for the help! I could not find any older version than 11.2.x of jdbc driver but it doesn't seem to work, even after I added the parameter to spark config of the cluster I use to create the external connection. I guess I have to go b...

austinoyoung · 06-23-2025

Thank you, TheOC, for the information! Yes, adding the "parameter" is the fix but I don't seem to be able to find this option in setting up the external connection (the only available options are host, port, username, and password). Yes we have been ...

Databricks Community

User Stats

User Activity

oracle sequence number

create an external connection to oracle

Re: oracle sequence number

Re: create an external connection to oracle

Re: create an external connection to oracle