You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Keycloak 19 Quarkus with Ojdbc8 to avoid issue of UnsatisfiedLinkError: no ocijdbc21
#14362
We presently run keycloak (wildfly version) 18.0.2 and are looking to migrate to quarkus version.
We run on a server with Oracle12 client libraries installed, that connects to an Oracle 19 database.
For our quarkus deploy, we did a build with --db oracle, but when we started it we received the following error:
ERROR: java.lang.UnsatisfiedLinkError: no ocijdbc21 in java.library.path: [/usr/lib/oracle/12.2/client64/lib/, /usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]
This would appear to be caused by keycloaks usage of the jar: keycloak-quarkus/lib/lib/main/com.oracle.database.jdbc.ojdbc11-21.4.0.0.jar which expects the lib
What we have is: libocijdbc12.so
$ ls -l /usr/lib/oracle/12.2/client64/lib/
total 216260
-rw-rwxr--. 1 root root 8033199 Jan 27 2017 libclntshcore.so.12.1
-rw-rwxr--. 1 root root 71638263 Jan 27 2017 libclntsh.so.12.1
-rw-rwxr--. 1 root root 2981501 Jan 27 2017 libipc1.so
-rw-rwxr--. 1 root root 539065 Jan 27 2017 libmql1.so
-rw-rwxr--. 1 root root 6568149 Jan 27 2017 libnnz12.so
-rw-rwxr--. 1 root root 2218687 Jan 27 2017 libocci.so.12.1
-rw-rwxr--. 1 root root 124771800 Jan 27 2017 libociei.so
-rw-rwxr--. 1 root root 158543 Jan 27 2017 libocijdbc12.so
-rw-rwxr--. 1 root root 380996 Jan 27 2017 libons.so
-rw-rwxr--. 1 root root 116563 Jan 27 2017 liboramysql12.so
-rw-r--r--. 1 root root 3984814 Jan 27 2017 ojdbc8.jar
-rw-r--r--. 1 root root 37494 Jan 27 2017 xstreams.jar
So apart from copying the ojdbc8.jar over the file com.oracle.database.jdbc.ojdbc11-21.4.0.0.jar (which seems misleading and wrong, but using to prove it can still work), how can we otherwise ensure that our install of keycloak quarkus is able to use ojdbc8.jar instead? Is there a build option or something else we need to do?
For the wildfly version we used module config such as this:
On the quarkus version we had added the following module:
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Hi
We presently run keycloak (wildfly version) 18.0.2 and are looking to migrate to quarkus version.
We run on a server with Oracle12 client libraries installed, that connects to an Oracle 19 database.
For our quarkus deploy, we did a build with --db oracle, but when we started it we received the following error:
ERROR: java.lang.UnsatisfiedLinkError: no ocijdbc21 in java.library.path: [/usr/lib/oracle/12.2/client64/lib/, /usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]This would appear to be caused by keycloaks usage of the jar: keycloak-quarkus/lib/lib/main/com.oracle.database.jdbc.ojdbc11-21.4.0.0.jar which expects the lib
What we have is: libocijdbc12.so
We cannot change the oracle installation, and the documentation (https://www.keycloak.org/server/db) states compatible with Oracle 12c.
So apart from copying the ojdbc8.jar over the file com.oracle.database.jdbc.ojdbc11-21.4.0.0.jar (which seems misleading and wrong, but using to prove it can still work), how can we otherwise ensure that our install of keycloak quarkus is able to use ojdbc8.jar instead? Is there a build option or something else we need to do?
For the wildfly version we used module config such as this:
On the quarkus version we had added the following module:
All reactions