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

bthlan
(suspended)
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).

link

answered 21.06.2018 at 10:21

Andreas%20Rusch's gravatar image

Andreas Rusch
441145
accept rate: 92%

edited 25.06.2018 at 05:24

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
9.4k31958

Thanks Andreas Rusch,

Currently we use IvyEngine 7.0.3.57252 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

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×20

Asked: 21.06.2018 at 07:17

Seen: 1,667 times

Last updated: 25.06.2018 at 05:24