Technote (troubleshooting)
Problem(Abstract)
MSSQL2008 failover cannot be automatically setup using a variable in sandbox.cfg. Instead you have to manually hardcode it into jdbc.properties.in and activemqconfig.xml.in and run setupfiles.sh / setupfiles.cmd
Symptom
In jdbc.properties.in and activemqconfig.xml.in you have to hard code the URL string to allow MSSQL2008 failover as shown below:
jdbc.properties.in :-
sqlserver://servername:port;databaseName=GIS51;failoverPartner=otherservername
activemqconfig.xml.in :-
<property name="driverClassName">
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</property>
<property name="url">
<value>jdbc:sqlserver://servername:port;DatabaseName=GIS5;failoverPartner=otherservername</value>
</property>
<property name="username">
<value>GIS51</value>
</property>
A variable should be defined in sandbox.cfg which populates MSSQL2008 failover the same as oracle already does.
Cause
No variable defined in sandbox.cfg and functionality not added to jdbc.properties.in and activemqconfig.xml.in to check for variable.
Resolving the problem
Apply patch 5.1.03 and use new variable MSSQL_JDBC_URL in sandbox.cfg to define the full jdbc url.
Historical Number
00308090
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.