A way to get back lost session values
 

My web application is losing session values for some reason, and it happens after an external web page is called. My application is quite big, so any major change would require too much time. My database is Oracle, not Sql Server.

Would be there an alternative way to store value of those session variables? Actually I just need to keep two session variables.

I was thinking to store those values in a Oracle table. Key would be SessionID. I read that SessionID keeps its value even after other session variables are recycled or lost, but I'm not complete sure.

I was planning to put a function on each page, on Page_Load mewthod, checking if session variable is still there. If not, then go to Oracle table and retrieve it.

Something like:

If Session("MyVariable") Is dbNull.Value Then
Seek it on Oracle table, using SessionID as Key, and assign to variable Var
Session("MyVariable") = Var
End If

Do you think it would be OK? Can I trust SessionID?

Re: A way to get back lost session values
 

<jbeteta@gmail.com> wrote in message
news:60281abf-8b0f-4c5c-bd0f-1fd0eb5b4108@googlegroups.com...
> My web application is losing session values for some reason, and it
> happens after an external web page is called. My application is quite big,
> so any major change would require too much time. My database is Oracle,
> not Sql Server.
>
> Would be there an alternative way to store value of those session
> variables? Actually I just need to keep two session variables.
<snip>

The obvious reason for losing session variables is that you are storing
sessions in-proc and your application is recycling. So, on the assumption
that you are using in-proc (the default) I would change to state server.
Details here:
http://www.cryer.co.uk/brian/mswinsw...sion_store.htm

Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian

Re: A way to get back lost session values
 

Why not store them in cookies? they wouldn't expire unless you give them an expiration date


Mike Lalonde / Kat Lalonde
Sudbury, Ontario
Jumlers.com catering

Re: A way to get back lost session values
 

<gourmetkingsudbury@hotmail.com> wrote in message
news:a242de35-9889-4bf7-8d6f-872022db71ce@googlegroups.com...
> Why not store them in cookies? they wouldn't expire unless you give them
> an expiration date

Be aware that there are issues with using cookies:
1. Cookies limit the amount of data you can store - although they are fine
for small amounts of data.
2. If they know what they are doing then cookies can be read by the user -
although again this might or might not be an issue.
3. If someone is keen enough then I think they can modify the value of a
cookie, which then means that you need to verify that the value is legit.
4. If the website is in Europe then you ought to worry about the (daft) EU
cookie law.

I'm not anti cookies. They have their uses and it is good to be aware of
them.

Better would be for the OP to identify why session data is being lost.
However I expect we will never know because it doesn't look like the OP is
responding.
--
Brian Cryer
http://www.cryer.co.uk/brian