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</ElectronicMail>
</Contact>
');
</sql>
(error posted at the beginning of this message)
Any hints on how I could fix that?
Thank you,
ericdes