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 184.108.40.206.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.
Try using an oracle jdbc driver that is compatible with both oracle database versions.
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.