Concurrency - SqlConnection Already Open In Case Of Concurrent Access To Same Page
Dec 29, 2010
I have a strange problem in my ASP.Net 3.5 application. When multiple users try to access the same page (which has some long running methods), the application crashes at a point where it tries to open a connection to the database (a static method inside a static class). It appears that the connection is already open. However, this does not happen when there is only one user using the application. What I cannot understand is that how do actions of one user affect the other in a web application?
I double checked that all my open connections are being closed after performing their operation by appending a line of text to a text file whenever a connection is opened or closed. The number of opened and closed connections was equal. Also, the connections are opened and closed from one place only, where the close method is inside a Finally() block.
View 1 Replies
Similar Messages:
Mar 26, 2016
How to control concurrent requests for web sites?
View 1 Replies
May 14, 2010
i'm developing a ASP.NET web application which uses the AjaxControlkit 3.0.30512.20315. I have a ToolkitScriptManager instance on my master page which has some ScriptReferences in the CombineScripts collection. If i access my default page from 2 differenct clients after an iisreset, i get the following exception
[NullReferenceException: Object Reference not set to an instance of an object.]
System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) +143
System.Collections.Generic.Dictionary`2.set_Item(TKey key, TValue value) +11
AjaxControlToolkit.ToolkitScriptManager.GetScriptCombineAttributes(Assembly assembly) +129
AjaxControlToolkit.ToolkitScriptManager.IsScriptCombinable(ScriptEntry scriptEntry) +148
AjaxControlToolkit.ToolkitScriptManager.OnResolveScriptReference(ScriptReferenceEventArgs e) +415
System.Web.UI.ScriptManager.RegisterScripts() +191
System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object sender, EventArgs e) +113
System.Web.UI.Page.OnPreRenderComplete(EventArgs e) +8698462
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1029
Using .NET Reflector i found out that the GetScriptCombineAttributesmethod access a static dictionary, which is not protected against concurrent access. Either i have a race condition in my code or there is a bug in the AjaxToolkit.
View 2 Replies
Jul 6, 2010
When i connection on database Microsoft SqlServer 2008 By This code.
Code:
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [City]", cnn);
cnn.Open();
Code In configration Manager
Code:
<add name="myconnection" connectionString="Data Source=.;Initial Catalog=db;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
found this Sql Exception:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed. what is problem?
View 19 Replies
Mar 9, 2010
in one request i am updating session variable. in the other request, i am trying to access that session value, but it was blocked until the first request finish. I am using C# with ASP.NET 2.0 UPDATE: My page code looks like this.
while(int progress = DoWork() && progress <= 100 ){
Session["Progress"] = progress;
}
and my handler just return Session value.
context.Response.Write(Session["progress"].toString());
context.Response.End();
View 1 Replies
Oct 21, 2010
If multiple users access a web-form at the same time, how can I allow that using my code? Essentially each user reads and writes one variable in the application, and concurrent access is causing problem there.
View 5 Replies
Nov 16, 2010
Suppose I have two threads(Thread1, Thread2) where the threads are accessing the cache for a given object such as in the code below nearly at the same time:
Dim expensiveToGetData = Cache("ExpensiveDataKey")
If ExpensiveToGetData is nothing then
'because the cache has expired
ExpensiveToGetData = LoadExpensiveDataFromDataSource()
Cache("ExpensiveDataKey") = ExpensiveToGetData
end If
ProcessExpensiveData(ExpensiveToGetData)
Isn't it possible for both threads to load the cache because they both requested data from the cache that was nothing/expired? I've run some tests on a local machine and it seems that the cache is being loaded more than once. Is this a normal pattern?
View 2 Replies
Mar 30, 2010
I am stuck with the issue of concurrent access to Session object. Actually my problem is i m writing to session in frame1 and trying to access that same Session object at the same time in Frame2's Page. I know about the reader/writer lock. I made the enablesessionstate = readonly in the page where i m writing to session. its giving me strange behavior on IE and firefox.
Its working concurrently in IE8 ( means page2 is diplaying modified values while page1 is changing the session object) but does not work in Firefox even page load is not called untill function on page 1 completed. Either anyone can fix my issue with firefox or there is new solution to reader/writer lock so that i can read the session at the same time while writing.
View 2 Replies
May 19, 2010
I currently store ASP.net application data in XML files. Now the problem is I have asynchronous operations, which means I ran into the problem of simultanous write access on a XML file... Now, I'm considering moving to an embedded database to solve the issue. I'm currently considering SQlite and embeddable Firebird. I'm not sure however if SQlite or Firebird can handle multiple concurrent write access. And I certainly don't want the same problem again. Anybody knows? SQlite certainly is better known, but which one is better - SQlite or Firebird ? I tend to say Firebird, but I don't really know. No MS-Access or MS-SQL-express recommodations please, I'm a sane person.
View 5 Replies
Apr 3, 2010
in my application when i type sqlconnection it is not showing any intellisence, i added the namespace System.Data.Sqlclient not only sqlconnection even i am not getting Page calss can u help me.actually i am sharing this application from my company server.
in our company previously there was .net 2.0 frame work when this project was developed(one year back).
yesterday our company installed 3.0 .net frame work is this any problem for previous project which are developed in 2.0 how can i go through this problem.
View 2 Replies
Mar 1, 2010
In school we have been making a website where we need to use .adp vbscript pages. But also Microsoft Access databases.
We've added the connection string etc and bindings - all that works fine but when we go to open the page we get page cannot be found. It loads sometimes but most of the time we get that page not found screen.
We are using IIS.
The teachers and another students one works fine, We have done exactly what they have but we get no luck with bringing up the pages.
We get error 500.100 and Error line 8.
View 2 Replies
Dec 30, 2010
I have my project set up with the virtual path "/MyVirtualPath", create the virtual directory in IIS 6 (W2003) and everything works fine. Then to work better with Google Analytics I change the virtual path "/myvirtualpath" and change all redicecciones and links to lowercase. also applies the class "lowercase route urls in aspnet mvc" and works perfectly.
The problem I had to modify the virtual directory in IIS, delete virtual path "/MyVirtualPath" and I created the new "/myvirtualpath", but in all cases I use tilde "~" or where I make a "RedirecToAction" (which should take "LowercaseRoute"), continues to maintain the virtual path "/MyVirtualPath". For example, if I see the HTML source code in the browser, see "/MyVirtualPath/Content/Site.css" instead of "/myvirtualpath/Content/Site.css. "
View 1 Replies
Jun 16, 2010
My problem i am facing is that i do not know if it's possible to access a single field in my case sold from the following code.
[Code]....
What i want to do is have the checkbox true if the value of sold = yes and false if the value = no I have the checkbox ready on the asp.net side but just need for the checkbox to recognise the datafield, sold, and do and if check statement, is this possible if not i will work around it.
View 1 Replies
Jan 4, 2010
Why is there no default 'create/open' access to 'WebSites' from the VS2010 start page?
Background:I've succesfully been developing ASP.NET web applications (via WebSite method ((((Not WebProjects)))), using VisualWebDeveloper) for roughly 3 years. Personally, I prefer the WebSite method or strategy due to the decrease in both size and complexity (the web applications I build are generally for around 50-100 simultaneous users logging in and out and constantly manipulating data). I will continue bulding my sites via the 'Website' method provided VS2010 doesn't begin it's deprecation.The root of this question (which boiled into this post) came from perusing this article and this video tutorial. It's a shame to see functionality that brings with it an overall ease of use and increase in production capacity by decreasing both size and complexity of web application development... downplayed.
If the Visual Studio 2010 Development Team left this functionality out for a reason, I would very much like to know. So that I know what is going to be "sponsored by Microsoft" in a couple of years and I don't waste another second considering using the 'WebSite method' as a viable solution (as I know that I can't stick with vs2008 while rest the development community gets to evolve with the innovations implemented within vs2010)... WebSite method or the WebProjects method.
View 4 Replies
Mar 7, 2011
I have a .net web application (framework 2.o) and SQL Server 2005 as my backend. I need to design an application which fetches a particular unique pin number to a customer and then mark this record as used. The problem I face is as the no of concurrent users are more , same pin number is getting allotted to multiple users.
View 3 Replies
Aug 16, 2010
I have a website which has both html and aspx pages. for aspx pages i have added code in customerror section in web.config and is working fine, but only in case of aspx pages. I want if somebody looks for html page which does not exist should also be taken to error page.[URL]( What about html pages section) will only work if the site is hosted at my servers, but in my case the website is hosted somewhere else.
View 2 Replies
Feb 17, 2011
I have an asp.net page that contains an Iframe embedded with some data and a ImageButton. On ImageButton click event (server side) I have Response.Redirct:
Response.Redirect("results.aspx");
This always open the results.aspx in iframe. I want that results.aspx should always open in the parent window. I tried the following till now but none worked:
Response.Redirect("<script language='javascript'>self.parent.location='results.aspx';</script>");
Response.Redirect("javascript:parent.change_parent_url('results.aspx');");
..and also tried the options from [URL]
View 1 Replies
Oct 7, 2010
I wan to edit Database file which is with .dat Extension.
The Connection string use in Configuration file that is.
<add name="TecsHomeConnectionString"
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TecsHome.dat; Jet OLEDB:Database Password=fdsa"
providerName="System.Data.OleDb" />
I have TecsHome.dat file. I am opening it in MS Access using Passwored = fdsa but MS access prompting invalid Password
how can i open it if the given password in connectionstring is not working.
keep in mind i don't have source code. I just want to open .Dat Database file.
View 1 Replies
Aug 6, 2010
In what way is used optimistic concurrency?
I need to connect two tables together.
If you use optimistic concurrency at the same time, users will store data in a table?
In particular, I wonder what the difference is, if I save the aspx, or use optimistic concurrency.
View 1 Replies
May 17, 2010
i would like to know if there's something wrong in this asp.net code:
mydatareader = mycmd.executeReader()
if myDataReader.HasRow then
// Do something
end if
myConnection.Close()
If i avoid to call a "MyDataReader.Close()" does the connection close anyway ? I ask this because i'm assuming that if call a "MyConn.Close" it automatically close the associated datareader... or am i wrong ?
View 4 Replies
Aug 30, 2010
My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.
[Code]....
[Code]....
View 1 Replies
Aug 10, 2010
I am trying to handle concurrency in my application. Basically if user A has a support ticket open which currently has a status of 'Active' and user 'B' opens the same ticket and closes it (changing its status to closed), I would expect a confict execepton to be thown when user 'A' tries to close the support ticket. For some reason this is not happening. I have checked that Update check is set to 'Always' in the dbml file. Here is an exerpt of my code. // Update 'Active' lead to 'Close'
[Code]....
View 2 Replies
Oct 14, 2010
i have a hotle reservation system.
when a user select a room i want that it lockes and an other person can not select it.
i think it`s better that i have a flag in my table and when a user select room value of is false and if cancle reservation ,i changed it true.an other person can see room that they have true value .
View 7 Replies
Jan 13, 2011
I have the following problem:- I have a Settings table which has a value column, that is incremented everytime a Job is created (I use Entity framework to add the job and to update the value increment). So, I have something like this:
[Code]....
The problem is: I have a asp.net with concurrent calls to SaveJob Method. In this code, the value is shared, and if I call SaveJob 5 times for instance, the value column is 3, because the scope is not "locking" the other transactions until It's done, and the value is shared. I want to have the following scenario: Call SaveJob 5 times;Value column in Settings table is 5;Call SaveJob 3 more times;Value Column in Settings table is 8. I tried to implement something like pessimistic concurrency in EF, but I had no success. Whats the best way to handle that without using SQL Server queries directly? (like 'lock' and 'unlock' etc)
View 3 Replies
Nov 23, 2010
I want to know how to handle the concurrency throughy code ? ie: I want to access the Concurrency issue or error ? Because if i get the concurrency user or issue I have to do some manipulation.
View 4 Replies
