It passes with this configuration now
<datasources>
|
| <xa-datasource>
|
| <jndi-name>XAOracleDS</jndi-name>
|
|
<reauthentication-mechanism>org.jboss.resource.adapter.jdbc.vendor.DummyReauthenticationMechanism</reauthentication-mechanism>
| <user-name>scott</user-name>
| <password>tiger</password>
| <track-connection-by-tx/>
| <isSameRM-override-value>false</isSameRM-override-value>
| <connection-property
name="connectionProperties">key=Value</connection-property>
|
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
| <xa-datasource-property
name="uRL">jdbc:oracle:thin:@localhost:1522|jdbc:oracle:thin:@localhost:1523|jdbc:oracle:thin:@localhost:1524|jdbc:oracle:thin:@localhost:1521</xa-datasource-property>
| <!--
connection-url>jdbc:oracle:thin:@localhost:1522|jdbc:oracle:thin:@localhost:1523|jdbc:oracle:thin:@localhost:1524|jdbc:oracle:thin:@localhost:1521</connection-url
-->
|
| <!-- driver-class>oracle.jdbc.driver.OracleDriver</driver-class -->
| <url-delimiter>|</url-delimiter>
| <url-property>uRL</url-property>
| <!-- xa-datasource-property
name="User">scott</xa-datasource-property -->
| <!-- xa-datasource-property
name="Password">tiger</xa-datasource-property -->
| <!-- xa-datasource-property
name="ConnectionProperties">XATransLoose=true</xa-datasource-property
-->
| <min-pool-size>1</min-pool-size>
| <max-pool-size>5</max-pool-size>
| <prefill>true</prefill>
|
| <!-- 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>
Here is the results after deployment
22:00:25,160 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=XAOracleDS' to JNDI name
'java:XAOracleDS'
| 22:00:30,183 INFO [ConnectionFactoryBindingService] Unbound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=XAOracleDS' from JNDI name
'java:XAOracleDS'
| 22:00:30,262 WARN [XAManagedConnectionFactory] Failed to create an XA connection to
jdbc:oracle:thin:@localhost:1522: Could not create connection; - nested throwable:
(java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection)
| 22:00:30,263 WARN [XAManagedConnectionFactory] Failed to create an XA connection to
jdbc:oracle:thin:@localhost:1523: Could not create connection; - nested throwable:
(java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection)
| 22:00:30,265 WARN [XAManagedConnectionFactory] Failed to create an XA connection to
jdbc:oracle:thin:@localhost:1524: Could not create connection; - nested throwable:
(java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection)
| 22:00:30,281 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=XAOracleDS' to JNDI name
'java:XAOracleDS'
This looks perfectly okay as jdbc:oracle:thin:@localhost:1522,
jdbc:oracle:thin:@localhost:1523 and jdbc:oracle:thin:@localhost:1524 are invalid URL
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4148398#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...