Re: mod_plsql, mod_ose questions

From: BB <BarneyTheDinasour_at_barneyworld.com>
Date: Fri, 17 Jan 2003 13:19:01 GMT
Message-ID: <9pTV9.22540$UB4.94508_at_news-server.bigpond.net.au>


I think OSE is being desupported. Oracle are trying to push towards OC4J.

As for your problem could you just have one hidden field which was a reference to a table containing session related data?

ie when a user logs on give them a session number from a sequence and place that as a hidden field in a form.
Then have a table with columns session_id,

                                                field_name,
                                                field_value,
                                                date_expires
This may work but would be a bit messy.

"Maximus" <jskdfjsd_at_sdkfsdjk.com> wrote in message news:GqIV9.49326$sV3.2687950_at_news3.calgary.shaw.ca...
> "Frank" <fvanbortel_at_netscape.net> wrote in message
> news:3E272A4C.60503_at_netscape.net...
> > Maximus wrote:
> > > I want to use PL/SQL to write a web application but I can't figure out
 how
> > > maintain state with it. I have mod_plsql running but it seems to only
> > > function in stateless mode, and for the life of me I can't figure out
 where
> > > to find and how to install mod_ose, which is supposed to support
 stateful
> > > sessions. I really want to avoid using cookies and/or hidden form
> > > variables. Am I missing something or does mod_ose not exist in Oracle
 9i
> > > R2??
> > >
> > >
> >
> > mod__ose (2 underscores...) came/comes with the AS, not the RDBMS...
> > And it's still there.
> > BTW cookies and hidden fields are *very* common, as the internet *is*
> > stateless by design. Beats me why you would abandon that.
> >
> > Frank
>
> Could not find any reference in 9iAS rel 2 to mod_ose (or mod__ose). I
> would assume it is part of the Apache install but it simply isn't there.
 I
> know mod_ose was in 9iAS rel 1 but it seems to have been mysteriously
> dropped in release 2.
>
> As for mainting state, cookies don't work very well with multiple sessions
> on the same machine, since all browser instances share the same cookie
 data.
> Using hidden fields to maintain state is an option, but I would have to
 code
> about a hundred or so hidden form fields into every page. What a *&^%&!
> pain. :)
>
>
Received on Fri Jan 17 2003 - 14:19:01 CET

Original text of this message