Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-xxxfer.readnews.com!news-out.readnews.com!postnews3.readnews.com!nr2.newsreader.com.POSTED!not-for-mail From: Brian Tkatch Newsgroups: comp.databases.oracle.tools Subject: Re: How to simulate ORA-03114 "Not connected to Oracle" in a test application? Date: Fri, 09 Nov 2007 13:50:01 -0500 Message-ID: References: <47345e78$0$16669$9b4e6d93@newsspool3.arcor-online.net> <811Zi.13241$xa2.9514@read2.cgocable.net> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 43 Organization: NewsReader.Com Subscriber NNTP-Posting-Host: 63550c98.nr2.newsreader.com X-Trace: DXC=X7=F;_e[U[eSbeN62@bdOlOA8_@f\K_ib7oD1oC=h``nkMKQ9>8_9ZbAbmmAdWJcCbVfLdSL;bMA`jPQlIMEo2na X-Complaints-To: abuse@newsreader.com Xref: usenetserver.com comp.databases.oracle.tools:181774 X-Received-Date: Fri, 09 Nov 2007 13:50:01 EST (text.usenetserver.com) On Fri, 9 Nov 2007 12:45:34 -0500, "Paul" wrote: > >"André Hartmann" wrote in message >news:47345e78$0$16669$9b4e6d93@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 > You cannot raise that error. B.