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


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

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.



This is the ADW Database 19c, I can connect to this server from Datasource as well. My JDBC driver version is 19c.


zarneaung's picture
Joined: Jul 9 2020 - 9:53pm
Last seen: 3 months 2 weeks ago

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


zarneaung - 3 months 2 weeks ago

1 Answer:

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

vchiem's picture
Joined: May 1 2017 - 5:33pm
Last seen: 2 weeks 1 day ago