Upgrade from 7.1 to 7.6 - Oracle driver 11.2.x not supported anymore


(nicola) #1

I’m currently running sonarqube 7.1-alpine as a docker container, connecting to an Oracle database.
I tried to upgrade to sonarqube 7.6-Community, but during the boot I see this error in the logs:

2019.01.29 13:18:18 ERROR web[o.s.s.p.Platform] Web server startup failed: Unsupported Oracle driver version: 11.2.0.4.0. Minimal supported version is 12.1.
2019.01.29 13:18:18 INFO app[o.s.a.SchedulerImpl] Process [web] is stopped
2019.01.29 13:18:19 INFO app[o.s.a.SchedulerImpl] Process [es] is stopped
2019.01.29 13:18:19 INFO app[o.s.a.SchedulerImpl] SonarQube is stopped
2019.01.29 13:18:19 WARN app[o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 143

In the prerequisites Oracle 11.2.x driver is mentioned as supported.

Is the doc outdated?


(G Ann Campbell) #2

Hi,

Yes, the doc is outdated. Thanks for reporting it and sorry for your trouble. The docs correction is queued for 7.7. The ticket related to the technical change says

Users can still use Oracle11c but with the backward compatibility of the driver for Oracle 12g.

 
Sorry & thx again,
Ann


(nicola) #3

Hi,
About this point:

Users can still use Oracle11c but with the backward compatibility of the driver for Oracle 12g

How do I do that? Should I specify a flag during the start up of the container?


(G Ann Campbell) #4

Hi,

It took quite a bit of Google-fu to find it, but the answer appears to be that It Just Works.

 
Ann


(nicola) #5

I think the problem is not the oracle’s driver, maybe that one works for real. It looks to me that sonarqube has a check in its code that doesn’t allows oracle’s drivers older than version 12 (look here).

please correct me if I’m wrong.

thanks for the support,
Nicola


(G Ann Campbell) #6

Hi Nicola,

We added that exclusion because of a change in the underlying technical requirements. I promise we didn’t exclude the 11 driver arbitrarily.

 
:slight_smile:
Ann


(nicola) #7

Hi Ann,
I’m sure it was done for some good reason.
Just to summarize: I can’t upgrade to sonarqube 7.6, because that check will always detect that my Oracle is 11.2.x.

thanks for all your support,
Nicola


(G Ann Campbell) #8

Hi,

I think there’s a crossed wire. You can connect to 11 using the 12 driver.

Ann