I am curious to know if Oracle connection is shared between FME workspaces and transformers.
For example, I have a workspace which has SQLCreator, SQLExecutor, and Workspace Runner among the others. The workspace in the WorkspaceRunner will also have a bunch of SQLCreators, SQLExecutors, as well as FeatureReaders and FeatureWriters.
My question is will they all share the same Oracle connection/session?
Best answer by richardatsafe
Hi @denisnaumov,
Thanks for those great questions.
FeatureReaders / FeatureWriters use the same connections methods as readers and writers. All readers and transformers share the same database connection if they are set to use persistent connection you should only have a max of two connections per workspace regardless of what transformers or readers/writers you use. (The first for readers/transformers/featureReaders, and the second for all writers/featureWriters)
The workspaceRunners scenario is a good question. Child processes sent by the FME desktop from a workspaceRunner are a new instances, so unlike FME Server the child process will use new connections and not the parents connections.
Thanks,
Richard
This article may be of interest to you:
https://knowledge.safe.com/articles/79080/persistent-connections-and-oracle-database.html
It doesn't answer your question specifically, but you can infer a lot from it.
This article may be of interest to you:
https://knowledge.safe.com/articles/79080/persistent-connections-and-oracle-database.html
It doesn't answer your question specifically, but you can infer a lot from it.
I have read this article before posting my question. It doesn't answer my question directly or indirectly. It doesn't say anything about workspaces. I am also not sure about FeatureReaders and FeatureWriters and whether they are considered transformers or readers and writers.
+10Hi @denisnaumov,
Thanks for those great questions.
FeatureReaders / FeatureWriters use the same connections methods as readers and writers. All readers and transformers share the same database connection if they are set to use persistent connection you should only have a max of two connections per workspace regardless of what transformers or readers/writers you use. (The first for readers/transformers/featureReaders, and the second for all writers/featureWriters)
The workspaceRunners scenario is a good question. Child processes sent by the FME desktop from a workspaceRunner are a new instances, so unlike FME Server the child process will use new connections and not the parents connections.
Thanks,
Richard
+10I have read this article before posting my question. It doesn't answer my question directly or indirectly. It doesn't say anything about workspaces. I am also not sure about FeatureReaders and FeatureWriters and whether they are considered transformers or readers and writers.
Hi @denisnaumov,
Thanks for those great questions.
FeatureReaders / FeatureWriters use the same connections methods as readers and writers. All readers and transformers share the same database connection if they are set to use persistent connection you should only have a max of two connections per workspace regardless of what transformers or readers/writers you use. (The first for readers/transformers/featureReaders, and the second for all writers/featureWriters)
The workspaceRunners scenario is a good question. Child processes sent by the FME desktop from a workspaceRunner are a new instances, so unlike FME Server the child process will use new connections and not the parents connections.
Thanks,
Richard
