The catalog system does not support nested transactions since some of these
operations that you mentioned manipulate fulltext indexes.
Manipulation of fulltext indexes is not allowed as a part of a transaction.

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure!  For more info visit http://www.microsoft.com/security.  Please
reply to the newsgroups only


--------------------
From: ams8764@netscape.net
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Support for transactions when updating products data ?
Date: 23 Aug 2005 01:09:21 -0700
Organization: http://groups.google.com
Lines: 65
Message-ID: <1124784561.684399.232100@g49g2000cwa.googlegroups.com>
References: <1124729055.811038.33750@z14g2000cwz.googlegroups.com>
<TeDJLx0pFHA.340@TK2MSFTNGXA01.phx.gbl>
NNTP-Posting-Host: 62.23.237.17
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1124784567 19284 127.0.0.1 (23 Aug 2005
08:09:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 23 Aug 2005 08:09:27 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=62.23.237.17;
posting- account=PZ8s3Q0AAAAmg38VabALoICeANiC6nY1

Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!g49g2000cwa.googlegroups.com!not-fo
r-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3265
X-Tomcat-NG: microsoft.public.commerceserver.general

Let me give you an example...

Our business goal is to manage products that are associated to
categories and linked to other products.

We want to do something like this for a single product.

UpdateProductProperties(pid)
RemoveProductCategories(pid)
AddProductCategory(pid,cat)
RemoveProductRelationships(pid)
AddProductRelationship(pid,pid2)


We want to have it running in the context of a single transaction so
that we always have a consistent state if the execution gets broken in
the middle of the operations.

Methods have the following pseudo code

using Microsoft.CommerceServer.Interop.Catalog.Product;

UpdateProductProperties(productID)
{
CatalogManager cm = new CatalogManager();
cm.Initialize(...);
ProductCatalog productCatalog = cm.GetCatalog(...);
product = productCatalog.GetProduct( productID );
ADODB._Recordset rs = product.GetProductProperties;
// setting properties...
product.SetProductProperties(rs, false);
}

RemoveProductCategories(productID)
{
CatalogManager cm = new CatalogManager();
cm.Initialize(...);
ProductCatalog productCatalog = cm.GetCatalog(...);
product = productCatalog.GetProduct( productID );
ADODB._Recordset rs = product.ParentCategories;
..
category = productCatalog.GetCategory(...);
category.RemoveProduct(productId)
..
}

 AddProductRelationShip(productId1,produc
tId2)
{
CatalogManager cm = new CatalogManager();
cm.Initialize(...);
ProductCatalog prodCatalog = cm.GetCatalog(...);
Product product = prodCatalog.GetProduct(productId1);
product.AddRelationshipToProduct(productId2,...);
}

etc ...

We do not know if bundling all Commerce Server access is a single
function (thus mutualizing a single CatalogManager object) would help,
but it would break our granular approach to data updates.

Any CS built in mecanism that could allow me to do this ?

AMS

[ Post a follow-up to this message ]