db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thiwanka Somasiri <asthiwa...@gmail.com>
Subject Re: Wrong result in XMLSERIALIZE??
Date Sun, 18 Apr 2010 10:57:36 GMT
Hi Nirmal,
                No.I think you have not done any mistake.Just issue
the "maximumdisplaywidth"
command in ij with a sufficient value.That will show
the whole output.
*
*
*Thanks
*
On Sun, Apr 18, 2010 at 3:39 PM, Nirmal Fernando <nirmal070125@gmail.com>wrote:

> 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?
>
> Thanks.
>
> --
> Best Regards,
> Nirmal
>
> C.S.Nirmal J. Fernando
> Department of Computer Science & Engineering,
> Faculty of Engineering,
> University of Moratuwa,
> Sri Lanka.
>



-- 

Regards

A.S.Thiwanka Somasiri
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka.

Skype : executionerwild
MSN   : thiwas@ymail.com

Mime
View raw message