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

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

>
>"André Hartmann" <andre.hartmann_at_hotmail.de> wrote in message
>news:47345e78$0$16669$9b4e6d93_at_newsspool3.arcor-online.net...
>> 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