?
Solved

Validate XML with XSD

Posted on 2009-04-03
13
Medium Priority
?
539 Views
Last Modified: 2012-05-06
Hi,

I'm completely new to XML and I'm trying to validate and XML document with an XSD.  I've used two different tools to try and make this work and both fail with essentially the same error:

"The element declaration was not found for root element query.querySubmission.  "

I've read every thing I could find on this and I'm still baffled by the whole thing.  Here is the document header:

<?xml version="1.0" encoding="UTF-8"?>
<query:querySubmission xmlns:query="http://www.npdb-hipdb.hrsa.gov/Query" xmlns:co="http://www.npdb-hipdb.hrsa.gov/Common" xmlns:ad="http://www.npdb-hipdb.hrsa.gov/Address" xmlns:orgCd="http://www.npdb-hipdb.hrsa.gov/OrganizationCode" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.npdb-hipdb.hrsa.gov/Common \\voyager\c$\QRXS\npdb-hipdb-common.xsd">

Can anyone point me in the right direction?  Thanks
0
Comment
Question by:jimc5240
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24060548
That either means that the schema is not found at location
\\voyager\c$\QRXS\npdb-hipdb-common.xsd
or that the querySubmission element is not declared in that namespace

The target namespace of the schema appears to be
http://www.npdb-hipdb.hrsa.gov/Common

The namespace of the querySubmission is
http://www.npdb-hipdb.hrsa.gov/Query

Since they are different, this means that there is a schema import.
So make sure that inside the schema the imports of other schema modules is pointing to accessible files

Maybe you can send the schema
0
 

Author Comment

by:jimc5240
ID: 24060679
I just tried to attach the files and the web site says that the file extension .xsd is not allowed.  I tried zipping it up but no go.  Can I cut and paste something?

Thanks
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24060758
you can always change the extension to .txt
the server will then accept it
(or send a zip to my email address, found in my profile)
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 

Author Comment

by:jimc5240
ID: 24060791
Duh.  Here it is
npdb-hipdb-common.txt
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24061153
Hey, I can't verify where the problem is, because you are importing other schema modules, which you did not provide
please check them for further nested imports, I suspect there are more

    <import namespace="http://www.npdb-hipdb.hrsa.gov/OrganizationCode" schemaLocation="npdb-hipdb-organization-type-code.xsd"/>
    <import namespace="http://www.npdb-hipdb.hrsa.gov/Address" schemaLocation="npdb-hipdb-address.xsd"/>
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24061731
so, make sure that at your site, all modules you need are available at the import address
after that validate again

good luck

Geert
0
 

Author Comment

by:jimc5240
ID: 24062162
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24073170
well
before I can tell you more...
I think you are at least missing this one
npdb-hipdb-organization-type-code.xsd
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24073173
If you don't have that one, it explains why the XML was not valid
0
 

Author Comment

by:jimc5240
ID: 24101023
Okay, I think I found the remaining files but still can't get it to work.  Here are the files.
npdb-hipdb-organization-type-cod.txt
npdb-hipdb-organization.txt
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 1500 total points
ID: 24101204
I have to disappoint you, I am afraid.
The schemas I now have are all valid, but none of them defines an element querySubmission.
So, in the schema you have put as a schemalocation, the element is not defined,
so this can't work.
I am afraid you need yet another schema
0
 

Author Closing Comment

by:jimc5240
ID: 31566239
I know this isn't an aswer but I wanted to give you the points for the effort, thanks
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24163171
welcome, it would have pleased me more, if I would have given you more help
0

Featured Post

RHCE - Red Hat OpenStack Prep Course

This course will provide in-depth training so that students who currently hold the EX200 & EX210 certifications can sit for the EX310 exam. Students will learn how to deploy & manage a full Red Hat environment with Ceph block storage, & integrate Ceph into other OpenStack service

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question