If you are using an Oracle database with JBoss Application Server version 4.0.5 or version
4.2.3, you must edit the data source XML files to set the <mbean>
attribute to allow successful connection to the database.
To set the <mbean> attribute:
- Remove the <mbean> tag from the Global Configuration Data (GCD) data source XML
file, jboss_install_dir/server/myserver/deploy/FNDGCDXA-ds.xml.
- Open the data source XML file in a text editor.
- Delete the following <mbean> tag:
<mbean
code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
name="jboss.jca:service=OracleXAExceptionFormatter">
<depends optional-attribute name="TransactionManagerService">
jboss:service=TransactionManager
</depends>
</mbean>
- Save your change.
- Remove the <mbean> tag from the object store FNDosnameXA-ds.xml data
source XML files. Ensure that the data source XML files
for your object stores do not have the <mbean> tag.
- Add the <mbean> tag to the CEMP-mbean-ds.xml XML
file.
- Create an XML file and name it jboss_install_dir/server/myserver/deploy/CEMP-mbean-ds.xml.
- Add the following text to the XML file. Do not enter
any line breaks in the <mbean> tag.
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<mbean
code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
name="jboss.jca:service=OracleXAExceptionFormatter">
<depends optional-attribute-name="TransactionManagerService">
jboss:service=TransactionManager></depends>
</mbean>
</datasources>
- Save the file.