Imagine the following scenario - we have Page1 which contains controls Control A and Control B. Say Control A has a button, and on the click of this button we want Control B to react. But we want to do this in an abstract fashion, i.e. we can't have Control B knowing anything about Control A, and vice versa. That way we can develop the...
We have a data-warehousing package that our clients run during the day against their live transactional system. On most clients this seems to work fine but on busy clients we get deadlocking errors. By default SSIS runs with an isolation level of Serializable which is the highest isolation level on SQL 2005. The SSIS package is only ...
Is it possible to set the database isolation level (ie Serializable, repeatable-read etc) for a given EJB 3 method call? I understand that this is not covered by the EJB Spec, so details of how to do it on either a JBoss or Glassfish specific manner would be great. I'm starting to get the impression it's not possible and that you can o...
I am using TransactionScopes at a high level to wrap some high level code that makes a number of connections to the database. One of the functions I call is a generic read that is used for read only functions where a read uncommitted isolation level is needed. But in some cases it is used as part of large update operation and a read com...
When I am using a TransactionScope object I can specify the Isoaltion Level using the transaction options. What is the default isolation level used if none is specified? Is it possible to set an application wide default isolation level that would be used by the TransactionScopes? ...
We can wrap a call to a stored procedure in a transaction and specify an isolation level. Or we can put the transaction inside the stored procedure specify an isolation level there. Which is it better to do? ...
How can one reach web-module isolation (i.e. each contained web-app is isolated from the others in the same .EAR) in jboss 4.2.2 when deployed inside a isolated .EAR file? Jboss 4.2.2 keeps warning that web-module (jboss-web) level deployment descriptor class loading configuration is ignored when deployng an EAR file. ...
If I had a 1000 asp.net websites each with 30 DLL's in their /bin folders. Therefore 30,000 DLL's. Would the websites / web server / machine run faster if I registered one set of the DLL's into the Global Assembly Cache and each site used the DLL's in the GAC? e.g. would the websites collectively use less memory? ...
Hi. I'm having a problem with deadlock on SELECT/UPDATE on SQL Server 2008. I read answers from this thread: http://stackoverflow.com/questions/661908/sql-server-deadlocks-between-select-update-or-multiple-selects but I still don't understand why I get deadlock. I have recreated the situation in the following testcase. I have a table:...
If you need to minimize concurrency as much as possible, which isolation level (repeatable read, serializable, read committed, read uncomitted) would work best? ...
I'm working on an enterprise application that relies heavily on message queues, com+, databases, httpcontext, static utility classes etc. Since there's 600 projects in our system it seems impractical to rewrite to use inversion of control. Typemock claims they are the only isolation framework that doesn't require you to rewrite your co...
Is there any sure-fire way to ensure Threads remain isolated from one-another, in Java? I've had an issue for a week and a half, where Threads implementing various 3rd party source code keep colliding due to static variables and other such things that are really beyond my control. I know a single system can run as many instances of the...
I can't seem to get MySQL 5.0.32 on 32bit x86 Debian to honour transaction isolation levels. I've reduced my problem to its simplest form, tested with the mysql command-line client: -- On node writer: -- DROP TABLE test; CREATE TABLE test ( name VARCHAR(255) ); set autocommit=0; set transaction isolation level read committed; beg...
I'm looking for pointers and information here, I'll make this CW since I suspect it has no single one correct answer. This is for C#, hence I'll make some references to Linq below. I also apologize for the long post. Let me summarize the question here, and then the full question follows. Summary: In a UI/BLL/DAL/DB 4-layered application...
I'm a bit confused by the documentation here. I have a transaction, which start transaction does some updates does some selects does some more updates commit I want my selects at step 3 to see the results of updates in step 2 but I want to be able to roll back the whole thing. read committed seems to imply that selects only show ...
Hi folks, I am using RSpec for writing my controller tests/specs. I faced the problem, that the following code gets rendered: render :update do |page| page['middle_content'].replace_html :partial => "admin/pages/show" end Isolation mode is the default, isn't it? How can I fix this or am I doing something wrong? Here is for examp...
I apologize now if my upcoming explanation doesn't make enough sense; I'm reknown for it, though I try to do otherwise. I'm writing a service that makes use of user-defined plugins. I'm trying to isolate them -- keeping their assemblies out of the service's appdomain -- by making use of interfaces defined in a shared assembly. What's ...
There are many online judge sites which can verify your program by comparing its output to the correct answers. What's more, they also check the running time to make sure that your program running time doesn't exceed the maximum limit. So here is my question, since some online judge sites run several test programs at the same time, how...
Is there any way to get mysql queries to not take any locks on myisam tables? My problem seems to be that my Sphinx Search indexer takes a lock on one of my myisam tables for over 60s which seem to make update statements wait on the locks to be released which in turn makes other queries wait for the update statements to complete. The i...
I am trying to deploy my application (packed in .war file) that work properly on JBoss 4.2.3 to JBoss 5.1 (using java 5). Currently during deployment time I see in the server.log the error: ... Caused by: org.jboss.xb.binding.JBossXBRuntimeException: Failed to create a new SAX parser ... Caused by: java.lang.ClassCastE...