[cisco-voip] AXL (XML) ADMIN TOOLKIT using insert

[Thorsten.Mayr at barclayscapital.com]

Thanks for the hint. Appreciate that writing directly to the DB always is a last resort.
Of course we have sign off from AS for all changes we commit to the DB directly if we ever have to resort to go that way.

Upgrades in big environments unfortunately can take some time but support has to go on and features have to be enabled.

I can think of at least 10 awful ways that can/have happened during or after upgrades - the same time I know of around 30 bugs which scream UPGRADE at me every day

Cheers
T

-----Original Message-----
From: Peter Slow [mailto:peter.slow at gmail.com] 
Sent: Wednesday, September 08, 2010 3:55 PM
To: Mayr, Thorsten: IT (LDN)
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] AXL (XML) ADMIN TOOLKIT using insert

Thorsten,
    While this may work, it's a Pretty Dangerous thing to be doing.
Especially on a regular basis. Messing directly with your DB is no
joke and should be a last resort. Upgrading your CUCM to a version
where your bug is fixed is a much safer, is a TAC supported method,
and is significantly less likely to bite you in the arse. If your bug
is resolved in a later version of code, and I believe from what you
said that it is, you really need to upgrade. I can think of at least
10 different awful things that could happen as a result of manual
changes directly to your DB.

-Peter




On Wed, Sep 8, 2010 at 7:52 AM,  <Thorsten.Mayr at barclayscapital.com> wrote:
> Got it fixed. Silly syntax error that made me screw up the entire statement
> in the xml file... For any future references attached the correct file.
>
> Insert is supported and the correct statement for the xml file is:
>
>
>
>                 <sql update="insert into ...
>
>
>
>
>
>
>
>
>
>
>
>
>
> From: cisco-voip-bounces at puck.nether.net
> [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Mayr, Thorsten: IT
> (LDN)
> Sent: Tuesday, September 07, 2010 2:30 PM
> To: cisco-voip at puck.nether.net
> Subject: [cisco-voip] AXL (XML) ADMIN TOOLKIT using insert
>
>
>
> Has anybody used xml files with insert statements rather update or select
> statements?
>
>
>
> e.g.: content of an query.xml file
>
>
>
> --------------------------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
>
> <!DOCTYPE data [
>
>                 <!ELEMENT data (sql+)>
>
>                 <!ELEMENT sql EMPTY>
>
>                 <!ATTLIST sql
>
>                 query CDATA #IMPLIED
>
>                                 update CDATA #IMPLIED
>
>>
>
> ]>
>
> <data>
>
>                 <sql update="update numplan set
> fkcallingsearchspace_sharedlineappear =
> '01055b38-e985-1313-dd74-e4d72a8365bd' where dnorpattern = '11111'"/>
>
> </data>
>
> ----------------------------------------
>
>
>
> Instead of the above "update" . I'd like to send an "insert"
>
> The table in question: "telecastersubscribedservice"
>
>
>
>
>
> Any ideas or ideally examples much appreciated.
>
>
>
> Thanks
>
> T
>
>
>
> (cucm version 6.1.2 flavour with a broken BULK update for the ip phone
> service)
>
> Upgrade to 7 will happen but need to subscribe a "few" phones to the ip
> phone service on multiple 6.x cluster before.
>
>
>
> _______________________________________________
>
>
>
> This e-mail may contain information that is confidential, privileged or
> otherwise protected from disclosure. If you are not an intended recipient of
> this e-mail, do not duplicate or redistribute it by any means. Please delete
> it and any attachments and notify the sender that you have received it in
> error. Unless specifically indicated, this e-mail is not an offer to buy or
> sell or a solicitation to buy or sell any securities, investment products or
> other financial product or service, an official confirmation of any
> transaction, or an official statement of Barclays. Any views or opinions
> presented are solely those of the author and do not necessarily represent
> those of Barclays. This e-mail is subject to terms available at the
> following link: www.barcap.com/emaildisclaimer. By messaging with Barclays
> you consent to the foregoing.  Barclays Capital is the investment banking
> division of Barclays Bank PLC, a company registered in England (number
> 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.
> This email may relate to or be sent from other members of the Barclays
> Group.
>
> _______________________________________________
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>