ReportServer Forum

aguiral

Member

Registered: 2017-11-30

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

eduardo

Administrator

Registered: 2016-11-01

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

eduardo

Administrator

Registered: 2016-11-01

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