Help connecting to Oracle 19c in Talend ESB 5.4.1

[DM1643838338]

We have an old project in Talend ESB 5.4.1

We need it to work with Oracle 19c

I opened the project in Open Studio and specified the new connection information for the tOracleConnection. But DB Version doesn't have values higher the Oracle 11-6. It uses ojdbc6.jar.

I added ojdbc7,jar to the project classpath, I also just copied it to the Studio\lib\java but tOracleConnection still allows to select Oracle 11 or 11-6 but not versions higher then that.

I also tried just delete ojdbc6.jar from

Studio\lib\java but when I build a project it requires me to download ojdbc6.jar. Somewhere I saw suggestions to rename ojdbc7 as ojdbc6 and replace the original ojdbc6.jar. It din't make a difference.

Any suggestions? What do I do wrong? Should I be able to connect to Oracle 19 from old Talend ESB 5.4.1 or I need to use a newer version of Talend? Please advise.

[Anonymous]

Hello @Dina Masis​ ,

You can upgrade the oracle jdbc driver by open the Window->show view->Talend->Modules view, the search the ojdbc6 to find the module ojdbc6.jar, click the "..." button to open the Install Module dialog, select the ojdbc8.jar that's for oracle19c db, and provide a Custom MVN URI: mvn:com.oracle.jdbc/ojdbc8/19.3.0.0/jar like the below, click OK to install it. then you can use this new driver in Oracle components in the job.

 

please refer to the article: https://help.talend.com/r/en-US/8.0/studio-user-guide/installing-external-modules-manually-using-modules-view

Best regards

Aiming

[DM1643838338]

Thank you very much Aiming. In Talend 5.4.1 I can't specify MVN URI but I was able to just select ojdbc7.jar from the file system. In Modules view they are still shown as ojdbc6.jar but it's working now in the Studio. The question is now how to deploy it to the server. I am very new to Talend ESB. I exported service as kar file and replaced the old with this new one on the server Runtime/container/deploy. Just in case I copied ojdbc7.jar to the same location and to the Runtime/container/lib. Then I start the Talend ESB Container Service on Services.

But it's not working. I am getting the Job execution error;ORA-28040: No matching authentication protocol

What do I do wrong?