Hello Dava
Yes, you can share and use the connection between main job and jobjet.

Best regards

          shong

shong wrote:

Hello Dava
Yes, you can share and use the connection between main job and jobjet.

Best regards

          shong

Shong,

I tried this, but I cannot link tOracleRow_9 to the joblet (Insert MsgLog) using the "OnSubjobOk" trigger link.  I have setup the shared db connection in both.

My goal is to connect  tOracleRow_9 to connect to the joblet, and then connect the joblet to tOracleRow_8.

???

Screenshots below.

I should add that I can get this to work, using an "Input" inside the joblet instead of a "Trigger Input".  However, since a row trigger would call this in this way, that requires that incomming schemas to the joblet to be the same, and they will not be in my application.  So to get around that, if I remove all all schema elements, then I can get it to work.  But that workaround is not the best in my opinion.  I woudl prefer to use an "OnSubjobOk" trigger to link into the "Trigger Input" in the joblet.

Also, there needs to be a tOracle component.  It would act just like tOracleRow, but would not be considered iterative.  It would be just like a tOracleSP, but not require a stored proc to be executed.  I.E. It could execute any SQL that does not return a resultset.


I am using 3.1.4.

Dave

Last edited by dadumas (2009-12-02 21:49:54)

shong wrote:

Hello

but I cannot link tOracleRow_9 to the joblet (Insert MsgLog) using the "OnSubjobOk" trigger link.

I thought you should know that you are not allowed to create a cycle flow in Talend. See [Forum, topic 1468] multiple tAgregateRow and tMap components.

Best regards

         shong

Shong,

looked at that post, but I did not see the similarity that you describe.  I am just trying to link up an upstream input to the joblet, and a ink from the joblet to the downstream component.

???


Dave