Store SessionState in SQL Server?

[adam_recktenwald]

Hi all,

We have a multi-server web farm with several portal application servers (NetWeaver 2004, SP19, PDK 2.5 runtime) and .net runtime services. Because of this, I'd like to be able to store our .net session state in SQL so that no matter what server the user hits, the session would be available.

Anyone know of a way to pull this off with the .net PDK?

Thanks!

-Adam

[Former Member]

Hi Adam,

how are you doing ?

Session Management [SessionManagementSettings] in EP is a portal service, it is not currently available using the NPDK

As of this post, only Systems Service & User Management Service is available

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/com.sap.km.cm.docs/library/dotnet/pdk%20for%20.net/developer's%20Guide%20PDK%202.0%20for%20.NET/index.html" target="_new">NPDK Portal Services : https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/com.sap.km.cm.docs/library/dotnet/pdk%20for%20.net/developer's%20Guide%20PDK%202.0%20for%20.NET/index.html</a>

As a work around,

1> you could create your own session management table in SQL :

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/com.sap.km.cm.docs/library/dotnet/pdk%20for%20.net/developer's%20Guide%20PDK%202.0%20for%20.NET/index.html" target="_new">NPDK Access SQL Server : https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/com.sap.km.cm.docs/library/dotnet/pdk%20for%20.net/developer's%20Guide%20PDK%202.0%20for%20.NET/index.html</a>

[please copy paste the link, the ' in the URL usually makes it un recognizeable]

2> use hidden input tags in your iViews

<input type=hidden id="hidName" runat=server name ="hidName" value="myName">

with respect,

amit