db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Wrong result in XMLSERIALIZE??
Date Sun, 18 Apr 2010 10:09:36 GMT
Hi All,

Here is the scenario I encountered this problem of wrong result.


ij> connect 'jdbc:derby:memory:dummy;create=true';
ij> create table t ( a xml );
0 rows inserted/updated/deleted
ij> insert into t ( a ) values ( xmlparse( document '<?xml version="1.0" encodin
g="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"  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="a
ll" />     <script type="application/x-javascript" src="z_files/subscribe.js"></
script>   </head></html>' preserve whitespace ) );
1 row inserted/updated/deleted
ij> select xmlserialize(a as clob) from t;
<?xml-stylesheet href="z_files/global.css" type="text/css"?><html xmlns="http://
www.w3.org/1999/xhtml" xmlns:xul="http://www.mo&

1 row selected


Why is the result not complete? or Did I make any mistake here?


Best Regards,

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.

View raw message