Just wondering if anyone knows whether there is support for sql transactions when using the executeSQL methods?
 
Thanks

I have a problem adding analog devices to a VGx with a security profile having secure mode enabled.
Using addGatewaySccpEndpoints results in error "The specified Security Profile is not valid for this device type"
Inspired by your post, I tried the follwoing:
addPhone with Standard Non-Secure profile
do executeUpdateSql with
insert into mgcpdevicemember ...
update device set fksecurityprofile=...
Result: Error 480: The security mode of every real device on any given analog gateway must remain consistent with that of every other device on that gateway...
Hence I tried:

update device set fksecurityprofile=...
insert into mgcpdevicemember ...

And now the result: Error 448: The specified Security Profile is not valid for this device type
That means, these business rules are implemented as triggers activated by each single action (insert/update).
Question: Is there any chance to postpone application of these business rules until the end of transaction?
There must be same trick, since manually (GUI) one can add these phones. 
 
 
 
 
 

I'm out of office today from 1 p.m to 6 p.m.
In case of urgency please leave a message on the mobile phone.

Marco