You can enable a JBoss Application Server connection to the Global Configuration Data (GCD) and object store
databases after failover.
To enable JBoss Application Server connection
to the GCD and object store databases after failover:
- Open the JBoss_HOME/server/all/deploy/*-ds.xml files
that you created for the your data sources in a text editor.
- Uncomment the following lines, depending on your database
type:
Option |
Description |
DB2® |
<check-valid-connection-sql>
SQL statement
</check-valid-connection-sql>
Where SQL statement is
specific for DB2. For information,
see JBoss Application Server documentation
for "Connectors on JBoss". |
Oracle |
<valid-connection-checker-class-name>
org.jboss.resource.adapter.
jdbc.vendor.
OracleValidConnectionChecker
</valid-connection-checker-class-name>.
|
MS SQL Server |
<check-valid-connection-sql>
SQL statement
</check-valid-connection-sql>
Where SQL statement is
specific for MS SQL Server. For information, see JBoss Application Server documentation for "Connectors
on JBoss". |
- Save your changes.