A way to get back lost session values

Discussion in 'ASP .Net' started by jbeteta, Oct 12, 2012.

  1. jbeteta

    jbeteta Guest

    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?
    jbeteta, Oct 12, 2012
    1. Advertisements

  2. jbeteta

    Brian Cryer Guest


    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:

    Hope this helps.
    Brian Cryer, Nov 1, 2012
    1. Advertisements

  3. 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
    gourmetkingsudbury, Nov 7, 2012
  4. jbeteta

    Brian Cryer Guest

    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

    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
    Brian Cryer, Nov 7, 2012
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.