[
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.
