Re: Profiles, idle time and the web

I would have to agree with Victoria. There's no need for such rudeness, no matter how frustrated the web programmers make you. It's about professionalism.

David Peasley
Adams State College
Alamosa, CO 81102
david_at_adams.edu

dgoulet_at_vicr.com wrote:

> Victoria,
>
> I must assume from your reply that you have not been bothered by WEB based
> applications previously. Well, I have and I can sympathize with both of you.
> It's just very obvious that your new at it and MLaden is not. Sure we all
> should not vent our frustrations in an unsympathetic manner, but you don't know
> how many times I'd love to wring a web developers neck over this. The problem
> is that whether the app is developed in house or by a third party the developer
> always assumes that the DB is a constant resource that they and their surfers
> will have UNLIMITED access to. They are also not very aware of or care about
> error trapping. All of these normal concepts to client/server developers seem
> to be unfathomable by WEB folks. Consequently your stuck with two basic
> options:
>
> 1) don't monitor idle time at all (idle time limit = unlimited)
> 2) reboot the web server daily and whenever an error gets reported
>
> OH, BTW; don't do cold backups either, WEB folk can not understand why anyone
> would want to do a backup in such a "dynamic" environment. Also, don't try to
> explain the need to do recovery when the DB crashes to them, because 'nothing
> ever crashes' in their world.
>
> And folks wonder why I've said that the WEB is irrelevant.
>
> Dick Goulet
> ____________________Reply Separator____________________
> Author: "Victoria DeVore" <DEVOREV_at_gw.lbcc.cc.or.us>
> Date: 10/16/00 6:55 PM
>
> If you have nothing better to do than answer a question in such a demeaning and
> senseless manner, you should not be answering at all! Trust me, you would never
> work in my shop!
>
> Victoria DeVore
> Linn-Benton Community College
> Systems & Application Programming Manager
> 6500 Pacific Blvd. SW
> Albany, OR 97321
> (541)917-4355
> (541)917-4379 FAX
> devorev_at_gw.lbcc.cc.or.us
>
> >>> MGogala_at_oxhp.com 10/16/00 06:21PM >>>
> Of course that killing of the session will cause an exception in
> the running forms programs! What do you think should happen? The
> form should proceed normally regardless of the fact that it has
> just been disconnected from the database? I don't think so. Remember,
> the whole session and with it the whole form context is gone. What
> should a decent the form do? Ignore such a minute annoyance? Send
> the user back to Kansas? Page the DBA?
>
> -----Original Message-----
> Sent: Monday, October 16, 2000 7:21 PM
> To: Multiple recipients of list ORACLE-L
>
> I am maintaining a third party application system that is run thru the web
> via OAS 4.0.8.1 to D2K 1.6.1 server. I am trying to control user idle time.
> We set an idle time of 120 minutes in a profile on the database side. The
> only problem is it causes unhandled exceptions in the forms. I know I could
> control this in the form, but as I mentioned this is a third party product.
> There are 100s of forms and I do not want to modify all of the forms, let
> alone maintain them.
>
> My question is, is there any other way to capture this idle timeout? Any
> suggestions?
>
> Victoria DeVore
> Linn-Benton Community College
> Systems & Application Programming Manager
> 6500 Pacific Blvd. SW
> Albany, OR 97321
> (541)917-4355
> (541)917-4379 FAX
> devorev_at_gw.lbcc.cc.or.us
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Victoria DeVore
> INET: DEVOREV_at_gw.lbcc.cc.or.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Victoria DeVore
> INET: DEVOREV_at_gw.lbcc.cc.or.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Oct 17 2000 - 15:06:40 CDT