topic Re: [resolved] Problem with using existing connection (oracle) in Talend Studio

[resolved] Problem with using existing connection (oracle)

Anonymous — Mon, 27 Jul 2015 18:10:32 GMT

Hi,
I have a similar issue as posted by Jijli early today. Table truncated but no data inserted. I have a simple job:

tOracleconnection_1 - property type, repository. Use or register a shared DB connection box check, and shared name entered.
tFileInputPositional_1 - pick up a fixed width text file with repository schema applied. limited 50 rows
tOracleOutput_1 - used an existing connection box checked. component list "tOracleconnection_1" in yellow color. Action on table - truncate, action on data- insert, schema-repository, die on error box checked. Dynamic setting, component list and tOracleConnection_1.

I ran it with no errors. I check the oracle table truncated but no data inserted. It works fine without using an existing connection.

Please help.
Thanks
Andy

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Tue, 28 Jul 2015 04:23:38 GMT

Hi,

Use or register a shared DB connection box check, and shared name entered.

Did you want to share your connection or fetch a connection shared by a parent or child Job? This option allows you to share one single DB connection among several DB connection components from different Job levels that can be either parent or child.
Could you please show us your job design screenshot?

Best regards
Sabrina

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Tue, 28 Jul 2015 16:04:37 GMT

as you can see the jpg. tOracleOutput_1 truncated the table but no data inserted. It's using the connection defined in tOracleconnection_1.

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Tue, 28 Jul 2015 16:06:28 GMT

here's the design:

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Tue, 28 Jul 2015 16:15:32 GMT

design:

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Wed, 29 Jul 2015 09:01:39 GMT

Hi andrew.tan,

Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Note: screenshots works only if you drag&drop the image directly in the editor window.

Best regards
Sabrina

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Wed, 29 Jul 2015 14:29:21 GMT

Sorry for the delay. Please have a look at the design below. The one on the right is duplicate.

The part that I need help with is the tOracleOutput_1. It truncated the table but no data inserted, the 50 rows from tFileInputPositional_1.

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Wed, 29 Jul 2015 14:33:04 GMT

screenshot:

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Thu, 30 Jul 2015 08:44:58 GMT

hi,
commit your data on Component Ok trigger or roolback on componenet error.

When you 're using a shared connection , you 're in a transaction ans so you've to manage commit & roolback

ps : simple test : run your job like this and use commit sql command from your Oracle edi ...

regards
laurent

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Thu, 30 Jul 2015 20:01:56 GMT

Thanks for the help.
Data finally got inserted to the tables. I have attached 2 images from 2 different jobs. One with OracleCommit and one with OracleClose.

Re: [resolved] Problem with using existing connection (oracle)

Anonymous — Fri, 31 Jul 2015 15:00:55 GMT

thanks to put post as resolved

regards