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

No comments:

Post a Comment