On Fri, 9 Nov 2007 14:19:51 +0100, André Hartmann
<andre.hartmann@[EMAIL PROTECTED]
> wrote:
>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.
According to the do***entation:
ORA-03114 not connected to ORACLE
Cause: A call to Oracle was attempted when no connection was
established. Usually this happens because a user-written program has
not logged on. It may happen if communication trouble causes a
disconnection. In addition, this message could occur when ALTER SYSTEM
KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the
IMMEDIATE qualifier because, in those cases, the client's connection
to the database is terminated without waiting for the client to issue
a request.
Action: Try again. If the message recurs and the program is user
written, check the program.
B.
>
> 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é
>:)
|
