[jboss-user] [JCA/JBoss] - Datasource with <ha-xa-datasource> is not deployed under JBO
Hi,
I try to deploy the following datasource to enable failover features under a JBOSS 5.0 GA
application server.
This xml datasource is validated against the dtd.
For moment, I use only one database URL just to begin my test.
My datasource file is perhaps wrong, but no explicit error message could help me to
understand why this datasource is not deployed.
Thanks for your help.
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!DOCTYPE datasources
| PUBLIC "-//JBoss//DTD JBOSS JCA Config 5.0//EN"
| "http://www.jboss.org/j2ee/dtd/jboss-ds_5_0.dtd">
| <datasources>
| <ha-xa-datasource>
|
| <jndi-name>jdbc/xxx-ds</jndi-name>
|
| <track-connection-by-tx></track-connection-by-tx>
|
| <!-- Connection settings -->
|
|
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
|
| <xa-datasource-property
name="URL">jdbc:oracle:thin:@host:1523:SID</xa-datasource-property>
|
| <url-property>URL</url-property>
|
| <url-delimiter>|</url-delimiter>
|
| <!-- set to false to fix problems with Oracle -->
|
| <isSameRM-override-value>false</isSameRM-override-value>
|
| <user-name>XXX</user-name>
|
| <password>YYY</password>
|
| <!--pooling parameters-->
|
| <min-pool-size>10</min-pool-size>
|
| <max-pool-size>100</max-pool-size>
|
| <!-- sets the idle timeout to 15 minutes -->
|
| <idle-timeout-minutes>15</idle-timeout-minutes>
|
| <!-- Oracles XA datasource cannot reuse a connection outside a transaction once
enlisted in a
|
| global transaction and vice-versa -->
|
| <no-tx-separate-pools></no-tx-separate-pools>
|
| <check-valid-connection-sql>SELECT * FROM
MY_CONSTANT_TABLE</check-valid-connection-sql>
|
|
<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>
|
| <!-- Prepared Statements -->
|
| <prepared-statement-cache-size>200</prepared-statement-cache-size>
|
| <share-prepared-statements></share-prepared-statements>
|
| </ha-xa-datasource>
|
| </datasources>
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4214949#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...