	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.2

More efficient way to parse an XML doc in Java using XPath

Asked by Ben00Golden in XPath, J2EE, Extensible Markup Language (XML)

Tags: Java, XML, XPath

I've written a piece of code that works. It uses XPath to extract some values in a XML doc and return each value, however it seems to be a very inefficient way to do it as I have to create new StringReader and InputSource objects for each value I want to read. I have tried re-using the InputSource object for each read, but then I get an error when trying to read the second value: java.io.IOException: Stream closed.

Is there a more efficient way to do this?

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:

           
           
             package com.xxxxx.myapi;
 
import javax.servlet.http.HttpSession;
 
import javax.xml.xpath.*;
import java.net.*;
import java.io.*;
import org.xml.sax.*;
 
/* SAMPLE XML:
        <myapi>
                <ERROR_CODE>0</ERROR_CODE>
                <ERROR_MESSAGE>SUCCESS</ERROR_MESSAGE>
                <PAN_LENGTH>16</PAN_LENGTH>
                <ISSUE_NR_LENGTH>0</ISSUE_NR_LENGTH>
                <START_DATE>N</START_DATE>
                <SCHEME_LETTER>V</SCHEME_LETTER>
                <SCHEME_NAME>Visa</SCHEME_NAME>
                <PROCESSING_REQUIREMENT>0</PROCESSING_REQUIREMENT>
                <CRM_PAYMENT_TYPE>VISA</CRM_PAYMENT_TYPE>
                <CREDIT_OR_DEBIT>CREDIT</CREDIT_OR_DEBIT>
                <CONTINUITY>CONTINUOUS</CONTINUITY>
        </myapi>
*/
 
public class myapi extends CallOutAction {
 
        protected String xmpCallOutExecute(HttpSession session, Object[] args)
        throws Exception {       
 
                String sXMLResponse = "";
 
        /* -----------------------------------------------------------------
           CODE HERE TO CALL HTTP API THAT RETURNS AN XML DOC IN A String OBJECT
           SIMILAR TO THAT SHOWN IN THE EXAMPLE ABOVE, THIS IS STORED IN
           sXMLResponse
           ----------------------------------------------------------------- */
 
                // DECODE RESPONSE
                try {
                        
                        // CREATE NEW INSTANCES OF XPATH FACTORY OBJECT
                        XPathFactory factory = XPathFactory.newInstance();
                        XPath XPathObject = factory.newXPath();                 
 
                        // COLLECT DATA FROM XML RESPONSE
                        setResult(session, outResultCode, getXMLValue(sXMLResponse, XPathObject, "/myapi/ERROR_CODE")); 
                        setResult(session, outErrorMessage, getXMLValue(sXMLResponse, XPathObject, "/myapi/ERROR_MESSAGE")); 
                        setResult(session, outCardLength, getXMLValue(sXMLResponse, XPathObject, "/myapi/PAN_LENGTH")); 
                        setResult(session, outIssueNumberLength, getXMLValue(sXMLResponse, XPathObject, "/myapi/ISSUE_NR_LENGTH")); 
                        setResult(session, outRequireStartDate, getXMLValue(sXMLResponse, XPathObject, "/myapi/START_DATE")); 
                        setResult(session, outSchemeLetter, getXMLValue(sXMLResponse, XPathObject, "/myapi/SCHEME_LETTER")); 
                        setResult(session, outSchemeName, getXMLValue(sXMLResponse, XPathObject, "/myapi/SCHEME_NAME")); 
                        setResult(session, outCreditDebit, getXMLValue(sXMLResponse, XPathObject, "/myapi/CREDIT_OR_DEBIT")); 
                        setResult(session, outContinuity, getXMLValue(sXMLResponse, XPathObject, "/myapi/CONTINUITY")); 
 
                                                                        
                } catch (Exception e) {
                log.error("MYAPI IDENTIFY FAILED [PARSE XML RESPONSE ERROR]: " + e.getMessage(), session);
                        return fwdFail;             
                }
                
                return fwdSuccess;                  
        }
        
        private String getXMLValue(String sXMLResponse, XPath XPathObject, String sXPath)
        throws XPathExpressionException {
                
                // CREATE INPUT SOURCE
                StringReader sr = new StringReader(sXMLResponse);
                InputSource isXML = new InputSource(sr);
                
                // CREATE XPATH EXPRESSION
                XPathExpression xpeExpr = XPathObject.compile(sXPath);
                
                // RETURN RESULT
                return xpeExpr.evaluate(isXML);
                        
        }
}

           
         

20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20090701_SELECT_ZONES

Hall of Fame

1. Gertone109,225
2. abel28,922
3. zc222,900
4. BigRat14,628
5. Ray_Pas...9,250
6. Tiggerito8,450
7. sdstuber7,500
8. MogalManic5,100
9. Dabas5,000
10. TomLun4,400
11. tetorvik4,000
11. Christofer...4,000
11. GuitarRich4,000
14. kmartin73,500
15. TheLearn...3,000
15. acperkins3,000
17. numberkr...2,750
18. Zvonko2,500
18. RQuadling2,500
18. PaulHews2,500
18. 668662,500
18. TanLiHao2,500
23. hielo2,250
24. CEHJ2,225
25. JestersGrind2,000
25. jim_cakalic2,000
25. ryancys2,000
25. angus_y...2,000
25. jinal2,000
25. oobayly2,000
25. bugada2,000
25. mwvisa12,000
25. alain342,000
25. CraigYellick2,000
25. _agx_2,000
25. clayfox2,000
25. brejk2,000
25. cxr2,000
25. bishillo2,000
25. ajnt__2,000
25. sree_ven2,000
25. JeffHand2,000
25. moagrius2,000
25. wht19862,000
25. sundar622,000
25. mas_oz...2,000
25. mallcore2,000
25. WesWilson2,000

1. Gertone128,725
2. zc230,100
3. abel28,922
4. BigRat14,628
5. sdstuber14,000
6. TheLearn...10,000
7. Ray_Pas...9,250
8. Tiggerito8,450
9. Dabas7,000
10. hielo6,250
11. MogalManic5,100
12. TomLun4,400
13. CEHJ4,225
14. tetorvik4,000
14. Christofer...4,000
14. GuitarRich4,000
17. kmartin73,500
18. TimCottee3,375
19. mwvisa13,200
19. sm3943,200
21. acperkins3,000
21. quincydude3,000
23. numberkr...2,750
24. Zvonko2,500
24. RQuadling2,500
24. PaulHews2,500
24. 668662,500
24. TanLiHao2,500

More efficient way to parse an XML doc in Java using XPath

Asked by Ben00Golden in XPath, J2EE, Extensible Markup Language (XML)

Tags: Java, XML, XPath

About this solution