470,815 Members | 1,267 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

custom session management using Oracle in web garden scenario

Hello,

I am trying to write a custom session manager in ASP.NET 2.0 using
oracle as the backend. I want to know how the session expires in web
garden and we are using NLB (a session can be served by the multiple
web servers)

Following are few points:

1. How to cleanup session data on Oracle table (on which event need to
cleanup) also how does session expire works in webgarden (is it
possible that all the web server have session active for a particular
client)
2. Can we use Caching to save session data (don't want to hit database
server on every page to load the session data - just a idea)?
3. We are using NLB
4. Custom session management inheriting "SessionStateStoreProviderBase"
class with ASP.NET 2.0/Oracle

I was not able to find any article, which answers these issues. If
anyone can answer these

Thanks in Advance
Sam

Sep 12 '06 #1
2 2571
if you use an out of process session manager then there is no expire event,
you just use a timer. You need to know the session cookie timeout, then
purge sessions older than that.

in the microsft version, they update a timestamp everytime a session is
used. then then schedule a sqlagent job (every few minutes) to delete any
session old enough to expire. you can write simular code.

-- bruce (sqlwork.com)

<sa********@gmail.comwrote in message
news:11**********************@e63g2000cwd.googlegr oups.com...
Hello,

I am trying to write a custom session manager in ASP.NET 2.0 using
oracle as the backend. I want to know how the session expires in web
garden and we are using NLB (a session can be served by the multiple
web servers)

Following are few points:

1. How to cleanup session data on Oracle table (on which event need to
cleanup) also how does session expire works in webgarden (is it
possible that all the web server have session active for a particular
client)
2. Can we use Caching to save session data (don't want to hit database
server on every page to load the session data - just a idea)?
3. We are using NLB
4. Custom session management inheriting "SessionStateStoreProviderBase"
class with ASP.NET 2.0/Oracle

I was not able to find any article, which answers these issues. If
anyone can answer these

Thanks in Advance
Sam

Sep 12 '06 #2
Bruce,

Thanks for response,

Well we are not using SQL server here.

When the Abandon method is called for a particular session, the data
for that session is deleted from the data store using the RemoveItem
method; otherwise the data will remain in the session data store to
serve future requests for the session. will this make sence in this
scenario

Thanks
Sam

bruce barker (sqlwork.com) wrote:
if you use an out of process session manager then there is no expire event,
you just use a timer. You need to know the session cookie timeout, then
purge sessions older than that.

in the microsft version, they update a timestamp everytime a session is
used. then then schedule a sqlagent job (every few minutes) to delete any
session old enough to expire. you can write simular code.

-- bruce (sqlwork.com)

<sa********@gmail.comwrote in message
news:11**********************@e63g2000cwd.googlegr oups.com...
Hello,

I am trying to write a custom session manager in ASP.NET 2.0 using
oracle as the backend. I want to know how the session expires in web
garden and we are using NLB (a session can be served by the multiple
web servers)

Following are few points:

1. How to cleanup session data on Oracle table (on which event need to
cleanup) also how does session expire works in webgarden (is it
possible that all the web server have session active for a particular
client)
2. Can we use Caching to save session data (don't want to hit database
server on every page to load the session data - just a idea)?
3. We are using NLB
4. Custom session management inheriting "SessionStateStoreProviderBase"
class with ASP.NET 2.0/Oracle

I was not able to find any article, which answers these issues. If
anyone can answer these

Thanks in Advance
Sam
Sep 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Microsoft | last post: by
7 posts views Thread by Billy Jacobs | last post: by
1 post views Thread by Tom L | last post: by
20 posts views Thread by Shiv Kumar | last post: by
8 posts views Thread by karahan celikel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.