I'm not a MySQL guy. I'm pretty confident, when done properly,
TransactionScope works with MySQL simply because I haven't seen anyone post
here that it doesn't.
using (var ts = new TransactionScope())
{
// Do some RavenDB work here maybe
// Open the session & transaction inside the TransactionScope
using (var session = sessionFactory.OpenSession())
{
using (var tx = session.BeginTransaction())
{
// Do all your NH / MySQL work here
tx.Commit();
}
}
// You can also do some RavenDB work here
// Notice that this is *after* the session has been disposed.
ts.Complete();
}
On Sat, Nov 20, 2010 at 7:40 AM, Jacob Madsen <[email protected]> wrote:
> Hi all,
>
> I have a customer where the system is running on Amazon Web Services.
> They already have a running system with NH and MySql. TransactionScope
> is not used, since NH transactions is enough to do the job.
>
> The MySql setup is tested, multiple machines and have great uptime.
>
> Now they are trying out RavenDB for some reporting features. They want
> to use TransactionScope for transactions.
>
> This is now an issue, since NH or the MySql client throw up with
> "Nested transactions are not supported", when BeginTransaction() is
> invoked on the ISession object.
>
>
> Is it a complete no-go with MySql or can we do something to get
> TransactionScope working with NH transaction?
>
> I read several times read on this list that NH transaction is needed
> for NH internals to work properly, so I don't wont to stop using it.
>
>
> Cheer!
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
