Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3

[kulbhushanc]

Hi,

I am unable to create Xa-dataSource with oracle 10 g data base using teiid 9.1.3, where as I am successfully able to create Non-Xa Data Source using the same Credentials.

I have also able to create Xa DataSource for Mysql database.

Thanks,

Kulbhushan Chaskar

[shawkins]

Are you sure this is a Teiid issue, or are you having a general issue with configuring the WildFly datasource?

[kulbhushanc]

I am not sure whether this is a teiid issue or not, but yes I am trying to configure xa-datasource through wildfly.

I am getting below error message on screen while testing the xa-datasource for oracle database.

Failed to create JDBC connection.

An internal error occurred.

Details:

Unexpected HTTP response: 500

Request

{

  "address" => [

  ("subsystem" => "datasources"),

  ("xa-data-source" => "XAOracleDS2")

  ],

  "operation" => "test-connection-in-pool"

}

Response

Internal Server Error

{

  "outcome" => "failed",

  "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",

  "rolled-back" => true,

  "response-headers" => {"process-state" => "reload-required"}

}

[rareddy]

"I am trying to configure xa-datasource through wildfly."

How?

[kulbhushanc]

I am using jboss admin console to create datasource, VDB but I was facing problem to configure XA datasouce but when I added a line <module name="javax.transaction.api"/> to module.xml it worked now I am able to create XA dasource for oracle too.

<module name="javax.transaction.api"/>

[rareddy]

Where did you add this extra module dependency? which module.xml?

[kulbhushanc]

at below location:

teiid-9.1.3-wildfly-server\teiid-9.1.3\modules\system\layers\base\com\oracle\main

[shawkins]

Did you get an exception related to classloading?

I can see for some of the other driver modules we include javax.transaction.api, but not oracle.