About neblaz

neblaz · 07-20-2021

I try Apache HttpClient to send text message to Cisco VoIP Phones. HttpPost httpPost = new HttpPost(url); httpPost.setEntity(new StringEntity(body, ContentType.TEXT_XML)); httpPost.addHeader(new BasicScheme().authenticate(usernamePasswordCredentials,...

neblaz · 05-31-2021

I want to do an INSERT INTO on a CUCM table. There are two SQL requests:- ExecuteSQLQueryReq- ExecuteSQLUpdateReq I need the PKID of that insert.How to do that? Which of the two Req to use?

neblaz · 06-02-2021

In theory your right, after the INSERT INTO simply query the tuple.But as far as I can see, the primary key is PKID.That means, that there could be possibly many tuples where only the PKID differs.After the INSERT INTO I could get back more then the ...

neblaz · 06-02-2021

newid() would be the correct method. But, it doesn't give back the PKID.In fact I can remove the newid() entirely in the INSERT INTO statement, as according to the Data Dictionary the default value for the PKID will be generated with newid(). INSERT ...

neblaz · 05-31-2021

It looks like an INSERT INTO has to be done with ExecuteSQLUpdateReq. I found this example:https://community.cisco.com/t5/management/get-pkid-of-inserted-row/td-p/3429510 Which shows an example to use "newId()" function.But what kind of function is "...

Member Since	‎05-31-2021 05:13 AM
Date Last Visited	‎07-27-2021 06:49 AM
Posts	5
Total Helpful Votes Received	5

User Statistics

User Activity

Tesxt Message to VoIP Phone - CiscorIPPhoneError 1

AXL INSERT INTO on CUCM 12.5 table - Get new PKID

Re: AXL INSERT INTO on CUCM 12.5 table - Get new PKID

Re: AXL INSERT INTO on CUCM 12.5 table - Get new PKID

Re: AXL INSERT INTO on CUCM table - Get new PKID