18 Apr
2010
18 Apr
'10
8:21 p.m.
Hello,
I am trying to use SQLOps Module in my kamailio 1.5 configuration.
According to your explanations every result of sql_query should be
freed just after using that data.
So it means that there will be better to fetch for THE SAME data three
times instead of just one.
Am I right?
But nevertheless I've been trying to query just one and free the
result of the sql_query at the end of the file.
Could sb tell me if the result of sql query executed in the main part
of the script is remembered and could be used on failure route as
well?
Thanks,
Maciej.
19 Apr
19 Apr
2:35 a.m.
On 04/18/2010 01:21 PM, Maciej Bylica wrote:
Hello,
I am trying to use SQLOps Module in my kamailio 1.5 configuration.
According to your explanations every result of sql_query should be
freed just after using that data.
So it means that there will be better to fetch for THE SAME data three
times instead of just one.
Am I right?
But nevertheless I've been trying to query just one and free the
result of the sql_query at the end of the file.
Could sb tell me if the result of sql query executed in the main part
of the script is remembered and could be used on failure route as
well?
As far as I know, sqlops results are freed at the end of invocation of
script processing of a given message, be that a request or a reply.
They do not persist for the life of the transaction, and therefore
cannot be reused in failure_route.
--
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/
2:56 a.m.
Hi Alex,
As far as I know, sqlops results are freed at the end
of invocation of
script processing of a given message, be that a request or a reply. They do
not persist for the life of the transaction, and therefore cannot be reused
in failure_route.
Yes you are right. So it is not by my mistake :)
Thanks,
Maciej.
11:14 a.m.
On Monday 19 April 2010, Maciej Bylica wrote:
Hi Maciej,
you could e.g. just store certain query results in an AVP, and then use this
later in the failure_route or reply_route.
Cheers,
Henning
As far as I
know, sqlops results are freed at the end of invocation of
script processing of a given message, be that a request or a reply. They
do not persist for the life of the transaction, and therefore cannot be
reused in failure_route.
Yes you are right. So it is not by my mistake :) 
12:04 p.m.
On 4/19/10 1:35 AM, Alex Balashov wrote:
On 04/18/2010 01:21 PM, Maciej Bylica wrote:
the sqlops query is freed either by the
sql_result_free() or by another
sql_query() that stores over the same result id. So you can use the same
result for many sip messages, but withing the same process, the result
uses private memory.
Cheers,
Daniel
--
Daniel-Constantin Mierla * http://www.asipto.com/ *
http://twitter.com/miconda *
http://www.linkedin.com/in/danielconstantinmierla
Hello,
I am trying to use SQLOps Module in my kamailio 1.5 configuration.
According to your explanations every result of sql_query should be
freed just after using that data.
So it means that there will be better to fetch for THE SAME data three
times instead of just one.
Am I right?
But nevertheless I've been trying to query just one and free the
result of the sql_query at the end of the file.
Could sb tell me if the result of sql query executed in the main part
of the script is remembered and could be used on failure route as
well?
As far as I know, sqlops results are freed at the end of invocation of
script processing of a given message, be that a request or a reply.
They do not persist for the life of the transaction, and therefore
cannot be reused in failure_route.
21 Apr
21 Apr
10:52 a.m.
Hello,
I am trying to use SQLOps Module in my kamailio 1.5 configuration.
According to your explanations every result of sql_query should be
freed just after using that data.
So it means that there will be better to fetch for THE SAME data three
times instead of just one.
Am I right?
But nevertheless I've been trying to query just one and free the
result of the sql_query at the end of the file.
Could sb tell me if the result of sql query executed in the main part
of the script is remembered and could be used on failure route as
well?
As far as I know, sqlops results are freed at the end of invocation of
script processing of a given message, be that a request or a reply. They do
not persist for the life of the transaction, and therefore cannot be reused
in failure_route.
5332
days inactive
5335
days old
5 comments
4 participants
participants (4)
-
Alex Balashov -
Daniel-Constantin Mierla -
Henning Westerholt -
Maciej Bylica