Yes, you helped me a lot with your post! I did not have the "right" pool type, so I changed it. Thanks for that!
With that I have a potential improvement of OpenAccess: why not showing the user a hint in the Model Settings window when selecting Oracle as backend?! In this hint there should be a link to this
. What about that idea?
But I have some more questions that came up with this problem:
- Is it possible to use more than one context instance? Are there any pitfalls?
- Do you have any idea how to detect that the connection to the Oracle database is broken? There are many Oracle error codes and I don't know which of these are relevant for my problem. Is there any flag in the context object? I did not find anything that would help me.
- What exactly returns OpenAccessContextBase.Connection
if a connection pool is used? (in my case Oracle manages the connection pool)
Once again, thanks for your answer ;)