Skip to main content
Question

Reopening or testing connection to Oracle


Forum|alt.badge.img

Hello,

I've encountered to a problem with my connection to Oracle DB. I have a workbench that needs a fair amount of time to process. I don't know how but connecting to Oracle DB is executed at the start of translation an by the time all features are ready to be written to DB FME gives me message:

Error committing transaction on Oracle connection: message was `ORA-03114: not connected to ORACLE'. (serverType=`ORACLE8I', serverName=`//ORACLE_DB:1521/orcl', userName=`SYSTEM', password=`***', dbname=`')

 

After this message translation is still active but nothing is happening. My DB is located on separate server connected over LAN network.

Is there a possibility to:

a) Set that connection to Oracle DB is executed when features are ready to commit?

b) When connection is lost that FME reconnects to DB an continue with translation?

I am using FeatureWriter to write to my DB with FeatureHolder in front of it.

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings