db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C.S. Nirmal J. Fernando (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4623) "XML data type" page in ref needs some modifications
Date Sun, 25 Apr 2010 18:09:49 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12860728#action_12860728
] 

C.S. Nirmal J. Fernando commented on DERBY-4623:
------------------------------------------------

Bryan following are the steps I followed.

*I removed the classpath values for xalan.jar and xercesImpl.jar, and still XMLSERIALIZE (xml
queries) works fine.

C:\Users\Nirmal>echo %classpath%
%classpath%;C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar;C:\OtherNirmal\GSoC\Cod
e\jars\sane\derbytools.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyrun.jar;C:\Ot
herNirmal\GSoC\Code\jars\sane\derbynet.jar;C:\OtherNirmal\GSoC\Code\jars\sane\de
rbyclient.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyTesting.jar;C:\OtherNirmal
\GSoC\Code\tools\java\jakarta-oro-2.0.8.jar;C:\OtherNirmal\GSoC\Code\tools\java\
junit.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_cs.jar;C:\OtherNirmal\G
SoC\Code\jars\sane\derbyLocale_de_DE.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derb
yLocale_es.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_fr.jar;C:\OtherNir
mal\GSoC\Code\jars\sane\derbyLocale_hu.jar;C:\OtherNirmal\GSoC\Code\jars\sane\de
rbyLocale_it.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ja_JP.jar;C:\Oth
erNirmal\GSoC\Code\jars\sane\derbyLocale_ko_KR.jar;C:\OtherNirmal\GSoC\Code\jars
\sane\derbyLocale_pl.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pt_BR.ja
r;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ru.jar;C:\OtherNirmal\GSoC\Code
\jars\sane\derbyLocale_zh_CN.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_
zh_TW.jar;C:\OtherNirmal\GSoC\Document\lib\fop.jar;C:\OtherNirmal\GSoC\Document\
lib\avalon-framework-4.2.0.jar;C:\OtherNirmal\GSoC\Document\lib\batik-all-1.6.ja
r;C:\OtherNirmal\GSoC\Code\classes;.

C:\OtherNirmal\GSoC\Code\jars\sane>java org.apache.derby.tools.ij
ij version 10.6
ij> CONNECT 'jdbc:derby:nirmal;create=false';
ij> select xmlserialize(a as CLOB) from xml_test;
1

--------------------------------------------------------------------------------
------------------------------------------------
<title>nirmal</title>


1 row selected
ij> exit;


*Next I removed xalan.jar in \tools\java and start ij in the same command prompt.

C:\OtherNirmal\GSoC\Code\jars\sane>java org.apache.derby.tools.ij
ij version 10.6
ij> CONNECT 'jdbc:derby:nirmal;create=false';
ij> select xmlserialize(a as CLOB) from xml_test;
ERROR XML00: Failed to locate 'Xalan' API or implementation classes.  XML operat
ions are not permitted unless these classes are in your classpath.
ij> exit;

*When I placed xalan.jar again in the \tools\java, I got the correct result.


Thanks.




> "XML data type" page in ref needs some modifications
> ----------------------------------------------------
>
>                 Key: DERBY-4623
>                 URL: https://issues.apache.org/jira/browse/DERBY-4623
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0,
10.5.1.1, 10.5.2.0, 10.5.3.0
>            Reporter: C.S. Nirmal J. Fernando
>            Assignee: C.S. Nirmal J. Fernando
>            Priority: Trivial
>         Attachments: DERBY-4623.diff, DERBY-4623.zip
>
>
> I think this page (http://db.apache.org/derby/docs/10.5/devguide/cdevstandardsxml.html
) need some more explanation on areas such as:
>     1) Setting paths of xercesImpl.jar and xalan.jar in the CLASSPATH
>     2) Command that user should use to start the Derby i.e. java org.apache.derby.tools.ij
>     3) Mention that user needed to create a table which contains XML data type column/s,
because users might thought that they can retrieve XML data from an any table.
>     4) Mention the requirements that are needed when inserting values to a XML data typed
column, i.e. need of XML keywords document & preserve whitespace, tags etc.
>     5) A small example which is clearly shows the creation, insertion & selection
using XML data type. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message