xml sort using xslt

khdani · #1 (**permalink**) 05-24-2009, 09:02 AM

hello,
i try to sort xml using this xslt:

Code:

<?xml version="1.0" ?>
<xsl:stylesheet xmlns:xsl="link to w3c" Version="1.0">
<xsl:output method="text"/>
<xsl:template match="Messages">
<xsl:apply-templates>
<xsl:sort select="EMAIL" order="descending"/>
</xsl:apply-templates>
</xsl:template>
<xsl:template match = "Message">
ID: <xsl:apply-templates select="ID"/>EMAIL: <xsl:apply-templates select="EMAIL"/>
SUBJECT: <xsl:apply-templates select="SUBJECT"/>
DATE: <xsl:apply-templates select ="DATE"/>
BODY: <xsl-apply-templates select = "BODY"/>
<xsl:text></xsl:tetx>
</xsl:template></xsl:stylesheet>

and this code in java:

Code:

		Source xsl = new StreamSource(xslBuilder.toString());
		Source xml = new StreamSource(this.path);
			DOMResult result = new DOMResult(this.doc);
			TransformerFactory transFactory = TransformerFactory.newInstance();
			javax.xml.transform.Transformer transformer = transFactory.newTransformer(xsl);
			transformer.transform(xml, result);

(the xsl is in string)
but i get an error: no protocol
and fatal error: could not compile stylesheet

please help...

OrangeDog · #2 (**permalink**) 05-24-2009, 04:33 PM

Is your xslBuilder correctly initialised? Is this.path correct? Does both your xml and your xsl follow the w3c standards exactly?

(possibly useful link: XSL Transformations (XSLT) Version 2.0)

khdani · #3 (**permalink**) 05-24-2009, 04:57 PM

xslBuilder is StringBuilder, the whole xsl is created in StringBuilder
'this.path' is also correct
both xml and xsl follow w3c:
xml

Code:

<?xml version="1.0" encoding="utf-8" ?>
<Mail>
	<Message>
		<ID>1</ID>
		<EMAIL>mail@mail.com</EMAIL>
		<SUBJECT>Subject1</SUBJECT>
		<DATE>10/05/2009</DATE>
		<BODY><![CDATA[Hello :)]]></BODY>
	</Message>
</Mail>

xsl

Code:

		StringBuilder xslBuilder = new StringBuilder();
		xslBuilder.append("<?xml version=\"1.0\" encoding =\"UTF-8\" ?>");
		xslBuilder.append("<xsl:stylesheet xmlns:xsl=\"link wo w3c" Version=\"1.0\">");
		xslBuilder.append("<xsl:output method=\"text\"/>");
		xslBuilder.append("<xsl:template match=\"Messages\">");
		xslBuilder.append("<xsl:apply-templates>");
		xslBuilder.append("<xsl:sort select=\"" + sortArg+"\" order=\"" + order + "\"/>");
		xslBuilder.append("</xsl:apply-templates>");
		xslBuilder.append("</xsl:template>");
		
		xslBuilder.append("<xsl:template match = \"Message\">");
		xslBuilder.append("ID: <xsl:apply-templates select=\"ID\"/>");
		xslBuilder.append("EMAIL: <xsl:apply-templates select=\"EMAIL\"/>");
		xslBuilder.append("SUBJECT: <xsl:apply-templates select=\"SUBJECT\"/>");
		xslBuilder.append("DATE: <xsl:apply-templates select =\"DATE\"/>");
		xslBuilder.append("BODY: <xsl-apply-templates select = \"BODY\"/>");
		xslBuilder.append("<xsl:text>");
		xslBuilder.append("</xsl:tetx>");
		
		xslBuilder.append("</xsl:template>");
		
		xslBuilder.append("</xsl:stylesheet>");

OrangeDog · #4 (**permalink**) 05-24-2009, 10:36 PM

Does this operation work when not executed in Java? That is, is the output as expected if you simply apply the stylesheet to the xml and view in a browser?

khdani · #5 (**permalink**) 05-25-2009, 01:19 PM

well actually i did had some errors in xsl, but i fixed them and verified with XMLSpy. XMLSpy transforms the xml correctly but the java code gives same error

RamyaSivakanth · #6 (**permalink**) 05-25-2009, 01:21 PM

Could u paste the complete code with xsl?

khdani · #7 (**permalink**) 05-25-2009, 01:53 PM

i think i fixed the problem,
i should set systemID to some xslt file.
but i can't parse the result dom.

Code:

			DOMSource source = new DOMSource(this.doc);
			DOMResult result = new DOMResult();			
			TransformerFactory transFactory = TransformerFactory.newInstance();
			javax.xml.transform.Transformer transformer = transFactory.newTransformer(xsl);
			transformer.transform(source, result);	
			this.doc = (Document)result.getNode();

if i call:
[code]
this.doc.getDocumentElement().getElementsByTagName ("tagname");
i get an empty list...
but if i check in debugger the result node indeed has the xml dom tree transformed...

khdani · #8 (**permalink**) 05-25-2009, 02:08 PM

fixed that too
thank you

DSS · #9 (**permalink**) 06-20-2010, 09:04 AM

Sort XML by Date using XSL | Easy Tips and Tricks

Follow this link for the solution. Works great for me. Cheers!