topic Re: tRunJob using dynamic job option DOES work with shared db connections in Talend Studio

tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Tue, 03 Sep 2013 20:53:42 GMT

I am using TOS 5.1.3
I successfully run tRunJob using the dynamic job option, and do not get errors when using shared db connections in my subjobs (child jobs).
The tRunJob documentation states the following:
This option is incompatible with the Use or register a shared DB Connection option of database connection components. When tRunJob works together with a database connection component, enabling both options will cause your Job to fail.
Was the above fixed, and the documentation is just out of date?
Dave

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 03:50:36 GMT

Hi,
Did you check a "Use or register a shared DB Connection" option in your txxxConnection? Could you please share your screenshot of txxxConnection setting and workflow with us?
Best regards
Sabrina

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 14:42:28 GMT

Hi,
Did you check a "Use or register a shared DB Connection" option in your txxxConnection? Could you please share your screenshot of txxxConnection setting and workflow with us?
Best regards
Sabrina

Sure. images are attached. So, have you heard this limitation was fixed?
Dave

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 18:10:28 GMT

Have you got a screenshot of the connection in your child job?

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 21:06:30 GMT

Have you got a screenshot of the connection in your child job?

sure. attached.
Dave

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 21:07:37 GMT

Have you got a screenshot of the connection in your child job?

attached.

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 21:11:41 GMT

Have you got a screenshot of the connection in your child job?

attached.
Sorry - had to get the file small enough to attach.
Dave

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Wed, 04 Sep 2013 21:23:51 GMT

What I think is happening is...
You've passed context to your child job and you've entered the context parameters in to your child Job's connection.
You're actually creating a new shared connection; which happens to have the same name.
It's unfortunate that the check box is "Use or register..." as this causes confusion.
Try removing the context variables and you should see it fail.

Re: tRunJob using dynamic job option DOES work with shared db connections

alevy — Thu, 05 Sep 2013 15:48:49 GMT

You can test by doing just an insert or update in the parent (with Auto-commit unchecked) and just a commit in the child. I can say fairly confidently that your change won't be committed.

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Thu, 05 Sep 2013 19:07:23 GMT

What I think is happening is...
You've passed context to your child job and you've entered the context parameters in to your child Job's connection.
You're actually creating a new shared connection; which happens to have the same name.
It's unfortunate that the check box is "Use or register..." as this causes confusion.
Try removing the context variables and you should see it fail.

I hard coded the target connection params in the child. It did not fail, but the data did not get committed. I commit in the parent job. So, you are correct - it is just creating a "new" shared connection.
Talend should add functionality that overcomes this limitation.
thanks so much for your help!
Dave

Re: tRunJob using dynamic job option DOES work with shared db connections

Anonymous — Thu, 05 Sep 2013 19:09:53 GMT

You can test by doing just an insert or update in the parent (with Auto-commit unchecked) and just a commit in the child. I can say fairly confidently that your change won't be committed.

yes - I did the reverse (commit in parent), but the child data did not get committed - so bummer - does not work as I originally thought.
Thanks!
Dave