[Freeswitch-dev] Fw: Usage of ODBC pooling

[Erjan Tylepov]

Hi all!

I guess, that mod_nibblebill's functions bill_event and get_balance lacks either mutex locking or connection pooling. Could someone check this out?
What will happen if two or more calls (threads) get into those functions, i.e. there's a probability, that they'll use globals.master_odbc simultaniously?


----- Original Message -----
From: Erjan Tylepov [mailto:e.tylepov at btcom.kz]
To: freeswitch-dev at lists.freeswitch.org
Sent: Thu, 15 Mar 2012 09:24:21 +0000
Subject: Usage of ODBC pooling


> Hi there!
> 
> Is this sequence, which should be executed for every db access, is a right
> way of ODBC connection pooling usage in FS:
> switch_odbc_handle_new
> switch_odbc_handle_connect
> either
>     switch_odbc_handle_exec
>     switch_odbc_statement_handle_free
> or
>     switch_odbc_handle_callback_exec
> switch_odbc_handle_disconnect?
> 
> Regards,
> YT.