Is there an RDBMS driver in the Erlang universe whose API supports transactions? The docs for odbc, epgsql and emysql do not specify any kind of transaction support.
> Is there an RDBMS driver in the Erlang universe whose API supports transactions? > The docs for odbc, epgsql and emysql do not specify any kind of transaction support.
Erlydb had transaction support, and some people may still be using it.
ODBC actually does too. You use odbc:connect/2 followed by odbc:commit/2, unless you have {auto_commit, on}, in which case every query is a transaction.
Look at the tests to see how transactions are used. I use them extensively in my current project.
Alex Arnon <alex.ar...@gmail.com> writes: > Hi All,
> Is there an RDBMS driver in the Erlang universe whose API supports > transactions? > The docs for odbc, epgsql and emysql do not specify any kind of > transaction support.
> > Is there an RDBMS driver in the Erlang universe whose API supports > > transactions? > > The docs for odbc, epgsql and emysql do not specify any kind of > > transaction support.
Just to reiterate Ulf's point, in case you missed it. The standard Erlang odbc module supports transactions when you odbc:connect/2 using the option {auto_commit, off}.
Although, if I remember correctly, nested txns are not supported.
On Mon, May 2, 2011 at 8:18 PM, Alex Arnon <alex.ar...@gmail.com> wrote: > Thank you all for the solutions, this is very helpful! > We will evaluate the epgsql and erlang-mysql solutions.
> On Mon, May 2, 2011 at 9:43 PM, Parnell Springmeyer <ixma...@gmail.com>wrote:
>> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1
>> > Is there an RDBMS driver in the Erlang universe whose API supports >> > transactions? >> > The docs for odbc, epgsql and emysql do not specify any kind of >> > transaction support.
> Just to reiterate Ulf's point, in case you missed it. The standard Erlang > odbc module supports transactions when you odbc:connect/2 using the option > {auto_commit, off}.
> Although, if I remember correctly, nested txns are not supported.
> Robby
> On Mon, May 2, 2011 at 8:18 PM, Alex Arnon <alex.ar...@gmail.com> wrote:
>> Thank you all for the solutions, this is very helpful! >> We will evaluate the epgsql and erlang-mysql solutions.
>> On Mon, May 2, 2011 at 9:43 PM, Parnell Springmeyer <ixma...@gmail.com>wrote:
>>> -----BEGIN PGP SIGNED MESSAGE----- >>> Hash: SHA1
>>> > Is there an RDBMS driver in the Erlang universe whose API supports >>> > transactions? >>> > The docs for odbc, epgsql and emysql do not specify any kind of >>> > transaction support.
On Mon, May 2, 2011 at 10:24 PM, Alex Arnon <alex.ar...@gmail.com> wrote: > Hi All,
> Is there an RDBMS driver in the Erlang universe whose API supports > transactions? > The docs for odbc, epgsql and emysql do not specify any kind of transaction > support.
On Tue, May 3, 2011 at 3:39 PM, mabrek <mab...@gmail.com> wrote: > On Mon, May 2, 2011 at 10:24 PM, Alex Arnon <alex.ar...@gmail.com> wrote: > > Hi All,
> > Is there an RDBMS driver in the Erlang universe whose API supports > > transactions? > > The docs for odbc, epgsql and emysql do not specify any kind of > transaction > > support.
I know that the Odbc library has a commit/2 and commit/3, but I'm not sure if
I am interpreting its use correctly.
If I create a session with the {auto_commit, off} attribute and then do a
series of separate sql_query/2 SELECT statements (not batched statements,
but separate invocations of sql_query/2), followed by a committ/2, are the
selects all done within a single transaction guaranteeing ACID properties?
On Mon, May 2, 2011 at 2:24 PM, Alex Arnon <alex.ar...@gmail.com> wrote:
> Hi All,
> Is there an RDBMS driver in the Erlang universe whose API supports
> transactions?
> The docs for odbc, epgsql and emysql do not specify any kind of transaction
> support.
On Thu, May 5, 2011 at 3:40 AM, Alex Arnon <alex.ar...@gmail.com> wrote:
> Oh, excellent! Thank you very much!
> On Tue, May 3, 2011 at 3:39 PM, mabrek <mab...@gmail.com> wrote:
>> On Mon, May 2, 2011 at 10:24 PM, Alex Arnon <alex.ar...@gmail.com> wrote:
>> > Hi All,
>> > Is there an RDBMS driver in the Erlang universe whose API supports
>> > transactions?
>> > The docs for odbc, epgsql and emysql do not specify any kind of
>> transaction
>> > support.
