Cannot connect Oracle when config system db

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

ivy7x

asked 21.06.2018 at 07:17

bthlan
(suspended)
accept rate: 0%

One Answer:

active answers oldest newest most voted

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 Rusch
441●1●4●5
accept rate: 92%

edited 25.06.2018 at 05:24

Reguel Werme... ♦♦
9.4k●3●19●58

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

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Tags:

ivy7x ×20

Asked: 21.06.2018 at 07:17

Seen: 1,608 times

Last updated: 25.06.2018 at 05:24

Cannot connect Oracle when config system db

Follow this question

Related questions