Hi,
We have an application that we run against an ORACLE RAC database and have the connections configured using Oracle JNDI connection pool resource in
Tomcat. This all works fine. e.g.
<Context path="/lagan" docBase="/lagan">
<Resource name="jdbc/lagan"
auth="Container"
type="oracle.jdbc.pool.OracleDataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
url="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=cluster-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=cluster-vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=cluster1)))"
user="XX"
password="XX"
maxActive="20"
maxIdle="10"
maxWait="-1"
connectionCachingEnabled="true" />
</Context>
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
Thanks
Fred