How to keep WHERE condition in Table Compare?

[Satya]

Hi,

I would like to compare a table (using DBSolo) using .xml file, with where condition.

when I'm mentioning where condition (with >, < in .xml file), it's erroring out.

SEVERE: MainApp: Error performing comparison: {0}
oracle.xml.parser.v2.XMLParseException; lineNumber: 20; columnNumber: 47; '<' cannot appear in attribute value.
    at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:326)
    at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:438)
    at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:246)
    at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:175)
    at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:131)
    at com.dbsolo.O.EA.A(Unknown Source)
    at com.dbsolo.Z.V.A(Unknown Source)
    at com.dbsolo.P.E.A.G(Unknown Source)
    at com.dbsolo.ui.MainApp.main(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84)
    at com.install4j.runtime.launcher.UnixLauncher.start(UnixLauncher.java:66)
    at install4j.com.dbsolo.ui.MainApp_commandLine.main(Unknown Source)

Thanks,

Satya

[DB Solo Admin]

All special characters need to be escaped. If you do it in the UI it will be done automatically when you save the comparison XML file. You can then view the file to see the escaped values for various characters.

Marko

[Satya]

I tried, in UI (version 5.3.1), kept WHERE condition and saved the .xml file.

But when I reload/checked the .xml, I didn't find WHERE condition.

btw, what is the escape character, is it \ ?

[DB Solo Admin]

You should see something like this in the xml file

<MYTABLE included="true" where="MYCOLUMN &lt; 1" mappedwhere="MYCOLUMN &lt; 1" pk_order="" mapped="MYTABLE" mapped_pk_order="">