https://community.qlik.com/t5/Talend-Studio/Connection-pool-inside-joblet/m-p/2294116#M67025 <P>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?</P> Wed, 25 Apr 2018 06:29:03 GMT Anonymous 2018-04-25T06:29:03Z https://community.qlik.com/t5/Talend-Studio/Connection-pool-inside-joblet/m-p/2294115#M67024 <P>I created a Poc Route that contains a job and a joblet.</P> <P>Inside a job I generate data and insert it to DB. I have a tOracleConnection component that uses connection pooling.</P> <P>I deploy the poc to the runtime.</P> <P>&nbsp;</P> <P>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.</P> <P>How can I solve that?</P> <P>&nbsp;</P> <P>Inside Route</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.PNG" style="width: 891px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwX2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141642iB7ED63BFA6B3F947/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwX2.png" alt="0683p000009LwX2.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Inside job</P> <P><BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwDB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150735i88C94FB74E07E867/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwDB.png" alt="0683p000009LwDB.png" /></span></SPAN></P> <P>Inside joblet</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.PNG" style="width: 839px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lwmp.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155119i60D4085C0DAE3C92/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lwmp.png" alt="0683p000009Lwmp.png" /></span></SPAN></P> <P>&nbsp;tOracle connection component</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture5.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwrP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140051iD2C6537509FE3C34/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwrP.png" alt="0683p000009LwrP.png" /></span></SPAN></P> Sat, 16 Nov 2024 08:21:16 GMT https://community.qlik.com/t5/Talend-Studio/Connection-pool-inside-joblet/m-p/2294115#M67024 Anonymous 2024-11-16T08:21:16Z https://community.qlik.com/t5/Talend-Studio/Connection-pool-inside-joblet/m-p/2294116#M67025 <P>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?</P> Wed, 25 Apr 2018 06:29:03 GMT https://community.qlik.com/t5/Talend-Studio/Connection-pool-inside-joblet/m-p/2294116#M67025 Anonymous 2018-04-25T06:29:03Z