From issues at jboss.org Mon Feb 29 03:56:00 2016
Content-Type: multipart/mixed; boundary="===============3897672685730072692=="
MIME-Version: 1.0
From: Anton Saburov (JIRA) <issues at jboss.org>
To: jboss-jira at lists.jboss.org
Subject: [jboss-jira] [JBoss JIRA] (WFCORE-1416) PostgreSQL Non-XA DS -
 relation does not exists
Date: Mon, 29 Feb 2016 03:56:00 -0500
Message-ID: <JIRA.12608063.1456735759000.49916.1456736160601@Atlassian.JIRA>
In-Reply-To: JIRA.12608063.1456735759000@Atlassian.JIRA

--===============3897672685730072692==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


     [ https://issues.jboss.org/browse/WFCORE-1416?page=3Dcom.atlassian.jir=
a.plugin.system.issuetabpanels:all-tabpanel ]

Anton Saburov updated WFCORE-1416:
----------------------------------
    Summary: PostgreSQL Non-XA DS - relation does not exists  (was: Pjstgre=
SQL Non-XA DS - relation does not exists)


> PostgreSQL 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 JDB=
C 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 work=
ing
> WildFly 10 - I get error.
> Registered PostgreSQL JDBC driver as a module:
> module add --name=3Dorg.postgresql --resources=3Dpostgresql-9.3-1102-jdbc=
41.jar --resource-delimiter=3D, --dependencies=3Djavax.api,javax.transactio=
n.api
> Registered PostgreSQL JDBC driver:
> /subsystem=3Ddatasources/jdbc-driver=3Dpostgresql:add(driver-name=3Dpostg=
resql, driver-module-name=3Dorg.postgresql, driver-class-name=3Dorg.postgre=
sql.Driver, driver-datasource-class-name=3Dorg.postgresql.ds.PGSimpleDataSo=
urce, driver-xa-datasource-class-name=3Dorg.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 ex=
ist
> When I try to use XA DS - all is OK.
> I checked list of schema by SQL script: "select distinct table_schema fro=
m 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)

--===============3897672685730072692==--