Problems with XA Resource (Oracle) and JBoss 3.2.4
reisner Jan 25, 2005 7:58 AMHi,
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?