jdbc.properties.in and activemqconfig.xml.in do not have checks for MSSQL failover , jdbc url string incorrect

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:

(0 users)Average rating

Document information


More support for:

Sterling B2B Integrator
Installation

Software version:

5.1

Operating system(s):

All

Software edition:

All Editions

Reference #:

1576027

Modified date:

2012-11-15

Translate my page

Machine Translation

Content navigation