db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Enabling XML Operations: Setting XALAN in CLASSPATH
Date Fri, 16 Apr 2010 15:27:49 GMT
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:


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 "&#160;">]>

<?xml-stylesheet href="z_files/global.css" type="text/css"?> <html 
id="feedHandler" xmlns="http://www.w3.org/1999/xhtml"  
<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,

View raw message