I tried to check in WildFly 8.2.1 and 9.0.2 - everything is working. WildFly 10 - I get error.
- Registered PostgreSQL JDBC driver as a module:
module add --name=org.postgresql --resources=postgresql-9.3-1102-jdbc41.jar --resource-delimiter=, --dependencies=javax.api,javax.transaction.api
- Registered PostgreSQL JDBC driver:
/subsystem=datasources/jdbc-driver=postgresql:add(driver-name=postgresql, driver-module-name=org.postgresql, driver-class-name=org.postgresql.Driver, driver-datasource-class-name=org.postgresql.ds.PGSimpleDataSource, driver-xa-datasource-class-name=org.postgresql.xa.PGXADataSource)
Created Non-XA Datasource - MyDS and XA Datasource MyXADS
When I try to use Non-XA DS - I got error: relation "<table>" does not exist
When I try to use XA DS - all is OK.
I checked list of schemas by SQL script: "select distinct table_schema from information_schema.tables"
For Non-XA I see only this:
- information_schema
- pg_default
For XA I see this:
- information_schema
- pg_default
- public
Maybe I have to make some additional options for DS ?
