]
Brian Stansberry moved WFCORE-1416 to WFLY-6299:
------------------------------------------------
Project: WildFly (was: WildFly Core)
Key: WFLY-6299 (was: WFCORE-1416)
PostgreSQL Non-XA DS - relation does not exist
----------------------------------------------
Key: WFLY-6299
URL:
https://issues.jboss.org/browse/WFLY-6299
Project: WildFly
Issue Type: Bug
Environment: WildFly 10.0.0.Final, PostgreSQL 9.4, PostgreSQL JDBC Driver 9.3 and
9.4
Reporter: Anton Saburov
Labels: datasource, postgresql
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 ?