oracle question
From: <XX>
Date: Fri, 17 Jan 2003 14:40:10 +0800
Message-ID: <b088he$4qo7_at_rain.i-cable.com>
Date: Fri, 17 Jan 2003 14:40:10 +0800
Message-ID: <b088he$4qo7_at_rain.i-cable.com>
I have an powerbuilder application that connect to oracle 8.1.7.
The application will automatically retry the db connection if it is failed.
When the oracle is shutdown, the application keep retrying until connection
is success.
The problem is:
Although statement 'connect using trans_obj' fail, there is a
oracle process generated. Although the statement 'disconnect using
trans_obj' fail, the generated
oracle process is not released. At the end, there is a lot of oracle
processes generated.
The generated processes will not be released until the application is
terminated.
How should I implement the retry function?
Thanks. Received on Fri Jan 17 2003 - 07:40:10 CET