As part of my (new) database version control methodology, I\'m writing a \"change script\" and want the change script to insert a new row into the SchemaChangeLog table if the script is executed succe
I am trying to nest TransactionScopes (.net 4.0) as you would nest Transactions in SQL Server, however it looks like they operate differently. I want my child transactions to be able to rollback if th
I have a question about Spring transaction propagation. Suppose I use @Transactional(propagation = Propagation.开发者_如何学PythonREQUIRED) to annotate a method m1(). When execution logic enters m1(),
We are running several calls against a SQL Server database within a transaction 开发者_如何转开发scope using entity framework.
I have some scenarios where I need to have multiple calls to .SubmitChanges() on a datacontext, but I want to explicitly control the transaction myself to make it atomic. For a while I have been doing
Using mysql 5.1.41 and innodb I\'m doing some data import, b开发者_JAVA技巧ut can\'t use load data infile, so I\'m manually issuing insert statements. I found that it\'s much faster to disable auto c
Here is my scenario: we have a database, let\'s call it Logging, with a table that holds records from Log4Net (via MSMQ). The db\'s recovery mode is set to Simple: we don\'t care about the transaction
I have a few tables where Foreign Key constraints are add开发者_开发问答ed. These are used with code generation to set up specific joins in generated stored procedures.
I have been trying to find info on the web about the differences between t开发者_如何学Gohese statements, and it seems to me they are identical but I can\'t find confirmation of that or any kind of co
I\'m using 2 PU in stateless EJB and each of them is invoked on one method: @PersistenceContext(unitName=\"PU\")