Connection pool inside joblet

Six Stars

Connection pool inside joblet

I created a Poc Route that contains a job and a joblet.

Inside a job I generate data and insert it to DB. I have a tOracleConnection component that uses connection pooling.

I deploy the poc to the runtime.

 

If I put a commit component inside a job the data is inserted into DB(After I run the route) but if I put it inside a joblet the data is not inserted.

How can I solve that?

 

Inside Route

Capture1.PNG

 

Inside job


Capture2.PNG

Inside joblet

Capture3.PNG

 tOracle connection component

Capture5.PNG

Six Stars

Re: Connection pool inside joblet

So my question is if I use connection pooling and if I use commit component inside the joblet(like in the picture) can I insert data to Oracle DB?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.