Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
A way to get back lost session values
21 views
Skip to first unread message
jbe...@gmail.com
Oct 12, 2012, 11:57:18 AM10/12/12
to
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?
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?
Brian Cryer
Nov 1, 2012, 12:05:14 PM11/1/12
to
<jbe...@gmail.com> wrote in message
news:60281abf-8b0f-4c5c...@googlegroups.com...
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/mswinswdev/ms_vbnet_howto_session_store.htm
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian
news:60281abf-8b0f-4c5c...@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>
> 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.
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/mswinswdev/ms_vbnet_howto_session_store.htm
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian
gourmetki...@hotmail.com
Nov 7, 2012, 6:22:37 AM11/7/12
to
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
Mike Lalonde / Kat Lalonde
Sudbury, Ontario
Jumlers.com catering
Brian Cryer
Nov 7, 2012, 7:28:32 AM11/7/12
to
<gourmetki...@hotmail.com> wrote in message
news:a242de35-9889-4bf7...@googlegroups.com...
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
news:a242de35-9889-4bf7...@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:
> an expiration date
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
0 new messages