Issue with XA transaction type for oracle 9i

Getting the below error when creating adapter service for XA transaction type connection.
Connection is enabled with out any issue.But could not create adapter service for the below reason.Looks like no additional jars are needed as connection enabled fine without any issues.

Note : Local transaction type connection is working fine for all operations with same database.

Is there any setup required at database side or webMethods side.

Error Info [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource Mot_Legal_Connectors:koko_XA_NEW.
Enlist Failed

connection details for Mot_Legal_Connectors:koko_XA_NEW Details

Connection Type JDBC Adapter Connection
Package Name Mot_Legal_Connectors
Connection Properties
Transaction Type XA_TRANSACTION
DataSource Class oracle.jdbc.xa.client.OracleXADataSource
serverName xxxxx
user xxxx
password ******
databaseName xxx
portNumber xxxx
networkProtocol tcp
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 5
Maximum Pool Size 10
Pool Increment Size 5
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

Would appreciate your quick response.


Make sure

XA transaction only works with OCI oracle driver not with JDBC driver.


which driver version are you using?

Oracle 9i or Oracle 10g?

At least with 10g Driver I can connect to our 9i Databases with XA-Transaction without any problems.

10g Driver has also LOB-Support for Thin-mode and should be more performant the 9i Driver.