Facing issues for some Talend jobs where driver is Oracle 11.1.0.6. Need help to know where to check driver version in Studio or TAC?

[NC1648133212]

We are currently using Talend 6.2.1

We have upgraded our database to Oracle 19c

We intend to remain on same Talend version.

We are facing issue with connectivity an getting issue:

java.sql.SQLException: ORA-28040: No matching authentication protocol

Few of the components inside Talend are using

Oracle 11.1.0.6 driver and few are using 12.1.0.2

We are not facing any issue for jobs where driver is

12.1.0.2 version

We ae facing issues for some Talend jobs where driver is Oracle 11.1.0.6

1. Our question is - how do we identify which components are on Oracle 11.1.0.6 where we are facing issues. Request steps to find out in Talend or any server or database if needed.

2. Are these drivers part of Talend Devleopment Studio or Talend Administrative Center (TAC)?

Please guide us on above. This is urgent for us.

[Anonymous]

I'm not sure I have correctly understood the question here, but have you tried looking in the .items files for the job? These are all XML files essentially. You will find an element that looks similar to this.....

<elementParameter field="CLOSED_LIST" name="DB_VERSION" value="ORACLE_18"/>

This shows the DB version selected for your connection. This should help you go some way in identifying this.

[ChaitraCP]

I'm facing same issue. Kindly help me on this.