Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your first option, xmllint (libxml2), does give line numbers for errors in the xml (and also in the xsd). You probably just need a later version. I just confirmed both using my copy, which is:</p> <pre><code>&gt; xmllint --version xmllint: using libxml version 20627 </code></pre> <p>Example output:</p> <pre><code>invalidXml.xml:4: element c: Schemas validity error : Element 'c': This element is not expected. Expected is ( b ). invalidXml.xml fails to validate &lt;?xml version="1.0"?&gt; &lt;invalidXmlEg&gt; &lt;a/&gt; &lt;!-- &lt;b&gt;&lt;/b&gt; --&gt; &lt;c/&gt; &lt;/invalidXmlEg&gt; </code></pre> <p>Where the xsd is:</p> <pre><code>&lt;xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"&gt; &lt;xs:element name="invalidXmlEg"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="a" type="xs:string" /&gt; &lt;xs:element name="b" type="xs:string" /&gt; &lt;xs:element name="c" type="xs:string" /&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;/xs:schema&gt; </code></pre> <p>NOTE: I have noticed that xmllint will accept elements names that it shouldn't (e.g. "<code>&lt;invalidXml.xsd&gt;</code>"), but this doesn't seem to affect your task.</p> <p><em>EDIT</em> adding the "compiled with" part of the version:</p> <pre><code> compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron Modules Debug Zlib </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POCommand-line XML validator for Windows
      singulars
      1. PTQuestion
    1. PTAnswer
    1. US13ren
    1. US13ren
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCommand-line XML validator for Windows
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COInteresting! The version I'm using is 20703, which produces "`Element 'c': This element is not expected. Expected is ( b ).`" (nearly identical, but lacks line number). I'll have to see if I can dig up and older version.
      singulars
      1. PO
      1. USBen Blank
    2. COSeems a backward step... I wonder if they added an option, for whether line numbers are included or not? Might be worth checking the docs (maybe --verbose). Or... maybe it's to do with what has been compiled in? I didn't include that, but I'll add it (also I'm running on linux, which shouldn't make any difference): it's compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron Modules Debug Zlib
      singulars
      1. PO
      1. US13ren
    3. COLooks like the version of `libxml` in Cygwin is compiled with the same options, and there doesn't seem to be any `--verbose`-like option. I ended up grabbing the Win32 binaries for 2.6.27 from the official site and it works just fine. A backwards step, indeed. :-)
      singulars
      1. PO
      1. USBen Blank
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload