A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
SQL Server database failover
Joined: Aug 17, 2009
Aug 17, 2009 07:04:35
We have an application that we run against an ORACLE RAC database and have the connections configured using Oracle JNDI connection pool resource in
. This all works fine. e.g.
<Context path="/lagan" docBase="/lagan">
However we have some applications that use SQL Server 2005 and implement clustering through the standard windows clustering functionality, e.g. database failover.
Can the database connection in Tomcat be configured to support this type of SQL Server Cluster
Joined: Apr 14, 2004
Aug 17, 2009 07:27:13
It depends on your driver. I believe jTDS can do this, and I'm pretty certain the MS 2005 driver can do it too.
However, if you are using clustering you should not need to do anything special to your data source, it should just work, since Windows is doing all the clustering magic.
It is sorta covered in the
JavaRanch Style Guide
subject: SQL Server database failover
Passing user and password in Oracle RAC url
JBOSS 4.3.0 EAP Clustering with Apache HTTP Server 2.2.11
Oracle RAC intermittent connection
Multi datasource in websphere
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013