Re: How to simulate ORA-03114 "Not connected to Oracle" in a test application?

From: Brian Tkatch <N/A>
Date: Fri, 09 Nov 2007 13:50:01 -0500
Message-ID: <>

On Fri, 9 Nov 2007 12:45:34 -0500, "Paul" <> wrote:

>"André Hartmann" <> wrote in message
>> Hi there,
>> I would like to simulate ORA-03114 in a test application and I would like
>> to get some clues as to how to do this.
>> Since people are probably going to ask why I want to do that, here is
>> some background. An Oracle client application of ours that connects to
>> Oracle via OCI, sometimes faces loss of connection, for example when a lap
>> to goes into hibernation or the network is unstable. We are speaking of a
>> Windows 2000, XP, Vista client here. Now we want to improve the error
>> handling in our application in this specific case. That is no problem
>> because ORA-03114 can be detected and appropriate measures can be taken
>> (error message, automatic reconnection, ...).
>> However for every issue that we fix in our applications we are writing a
>> test case which will test a particular behaviour or bug fix. We do this in
>> form of unit tests, so the unit test application will simply run for a
>> short or long span of time without user interaction and protocol what
>> happened, for example how many of the tests succeeded and how many failed.
>> The loss of connection we dont know how to simulate. One way is to use
>> OEM and manually KILL the session at the appropriate point of time and see
>> what the application will do. But that requires user interaction, so its
>> not like you can run the tests over night and just scan the protocol the
>> next morning...
>> We are using MS Dev studio 2005/2003 and the standard OCI library. Thanks
>> very much in advance
>> André
>> :)
>Raise application error , kill

[Quoted] You cannot raise that error.

B. Received on Fri Nov 09 2007 - 19:50:01 CET

Original text of this message