How to delete the values in table TMODEL_Category.

[Feng Tang <fe...@thedistillery.com.au>]

Hi all,
I can delete tmodel, binding, and service tables, etc. But I am not able
to delete TMODEL_CATEGORY. Even I use on delete cascade when I create
the table, I am still not able to delete the value in tmodel_category
table. Since I found the data in Tmodel table is not really deleted,
it's just marked as deleted. So I am guessing the on delete cascade will
not effect the tmode_category table even I call uddi4j api,
proxy.delete_tmodel(). Am I right? It there any one can help me to solve
this problem?
Many thanks!
Feng


The Distillery Pty Limited
ABN 69 080 932 467
PO Box 940, Dickson ACT 2602, AUSTRALIA
Phone: +61 2 6272 0200
Fax: +61 2 6262 5151
Web: www.thedistillery.com.au

The Distillery Inc
2111 Wilson Blvd, Suite 700,
Arlington, Virginia 22201, USA
Phone: +1 703 351 5082
Web: www.thedistilleryinc.com

The Distillery (Europe) Ltd
90 Long Acre, London WC2E 9RZ, UK
Phone: +44 (0) 20 7849 3330
Fax:  +44 (0) 20 7849 3200


---------------------------------------------------------------------
The information contained in this email and any files attached may be
confidential and/or copyrighted information of The Distillery, Third
Parties and/or the intended recipient and may be the subject of legal
privilege or public interest immunity. You may only reproduce or
distribute the material if you are expressly authorised by us to do
so. If you are not the intended recipient, any use, disclosure,
copying, circulation, forwarding, printing or publication of this
message or attached files is strictly forbidden.

If you have received this document in error or are not an intended
recipient, please notify the sender and delete from your Inbox and/or
system.

The Distillery does not represent or warrant that files attached to
this e-mail are free from computer viruses or other defects and
liability is limited to the resupply (or cost of resupply) of the
attached files.
---------------------------------------------------------------------

RE: How to delete the values in table TMODEL_Category.

[Steve Viens <st...@viens.net>]

Feng, you are correct.  This is by design per the UDDI spec.

The way to remove a TModel CategoryBag (i.e. a row from the
tmodel_category table) is to update the TModel via a "save_tModel"
request making sure the CategoryBag or individual KeyedReference value
has been removed from the TModel first.

For example:

  1) Call get_tModelDetail to get a copy of the TModel
  2) Remove the CategoryBag from the Tmodel
  3) Call save_tModel passing the altered TModel.

Does that make sense?

Steve

-----Original Message-----
From: Feng Tang [mailto:fengt@thedistillery.com.au] 
Sent: Wednesday, February 16, 2005 7:09 PM
To: juddi-dev@ws.apache.org
Subject: How to delete the values in table TMODEL_Category.


Hi all,
I can delete tmodel, binding, and service tables, etc. But I am not able
to delete TMODEL_CATEGORY. Even I use on delete cascade when I create
the table, I am still not able to delete the value in tmodel_category
table. Since I found the data in Tmodel table is not really deleted,
it's just marked as deleted. So I am guessing the on delete cascade will
not effect the tmode_category table even I call uddi4j api,
proxy.delete_tmodel(). Am I right? It there any one can help me to solve
this problem? Many thanks! Feng


The Distillery Pty Limited
ABN 69 080 932 467
PO Box 940, Dickson ACT 2602, AUSTRALIA
Phone: +61 2 6272 0200
Fax: +61 2 6262 5151
Web: www.thedistillery.com.au

The Distillery Inc
2111 Wilson Blvd, Suite 700,
Arlington, Virginia 22201, USA
Phone: +1 703 351 5082
Web: www.thedistilleryinc.com

The Distillery (Europe) Ltd
90 Long Acre, London WC2E 9RZ, UK
Phone: +44 (0) 20 7849 3330
Fax:  +44 (0) 20 7849 3200


---------------------------------------------------------------------
The information contained in this email and any files attached may be
confidential and/or copyrighted information of The Distillery, Third
Parties and/or the intended recipient and may be the subject of legal
privilege or public interest immunity. You may only reproduce or
distribute the material if you are expressly authorised by us to do so.
If you are not the intended recipient, any use, disclosure, copying,
circulation, forwarding, printing or publication of this message or
attached files is strictly forbidden.

If you have received this document in error or are not an intended
recipient, please notify the sender and delete from your Inbox and/or
system.

The Distillery does not represent or warrant that files attached to this
e-mail are free from computer viruses or other defects and liability is
limited to the resupply (or cost of resupply) of the attached files.
---------------------------------------------------------------------