Hello Ivy team,

When try to connect Oracle when config system db, I got the exception "timezone region not found". When I try to connect to another database(ie: postgres). Do you have any clue for this issue? alt text

Thanks, Lan Bui

asked 21.06.2018 at 07:17

bthlan's gravatar image

accept rate: 0%

That's when the ojdbc driver and the database don't play nicely together regarding time zones, i.e. the ojdbc driver sends a time zone ID to the DB server that the server doesn't know.

What Ivy and Oracle DB versions are you using exactly?

One way to fix it would be to downgrade (or upgrade, if your Oracle DB server is newer) the ojdbc library.

If you don't want to change the ojdbc version, a workaround would be to specify -Doracle.jdbc.timezoneAsRegion=false in the Engine system properties (by setting it in the ivy.vm.additional.options in your .ilc file in the /bin folder).


answered 21.06.2018 at 10:21

Andreas%20Rusch's gravatar image

Andreas Rusch
accept rate: 92%

edited 25.06.2018 at 05:24

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦

Thanks Andreas Rusch,

Currently we use IvyEngine and Oracle 11g Release 2. I see that in the Oracle page, they suggest to use ojdbc6.jar and that version of IvyEngine is using ojdbc8, after I change to use ojdbc6, it can work. Thanks for you support!

(22.06.2018 at 00:30) bthlan bthlan's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 21.06.2018 at 07:17

Seen: 569 times

Last updated: 25.06.2018 at 05:24