[SR-Users] Kamailio and Oracle database

[gmele]

Hello Daniel,

I'm now investigating the presence notification module problem and the odbc
query:

replace watchers
(presentity_uri,watcher_username,watcher_domain,event,status,inserted_time,reason
) values ('sip:xxx at zzzzzzz','yyyyy','zzzzzzzz,'presence',1,1462197118,'');

This query will insert a new row if it doesn't exist and replace it if it
exists in the table.

This requests fails with unixodbc and oracle as it seems it is not
supported. Can you confirm me if the odbc query replace is supported for
oracle? Didn't find anything on the web.

Is there the possiblity to split this query in 2: first a select, then an
insert or update?

Thx

Regards


Giovanni



--
View this message in context: http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148039.html
Sent from the Users mailing list archive at Nabble.com.