[OpenSER-Users] RE: OpenSER Oracle Connection - sr-users

10 Aug 2007

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: &lt;Martin.Gruber1(a)infineon.com&gt;
 Subject: [OpenSER-Users] OpenSER Oracle Connection
 To: &lt;users(a)openser.org&gt;
 Message-ID:
 	
 &lt;2934B34075D2164BB8F95C3EB2C813D90205DDC6(a)mucse341.eu.infineon.com&gt;
 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.



    