I get that since tRunJob runs subs jobs in independent processes, you can't use shared DB connection.
Checking "Use or register a shared DB connection" option will not share it.
Is there a workaround for this problem?
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 https://community.talend.com/t5/Design-and-Development/setting-up-JDBC-connection-pool-in-Talend-ESB...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas