#1 2017-12-20 09:44:19

aguiral
Member
Registered: 2017-11-30
Posts: 24

set up oracle connection property

Hi,

I'm using RS CE (RS3.0.3-6000 (2017-10-25-16-10-52)).

I have to connect to an Oracle 8 DB.

I'm getting this error

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region  not found

and as I have googled, it would fixed by setting this property on the specific datasource:

oracle.jdbc.timezoneAsRegion=FALSE


Therefore, how can I set up this property on the ReportServer configuration for that specific Oracle datasource ?

Thanks

Alfredo

Offline

#2 2017-12-23 11:48:14

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,204
Website

Re: set up oracle connection property

Hi Alfredo,

we are looking into this and will update this thread when we have more information.

Regards,
Eduardo

Offline

#3 2019-02-19 14:41:06

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,204
Website

Re: set up oracle connection property

Hi Alfredo,

for completeness: a JDBC-Properties field was added in reportserver 3.0.4: https://reportserver.net/releasenotes/RS3.0.4.html
RS-2382    New Feature    Add Properties field to database relational datasources to hold jdbc URL properties

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB