SSDN - Using same xquery for 2 xml files

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Website Feedback (249)
	XSLT Help and Discussion (7625)
	XQuery Help and Discussion (2017)
	Issue with Processing Instruct... (2)
	problem converting json to XML... (2)
	Problem base64 decoding string... (3)
	Problems posting multipart for... (5)
	trouble with download of price... (2)
	Problem with http-post not bei... (3)
	path problem, xps_file:writeAl... (9)
	Xquery update support? (2)
	problem with Stylus studio try... (5)
	adding dtd reference to xml ou... (4)
	xquery escaping ambarsand when... (3)
	Whitespace problem when return... (5)
	Problem with namespace prefix ... (5)
	Sending via SFTP returns unexp... (1)
	Query and Sftp clent (4)
	xquery and try - catch (3)
	Query + ddtek:http-post optio... (5)
	Example files referenced in do... (3)
	Automatic Error Detection and ... (3)
	Working with result of ddtek:h... (2)
	[1-20] [21-40] [41-60] Next
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

rajat nair

Subject: Using same xquery for 2 xml files
Author: rajat nair
Date: 30 Jan 2008 04:55 PM
Originally Posted: 30 Jan 2008 04:54 PM

Hi,
I have 2 xml files,both in oag format and with non overlapping tags.I wanted to use a single xquery file and do something like this,

<PurchaseOrderLine>
<LineNumber>
{doc('file:///c:/Tp_request.xml')/TradePowerRequest/RequestDetail/ItemLineNumber/text()}
</LineNumber>
{
for $RequestDetail in doc('file:///c:/Tp_request.xml')/TradePowerRequest/RequestDetail
return
<items>
{
if( $RequestDetail/ItemNumber/@source = "UI" ) then
<item1>

{doc('file:///c:/AwailResponse.xml')/DetailAvailability/DisplaySequence/text()}

</item1>

else
()
}
</items>
}
</PurchaseOrderLine>
Is this possible to run the same xquery for 2 different xmls and produce a merged new xml?.

Rajat

Minollo I.

Subject: Using same xquery for 2 xml files
Author: Minollo I.
Date: 31 Jan 2008 09:04 AM

Absolutely, it is possible. Your XQuery looks syntactically fine at a first glance; are you having specific problems?

rajat nair

Subject: Using same xquery for 2 xml files
Author: rajat nair
Date: 31 Jan 2008 12:29 PM
Originally Posted: 31 Jan 2008 10:02 AM

Hi,
Thanks for the prompt reply,i m using java code that was generated from stylus studio enterprise edition from this xquery.The probelm is how do i pass/bind 2 incoming xml's to the XqPreparedExpression variable.I have attached my java code along with this post.Is is possible to pass more than 2 incoming xmls to get a single outgoing xml too??

public class tradetest3docs {
static String theDocumentBytes;
static String td;
static String t1d;
//private static Logger logger = Logger.getLogger(Quadesptest.class);
public static final String OAG_NAMESPACE_URI = "http://www.openapplications.org/oagis/9";
public static final Namespace OAG_NAMESPACE = Namespace.getNamespace("oag", OAG_NAMESPACE_URI);
public static final String ESB_BODY_XPATH_EXP = "/esb:Envelope/esb:Body";

public static void main(String[] args) throws Exception {

String xqueryUri = "file:///c:/Tp3.xquery";
Reader xqueryReader = null;
XQConnection xqconnection = null;
XQPreparedExpression xqExpr = null;

try {

System.out.println();
System.out.println("XQuery starting.");

xqueryReader = new FileReader(new File(new URI(xqueryUri)));
File fxml = new File("C:\\Tp_request.xml");
File f2xml = new File("C:\\AwailResponse.xml");

Configuration config = getConfiguration();
XQDataSource dataSource = new SaxonXQDataSource(config);
xqconnection = dataSource.getConnection();

XQStaticContext context = xqconnection.getStaticContext();
context.setBindingMode(XQConstants.BINDING_MODE_DEFERRED);
context.setBaseURI(xqueryUri);
xqconnection.setStaticContext(context);
XMLOutputter out = new XMLOutputter(org.jdom.output.Format
.getPrettyFormat());
SAXBuilder builder = new SAXBuilder(false);
org.jdom.Document doc = builder.build(new FileReader(fxml));
org.jdom.Document doc1 = builder.build(new FileReader(f2xml));

theDocumentBytes = out.outputString(doc);

System.out.println("substring"+theDocumentBytes);

xqExpr = xqconnection.prepareExpression(xqueryReader);
xqExpr.bindDocument(XQConstants.CONTEXT_ITEM, theDocumentBytes,xqconnection.createDocumentType());

Properties prop = new Properties();

String str = xqExpr.executeQuery().getSequenceAsString(prop).toString();

td = out.outputString(ProcessDocument(str));
System.out.println("The String document is :" +td );
System.out.println("XQuery finished.");
} finally {
if (xqueryReader != null) xqueryReader.close();
if (xqExpr != null) xqExpr.close();
if (xqconnection != null) xqconnection.close();
}
}

private static Configuration getConfiguration() {

Configuration config = new Configuration();
config.getSystemURIResolver().setRecognizeQueryParameters(true);
config.setValidation(false);
config.setStripsWhiteSpace(Whitespace.IGNORABLE);
return config;
}
public static org.jdom.Document ProcessDocument(String s) throws Exception{
SAXBuilder builder1 = new SAXBuilder(false);
org.jdom.Document document = builder1.build(new StringReader(s));
return document;
}
private static void setNamespace(Element elem, Namespace namespc){
List content = elem.getChildren();
Iterator iterator = content.iterator();

while (iterator.hasNext()) {
Element currElem = (Element)iterator.next();
currElem.addNamespaceDeclaration(namespc);
currElem.setNamespace(namespc);
// logger.debug("Element Name: "+ currElem.getName());
setNamespace(currElem, namespc);

}
}}

Regards
Rajat

Minollo I.

Subject: Using same xquery for 2 xml files
Author: Minollo I.
Date: 31 Jan 2008 12:00 PM

You will need to use one or two external variables if you want to bind data from your Java application.

I find it more clear in this case to just use two external variables and not the static default input; so, I would change the query into:

declare variable $input1 as document-node(element(*, xs:untyped)) external;
declare variable $input2 as document-node(element(*, xs:untyped)) external;

<PurchaseOrderLine>
<LineNumber>
{ $input1/TradePowerRequest/RequestDetail/ItemLineNumber/text() }
</LineNumber>
{
for $RequestDetail in $input1/TradePowerRequest/RequestDetail
return
<items>
{
if($RequestDetail/ItemNumber/@source = "UI") then
<item1>
{ $input2/DetailAvailability/DisplaySequence/text() }
</item1>
else ()
}
</items>
}
</PurchaseOrderLine>

...and the Java code into... (btw, note that you don't need to use jdom at all; it's actually a much more performing and scalable solution not using it)

import com.ddtek.xquery3.*;
import com.ddtek.xquery3.xqj.DDXQDataSource;
import com.ddtek.xquery3.xqj.DDXQJDBCConnection;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.OutputStreamWriter;
import java.io.Reader;
import java.io.Writer;
import java.net.URI;
import javax.xml.namespace.QName;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.stream.StreamSource;

public class test {

public static void main(String[] args) throws Exception {

Writer outWriter = null;
String xqueryUri = "file:///c:/Tp3.xquery";
Reader xqueryReader = null;
XQConnection xqconnection = null;
XQPreparedExpression xqExpr = null;

try {

System.out.println();
System.out.println("XQuery starting.");

xqueryReader = new FileReader(new File(new URI(xqueryUri)));

DDXQDataSource dataSource = new DDXQDataSource();
dataSource.setOptions("serialize=indent=yes");
dataSource.setBaseUri(xqueryUri);
xqconnection = dataSource.getConnection();

// default input data type - this declares that the default context node is a document.
XQItemType type = xqconnection.createElementType(null, XQItemType.XQBASETYPE_UNTYPED);
XQItemType documentType = xqconnection.createDocumentElementType(type);
XQStaticContext context = xqconnection.getStaticContext();
context.setContextItemStaticType(documentType);
context.setBindingMode(XQConstants.BINDING_MODE_DEFERRED);
xqconnection.setStaticContext(context);

outWriter = new OutputStreamWriter(System.out);

xqExpr = xqconnection.prepareExpression(xqueryReader);

xqExpr.bindDocument(new QName("input1"), new StreamSource(new File("C:\\Tp_request.xml")));
xqExpr.bindDocument(new QName("input2"), new StreamSource(new File("C:\\AwailResponse.xml")));
xqExpr.executeQuery().writeSequenceToResult(new StreamResult(outWriter));

outWriter.flush();
System.out.println();
System.out.println("XQuery finished.");
} finally {
if (outWriter!=null) outWriter.flush();
if (xqueryReader != null) xqueryReader.close();
if (xqExpr != null) xqExpr.close();
if (xqconnection != null) xqconnection.close();
}
}
}

I'm also attaching the code for your convenience.

Tp3.xquery
Modified XQuery

test(1).java
The Java file

rajat nair

Subject: Using same xquery for 2 xml files
Author: rajat nair
Date: 31 Jan 2008 01:33 PM

that works !!! ty for the prompt reply

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.