Skip to main content
Question

Reopening or testing connection to Oracle

  • June 14, 2018
  • 0 replies
  • 48 views
L
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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,058
Posts
121,723
Replies
39,686
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.