Recovering MDM database connection due to sudden outage in network.
book
Article ID: KB0085437
calendar_today
Updated On:
TIBCO MDM
|
-
|
Not Applicable
|
-
|
Description
Description:
Once connection to a database is lost, MDM does not reconnect automatically once a connection is available.
Symptoms:
When a connection to a database is lost, the following error is reported when attempting to reconnect.
--
SQL-8201: Database error. SQL state Unknown. Database specific error code (if any) was Unknown. Database error message (if any) was: Unknown. SQL-8201: Database error. SQL state . Database specific error code (if any) was 0. Database error message (if any) was: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed..
--
Cause: As valid-connection-checker is not set in the Standalone.xml file, MDM will not retry a connection to a database once disconnected.
Resolution
The following changes should be made in the standalone.xml file.
Current Values:
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
New Value:
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
Issue/Introduction
Recovering MDM database connection due to sudden outage in network.
Additional Information
MSSQL
https://community.jboss.org/message/617978
https://community.jboss.org/wiki/HowToSetADatasourceConnectionToMSSQLServer
For Oracle:
https://community.jboss.org/thread/228038
Feedback
thumb_up
Yes
thumb_down
No