topic Re: Driver not found for oracle database multitenancy architecture in Talend Studio

Driver not found for oracle database multitenancy architecture

JPradhan1679402896 — Fri, 15 Nov 2024 21:57:53 GMT

Hi,

Recently, we moved our oracle databases to multitenancy architecture, and because of that, we want to use both the primary and secondary databases in the same connection string, and our connection string looks like this:

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=DBServer1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=DBServer2)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB_APPL)))

And in the package lib folder, we have the ojdbc8-12.2.0.1.jar file in place, but when i run the job, it throws error: suitable Driver not found

We are using Talend 7.2 version. And our oracle databases are 19c.

Could you please help me with this?

Regards

Jyoti

Re: Driver not found for oracle database multitenancy architecture

Anonymous — Fri, 24 Mar 2023 03:07:40 GMT

Hello Jyoti,

Could you please try to download the oracle 19 c driver jar from https://mvnrepository.com/artifact/com.oracle.ojdbc/ojdbc8/19.3.0.0

them import the ojdbc8-19.3.0.0.jar by Window->show view->Talend -> Modules view in the studio

then re-try the job?

Re: Driver not found for oracle database multitenancy architecture

JPradhan1679402896 — Thu, 30 Mar 2023 08:20:16 GMT

Hello Achen,

I downloaded the specific jar, but i dont see Talend in 'show view', instead, i see the 'Modules' in the below sections:

Also, i added the jar in the lib floder of the job package on the server. But still, i get the same error.

Regards

Jyoti

Re: Driver not found for oracle database multitenancy architecture

JPradhan1679402896 — Thu, 30 Mar 2023 08:32:50 GMT

And in the below screenshot as you can see, i can only see DB versions upto oracle 18, i dont see oracle 19 there in the list. Could that be a reason?

Re: Driver not found for oracle database multitenancy architecture

SMR040 — Mon, 03 Apr 2023 22:16:41 GMT

I believe Oracle 19c support was introduced in Talend 7.3. Might want to consider upgrading your Talend version.

Also the documentation states that it is recommended to use ojdbc10 instead of 8. refer to below docs:

https://help.talend.com/r/en-US/7.3/installation-guide-windows/compatible-databases

Re: Driver not found for oracle database multitenancy architecture

Anonymous — Mon, 10 Apr 2023 05:13:09 GMT

Hello,

We have added support for Oracle 19c since V 7.3.1.

With your V 7.2.1 solution, you could try generic JDBC as an interim solution till you get 7.3 release.

Best regards

Sabrina