This question is locked. New answers and comments are not allowed.
This is my first post here in this forum and I hope that I'm right here ;)
At the moment I write a Windows service that loads data from a third party system and saves them to an Oracle database. From time to time the database must be rebooted or the network is not available any more, so the database connection gets broken. This can happen during the service doing nothing and also while executing queries.
Is there any possibility for an automatic reconnect of the current context? I must say that I create only one context at the beginning of the service lifetime. Or do I have to create a new context each time I want to exchange data with database?
At the moment I write a Windows service that loads data from a third party system and saves them to an Oracle database. From time to time the database must be rebooted or the network is not available any more, so the database connection gets broken. This can happen during the service doing nothing and also while executing queries.
Is there any possibility for an automatic reconnect of the current context? I must say that I create only one context at the beginning of the service lifetime. Or do I have to create a new context each time I want to exchange data with database?