Hi All, I wanted to do some XML Operations in Derby. For that I found that I need to have xalan.jar in my CLASSPATH. So I downloaded Xalan binaries and set the CLASSPATH variable (in Vista). Following is the echo %CLASSPATH% result:
Microsoft Windows [Version 6.0.6001] Copyright (c) 2006 Microsoft Corporation. All rights reserved. C:\Users\Nirmal>echo %CLASSPATH% C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar;C:\OtherNirmal\GSoC\Code\jars\sane\ derbytools.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyrun.jar;C:\OtherNirmal\GS oC\Code\jars\sane\derbynet.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyclient.ja r;C:\OtherNirmal\GSoC\Code\jars\sane\derbyTesting.jar;C:\OtherNirmal\GSoC\Code\t ools\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\GSoC\Code\jar s\sane\derbyLocale_de_DE.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_es.j ar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_fr.jar;C:\OtherNirmal\GSoC\Cod e\jars\sane\derbyLocale_hu.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_it .jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ja_JP.jar;C:\OtherNirmal\GSo C\Code\jars\sane\derbyLocale_ko_KR.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyL ocale_pl.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pt_BR.jar;C:\OtherNi rmal\GSoC\Code\jars\sane\derbyLocale_ru.jar;C:\OtherNirmal\GSoC\Code\jars\sane\d erbyLocale_zh_CN.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_zh_TW.jar; C: \OtherNirmal\GSoC\xalan-j_2_7_1-bin-2jars\xalan-j_2_7_1\xalan.jar;C:\OtherNirmal \GSoC\xalan-j_2_7_1-bin-2jars\xalan-j_2_7_1\serializer.jar;C:\OtherNirmal\GSoC\x alan-j_2_7_1-bin-2jars\xalan-j_2_7_1\xml-apis.jar;C:\OtherNirmal\GSoC\xalan-j_2_ 7_1-bin-2jars\xalan-j_2_7_1\xercesImpl.jar;C:\OtherNirmal\GSoC\xalan-j_2_7_1-bin -2jars\xalan-j_2_7_1\xsltc.jar;C:\OtherNirmal\GSoC\xalan-j_2_7_1-bin-2jars\xalan -j_2_7_1\samples\xalansamples.jar I have colored the paths related to Xalan for readability purposes. But when I execute following ij> SELECT XMLSERIALIZE(x as CLOB) FROM t; the result was this, ERROR XML00: Failed to locate 'Xalan' API or implementation classes. XML operat ions are not permitted unless these classes are in your classpath. I would be really appreciate if some one can help me to work this out. Thank you very much. -- Best Regards, Nirmal C.S.Nirmal J. Fernando Department of Computer Science & Engineering, Faculty of Engineering, University of Moratuwa, Sri Lanka.
