SUMMARY:
Attempting to validate an oracle datasource switch from “thin” to “oci” client I get:
Incompatible version of libocijdbc[Jdbc:218000, Jdbc-OCI:2112000]
Can anyone who looks at the source code share the version matching logic for the oracle OSGI extensions and the oracle native client ?
Even better are the versions of the lucee OSGI oracle client and the oracle native client that are compatable?
MORE DETAIL
Instead of the default ‘thin’ version of the oracle driver , I’m attempting to use the oci version because co-workers suggest I can set an environment variable and maybe make my timezone issues go away. (see: previous post re ORA-01882 )
However it doesn’t look like there is a current lucee provided OSGI version of the oracle driver than matches up the available oracle provided instant clients:
Attempting to validate a switch from “thin” to “oci” client I get:
Incompatible version of libocijdbc[Jdbc:218000, Jdbc-OCI:2112000
From Lucee extensions page these are the available oracle OSGI wrapped drivers:
download version (19.12.0.0000)
21.8.0.0-ojdbc11
21.8.0.0-ojdbc8
21.3.0.0000
21.3.0.0-ojdbc11
21.3.0.0-ojdbc8
19.17.0.0-ojdbc8
19.12.0.0-ojdbc8
19.12.0.0000
12.1.0.2
11.2.0.4
10.2.0.2
From the oracle instant-client download page these are the available versions
21.12.0.0.0
19.21.0.0.0
19.19.0.0.0 (Requires glibc 2.14) - for OL9/RH9 only
12.2.0.1.0
12.1.0.2.0
11.2.0.4.0
11.1.0.7.0
10.2.0.5
10.1.0.5
It looks like lucee: 12.1.0.2 / oracle: 12.1.0.2.0 , is the best match but these are awfully old (out of support in 2022 ) Also my first experiment, with these versions, late-ish last night, I got new error I did not record.
As a semi relevant aside, The systemd unit file tomcat9.service has: Environment="LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib:$LD_LIBRARY_PATH"
…when it doesn’t lucee complains about not finding libocijdbc21)
Lucee 5.4.4.38
oracle driver: 21.8.0.0-ojdbc11
ubuntu 22.04
tomcat: 9.0.58-1ubuntu0.1
openjdk-11-jre-headless:amd64 11.0.21+9-0ubuntu1~22.04
oracle-instantclient-basic 21.12.0.0.0-2 amd64