VDB XML transformation fails if the backend JDBC URL contains & characters
--------------------------------------------------------------------------

         Key: SEQUOIA-836
         URL: https://forge.continuent.org/jira/browse/SEQUOIA-836
     Project: Sequoia
        Type: Bug
  Components: Core  
    Versions: Sequoia 3.0 beta1, Sequoia 2.10.2    
    Reporter: Jeff Mesnil
 Assigned to: Jeff Mesnil 
     Fix For: Sequoia 2.10.3, Sequoia 3.0


The user can set several options in the JDBC URL of a backend in the vdb.xml 
file by separating
them with escaped ampersand -- & --:
jdbc:mysql://node1/db1?zeroDateTimeBehavior=convertToNull&foo=bar

The VDB XML parser will unescape the XML entities (like &) in the URL and use 
this unescaped version
to create the corresponding DatabaseBackend:
jdbc:mysql://node1/db1?zeroDateTimeBehavior=convertToNull&foo=bar

However the CLI command "show virtualdatabase config" is not working anymore
because we will use the unescaped URL before transforming the xml returned
by DatabaseBackend.getXml() to prettify it.

DB1(admin) > show virtualdatabase config
Transformation of xml file failed.

To fix it, we must return in DatabaseBackend.getXml() an escaped version of the 
JDBC URL



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to