On Fri, 9 Nov 2007 12:45:34 -0500, "Paul" <paulq_1998@[EMAIL PROTECTED]
>
wrote:
>
>"André Hartmann" <andre.hartmann@[EMAIL PROTECTED]
> wrote in message
>news:47345e78$0$16669$9b4e6d93@[EMAIL PROTECTED]
>> 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
>
You cannot raise that error.
B.


|