We are going to be moving soon to a mirrored database implementation for MS SQL2005. This is supported in ADO connection strings via the "failover partner" keywords. Is this supported in the NHibernate connection strings?

Here's an example ADO connection string:

"Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;"

I can't test this right now but hoping to hear if anyone has done this and if there were any issues.

Thanks
H

We're in the same boat ourselves at the moment. We think that it should work just fine in theory b/c NHibernate 1.2 uses System.Data version 2.0. Yet, you never know with these things. Just wanted to follow up and see if you had a chance to test and, if so, were there any gotchas of which we should be aware. Thanks....

Hi,

We have not done this yet. Will update as soon as we do implement this. (that's if we do it too).

H

Long story short, it does indeed work. We had a slight hiccup with the way we were caching our NHibernate session and had to add a method that verifies the session's connection is still open when we pull it out of the call context.