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 at 07:17

bthlan's gravatar image

bthlan
11114
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 at 10:21

Andreas%20Rusch's gravatar image

Andreas Rusch
1312
accept rate: 75%

edited 25.06 at 05:24

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
7.1k11342

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 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

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:

×17

Asked: 21.06 at 07:17

Seen: 114 times

Last updated: 25.06 at 05:24