camel - xml

[smilevasu6]

Hi,

I am having xml data like 

<results>
        <row>
                <EMPNO>7369</EMPNO>
                <ENAME>SMITH</ENAME>
                <SAL>800</SAL>
                <DEPTNO>10</DEPTNO>
        </row>
        <row>
                <EMPNO>7499</EMPNO>
                <ENAME>SMITH></ENAME>
                <SAL>1600</SAL>
                <DEPTNO>20</DEPTNO>
        </row>
        <row>
                <EMPNO>7521</EMPNO>
                <ENAME>SMITH</ENAME>
                <SAL>1250</SAL>
                <DEPTNO>30</DEPTNO>
        </row>
        <row>
                <EMPNO>7566</EMPNO>
                <ENAME>SMITH</ENAME>
                <SAL>2975</SAL>
                <DEPTNO>20</DEPTNO>
        </row>
</results>


I am writing  a camel router like,

from("file:C://Sri/?fileName=table_export_new.xml").
                //to("file:C://Sri/table_export_new.xml").
                setHeader("results", xpath("/row/EMPNO/text()), String.class")).
                setHeader("results", xpath("/row/ENAME/text()), String.class")).
                setHeader("results", xpath("/row/SAL/text()), String.class")).
                setHeader("results", xpath("/row/DEPTNO/text()), String.class"))
        //.convertBodyTo(String.class)
                .end();

And i am getting error as 

org.apache.camel.builder.xml.InvalidXPathExpression: Invalid
xpath:/row/EMPNO/text()), String.class. Reason:
javax.xml.xpath.XPathExpressionException

Can you please help me on this?

After this i want to put the data into database as well.

Please 




--
View this message in context: 
http://camel.465427.n5.nabble.com/camel-xml-tp5759622.html
Sent from the Camel - Users mailing list archive at Nabble.com.