Uploaded image for project: 'Application Server 7'
  1. Application Server 7
  2. AS7-5238

Cannot see more than 8 XADatasources in console.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 7.1.3.Final (EAP)
    • 7.1.2.Final (EAP)
    • Console
    • None

    • Firefox, Internet Explorer and Chrome

    • Hide

      1. Create more than 8 XADatasources. Add 9 datasources this to standalone.xml, for example:

      <datasources>
      <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
      ...
      </datasource>
      <xa-datasource jndi-name="java:jboss/DB1" pool-name="DB1" use-ccm="false">
      <xa-datasource-property name="url">
      DB1
      </xa-datasource-property>
      <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
      <driver>h2</driver>
      <xa-pool>
      <is-same-rm-override>false</is-same-rm-override>
      <interleaving>false</interleaving>
      <pad-xid>false</pad-xid>
      <wrap-xa-resource>false</wrap-xa-resource>
      </xa-pool>
      <security>
      <user-name>sa</user-name>
      <password>sa</password>
      </security>
      <validation>
      <validate-on-match>false</validate-on-match>
      <background-validation>false</background-validation>
      </validation>
      <statement>
      <share-prepared-statements>false</share-prepared-statements>
      </statement>
      </xa-datasource>
      <xa-datasource jndi-name="java:jboss/DB2" pool-name="DB2" use-ccm="false">
      <xa-datasource-property name="url">
      DB2
      </xa-datasource-property>
      ...
      </xa-datasource>
      ...
      <drivers>
      ...
      </drivers>
      </datasources>

      2. Open the console at http://localhost:9990/console/App.html#datasources
      3. Open the XA Datasources tab
      4. Scoll down the list of datasources, and observe only 8 are viewable.

      Show
      1. Create more than 8 XADatasources. Add 9 datasources this to standalone.xml, for example: <datasources> <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"> ... </datasource> <xa-datasource jndi-name="java:jboss/DB1" pool-name="DB1" use-ccm="false"> <xa-datasource-property name="url"> DB1 </xa-datasource-property> <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> <driver>h2</driver> <xa-pool> <is-same-rm-override>false</is-same-rm-override> <interleaving>false</interleaving> <pad-xid>false</pad-xid> <wrap-xa-resource>false</wrap-xa-resource> </xa-pool> <security> <user-name>sa</user-name> <password>sa</password> </security> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </xa-datasource> <xa-datasource jndi-name="java:jboss/DB2" pool-name="DB2" use-ccm="false"> <xa-datasource-property name="url"> DB2 </xa-datasource-property> ... </xa-datasource> ... <drivers> ... </drivers> </datasources> 2. Open the console at http://localhost:9990/console/App.html#datasources 3. Open the XA Datasources tab 4. Scoll down the list of datasources, and observe only 8 are viewable.
    • Workaround Exists
    • Hide

      Manage the extra datasources via the CLI, or standalone.xml configuration file.

      Using the CLI, test the datasource like this, replacing ExampleDS, with your datasource name.

      /subsystem=datasources/data-source=ExampleDS:test-connection-in-pool

      Show
      Manage the extra datasources via the CLI, or standalone.xml configuration file. Using the CLI, test the datasource like this, replacing ExampleDS, with your datasource name. /subsystem=datasources/data-source=ExampleDS:test-connection-in-pool

      When creating more than 8 XADatasources, we can only see a total of 8 in the web administration console.

              rhn-support-hbraun Heiko Braun
              rhn-support-jshepher Jason Shepherd
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: