oracle-r2dbc icon indicating copy to clipboard operation
oracle-r2dbc copied to clipboard

Support oracle.jdbc.timezoneAsRegion driver parameter

Open osi opened this issue 2 years ago • 2 comments

When using the docker image provided at https://registry.hub.docker.com/r/gvenzl/oracle-xe with Testcontainers, specifically the gvenzl/oracle-xe:11-slim image, connections fail if the JVM's timezone is set to Etc/UTC.

Setting the property oracle.jdbc.timezoneAsRegion as a system property, as described here, https://gist.github.com/jarek-przygodzki/cbea3cedae3aef2bbbe0ff6b057e8321 is a fix.

It would be nice if this property were supported directly by this driver, so it could be scoped to the connection.

osi avatar Jul 05 '22 16:07 osi

@osi, thank you for showing me this!

I can easily add an extended option for oracle.jdbc.timezoneAsRegion. I'll plan to do that as I sink some time into Oracle R2DBC this week.

Also, just wanted to note that Oracle R2DBC is only verified with Oracle Database versions 18 and newer. I believe the docker image you have is version 11.x.

Michael-A-McMahon avatar Jul 05 '22 18:07 Michael-A-McMahon

Thanks! Yes, the image is for 11.x, as we have an instance running this version in production.

I understand that Oracle R2DBC is only verified with v18 and higher. Thankfully we can verify our interactions with the docker image to get some confidence against this older version. Our usage of this is also as a part of migrating off of this older version as well. As famous last words, we hopefully won't be running in this configuration for too long 😀

osi avatar Jul 05 '22 18:07 osi