Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-14659

(7.0.z) Single quotes are missed from --check-valid-connection-sql when adding xa data source via jboss-cli --command

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 7.0.0.GA
    • CLI
    • None
    • Hide

      when running the following cli command for adding xa-data-source

      "/path/to/jboss-cli.sh"  -c controller=localhost --command="xa-data-source add  --name=test --jndi-name=java:/test --driver-name=h2  --user-name=sa  --password=sa  --enabled=true  --xa-datasource-properties={\"URL\"=>\"jdbc:h2:mem:test\"}  --check-valid-connection-sql=\"INSERT INTO some_table VALUES (123, 'some_value');\" "
      

      expected results:
      "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, 'some_value');"

      actual results:
      "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, some_value);"
      single quotes are missed

      Show
      when running the following cli command for adding xa-data-source "/path/to/jboss-cli.sh" -c controller=localhost --command= "xa-data-source add --name=test --jndi-name=java:/test --driver-name=h2 --user-name=sa --password=sa --enabled= true --xa-datasource-properties={\" URL\ "=>\" jdbc:h2:mem:test\ "} --check-valid-connection-sql=\" INSERT INTO some_table VALUES (123, 'some_value' );\ " " expected results: "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, 'some_value');" actual results: "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, some_value);" single quotes are missed

    Description

      when running the following cli command for adding xa-data-source

      "/path/to/jboss-cli.sh"  -c controller=localhost --command="xa-data-source add  --name=test --jndi-name=java:/test --driver-name=h2  --user-name=sa  --password=sa  --enabled=true  --xa-datasource-properties={\"URL\"=>\"jdbc:h2:mem:test\"}  --check-valid-connection-sql=\"INSERT INTO some_table VALUES (123, 'some_value');\" "
      

      expected results:
      "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, 'some_value');"

      actual results:
      "Check Valid Sql" equal to "INSERT INTO some_table VALUES (123, some_value);"
      single quotes are missed

      Attachments

        Activity

          People

            jdenise@redhat.com Jean Francois Denise
            test00oleksiilv Oleksii V (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: