How to share a DB Connection in dynamic tRunJob

[sarora1]

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?

[Anonymous]

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...