0 Replies Latest reply on Feb 29, 2016 10:30 PM by Anton Saburov

    PostgreSQL: Non-XA DS - relation does not exist

    Anton Saburov Newbie

      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 ?