Data Source Oracle 12c and Oracle 19c cant' use at the same time

[zarneaung]

Hello,

I'm using the Jasper Server CE 7.8.0 Edition.

I have two data source, One is the Oracle Database 19c (ADW), and another one Oracle Database 12c Standard Edition Release 12.2.0.1.0.

I faced the some issue at Data Source that I can't use Oracle 19c Database and Oracle 12c Database at the same time.

I thought that was the JDBC Oracle Driver Problem, When I was trying with Oracle 19c Driver, It is fine for 19c database connection but at the same time I can't connect to 12c driver.

I was tried with 19c driver, 12c driver in

When I had installed 12c driver in 12c data source, It was fine for 12c data source connection, but after that  I can't use 19c (ADW) connection.

How can I solve it? Please kindly help me.

I'm sorry for my bad English.

 

 

 

[vchiem]

Try using an oracle jdbc driver that is compatible with both oracle database versions.

[zarneaung]

Hello @Vchiem,

Thank you for your time and your answer.

From now on, both data sources are working as well.

I found that error too " ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found".

That's why I also changed to setenv.sh.

JAVA_OPTS=-Doracle.jdbc.timezoneAsRegion=false"