Application Opening Too Many Oracle Database Connections?
Feb 17, 2010
I have an application, which connects to a Oracle 10g R2 database, but what it is doing is opening lots and lots of connections and is not disposing them.
My application is using the MVC model, and I have Database Connection Class, which on unload of the page calls my dispose method, which consists the dispose and close commands. Further, on model control, on each of methods requesting data from the database, I am calling the close method on Oracle Data Reader.
View 7 Replies
Similar Messages:
Feb 22, 2010
We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:
Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because
all pooled connections were in use and max pool size was reached.
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.
View 1 Replies
Nov 18, 2010
I should be closing my readers and connections in a more robust way? Some of my questions are:
- If a try-catch block is used, should the closures be done in the Finally section? Or in the main Try section?
- Should all closures assess whether or not the control is already open before closing (to prevent error)? (see closure of conn below)
- Are there any other preferable ways of handling this? Trying to improve my code!
[Code]....
View 3 Replies
Oct 2, 2010
how i can use Oracle database with asp.net mvc 2 web application?
View 3 Replies
May 28, 2010
How to intregrate an oracle database with an asp.net web application?... Any good tutorial to start with?
View 1 Replies
Feb 26, 2010
I have two PC. In one pc(PC1) i have installed oracle express edition 10g (10.2.0.0 as far as i know). And in another(PC2) i have installed visual studio 2008 sp1. In PC2 the ASP.Net application is running. But i can not connect to the oracle database to PC1. PC1 and PC2 are connected by LAN(TCP/IP {Actually they are connected by wire and given two IP} ) But it was working perfectly while both ASP.net application and database were in the samae PC. ca
the NHibernate configuration file is:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory> [code].....
View 1 Replies
Dec 3, 2010
I am developing an web application using csharp and oracle as database. I have table with columns like below. How can I ensure that sql selects from one table column but it shows two columns depending weather it is Debit or credit. How can I come up with something Statement of Account ?
Number Amount Type
2 6000 Dr
3 4500 Cr
4 2300 Dr
5 1200 Dr
6 1300 Cr
Now I want the sql out put to be as below. How can I achieve?
NUMBER Dr CR Balance
2 6000 1000
3 4500 5500
4 2300 3200
5 1200 2000
6 1300 3300
View 4 Replies
Oct 28, 2010
I am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
View 7 Replies
Jan 19, 2011
I'm having some problems with connections to an SQL database not closing after being opened, which is maxxing out the pool and causing the site not to load any of the dynamic content (until eventually unused idle connections get close, as the problem seems to go away after a while).
I've been through my code several times and can't figure out where things are not being closed properly.
Is there a surefire way to make sure these connections are properly closed? Or to pinpoint where the problem lies?
Most places in the site I am using ObjectDataSource. You don't need to close a connection when using that, do you?
Where ObjectDataSource isn't used, a developer wrote this method and put it in a class file called "common.cs":
[Code]....
I searched the entire solution for every instance of "common.openDatabase()", and where it occurs I make sure there is a "cmd.Connection.Close();" that follows.
Am I missing something or doing it wrong?
Here's an example of where a db connection gets opened and then (purportedly) closed:
[Code]....
View 18 Replies
Jun 21, 2010
I am trying to determine if I have a database connection leak. So I need to see the number of open connections. I have some simple test code that creates a leak:
protected void Page_Load(object sender, EventArgs e)
{
for(int i = 0; i < 100; i++)
{
SqlConnection sql = new SqlConnection(@"Data Source=.SQLExpress;UID=sa;PWD=fjg^%kls;Initial Catalog=ABC");
sql.Open();
}
}
Note there is no .Close and this does infact crash after being run 3 times in quick succession.
In order to measure the leak I am running the Performance monitor and measuring SQLServer: General Statistics/User Connections:
However, these seem to be zero when I run my code:
What should I change to actually see the connections?
ANSWER
I have approved an answer below. Even though it doesn't use the performance tools, its good enough for my use. Bottom line is I wanted to see how many connections remain open after opening a web page and this did the trick.
View 2 Replies
Mar 7, 2011
I was asked to build a couple of small and basic websites, without the use of database connections, just plain forms with information and a couple of images and forms. So my question is, if I only use those "html" controls of the toolbox, the performance of the site will increase against those with lots of .net controls?
Some one told me to use php or any script language to do that kind of stuff, but I only know to code in .net.
View 5 Replies
Mar 27, 2010
I noticed that when I download a framework say like "Coolite" and open the solution, and find the Connection to the Database showed up in the Server Explorer.
In some other times, the Connection Dose not show.
I can create a connection to a Database in Server Exploere, but I need say to add it to my Web.Config directly, but not sure how. I am trying to drag-and-drop from the Server Explorer to Web.Config, it is not working.
When and how the Connections to Databases will show in Server Explorer ?
How I can create a connection to a Database using say a Wizard, and add it directly to Web.Config ?
View 3 Replies
Mar 14, 2011
I just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.
View 3 Replies
Apr 22, 2010
We have an internal ASP.Net 3.5 application that opens Pervasive SQL databases, reads the data, and then closes the connection. Unfortunately, when the user exits the application, and even when they close their browser, the w3wp process seems to be holding the PSQL database connections open, which is causing licensing issues for us. I would like the w3wp process to release the database connections once the last user has exited from the ASP.Net application. How can I get w3wp to release the connections?
Someone told me that the Powershell command, "gps w3wp | kill" will stop the w3wp process. Is there any way I can automate this, so that the process will be killed automatically when the last user exits our ASP.Net application?
View 1 Replies
Mar 30, 2010
SQL Server Express 2005 MS Visual Studio 2005 Using ASP.NET with VB code behind. Requirements: Click a button on an ASPX page to disconnect temporarily all DB connections when not in use to allow a script to backup/copy the database to a safe backup location. When a user access the db afterwords, the DB connections will be re-established.
If this is imposible, recommend an alternative. Note: I am working with what I have been given and authorized to use.
View 3 Replies
Jun 20, 2010
We are building an ASP.NET application with C#.net language and Oracle 9i database. Here we installed Oracle 9i client software on our PCs.We never worked on Oracle 9i database. It's the first time.We are planning to build stored procedures in Oracle database and call them from our ASP.NET application. Does working with Oracle stored procedures and ASP.NET is similar to that of working with MS SQL Server stored procedures and ASP.NET?
View 1 Replies
Feb 27, 2010
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 Replies
Dec 19, 2010
I have an ASP.NET/C# application that exports some data into an Excel spreadsheet using COM interop at the click of a Button control. When I click the button, Excel is opened with the generated spreadsheet. For what it's worth, here is the button code:
<asp:Button ID="export" Text="Export to spreadsheet" runat="server" OnClick="Export_Workbook" />
This works fine, except when I click the button, close the subsequent spreadsheet, and refresh the page. When the page is refreshed after clicking the button, the call to Export_Workbook() is made again and so the spreadsheet opens again. Firefox, for example, says this when you refresh: "To display this page, Firefox must send information that will repeat any action (such as a search or order confirmation) that was performed earlier." This is something I want to avoid.
I'm sure there's a better way to accomplish what I'm trying to do, I'm just not sure what the best approach is.
Edit
I've accomplished this by doing the following:
protected void Export_Workbook(object sender, EventArgs e)
{
Response.Redirect(Request.Url.AbsolutePath, false);
ItemList.Prepare_Workbook();
}
View 2 Replies
Jan 3, 2011
I'm trying to use the COM interop assembly to export some data to an Excel workbook for an ASP.NET web application. This works fine in development, since the server and the client are the same machine. However, when deployed, this is not the case. The deployed version does not throw an exception, but it also does not open Excel on the local machine (since ASP.NET is executed server-side, this is pretty obvious).
How do I go about creating an Excel application on the client's machine?
View 3 Replies
Jun 7, 2010
I installed blackberry VStudio plug-ins but i am not able to run my application in BB simulator. I want install any more software for opening my application in BB.
View 5 Replies
Jul 28, 2010
I have saw this done before I thought. Where you have a web application, and a debugger can output server side messages. I am trying to do something similar to this. I am not getting a Console from it though.
public class Global : System.Web.HttpApplication
{
protected void Application_Start(object sender, EventArgs e)
[code]...
View 3 Replies
Feb 20, 2012
I am working on a web application project to be deployed on an intranet. I need to provide users with the ability to allocate documents to projects so that I can show them a page that lists the documents for a project. When they click on the document I need it to open in the application that created it. Generally, just Word and Excel documents.
So, I've done all the 'Add a Document' stuff and I have a Gridview on the screen that displays the document name (test.doc) and the path (C:UsersFredTest.doc).
I have tried passing the Document Name and Document Path to this function:
Code:
protected void ShowFile(string DocumentName, string DocumentPath)
{
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.AddHeader("content-disposition", "attachment;filename="" + DocumentName + """);
Response.TransmitFile(DocumentPath);
Response.End();
}
and, for example, for my Word document it opens - but not before a 'Do you want to Open or Save this file dialog is presented' (unwanted, but not the end of the world) but, when the file opens you can't save it. (Even on my development box).
Is there a simple way of simply opening an Office document from within a .net web application project that just actually opens the document - so it can be edited and saved etc.
Edit: When the word file opens - if I click to save it it shows this as the path to the file:
C:UsersFredAppDataLocalMicrosoftWindowsTemporary Internet FilesContent.IE57T5D07IATest[4].doc
So, it's not opening the original file at all - it's creating a copy of it. I want users to simply be able to click on a file and open it. If I use 'C:UsersFredTest.doc' as a desktop shortcut - click on it and the file opens - the actual file - you can edit and save it. Why is it so hard to get a Word document to open from within a .net Web Application?
View 6 Replies
Feb 21, 2011
I am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
View 10 Replies
Mar 16, 2010
Is the "asp.net - oracle" a good solution for web applications?
View 6 Replies
Dec 20, 2010
needs to log informations about user actions (inserts, updates, deletes, etc) and exceptions and i want to store de log on Oracle10, so i'am searching some log framework to use.I read a little bit about:1 -Log4Net
2 - Logging Application Block3 - ElmahWhats your opinion about these log tools?Whats a good framework (or way to implement) log on my application?*After a discussion with the project manager, Logging Application Block will be our choice, but, lets comment about this =)
View 6 Replies
