Hi Hugh,
The XML Schema I had put in the database is actually part a of set of
many schemas by Oasis (the UBL standard), I'm quite sure they didn't
make any errors.
I tried to insert it again, and this seems to indicate it's well in the
database:
<pre>
SQLState: XSD01
Message: The XMLSchema for target namespace
"urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"
is already declared
</pre>
Does the SQL message SR449 really tell the XSD file is not valid,
shouldn't I have gotten an error message when I did a 'CREATE XML
SCHEMA' the first time?
Eric.
On 6/12/2009 11:40 AM, Hugh Williams wrote:
Hi Eric,
Where is the XML Schema declaration/creation you insert values are to be
validated against as the error seems to imply that is invalid in some
way? See the following documentation link for details on usage:
http://docs.openlinksw.com/virtuoso/CREATETABLE.html#sqlrefcreattablewithschema
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 11 Jun 2009, at 22:31, ericdes wrote:
I tried many ways around to find where this error could come from, to no
avail:
<pre>
SQLState: 42000
Message: SR449: XML parser detected an error:
FATAL : XML Schema Declaration
<x-virt-cache-xsd--urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2>
is not valid
at line 3 column 92 of '(value to be placed in column
tela_dtest.DBA.contacts of content)'
oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2">
----------------------------------------------------------------------^
</pre>
Here's how I created the table:
<sql>
CREATE TABLE tela_dtest..contacts (
id INTEGER IDENTITY PRIMARY KEY,
content XMLType WITH SCHEMA
('urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2',
'Contact')
);
</sql>
(no error)
The insert statement:
<sql>
INSERT INTO tela_dtest..contacts(content) VALUES('
<?xml version="1.0" encoding="utf-8"?>
<Contact
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2">
<Name
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">Mrs
Bouquet</Name>
<Telephone
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">0158
1233714</Telephone>
<Telefax
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">0158
1233856</Telefax>
<ElectronicMail
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2">bouq...@fpconsortial.co.uk
<mailto:bouq...@fpconsortial.co.uk></ElectronicMail>
</Contact>
');
</sql>
(error posted at the beginning of this message)
Any hints on how I could fix that?
Thank you,
ericdes
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
