AnsweredAssumed Answered

Where to set up Clarity database driver jdbc?

Question asked by matej256 on Apr 26, 2018
Latest reply on May 3, 2018 by matej256

Hi All,


I’d like to ask you where it can be set driver setting/path which is used to connect Clarity to the database – We suppose it should be file ojdbc14.jar in niku/clarity/lib folder…

We are getting this error in admin.log when tried to run Clarity services. (our DB team upgraded to Oracle 12c database)


4/26/18 8:44 AM (admin) Verifying Java Configuration...
4/26/18 8:44 AM (admin) Verifying Database Configuration...
4/26/18 8:44 AM (admin) Failure: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocol
4/26/18 8:44 AM (admin) Verifying App Service (app) Configuration...

Here is the same issue with my SQL developer used ojdbc14.jar:



However, My colleague, who has ojdbc8.jar file in his newer SQL developer, can connect to that Oracle 12c Database…


So for us the point is how can we set this driver to use it in Clarity? Simple copying ojdbc8.jar file into niku/clarity/lib and restarting Clarity didn’t help…Or if you have any other way how can we solve it, please advise.


Appreciate help fromNika_Hadzhikidi, gcubed, nick_darlington in advance as this is quite urgent for us because we can't move on with our upgrade activities.


Thanks a lot!