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.