Problem connection Oracle 11g

Highlighted
Four Stars

Problem connection Oracle 11g

Hello,

 

I try to connect an Oracle 11g DB in Talend 7.2.1 with JRE 8

 

I don't have any problem to connect the DB in SQLDevelopper.

 

2020-03-25 17_08_26-Connexion à la base de données.png

 

When I test the connection, I have this message :

2020-03-25 17_10_10-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ DecFiTest (Conne.png

 

When I select Oracle 18 version, I can connect the DB. But I can't create queries...

Tags (1)
Highlighted
Four Stars

Re: Problem connection Oracle 11g and creating first job

I try this setting and it's working :

 

2020-03-27 17_04_16-Connexion à la base de données.png

 

Now i'm trying to create a simple job to extract data from a table to a file. And I have this error :

2020-03-27 17_07_53-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ Local_Project (C.png

 

Could you help me ?

Highlighted
Four Stars

Re: Problem connection Oracle 11g and creating first job

I don't have the same error when I try multiple executioin without changes :

2020-03-27 17_12_23-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ Local_Project (C.png2020-03-27 17_15_08-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ Local_Project (C.png2020-03-27 17_15_36-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ Local_Project (C.png2020-03-27 17_15_57-Talend Open Studio for Data Integration (7.2.1.20190620_1446) _ Local_Project (C.png

Highlighted
Four Stars

Re: Problem connection Oracle 11g and creating first job

Hello,

 

It's ok, i have installed JDK 1.8 and change the settings in talend's preference...

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog