Hi Tung,
 
yes it is possible because the Query looks like a little bit strange. Maybe you should check out the
newest version of OpenSER......because i watched my Query and it looks okay.
Give it a try an tell me if it is running or not!
 
kind regards,
 
Martin


From: Tung Tran [mailto:tr.tung@gmail.com]
Sent: Thursday, October 04, 2007 9:29 AM
To: Gruber Martin (IFKL IT OS NV)
Cc: users@openser.org
Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.

Mr. Martin,
 
Sorry the errors are not disappear after I change the username to not null.
I think the errors should be in this query
 
 1(14057) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64
 1(14057) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator
 
If I copy this query and run directly on Oracle then I got error too, but I change the query to
    "select received, contact, socket, cflags from location where expires > now() and cflags  = 64"
 
then it works,
 
Do you think there is a bug in the code ?
 
Regards,

Tung
 
 
 


> he fields with Datatype number - constrain them to a distinct size

> 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@gmail.com]
> Sent: Wednesday, October 03, 2007 4:15 PM
> To: Gruber Martin (IFKL IT OS NV)
> Cc: users@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@gmail.com]
>> Sent: Wednesday, October 03, 2007 8:55 AM
>> To: Gruber Martin (IFKL IT OS NV)
>> Cc: users@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@openser.org [mailto:users-
>>> bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,
>>> October 03, 2007 7:18 AM To: users@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