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

[Peter Slow]

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
>
>