Jim Johnson's Blog - All Comments

re: Upcoming webcasts

Miguel Gasca — Sat, 23 Aug 2008 18:32:54 GMT

Hey Jim, just to prod you a bit, any chance of you giving any insight into what the Transactions team is working on nowadays?

Miguel

re: Building the transaction protocol documents

Miguel Gasca — Sat, 23 Aug 2008 18:29:54 GMT

Intense period of activity indeed! It made me smile reading through the docs for a bit.

re: The end of an era

Joseph Healy — Fri, 22 Aug 2008 08:47:46 GMT

Ah, Spitbrook - was there '85-'87 and lived up in Francestown. Now that takes me back a piece...

RIP...

re: MSDTC changes in WS2008, Part 3: Cluster features

Uttam Parui — Thu, 21 Aug 2008 04:46:58 GMT

Thanks Jim. This is very helpful. As I was testing, I had created two MSDTC resources in seperate groups (different from the SQL Server group). In that case the cluster resource name needs to be the MSDTC cluster resource, right? If not then how will it know which MSDTC to map to.

Also, is there a way we can test if SQL Server is infact using the right MSDTC resource?

re: Upcoming webcasts

jim-johnson — Mon, 14 Jul 2008 22:11:36 GMT

It looks like at least some are. I went to the MSDN webcasts page (using the link above) and looked at the on-demand list. I found Juval's, for instance, at www.microsoft.com/.../webcastdetails.aspx

I've updated the links.

Jim.

re: Upcoming webcasts

John Apps — Mon, 14 Jul 2008 18:56:49 GMT

Jim, any idea if these webcasts have been recorded and made available? The URLs you provide are for pages no longer available "page not found".

Cheers, John

Windows Server 2008的MSDTC改进

自由、创新、研究、探索…… — Sun, 29 Jun 2008 13:16:07 GMT

事务处理作为企业级开发必备的基础设施，WindowServer2008在事务处理上的改进也是很大的，无论是开发还是配置管理方面都得到了极大的改进。有几篇关于WindowsServer2008的...

Windows Server 2008的MSDTC改进

自由、创新、研究、探索…… — Sun, 29 Jun 2008 13:15:59 GMT

Windows Server 2008的MSDTC改进

自由、创新、研究、探索…… — Sun, 29 Jun 2008 13:15:47 GMT

Windows Server 2008的MSDTC改进

自由、创新、研究、探索…… — Sun, 29 Jun 2008 13:15:24 GMT

re: A simple class to help hooking up System.Transactions and the transacted file system in Longhorn

przepisy kulinarne zupy — Fri, 27 Jun 2008 09:03:01 GMT

This is interesting article, I did not it think that it yes. Interesting it knew persons about this how much. Sorry if I wrote bad there now my English is novice and I do not it write yet good.

re: MSDTC changes in WS2008, Part 3: Cluster features

Jim Johnson — Sun, 01 Jun 2008 22:03:00 GMT

Uttam,

Thanks much. You're right, there was a late change in the command line. That's what I get for doing the article away from the code. I've corrected the text of the post to reflect that.

The command you specified should probably work, based on some assumptions. The service name is the full SQL Server service name. It follows a pattern of MSSQLServer[number], so if this is the first SQL Server service, then that would be the right name. You should verify if it is on your system.

Second, the cluster resource name can be the MSDTC cluster resource, but I'm assuming that you have the MSDTC cluster resource in the same group as the SQL resource. In that case you could use the SQL cluster resource name. Then MSDTC would automatically attempt to use the MSDTC cluster resource that is in the same group.

Hope this helps,

Jim.

re: MSDTC changes in WS2008, Part 3: Cluster features

UTtam Parui — Thu, 29 May 2008 12:58:00 GMT

Jim,
Excellent information on MSDTC changes in WS2008. In the "msdtc.exe -tmMappingSet" command, -resourceName is not a valid option. The option is -clusterResourceName. Can you give an example of mapping MSDTC resource to SQL Server 2005 resource? OR can you validate if the following is correct?
Example- We have a SQL Server 2005 resource with service name MSSQLServer and have two MSDTC resources called MSDTC-win2k8msdtc and MSDTC-MSDTC. And I want the SQL Server resource to use MSDTC-win2k8msdtc. Is the below command correct?

Msdtc.exe –tmMappingSet –name MyMapping –service MSSQLServer –clusterresourcename MSDTC-win2k8msdtc

re: Multithreading with DependentTransaction

Jim Johnson — Sun, 04 May 2008 12:32:00 GMT

Michael,

Sorry for not replying earlier. It looks like you have taken this to http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3260331&SiteID=1, which is a good place to ask about the current product.

Jim.

re: Multithreading with DependentTransaction

Michael S. — Mon, 28 Apr 2008 10:28:00 GMT

Well I think that is not working.

I made a litte test with two database connections. But very simila to this Example

The Problem is as soon as Complete() is called in the Main TransactionScope every ExecuteNonQuery command gives an "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

A real Problem is that that eception is not catched by an try/catch in the main funcion. Insted the hole application crashes the bad way.

simplified code:
Main:
try
{
//Open two connections
using(TransactionScope ts = new TransactionScope(TransactionScopeOption.Requred, TimeSpan.MaxValue)
{
ThreadPool.QueueUserWorkItem(worker1, Transaction.Current.DependentClone(DependentCloneOption.BlockCommitUntilComplete));
ThreadPool.QueueUserWorkItem(worker2, Transaction.Current.DependentClone(DependentCloneOption.BlockCommitUntilComplete));
ts.Complete();
}
//Close the connections
}
catch(Exception(ex)
{
//Write Exception
}

Worker1:
DepednentTransaction dtx = (DependendTransaction)ar;
using(TrsansactionScope ts = new TransactionScope(dtx))
{
Thread.Sleep(9000);
ts.Complete();
}
dtx.Complete();

Worker2:
DepednentTransaction dtx = (DependendTransaction)ar;
using(TrsansactionScope ts = new TransactionScope(dtx))
{
Thread.Sleep(TimeSpan.FromSeconds(10));
//Make An Insert using one of the connections
ts.Complete();
}
dtx.Complete();