How to save Session Data using Oracle?
-
Hi I am creating a web application that will be running on an infrastructure which will utilise a number of web servers, web gardens and a load balancer. As the application is using Sessions, and that our application is using Oracle as the database, we would like to use the database to save the Session data. However, I am struggling to find any good examples on how to do this with Oracle. I note that Oracle provides the following class: Oracle.Web.SessionState.OracleSessionStateStore, but I am unsure what I need to do in the Code Behind and what if any tables do I need to create in the database. Can anyone help me, please?
-
Hi I am creating a web application that will be running on an infrastructure which will utilise a number of web servers, web gardens and a load balancer. As the application is using Sessions, and that our application is using Oracle as the database, we would like to use the database to save the Session data. However, I am struggling to find any good examples on how to do this with Oracle. I note that Oracle provides the following class: Oracle.Web.SessionState.OracleSessionStateStore, but I am unsure what I need to do in the Code Behind and what if any tables do I need to create in the database. Can anyone help me, please?
You can implement a custom session-state store provider for your Oracle database by creating a class that inherits the
SessionStateStoreProviderBaseclass Check them out, How to implement a custom Oracle session provider. [^] ASP.NET Custom Session Store Provider compatible with Oracle, SQL[^] :thumbsup:Cheers ! Abhijit Jana | My Blog | @Twitter | Daily .Net Tips