Showing posts with label mirroring. Show all posts
Showing posts with label mirroring. Show all posts

Friday, February 24, 2012

JDBC Support for Database mirroring

I am new to Microsoft SQL Server 2005 and i would like to make use of its database mirroring feature.
My question though is: is database mirroring supported by the JDBC driver and if so how would you implement/code a connection to principal and mirror servers i.e. how would i implement a client - redirect in case of failures.

Any help will be greatly appreciated.

I believe that this was answered here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=348327&SiteID=1

thanks,

Mark

Monday, February 20, 2012

JDBC Driver version to support SQL Server 2005 Database Mirroring

Hi

We are in the development phase of a project, which has SQL Server 2005 as the database, and Java for the presentation / business logic / services tiers. We are looking to increase resilience of the database tier and are intending to patch to service pack 1 and use the database mirroring facility. The advantages are quick failover which is important for this application. To implement this, what version of JDBC driver do we require? My concern is that although database mirroring is now supported in the database, we can't take advantage of it using Java?

Mark.

I think answer is here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=348327&SiteID=1

Thanks