Hi,
I guess the problem is that mysql .net connector does not support
distributed transactions. I had a similar problem trying to use
nservicebus with transactional msmq and nhibernate.
I've described my conclusions here
http://www.erata.net/net/nservicebus-with-nhibernate-and-mysql/
Hope it helps
eti
On 11/20/2010 21:19, Jason Dentler wrote:
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]
<mailto:[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]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto: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.
--
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.
