-
1. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
shawkins Feb 20, 2017 4:08 PM (in response to kulbhushanc)Are you sure this is a Teiid issue, or are you having a general issue with configuring the WildFly datasource?
-
2. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
kulbhushanc Feb 22, 2017 7:02 AM (in response to shawkins)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"}
}
-
3. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
rareddy Feb 22, 2017 9:10 AM (in response to kulbhushanc)"I am trying to configure xa-datasource through wildfly."
How?
-
4. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
kulbhushanc Feb 23, 2017 4:02 AM (in response to rareddy)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"/>
-
5. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
rareddy Feb 23, 2017 8:46 AM (in response to kulbhushanc)Where did you add this extra module dependency? which module.xml?
-
6. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
kulbhushanc Feb 24, 2017 12:35 AM (in response to rareddy)at below location:
teiid-9.1.3-wildfly-server\teiid-9.1.3\modules\system\layers\base\com\oracle\main
-
7. Re: Unable to create XA-DataSource for Oracle 10g database using Teiid 9.1.3
shawkins Feb 28, 2017 8:00 PM (in response to kulbhushanc)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.