Uploaded image for project: 'WildFly'
  1. WildFly
  2. WFLY-6299

PostgreSQL Non-XA DS - relation does not exist

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • None
    • None
    • Hide

      Code:

      try {
      Connection con = null;
      String dsType = request.getParameter("ds");
      InitialContext ic = new InitialContext();
      DataSource ds = (DataSource) ic.lookup("1".equals(dsType) ? "java:/MyDS" : "java:/MyXADS");
      con = ds.getConnection();

      PreparedStatement pst = con.prepareStatement("select distinct table_schema from information_schema.tables");
      ResultSet srs = pst.executeQuery();
      while (srs.next())

      { System.out.println("Schema:" + srs.getString(1)); }

      try {
      PreparedStatement st = con.prepareStatement("select * from public.jc_region");
      ResultSet rs = st.executeQuery();
      while (rs.next())

      { System.out.println("Region:" + rs.getString(1)); }

      } finally

      { con.close(); }

      } catch (Exception e)

      { e.printStackTrace(System.out); }
      Show
      Code: try { Connection con = null; String dsType = request.getParameter("ds"); InitialContext ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("1".equals(dsType) ? "java:/MyDS" : "java:/MyXADS"); con = ds.getConnection(); PreparedStatement pst = con.prepareStatement("select distinct table_schema from information_schema.tables"); ResultSet srs = pst.executeQuery(); while (srs.next()) { System.out.println("Schema:" + srs.getString(1)); } try { PreparedStatement st = con.prepareStatement("select * from public.jc_region"); ResultSet rs = st.executeQuery(); while (rs.next()) { System.out.println("Region:" + rs.getString(1)); } } finally { con.close(); } } catch (Exception e) { e.printStackTrace(System.out); }

      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 ?

              Unassigned Unassigned
              ansaspb Anton Saburov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: