https://community.qlik.com/t5/Talend-Studio/How-to-share-a-DB-Connection-in-dynamic-tRunJob/m-p/2246906#M32266 <P>I get that since tRunJob runs subs jobs in independent processes, you can't use shared DB connection.</P><P>Checking "Use or register a shared DB connection" option will not share it.</P><P>&nbsp;</P><P>Is there a workaround for this problem?</P> Sat, 16 Nov 2024 04:39:54 GMT sarora1 2024-11-16T04:39:54Z https://community.qlik.com/t5/Talend-Studio/How-to-share-a-DB-Connection-in-dynamic-tRunJob/m-p/2246906#M32266 <P>I get that since tRunJob runs subs jobs in independent processes, you can't use shared DB connection.</P><P>Checking "Use or register a shared DB connection" option will not share it.</P><P>&nbsp;</P><P>Is there a workaround for this problem?</P> Sat, 16 Nov 2024 04:39:54 GMT https://community.qlik.com/t5/Talend-Studio/How-to-share-a-DB-Connection-in-dynamic-tRunJob/m-p/2246906#M32266 sarora1 2024-11-16T04:39:54Z https://community.qlik.com/t5/Talend-Studio/How-to-share-a-DB-Connection-in-dynamic-tRunJob/m-p/2246907#M32267 <P>I *think* you might be able to do this if you run your job inside the Talend ESB runtime. You can use connection pooling there. I have only done this with services, but it should behave in the same way. Take a look at this forum post&nbsp;<A href="https://community.qlik.com/s/feed/0D53p00007vCnU6CAK" target="_blank">https://community.talend.com/t5/Design-and-Development/setting-up-JDBC-connection-pool-in-Talend-ESB-container/td-p/23255</A></P> Mon, 16 Sep 2019 21:25:23 GMT https://community.qlik.com/t5/Talend-Studio/How-to-share-a-DB-Connection-in-dynamic-tRunJob/m-p/2246907#M32267 Anonymous 2019-09-16T21:25:23Z