Re: Problem to Xquery a document from xindice collection

johan bos Tue, 16 Aug 2005 05:18:51 -0700

Thanks, I know my problem is the query format
Can anyone drive me to a good tutorial of XPATH query


here the different query I tried:

System.out.println("ADDING MESSAGE FROM PATH & NAME");

MessageDB.addDocument(mailDirectory +"dariusjbosSatAug13235020BST2005.xml");

//DOESN'T WORK (But it s fine, I suppose KEY ID is better as the result fromany query is the KEY.

System.out.println("RETRIEVE MESSAGE FROM NAME");
MessageDB.retrieveDocument("dariusjbosSatAug13235020BST2005.xml");

//WORKS BECAUSE it exists
System.out.println("RETRIEVE MESSAGE FROM KEY");
MessageDB.retrieveDocument("0601a7c0664aa59900000105bf073edf");

// WORKS TOO, OUTPUT is a list of KEY Document
System.out.println("COUNT MESSAGE FROM DB/MAIL");
MessageDB.queryCollection("count(//Message)");

//WORKS, OUTPUT is a list of KEY Document where dariusjbos appears
System.out.println("QUERY MESSAGE WITH DARIUSJBOS AS FROM");
MessageDB.queryCollection("/from/Address/name='dariusjbos'");

//DOESN'T Return ANything but at least no error from the query format
System.out.println("QUERY MESSAGE WITH CONTENT TYPE TEXT");
MessageDB.queryCollection("/[EMAIL PROTECTED]'text/plain']");

//DOESN'T Return ANything but at least no error from the query format
System.out.println("QUERY MESSAGE WITH [EMAIL PROTECTED] AS FROM");
MessageDB.queryCollection("/from/Address[adrs='mailto:[EMAIL 
PROTECTED]']/text()");

//DOESN'T WORK and ERROR for the query
System.out.println("QUERY STRING MESSAGE WITH CONTENT TYPE TEXT");
MessageDB.queryCollection("string(/[EMAIL PROTECTED]'text/plain']");

//DOESN'T Return ANything but at least no error from the query format
System.out.println("QUERY MESSAGE WITH DARIUSJBOS AS FROM v2");
MessageDB.queryCollection("/from/Address/name[. ='dariusjbos']");

So, for summary, can anyone as a good tuto reference website for xpath query

because i tried some, and most of the example doesn't fit (like the one with[. =dariusjbos])

What I want, is query adrs and the date from my xml, I suppose it willreturn a list of Key Document from Xindice DB and I have to manage fromthese Key to retrieve the full document


Is there any way to only retrieve part of the XML queried?

It s a mail application so from all the mail stored in Xindice, I want tocreate some sort of listing of message


Thanks in advance

<BLOCKQUOTE style='PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #A0C6E52px solid; MARGIN-RIGHT: 0px'><fontstyle='FONT-SIZE:11px;FONT-FAMILY:tahoma,sans-serif'><hr color=#A0C6E5size=1>From: "Lisa McCabe"<[EMAIL PROTECTED]> Reply-To:xindice-users@xml.apache.org To:<xindice-users@xml.apache.org> Subject: Re: Problem toXquery a document from xindice collection Date: Mon, 15 Aug 200520:56:51 -0400 MIME-Version: 1.0 Received: frommail.apache.org ([209.237.227.199]) by MC8-F24.hotmail.com with MicrosoftSMTPSVC(6.0.3790.211); Mon, 15 Aug 2005 17:57:11 -0700 Received:(qmail 60799 invoked by uid 500); 16 Aug 2005 00:57:10-0000 Received: (qmail 60786 invoked by uid 99); 16 Aug 200500:57:10 -0000 Received: from asf.osuosl.org (HELOasf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP;Mon, 15 Aug 2005 17:57:10 -0700 Received: pass (asf.osuosl.org:local policy) Received: from [24.248.88.131] (HELOmail.myeastern.com) (24.248.88.131) by apache.org (qpsmtpd/0.29) with ESMTP;Mon, 15 Aug 2005 17:57:29 -0700 Received: from MegaCool(unverified [66.212.211.142]) by myeastern-dot-com (MyEastern Mail -www.myeastern.com) with ESMTP id 24666502 for<xindice-users@xml.apache.org>; Mon, 15 Aug 2005 20:57:01-0400 Hi, Did you try the same query using the commandlineXindice to see if your xpath query works? That helps me in firguring outmy problems. I am doing the same type of stuff and compared our code -yours is the same as mine so it should work. -LisaMcCabe PS Good luck meeting your deadline! ----- OriginalMessage ----- From: "johan bos"<[EMAIL PROTECTED]> To:<xindice-users@xml.apache.org> Sent: Monday, August 15, 2005 1:57PM Subject: Problem to Xquery a document from xindicecollection > > Hello Everyone, > > Heremy problem, > I can connect and create a collection (mail) inxindice 1.1 (from > within my > servlet (tomcat 5)) > Ican add document to this collection (the ugly browser let me see them) > > but when i try to make a query using the example function forquering > xindice, i got an error such as below: (some of the messageare from my > debug) > > > trying to registerdatabase > Database xmldb:xindice://localhost:8080/db isconnected > Collection xmldb:xindice://localhost:8080/db isconnected > Collection mail already created >org.xmldb.api.base.XMLDBException: org.apache.xmlrpc.XmlRpcException: > Error > Compiling XPath Expression: Une étape d'emplacementétait attendue après > le > jeton ''/'' ou ''//''. >at > org.apache.xindice.client.xmldb.xmlrpc.CollectionImpl.runRemoteCommand(Colle ctionImpl.java:119) > at > org.apache.xindice.client.xmldb.xmlrpc.CollectionImpl.query(CollectionImpl.j ava:515) > at > org.apache.xindice.client.xmldb.XindiceCollection.query(XindiceCollection.ja va:259) > at > org.apache.xindice.client.xmldb.services.QueryService.query(QueryService.jav a:90) > at jmms.MessageDB.queryCollection(MessageDB.java:163) > atjmms.JMMSServlet.doMessageToDB(JMMSServlet.java:1009) > atjmms.JMMSServlet.doPost(JMMSServlet.java:342) > atjavax.servlet.http.HttpServlet.service(HttpServlet.java:709) > atjavax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at >org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:744) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav a:527) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo rkerThread.java:80) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) > at java.lang.Thread.run(Unknown Source) > Query/mail/Message/from/Address/[name='dariusjbos'] return an error >XML:DB Exception occured 1 org.apache.xmlrpc.XmlRpcException: Error >Compiling XPath Expression: Une étape d'emplacement était attendue après > le > jeton ''/'' ou ''//''. > > the xml document itry to query look like this: > <?xml version="1.0"encoding="UTF-8"?> > <Messagexmlns="URN:ietf:params:email-xml:" >rfc822="URN:ietf:params:rfc822:"> > <date>MonAug 15 19:03:47 CEST 2005</date> > <from> ><Address> ><adrs>mailto:[EMAIL PROTECTED]</adrs> ><name>dariusjbos</name> > </Address> > </from> > </Message> > > findafter the function i use to query the mail collection under db: > > public static void queryCollection()throws Exception { >Collection col = null; > try { > Stringdriver = >"org.apache.xindice.client.xmldb.DatabaseImpl"; >Class c = Class.forName(driver); > > Databasedatabase = (Database) c.newInstance(); >DatabaseManager.registerDatabase(database); > > col= >DatabaseManager.getCollection("xmldb:xindice://localhost:8080/db/mail"); > > String xpath ="//Message/from/Address/[name='dariusjbos']"; >XPathQueryService service = > (XPathQueryService)col.getService("XPathQueryService", > "1.0"); > ResourceSet resultSet = service.query(xpath); >ResourceIterator results = resultSet.getIterator(); >while (results.hasMoreResources()) { > Resource res =results.nextResource(); > System.out.println((String)res.getContent()); > } > } >catch (XMLDBException e) { >System.err.println("XML:DB Exception occurred " + e.errorCode > + > "" + e.getMessage()); > } >finally { > if (col != null) { >col.close(); > } > } > } > > please I really need to pass this problem (deadline in 3days) > > thanks in advance > > </BLOCKQUOTE>

Re: Problem to Xquery a document from xindice collection

Reply via email to