4 Replies Latest reply on Sep 27, 2012 2:28 AM by Wolf-Dieter Fink

    No pool-name in AS 7.1

    michel777 Newbie

      Hello

      In 7.0 pool-name can be specified when creating a datasource with CLI

      With 7.1 it seems that is no longer possible. Is-it normal (not listed in the :read-resource) ?

      Many thanks

        • 1. Re: No pool-name in AS 7.1
          Wolf-Dieter Fink Master

          From the xsd it looks like that the pool name is still available.

          Could you post your CLI command.

          • 2. Re: No pool-name in AS 7.1
            michel777 Newbie

            Below the CLI command

             

            [standalone@localhost:9999 /] /subsystem=datasources/data-source="java:jboss/datasources/MySqlDS2":add(jndi-name="java:jboss/datasources/MySqlDS2",pool-name="MySqlPool",driver-name="mysql",connection-url="jdbc:mysql://localhost:3306/test",user-name="root")

            'pool-name' is not found among the supported properties: [connection-url, driver-class, datasource-class, jndi-name, driver-name, new-connection-sql, url-delimiter, url-selector-strategy-class-name, use-java-context, jta, max-pool-size, min-pool-size, pool-prefill, pool-use-strict-min, user-name, password, security-domain, reauth-plugin-class-name, reauth-plugin-properties, flush-strategy, prepared-statements-cache-size, share-prepared-statements, track-statements, allocation-retry, allocation-retry-wait-millis, blocking-timeout-wait-millis, idle-timeout-minutes, query-timeout, use-try-lock, set-tx-query-timeout, transaction-isolation, check-valid-connection-sql, exception-sorter-class-name, exception-sorter-properties, stale-connection-checker-class-name, stale-connection-checker-properties, valid-connection-checker-class-name, valid-connection-checker-properties, background-validation-millis, background-validation, use-fast-fail, validate-on-match, spy, use-ccm]

             

            Thank

            • 3. Re: No pool-name in AS 7.1
              michel777 Newbie

              Hello

              Something wrong in my command ?

              • 4. Re: No pool-name in AS 7.1
                Wolf-Dieter Fink Master

                Hi Michel,

                 

                the 'pool-name' is no attribute it is the identifier. Use the following command:

                /subsystem=datasources/data-source="MySqlPool":add(jndi-name="java:jboss/datasources/MySqlDS2",driver-name="mysql",connection-url="jdbc:mysql://localhost:3306/test",user-name="root")

                After that the attribute pool-name is "MySqlPool"