Hi Nirmal,
For the record, I am able to use the XML operators if my classpath
contains the xml jars which are checked into Derby's tools/java directory:
tools/java/xalan.jar:tools/java/xercesImpl.jar
When my classpath contains those jars, I can successfully execute the
following script:
connect 'jdbc:derby:memory:dummy;create=true';
create table t ( a xml );
insert into t ( a ) values ( xmlparse( document '<?xml version="1.0"
encoding="UTF-8"?> <!DOCTYPE xsl:stylesheet [<!ENTITY nbsp " ">]>
<?xml-stylesheet href="z_files/global.css" type="text/css"?> <html
id="feedHandler" xmlns="http://www.w3.org/1999/xhtml";
xmlns:xul="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul";>
<head> <meta http-equiv="content-type" content="text/html;
charset=UTF-8" /> <title>Derby 10.6.1 Fixed Bugs List (ASF
JIRA)</title> <link rel="stylesheet" href="z_files/subscribe.css"
type="text/css" media="all" /> <script
type="application/x-javascript" src="z_files/subscribe.js"></script>
</head></html>' preserve whitespace ) );
select xmlserialize(a as clob) from t;
Hope this helps,
-Rick
