WildFly - PostgreSQL Non-XA DS - relation does not exist

[ansaspb]

Hi all,

I tried to execute simple select from PostgreSQL 9.4 - something like that "select * from jc_table"

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: ERROR: relation "jc_table" does not exist
When I try to use XA DS - all is OK.

I checked list of schema 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 ?

[gsanders]

Hi Anto,

do you run wildfly in standalone-mode?

if yes, try this:

/subsystem=datasources/jdbc-driver=postgresql:add(driver-name=postgresql,driver-class-name=org.postgresql.Driver,driver-module-name=org.postgresql,driver-xa-datasource-class-name=org.postgresql.xa.PGXADataSource)

[rcd]

You might be getting hit by WFLY-6157.