1 Reply Latest reply on Jan 28, 2005 2:36 PM by Adrian Brock

    Problems with XA Resource (Oracle) and JBoss 3.2.4

    Günther Reisner Newbie

      Hi,

      I am using JBoss 3.2.4. I have configured an Oracle XA datasource.

      Here is the *-ds.xml:

      <datasources>
      <xa-datasource>
      <jndi-name>OracleDS</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:@XXX_XXX</xa-datasource-property>
      <xa-datasource-property name="User">xxx</xa-datasource-property>
      <xa-datasource-property name="Password">xxx</xa-datasource-property>
      <no-tx-separate-pools />
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <min-pool-size>25</min-pool-size>
      <max-pool-size>80</max-pool-size>
      <blocking-timeout-millis>500000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <managedconnectionfactory-class>
      org.jboss.resource.adapter.jdbc.xa.oracle.XAOracleManagedConnectionFactory
      </managedconnectionfactory-class>
      </xa-datasource>
      <local-tx-datasource>
      <jndi-name>OracleAdminDS</jndi-name>
      <connection-url>jdbc:oracle:oci8:@XXX_XXX</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>xxx</user-name>
      <password>xxx</password>
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      </local-tx-datasource>
      </datasources>


      The Pad attribute of the XidFactory-MBean is also set to "true"

      The Oracle Database is XA ready.
      We use the Oracle version 9.2i, driver: 9.0.2.0.0

      First I get the Error: ORA-01591: lock held by in-doubt distributed transaction


      And in the connection pool are no more available connections:

      | ManagedConPool |
      Date | OracleDS |
      | AC CC IUC mC |
      Tue Jan 18 12:18:24 2005 | 079 020 001 019 |
      Tue Jan 18 12:22:25 2005 | 076 034 004 033 |
      Tue Jan 18 13:13:09 2005 | 073 030 001 033 |
      Tue Jan 18 13:13:39 2005 | 067 031 006 037 |
      Tue Jan 18 13:46:40 2005 | 048 011 006 038 |
      Tue Jan 18 13:47:12 2005 | 044 012 005 043 |
      Tue Jan 18 14:19:10 2005 | 039 014 000 050 |
      Tue Jan 18 14:41:08 2005 | 016 013 002 071 |
      Tue Jan 18 14:52:52 2005 | 007 013 002 080 |
      Tue Jan 18 15:10:07 2005 | 006 010 002 080 |
      Tue Jan 18 15:10:37 2005 | 005 010 000 080 |
      Tue Jan 18 15:11:07 2005 | 000 010 005 080 |
      Tue Jan 18 15:11:37 2005 | 000 010 005 080 |
      Tue Jan 18 15:12:07 2005 | 000 010 005 080 |

      ...

      Wed Jan 19 06:59:13 2005 | 000 003 002 080 |
      Wed Jan 19 06:59:43 2005 | 000 003 002 080 |
      Wed Jan 19 07:00:15 2005 | 000 003 002 080 |
      Wed Jan 19 07:00:45 2005 | 000 002 002 080 |
      Wed Jan 19 07:01:17 2005 | 000 002 002 080 |
      Wed Jan 19 07:01:47 2005 | 000 002 002 080 |
      Wed Jan 19 07:02:19 2005 | 000 002 002 080 |



      What could be the error?

      Can anyone help?