[asterisk-bugs] [JIRA] (ASTERISK-24364) Oracle over odbc realtime broken pjsip

[HZMI8gkCvPpom0tM (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-24364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

HZMI8gkCvPpom0tM updated ASTERISK-24364:
----------------------------------------

    Status: Waiting for Feedback  (was: Waiting for Feedback)

{quote}
vpbxdev*CLI> pjsip list endpoints

 Endpoint:  <Endpoint/CID.....................................>  <State.....>  <Channels.>
 =========================================================================================

No objects found.

[Oct  2 13:30:02] DEBUG[54316]: res_config_odbc.c:113 custom_prepare: Skip: 0; SQL: SELECT * FROM ps_endpoints WHERE id LIKE ? ORDER BY id
[Oct  2 13:30:02] DEBUG[54316]: res_config_odbc.c:129 custom_prepare: Parameter 1 ('id LIKE') = '%'
[Oct  2 13:30:02] DEBUG[54316]: res_odbc.c:1062 odbc_release_obj2: odbc_release_obj2(0x26386e8) called (obj->txf = (nil))
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'ID' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'TRANSPORT' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'AORS' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'AUTH' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'CONTEXT' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'DISALLOW' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'ALLOW' from retrieval
[Oct  2 13:30:02] DEBUG[54316]: res_sorcery_realtime.c:119 sorcery_realtime_filter_objectset: Filtering out realtime field 'DIRECT_MEDIA' from retrieval
{quote}




If i do same (SELECT * FROM ps_endpoints WHERE id LIKE '%' ORDER BY id) using ORACLE client i see that data exist in table.



> Oracle over odbc realtime broken pjsip 
> ---------------------------------------
>
>                 Key: ASTERISK-24364
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24364
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: pjproject/pjsip, Resources/res_odbc, Resources/res_pjsip
>    Affects Versions: 12.6.0
>            Reporter: HZMI8gkCvPpom0tM
>            Assignee: HZMI8gkCvPpom0tM
>
> In case of using pjsip with oracle realtime over odbc.
> Asterisk try to execute queryes like 
> {{SELECT ID FROM ps_endpoints WHERE id =:0;}}
> Binding variable to :0 is not allowed in oracle (at least for version 10.2.0.5.x) 
> Query constantly return ORA-01403: no data found
> After it realtime registrations functionality of pjsip completely stop to work.
> PS: If to use binding variable names like 
> {{SELECT ID FROM ps_endpoints WHERE id =:var0;}}
> oracle works ok. 
> It is possible bug in oracle of course, but i think that change of naming notation for odbc binding variables can solve a lot of compatibility issues with different databases.



--
This message was sent by Atlassian JIRA
(v6.2#6252)