ejabberd - Comments for "ODBC connection in http-bind"

rysi3k wrote: Thanks, it

mfoss — Sat, 09 Jul 2011 11:39:48 +0000

rysi3k wrote:

Thanks, it works, but I have idea, to put this functionality (db query) to different module.
So I want to execute query, from other module when the session timeouts.
Can I do this by any callback (in gen_fsm?) or other way ?

The only way I can think is that, in ejabberd_http_bind.erl you call
yourmod:run_sql_query(["SELECT VERSION()"])

And in yourmod.erl you define and export the function.

Thanks, it works, but I have

rysi3k — Tue, 05 Jul 2011 12:33:59 +0000

I think that the function

mfoss — Tue, 14 Jun 2011 10:33:04 +0000

I think that the function call needs to be inside a transaction, something like this:

handle_info({timeout, Timer, _}, _StateName,
    #state{id=SID, timer = Timer} = StateData) ->
    ?INFO_MSG("Session timeout. Closing the HTTP bind session: ~p", [SID]),
    %% This picks the first vhost defined in 'hosts' in ejabberd.cfg
    LServer = ?MYNAME,
    F = fun() ->
                run_sql_query(["SELECT VERSION()"])
        end,
    Res = run_sql_transaction(LServer, F).
    ?INFO_MSG("Result of my SQL query: ~p", [Res]),
    {stop, normal, StateData};