与asp.net的Oracle连接，以维护每个用户的oracle sessin信息. [英] Oracle connection with asp.net , to maintain oracle sessin information for each user basis.

问题描述

我正在使用ORACLE 11G作为后端编写ASP.NET应用程序，我的应用程序逻辑大部分是用ORACLE编写的.
现在我已经在后端编写了程序

I am writing as ASP.NET application with ORACLE 11G as back end my application logic are mostly written in ORACLE.
now i have written in procedure in backend

function checkLogin(uname in varchar,password varchar) return number;

从ASP.NET调用它，并返回0或1.
现在，当对用户登录进行身份验证时，我想将整个配置文件保存在该会话的oracle内存中，为此，我的连接不应该关闭，或者应该是持久连接.

但是在分布式环境应用程序中，我不能为每个用户建立一个连接.

通过连接池仍然可以做到这一点吗?
我如何维护会话内存，直到用户未从前端应用程序注销.

请提出建议.

it is called from ASP.NET and return 0 or 1 .
now when user login is authenticated i want to save whole profile in oracle memory for that session, for this my connection should not close, or it should be persistent connection.

but in distributed environment application i can not have one connection for each user.

Is this still possible to do by connection pooling.
HOW can i maintain session memory untill user did not logout from front end application.

Please suggest.

推荐答案

您是否遇到过在数据库中添加会话的概念?以下链接将有所帮助..一些链接引用了asp.net和sqlserver，但是大多数概念将适用于包括Oracle在内的任何数据库.
http://shiflett.org/articles/storing-sessions-in-a-database


http://www. developer.com/net/asp/article.php/3595766/Storing-Session-State-in-a-SQL-Server-Database.htm http://www.venkateswarlu.co.in/articles/DotNet/Storing_Session_State_in_a_SQL_Server_Database.aspx


http://stackoverflow.com/questions/4856324/tomcat-store-session-in-database

Have you come across the concept of stroing sessions in a database? The follwing links will help.. Some of the links are referring asp.net and sqlserver but most of the concepts will apply to any DB including Oracle..

http://shiflett.org/articles/storing-sessions-in-a-database


http://www.developer.com/net/asp/article.php/3595766/Storing-Session-State-in-a-SQL-Server-Database.htm

http://www.venkateswarlu.co.in/articles/DotNet/Storing_Session_State_in_a_SQL_Server_Database.aspx


http://stackoverflow.com/questions/4856324/tomcat-store-session-in-database

这篇关于与asp.net的Oracle连接，以维护每个用户的oracle sessin信息.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！