[OpenSER-Users] Error when connect to Oracle via ODBC.

[Martin.Gruber1 at infineon.com]

hi,
 
I think you should set the "expires" and "last_modified" field to date
and not timestamp.
And also a small hint.....the fields with Datatype number - constrain
them to a distinct size.
username should not be nullable!
 
hope this helps, otherwise contact me!
 
regards
Martin

________________________________

From: Tung Tran [mailto:tr.tung at gmail.com] 
Sent: Wednesday, October 03, 2007 4:15 PM
To: Gruber Martin (IFKL IT OS NV)
Cc: users at openser.org
Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.


Hi,
 
This is the structure of my location table.
If you need any information please let me know..
 
Thanks for your help in advanced
 
Regards
Tung


> Hi,
>
> please send me the structure of your location table.
>
> regards
>
> martin
>
> From: Tung Tran [mailto:tr.tung at gmail.com]
> Sent: Wednesday, October 03, 2007 8:55 AM
> To: Gruber Martin (IFKL IT OS NV)
> Cc: users at openser.org
> Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.
>
>
> Dear Martin,
>
> I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1 I
> also follow the guide on web to batch the unixodbc module and it
> runs with the error I just report.
> (http://openser.org/pipermail/users/2007-August/012532.html)
>
> Please help,
>
> Regards
> Tung
>
>
>> Hi,
>>
>> what version of OpenSER do you use. Seems that something in the
>> source is not running well. Check out the newest version first.
>> If it is not the case let me know!
>>
>> regards
>>
>> Martin
>>
>> From: users-bounces at openser.org [mailto:users-
>> bounces at openser.org] On Behalf Of Tung Tran Sent: Wednesday,
>> October 03, 2007 7:18 AM To: users at openser.org
>> Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.
>>
>>
>> Hi all,
>>
>> I am trying to connect Openser with Oracle via odbc. So far I can
>> connect sucessfully to Oracle DB via unixODBC module, I can
>> register and make call,
>> However I got this error from Openser debug that I dont know it
>> may effect to Openser operation
>>
>> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-
>>  00920: invalid relational operator
>>
>> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-
>>  00920: invalid relational operator
>>
>> 1(9499) db_raw_query: Error while submitting query  1(9499)
>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)
>> unixodbc:SQLExecDirect, rv=100. Query= delete from location where
>> expires
>> expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')  
>> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received,
>> contact, socket, cflags from location where expires > now() and
>> cflags & 64 = 64  1(9499)
>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator    1(9499)
>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator  
>> 1(9499) db_raw_query: Error while submitting query  1(9499)
>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)
>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
>> socket, cflags from location where expires > now() and cflags &
>> 64 = 64  1(9499)
>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator    1(9499)
>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator  
>> 1(9499) db_raw_query: Error while submitting query  1(9499)
>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)
>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
>> socket, cflags from location where expires > now() and cflags &
>> 64 = 64  1(9499)
>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator    1(9499)
>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
>> invalid relational operator    
>> Should anyone sucess customize Openser to work smoothly with
>> Oracle? please help.
>>
>> Thanks and regards
>> Tung
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20071004/a0b3120c/attachment.htm