[
https://jira.jboss.org/jira/browse/JOPR-104?page=com.atlassian.jira.plugi...
]
Ian Springer commented on JOPR-104:
-----------------------------------
For quick reference, here's what the oracle-xa-ds.xml looks like (from AS 4.2.3):
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- ATTENTION: DO NOT FORGET TO SET Pad=true IN transaction-service.xml -->
<!-- ===================================================================== -->
<datasources>
<xa-datasource>
<jndi-name>XAOracleDS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property
name="URL">jdbc:oracle:oci8:@tc</xa-datasource-property>
<xa-datasource-property
name="User">scott</xa-datasource-property>
<xa-datasource-property
name="Password">tiger</xa-datasource-property>
<!-- Uses the pingDatabase method to check a connection is still valid before
handing it out from the pool -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Oracles XA datasource cannot reuse a connection outside a transaction once
enlisted in a global transaction and vice-versa -->
<no-tx-separate-pools/>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
-->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</xa-datasource>
<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>
Oracle XA Datasource Creation through JON - Wrong template
----------------------------------------------------------
Key: JOPR-104
URL:
https://jira.jboss.org/jira/browse/JOPR-104
Project: Jopr
Issue Type: Bug
Components: Plugin - JBoss AS 4
Affects Versions: 2.1
Environment: OS: CentOS, jon-server-2.1.2.GA, JBoss AS 4.2.3 Oracle 10g
Reporter: senthurkumaran masilamani
JON Server Currently creates Oracle XA datasource with the following format.
<?xml version="1.0" encoding="UTF-8"?>
<xa-datasource>
<jndi-name>test</jndi-name>
<connection-url>jdbc:oracle:oci8:@tc</connection-url>
<user-name>a</user-name>
b
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<no-tx-separate-pools>true</no-tx-separate-pools>
<driver-class>oracle.jdbc.xa.client.OracleXADataSource</driver-class>
</xa-datasource>
It should follow the standard template as given in the jca examples(oracle-xa-ds.xml).
Due to this the XA datasources created through JON doesn't work properly. We are
trying to implement complete JBoss AS admin. through JON Server. This issue leads manual
effort to configure the XA DS.
Thanks & Regards
Senthur
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira