[jboss-jira] [JBoss JIRA] (WFCORE-1416) PjstgreSQL Non-XA DS - relation does not exists

[Anton Saburov (JIRA)]

Anton Saburov created WFCORE-1416:
-------------------------------------

             Summary: PjstgreSQL Non-XA DS - relation does not exists
                 Key: WFCORE-1416
                 URL: https://issues.jboss.org/browse/WFCORE-1416
             Project: WildFly Core
          Issue Type: Bug
         Environment: WildFly 10.0.0.Final, PostgreSQL 9.4, PostgreSQL JDBC Driver 9.3 and 9.4
            Reporter: Anton Saburov


I tried to check the same 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 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 ?



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)