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