2 Replies Latest reply on Oct 18, 2016 5:11 PM by Rich DiCroce

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

    Anton Saburov Newbie

      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 ?