1 Reply Latest reply on Mar 9, 2009 3:23 PM by Vicky Kak

    Datasource with <ha-xa-datasource> is not deployed under JBO

    Alain GATTONE Newbie

      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>