All,

I'm trying to handle the response from a PayPal reporting xml request. 
Below is a fragment of the larger xml:

<getMetaDataResponse>
  <reportId>#########64</reportId>
  <numberOfRows>2</numberOfRows>
  <numberOfPages>1</numberOfPages>
  <pageSize>1000</pageSize>
  <numberOfColumns>55</numberOfColumns>
  <columnMetaData colNum="1">
    <dataName>Transaction ID</dataName>
    <dataType>string</dataType>
  </columnMetaData>
  <columnMetaData colNum="2">
    <dataName>Time</dataName>
    <dataType>date</dataType>
  </columnMetaData>
...
...
...
</getMetaDataResponse>


I was trying to use the bold section of code to handle each row
(<columnMetaData> tag).  I'm not quite sure how to approach this.  I want to
store each row as a java object that will then be persisted to an oracle
database.  Any recomendations/examples.  Also the current code that I have
below, I get the following error, "The method otherwise() is undefined for
the type ExpressionNode".

Thanks,,


Dennis



        public void configure() throws Exception {

                try {
                        
from("quartz2://myGroupName/myTimerName?cron=0/20+*+*+*+*+?")
                                        .process(new 
RunReport()).to(JETTY_STRING)
                               .choice()
                                              
.when().xpath("/reportingEngineResponse/baseResponse/responseCode
= '100' and /reportingEngineResponse/runReportResponse/statusCode = '3'")
                                                 .log("Valid report response 
received\n")
                                 .process(new ReportResults()).to(JETTY_STRING)
                                    /*
                                     * Get Report Results
                                     */
                                    .choice()
                                      
.when().xpath("/reportingEngineResponse/baseResponse/responseCode = '100'
and /reportingEngineResponse/getResultsResponse/Results/statusCode = '3'")
                                          .log("Valid results response 
received\n")
                                          .process(new
ReportMetaData()).to(JETTY_STRING)
                                             /*
                                              * Get Report MetaData
                                              */
                                             .choice()
/                                       
.when().xpath("/reportingEngineResponse/baseResponse/responseCode       = 
'100'")
                                                   .log("Valid MetaData
received\n")
                                                  
.split(body().tokenizeXML("columnMetaData",
"getMetaDataResponse")).streaming().*process(new MetaDataResponseHandler())*
/                                               .otherwise()
                                                   .log("No Report MetaData
Received\n")
                                                   .process(new ErrorHandler())
                                             .endChoice() // End Get MetaData



--
View this message in context: 
http://camel.465427.n5.nabble.com/converting-xml-fragment-to-java-object-tp5780107.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to