[resolved] Problem with using existing connection (oracle)

Highlighted
Six Stars

[resolved] Problem with using existing connection (oracle)

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


Accepted Solutions
Seventeen Stars

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

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

All Replies
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

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

here's the design:
Six Stars

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

design:
Moderator

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

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


 



--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

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

screenshot:


Seventeen Stars

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

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
Six Stars

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

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.


                                                
                                                                                                                                                   
                                                                                                                                                                                                   
Seventeen Stars

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

thanks to put post as resolved Smiley Wink

regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog