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

Posted on December 10, 2022 at 4:57am

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.

 

 

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

 

Attachments: 
Image icon 3-driver-installed.png
JasperReports® Server
zarneaung's picture
zarneaung
2
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 setenv.sh.

JAVA_OPTS=-Doracle.jdbc.timezoneAsRegion=false"

zarneaung - 3 months 2 weeks ago
add comment

1 Answer:

Posted on December 12, 2022 at 3:52pm

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

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