Uploaded image for project: 'WildFly Core'
  1. WildFly Core
  2. WFCORE-676

data-source .. --new-connection-sql does not allow double qoutes in the SQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.0.0.CR2
    • 1.0.0.CR1
    • CLI
    • None
    • Hide

      Try variations of this command:

      data-source --name=ExampleDS --new-connection-sql="set role test identified by \"password\""

      The intention is to use double quotes around the password as this is needed when the password contains special characters.

      Several variations simply get refused, at best the xml ends up like:

      <new-connection-sql>set role test identified by password""</new-connection-sql>

      => two double quotes AFTER the password.

      It is assumed this will happen in other places where the syntax is similar.

      Show
      Try variations of this command: data-source --name=ExampleDS --new-connection-sql="set role test identified by \"password\"" The intention is to use double quotes around the password as this is needed when the password contains special characters. Several variations simply get refused, at best the xml ends up like: <new-connection-sql>set role test identified by password""</new-connection-sql> => two double quotes AFTER the password. It is assumed this will happen in other places where the syntax is similar.
    • Hide

      none that uses CLI commands

      Show
      none that uses CLI commands

    Description

      Setting an SQL statement with double quotes in it from the CLI is not possible:

      data-source --name=ExampleDS --new-connection-sql="set role test identified by \"password\""

      Attachments

        Activity

          People

            olubyans@redhat.com Alexey Loubyansky
            tfonteyn Tom Fonteyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: