Currently, I am faced with the challenge of using Ajax to submit a query to an external database located at http://foreignserver:1234/database?query="SELECT FROM WHERE". The goal is to execute the query, generate an XML file, and have it returned to me. This external server is powered by Apache Tomcat. Despite researching cross-site scripting, I have encountered some roadblocks:
-Implementing CORS is not feasible as support for IE7 is required, and configuring it in Tomcat appears overly complex.
-Unfortunately, easyXDM is off the table as well.
-My preference is to work with XML, and JSONP seems to be associated with JSON rather than XML.
-Considering the substantial amount of data expected back, iFrames do not seem like a viable solution.
What steps should be taken next?