Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 05:41 AM
hey @austinoyoung ,
I don't have an Oracle database to be able to test this for you, but I believe you can get around this error by following the steps laid out in here:
https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found
In short, I understand the fix to be adding the parameter:
oracle.jdbc.timezoneAsRegion=false
To your connection. Assuming your connection is set up similar to how it is laid out in this article, I believe the additional parameter can be added to the url, as such:
df.write.format('jdbc').options(
url='jdbc:oracle:thin:@192.168.11.100:1521:ORCL?oracle.jdbc.timezoneAsRegion=false',
driver='oracle.jdbc.driver.OracleDriver',
dbtable='testschema.test',
user='testschema',
password='password'
).mode('append').save()Let me know if this doesn't help and I'll have a deeper dive for you 🙂
TheOC
Cheers,
TheOC
TheOC