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
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
>
> 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.
>
> 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
>>
>> 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