[OpenSER-Users] RE: OpenSER Oracle Connection

[Papadopoulos Georgios]

Hi Martin,

I ran into the same issue (among many others) when I was trying to
connect OpenSER to Oracle.
I ended up changing code in the unixodbc module. Here is a patch you can
try, at your own risk of course... This will work if you use unixodbc
only with Oracle. 

--- /usr/src/openser-1.2.x/modules/unixodbc/utils.c     2007-06-05
17:12:58.000000000 +0300
+++ utils.c     2007-06-07 14:18:36.000000000 +0300
@@ -46,7 +46,7 @@
        struct tm* t;

        t = localtime(&_time);
-       return strftime(_result, _res_len, "%Y-%m-%d %H:%M:%S", t);
+       return strftime(_result, _res_len, "to_date(\'%Y-%m-%d
%H:%M:%S\',\'YYYY-MM-DD HH24:MI:SS\')", t);
 }


--- /usr/src/openser-1.2.x/modules/unixodbc/val.c       2007-06-05
17:12:58.000000000 +0300
+++ val.c       2007-06-07 15:07:00.000000000 +0300
@@ -157,10 +181,8 @@
                return -1;
        }

-       *_s++ = '\'';
        l = time2odbc(_v, _s, *_l - 1);
-       *(_s + l) = '\'';
-       *_l = l + 2;
+       *_l = l;
        return 0;
 }

Regards,

George



> Date: Wed, 8 Aug 2007 09:01:10 +0200
> From: <Martin.Gruber1 at infineon.com>
> Subject: [OpenSER-Users] OpenSER Oracle Connection
> To: <users at openser.org>
> Message-ID:
> 	
> <2934B34075D2164BB8F95C3EB2C813D90205DDC6 at mucse341.eu.infineon.com>
> Content-Type: text/plain;	charset="us-ascii"
> 
> Hi @all,
> 
> I want to run OpenSER with ORACLE Database. I use unixODBC and
> libsqora.so.10.1 to connect to the DB.
> But now I have problems with inserting Data in the DB.
> When OpenSER wants to add Data in the "location" table I 
> always get an error because of the timeformat (expires, last_modified)
> 
> I use SQL*Plus Client in Windows and when I write the 
> Connection String from OpenSER usrloc here, everything is 
> running well, Because I did alter session set nls_date_format 
> = 'YYYY-MM-DD HH24:MM:SS'; Is it a Driver problem?
> 
> Does anybody have a solution or experience with it?
> 
> Thanks
> 
> Martin
> 
> 
> 

Disclaimer
The information in this e-mail and any attachments is confidential. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorized to, and must not, read, copy, distribute, use or retain this message or any part of it. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.