Hi,

I setRetainLineNumbers("true") on SaxonXQDataSource.
But I am not able to understand how should I escape from xqj and call getSaxonItem() on XdmItem(). Is it done on XQResultSequence.Please explain with code.

I also want to ask, if I have to query multiple xml files in a folder , can it be done through s9API and how.

Thanks 
Sweta




------------------------------

Message: 4
Date: Tue, 20 Oct 2009 09:30:46 +0530
From: Sweta Kedia <swetakedia@gmail.com>
Subject: [saxon] How can i get line numbers for each result returned
       in      XQuery.
To: saxon-help@lists.sourceforge.net
Message-ID:
       <5cd259e50910192100i412b8578gb5db547785bf13d3@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I am trying to use net.saxon.xqj package for Xquery. I am using the result
Sequence to get Item as Stream  and then get its location. But I am getting
-1 everytime. Please help, should i use s9Api    or i can get line number
through Xqj also.


   public void runQuery() {

       try {
           SaxonXQConnection con = (SaxonXQConnection)
xqueryConnection.getConnection();
           con.getStaticContext().declareNamespace("xbrli", "
http://www.xbrl.org/2003/instance");
           con.getStaticContext().declareNamespace("bvf", "
http://www.biovail.com/2008-12-31");
           con.getStaticContext().declareNamespace("xsi", "
http://www.w3.org/2001/XMLSchema-instance");
           con.getStaticContext().declareNamespace("xlink", "
http://www.w3.org/1999/xlink");
           con.getStaticContext().setDefaultElementTypeNamespace("
http://www.xbrl.org/2003/linkbase");
           con.getStaticContext().setDefaultElementTypeNamespace("
http://www.w3.org/2001/XMLSchema");

           String queryFile="for $s in
fn:doc(\"C:/Users/A/Documents/Sweta/users/sweta231119791251796126671/Other/2008/Quarterly/2nd
Quarterly/bvf-20081231/bvf-20081231.xml\")" +
           "//bvf:StockholdersEquityBeforeComprehensiveIncomeNetOfTax, "+
            " $c in
fn:doc(\"C:/Users/A/Documents/Sweta/users/sweta231119791251796126671/Other/2008/Quarterly/2nd
Quarterly/bvf-20081231/bvf-20081231.xsd\")" +
            "//element[@name=local-name($s)]  "+
           " return($s, data($c/@name))";
           SaxonXQPreparedExpression expr = (SaxonXQPreparedExpression)
con.prepareExpression(queryFile);

           SaxonXQForwardSequence rs = (SaxonXQForwardSequence)
expr.executeQuery();

           while (rs.next()) {
               SaxonXQItem item = (SaxonXQItem) rs.getItem();
               Location local = item.getItemAsStream().getLocation();
               System.out.println(item.getItemAsString(null).toString() + "
at Line: " + local.getLineNumber());
           }


           / rs.close();
           con.close();
       }
       catch (javax.xml.xquery.XQException xq) {
           xq.printStackTrace();
           System.out.println(xq.getStackTrace().toString());
       }
       catch (Exception ex) {
           ex.printStackTrace();
       }
   }


}
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 5
Date: Tue, 20 Oct 2009 09:21:07 +0100
From: "Michael Kay" <mike@saxonica.com>
Subject: Re: [saxon] How can i get line numbers for each result
       returned        inXQuery.
To: "'Mailing list for the SAXON XSLT and XQuery processor'"
       <saxon-help@lists.sourceforge.net>
Message-ID: <FDA3E4877AC44CF2AD6036481C574455@Sealion>
Content-Type: text/plain; charset="us-ascii"

First you need to ensure that line numbers are maintained when Saxon builds
document trees using the doc() function. You can do this by calling
setRetainLineNumbers() on the SaxonXQDataSource object.

In your result, your query is returning alternate nodes and atomic values.
To get the line number of a node, you have to escape from XQJ into Saxon
interfaces: call getSaxonItem() on the XdmItem(), and if it is a node, the
result will be an instance of net.sf.saxon.om.NodeInfo, which has a
getLineNumber() method.

Generally, unless you want the portability benefits that come from using XQJ
(that is, you want to write applications that work with multiple XQuery
engines), I would recommend writing Saxon applications using the s9api
interface. It provides access to more of Saxon's capabilities, and is a
better fit to Saxon's architecture. However, I've tried to provide "escape
hatches" so that you can escape from XQJ interfaces into lower level Saxon
interfaces when necessary.

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay


 _____

From: Sweta Kedia [mailto:swetakedia@gmail.com]
Sent: 20 October 2009 05:01
To: saxon-help@lists.sourceforge.net
Subject: [saxon] How can i get line numbers for each result returned
inXQuery.


Hi,

I am trying to use net.saxon.xqj package for Xquery. I am using the result
Sequence to get Item as Stream  and then get its location. But I am getting
-1 everytime. Please help, should i use s9Api    or i can get line number
through Xqj also.


   public void runQuery() {

       try {
           SaxonXQConnection con = (SaxonXQConnection)
xqueryConnection.getConnection();
           con.getStaticContext().declareNamespace("xbrli",
"http://www.xbrl.org/2003/instance");
           con.getStaticContext().declareNamespace("bvf",
"http://www.biovail.com/2008-12-31");
           con.getStaticContext().declareNamespace("xsi",
"http://www.w3.org/2001/XMLSchema-instance");
           con.getStaticContext().declareNamespace("xlink",
"http://www.w3.org/1999/xlink");

con.getStaticContext().setDefaultElementTypeNamespace("http://www.xbrl.org/2
003/linkbase
");

con.getStaticContext().setDefaultElementTypeNamespace("http://www.w3.org/200
1/XMLSchema
");

           String queryFile="for $s in
fn:doc(\"C:/Users/A/Documents/Sweta/users/sweta231119791251796126671/Other/2
008/Quarterly/2nd Quarterly/bvf-20081231/bvf-20081231.xml\")" +
           "//bvf:StockholdersEquityBeforeComprehensiveIncomeNetOfTax, "+
            " $c in
fn:doc(\"C:/Users/A/Documents/Sweta/users/sweta231119791251796126671/Other/2
008/Quarterly/2nd Quarterly/bvf-20081231/bvf-20081231.xsd\")" +
            "//element[@name=local-name($s)]  "+
           " return($s, data($c/@name))";
           SaxonXQPreparedExpression expr = (SaxonXQPreparedExpression)
con.prepareExpression(queryFile);

           SaxonXQForwardSequence rs = (SaxonXQForwardSequence)
expr.executeQuery();

           while (rs.next()) {
               SaxonXQItem item = (SaxonXQItem) rs.getItem();
               Location local = item.getItemAsStream().getLocation();
               System.out.println(item.getItemAsString(null).toString() + "
at Line: " + local.getLineNumber());
           }


           / rs.close();
           con.close();
       }
       catch (javax.xml.xquery.XQException xq) {
           xq.printStackTrace();
           System.out.println(xq.getStackTrace().toString());
       }
       catch (Exception ex) {
           ex.printStackTrace();
       }
   }


}



-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference

------------------------------

_______________________________________________
saxon-help mailing list
saxon-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/saxon-help
The saxon-help list is archived at http://saxon.markmail.org/

End of saxon-help Digest, Vol 41, Issue 23
******************************************