Hibernate Books

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Connection strings with "failover partner"
PostPosted: Fri Sep 21, 2007 2:42 pm 
Newbie

Joined: Sun Aug 12, 2007 2:34 pm
Posts: 8
Location: Geneva, IL USA
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


Top
 Profile  
 
 Post subject: Any resolution?
PostPosted: Wed Nov 14, 2007 2:45 pm 
Newbie

Joined: Wed Nov 14, 2007 11:58 am
Posts: 2
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....


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 14, 2007 9:33 pm 
Newbie

Joined: Sun Aug 12, 2007 2:34 pm
Posts: 8
Location: Geneva, IL USA
Hi,

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

H


Top
 Profile  
 
 Post subject: We've confirmed that it works as expected
PostPosted: Fri Nov 16, 2007 5:58 pm 
Newbie

Joined: Wed Nov 14, 2007 11:58 am
Posts: 2
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.