Stop SQL execution by disconnecting Database Connection ???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rinu Gopalakrishna Pillai - 05 Oct 2007 20:24 GMT

Hi All,

I have a ASP/C# application that connect to Oracle database . After
issuing my SQL query if I close the browser or move into another page ( ie
whle executing in the databse serevr) will the SQL execution in server
continue or immediately stop.If it still continue how I can stop the
execution (by disconnecting the present database connection ???).

Please help.

Thanks and Regards
RGP

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 05 Oct 2007 20:34 GMT

Rinu,

You really can't. The server won't know that the connection has
terminated (as far as I know), and will continue processing the page. I'm
not sure if ASP.NET has some connection failure code to stop processing the
page in the event of a disconnect, but it is unlikely.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks and Regards
> RGP

Reply to this Message

Peter Bromberg [C# MVP] - 05 Oct 2007 20:39 GMT

Your only real defense in this situation is a call to
Response.IsClientConnected, but if you have already issued your database
call, then it's probably a moot point.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks and Regards
> RGP

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 05 Oct 2007 20:57 GMT

Hi,

> Hi All,
>
[quoted text clipped - 3 lines]
> continue or immediately stop.If it still continue how I can stop the
> execution (by disconnecting the present database connection ???).

I'm not very sure of how it will work, but I'm pretty sure that the
execution will continue, up to the point where the engine is ready to start
sending back some response, at this point as the client broke the connection
it will get an error and most posibly discard the processing.

If you do not get a good answer here you should post this in other groups,
as the same apply no matter what language you are using.

Reply to this Message

Stop SQL execution by disconnecting Database Connection ???

Free Magazines