db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Re: Wrong result in XMLSERIALIZE??
Date Sun, 18 Apr 2010 11:21:55 GMT
Hi Thiwanka,

Whoops, thanks for pointing it out!!

java -Dij.maximumDisplayWidth=1000 org.apache.derby.tools.ij

results displayed correctly when I increased the display width.

Sorry for any inconveniences.



On Sun, Apr 18, 2010 at 4:27 PM, Thiwanka Somasiri <asthiwanka@gmail.com> wrote:
> 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
>



-- 
Best Regards,
Nirmal

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

Mime
View raw message