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?