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:CommonAggregateComponen
ts-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:CommonAggregateCom
ponents-2">
<Name
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicCompone
nts-2">Mrs
Bouquet</Name>
<Telephone
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicCompone
nts-2">0158
1233714</Telephone>
<Telefax
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicCompone
nts-2">0158
1233856</Telefax>
<ElectronicMail
xmlns="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicCompone
nts-2">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
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
