Subject Re: [firebird-support] Single trans per connection?
Author Mark Rotteveel
On Fri, 8 Jun 2012 11:45:01 +0200, Kjell Rilbe <kjell.rilbe@...>
wrote:
> Hi,
>
> Please remind me, is it the case that you can only have a single active
> transaction per connection?

Technically Firebird allows you to use multiple, concurrent transaction on
a single connection, however not all drivers will expose it (eg Jaybird
doesn't do this as the JDBC spec specifies a single active transaction on a
connection).

> But you can have any number of commands/queries open for that single
> transaction and connection?

Yes

> This is in .Net and I'm using the FB provider version 2.6 or 2.7 I
think.

Not sure, you might want to try the .NET provider mailinglist.

Mark