Web Applications and Oracle

22 Jun 2006 6:15 PM

-JF-

Hi there!, I'm developing an application in asp.net and Oracle, but I have
the following problem, and is that the number of Sessions that connect to the
databases from my app growing and growing until the database displays an
ORA-00020, instead of use only one connections per user, I have two types of
connections in the database, one Shared and Dedicated, when I look at the
number of connections from the database, appears "n" connections (all of them
with status INACTIVE), is there any way to efficiently connect to the
database from web app's and use only one connection for each client? in the
code I have a cnnDB.Open(); and a cnnDB.Close(), each time I access to the
database, can you help me?

23 Jun 2006 10:22 PM

Matt Noonan

-JF- wrote:

> Hi there!, I'm developing an application in asp.net and Oracle, but I
> have the following problem, and is that the number of Sessions that
> connect to the databases from my app growing and growing until the
> database displays an ORA-00020, instead of use only one connections
> per user, I have two types of connections in the database, one Shared
> and Dedicated, when I look at the number of connections from the
> database, appears "n" connections (all of them with status INACTIVE),
> is there any way to efficiently connect to the database from web
> app's and use only one connection for each client? in the code I have
> a cnnDB.Open(); and a cnnDB.Close(), each time I access to the
> database, can you help me?

You could use an already established framework that reliably handles this
situation, such as the Enterprise Library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp

--
Matt Noonan
EasyObjects.NET: The O/RM for the Enterprise Library
http://www.easyobjects.net