BaseX-Talk December 2010

basex-talk@mailman.uni-konstanz.de

25 participants
40 discussions

Problems with XQuery matching records by compound key
by Jan Vlčinský (CAD) 25 Dec '10

25 Dec '10

Hi I am trying to match records from two different documents. Match key consists of two parts, so I simply build up a string from first and second match key and separate it by a hypen Here are source documents *Events.xml* <EVENTS>** * *<MSG id=*"{e8e85fdd-04d8-43ea-8090-e72337c3a30d}"* location=*"Prague"* event=*"Christmass"*/>** * *<MSG id=*"{7c94b2fc-b97c-4c09-b694-9993bfb2b93c}"* location=* "Bratislava"* event=*"Easterns"*/>** * *<MSG id=*"{bdbb11da-2c92-425d-9bf5-87c1e96e1bd4}"* location=*"Berlin"* event=*"Berlinale"*/>** </EVENTS>** * * *Reports.xml* <REPORTS>** * *<MSG id=*"{abcd}"* location=*"Prague"* event=*"Christmass"*/>** * *<MSG id=*"{efgh}"* location=*"Bratislava"* event=*"Easterns"*/>** * *<MSG id=*"{ijkl}"* location=*"Paris"* event=*"FassionFest"*/>** * *<MSG id=*"{mnqr}"* location=*"Moscow"* event=*"BalletFestival"*/>** </REPORTS> I am trying to find for each report all events, which are having the same location and event attributes So I build intermediate variables, containing pre-calculated keys And finally I try to find related events *match.xq* (:* *Construct* *matching* *keys* **for** *events* *:)** *let** **$event-msg-keys** *:=* * * *(*for** **$event** **in** */EVENTS/MSG** * **return** * * *<EVENT-MSG id="{$event/@id}" key="{concat($event/@location, '-', $event/@event)}"/>** * *)** * * (:* *Construct* *matching* *keys* **for** *reports* *:)** * * *let** **$report-msg-keys** *:=* * * *(*for** **$report** **in** */REPORTS/MSG* * * **return** * * *<REPORT-MSG id="{$report/@id}" key="{concat($report/@location, '-', $report/@event)}"/>** * *)** * * (:* *Find* *all* *events,* *related* **to** *each* *report:)** *for** **$report-msg** **in** **$report-msg-keys*** *let** **$report-msg-id** *:=* **$report-msg*/@id** *let** **$report-msg-key** *:=* **$report-msg*/@key** * * *let** **$related-events** *:=* * * *(*for** **$event-msg** **in** **$event-msg-keys*** * **where** **$event-msg*/@key* *=* **$report-msg-key*** * **return** **$event-msg*)** * * *return*** <REPORT-MSG id="{$report-msg-id}" key="{$report-msg-key}">** * *<RELATED-EVENTS>{$related-events}</RELATED-EVENTS></REPORT-MSG> However, resulting dokument does not show any related events <REPORT-MSG id=*"{abcd}"* key=*"Prague-Christmass"*>** * *<RELATED-EVENTS/>** </REPORT-MSG>** <REPORT-MSG id=*"{efgh}"* key=*"Bratislava-Easterns"*>** * *<RELATED-EVENTS/>** </REPORT-MSG>** <REPORT-MSG id=*"{ijkl}"* key=*"Paris-FassionFest"*>** * *<RELATED-EVENTS/>** </REPORT-MSG>** <REPORT-MSG id=*"{mnqr}"* key=*"Moscow-BalletFestival"*>** * *<RELATED-EVENTS/>** </REPORT-MSG> *Versions of BaseX* All the time I worked with GUI 1. I started testing on BaseX 6.3.4 2. I used a bit more complex data and query 3. After failing I tried on 6.3.1 4. There I was unable to open the collection with complains about Index out of bound Java error 5. Then I dropped the database and created it again. Trying to run the XQuery I got the same error. 6. returned back to 6.3.4 7. rewrote it to shorted sample, shown above I wonder, what I am doing wrong. Any advice? With best regards Jan Vlčinský

4 4

Use with Google App Engine
by Min Idzelis 20 Dec '10

20 Dec '10

I realize that BaseX can't be used as-is on the Google App Engine. The question I have is how much work would it be to get it up and running on the App Engine's datastore API instead of whatever you are using for indexing/storage. There is no access to a filesystem. The datastore does have a concept of hierarchical (parent-child) entities. In the datastore, the only operations that are supported are: get/put by key, inequality (<, >, =) filters, and a way to limit results that have a common ancestor (key). Would this be enough to support BaseX? Thanks, Min

4 8

(no subject)
by stefan coremans 19 Dec '10

19 Dec '10

The java binding explained under http://www.inf.uni-konstanz.de/dbis/basex/xqjb is working but i can't get it to work with a simple test class. where can i find some sample code ?

3 4

Responses in XML, uisng REST
by Mahender Didwania 17 Dec '10

17 Dec '10

Hi, BaseX returns XML for URLs like http://localhost:8984/basex/jax-rx/; however, database creation commands or collection creation commands result in text/plain content-type and plain-text being returned in response. Perhaps it will be useful, in pure XML processing apps, for these responses to also be in XML. Something like, <jax-rx:results xmlns:jax-rx="http://jax-rx.sourceforge.net"> <jax-rx:response status="201">Database 'Test' created in 38.22 ms.</jax-rx:response> </jax-rx:results> Regards, Mahender.

2 1

Hierarchical collections via REST
by Mahender Didwania 16 Dec '10

16 Dec '10

Hi, The changelog for 6.3.1 says: [ADD] REST: support for hierarchical collections added; details will follow I am using 6.3.4, but if I send a post request to /server/collection/subcollection, only the collection gets created (and the document is added to collection, not to subcollection). In view of the above, could you please throw more light on how the subcollections can be created using REST and how documents can be added to subcollections using REST? Thanks, Mahender

3 3

Re: [basex-talk] Hierarchical collections via REST
by Mahender Didwania 16 Dec '10

16 Dec '10

Hi, sscce below: Sequence1: Action: curl -i -X PUT "http://localhost:8984/basex/jax-rx/abcde" curl -i -X POST -H "Content-Type: text/xml" -d "<HelloWorld/>" "http://localhost:8984/basex/jax-rx/abcde/subA/docA" Expectation: Creation of docA in subcollection subA under collection abcde Actual: Creation of document named subAdocA in collection abcde Sequence2: Action: curl -i -X POST -H "Content-Type: text/xml" -d "<HelloWorld/>" "http://localhost:8984/basex/jax-rx/abcde/subA/docA" Expectation: Two documents with the same name in the same collection (at same hierarchy level) should be disallowed. Actual: Two documents with the same name in the same collection (at same hierarchy level) are allowed. I do not know how things will work later when xquery operations will be invoked using document name (i.e., which one will be fetched out of the two documents, since both have the same name). curl -i -X POST -H 'Content-Type: application/query+xml' -d '<query xmlns="http://jax-rx.sourceforge.net"><text>for $doc in collection("abcde") return base-uri($doc)</text></query>' 'localhost:8984/basex/jax-rx/' HTTP/1.1 200 OK Content-Type: text/xml Content-Length: 246 Server: Jetty(6.1.26) <jax-rx:results xmlns:jax-rx="http://jax-rx.sourceforge.net"><jax-rx:result>file:(somePath)/subAdocA</jax-rx:result><jax-rx:result>file:(somePath)/subAdocA</jax-rx:result></jax-rx:results> A delete using document name deletes all documents with the same name at the same hierarchy level: curl -i -X DELETE "http://localhost:8984/basex/jax-rx/abcde/subAdocA" HTTP/1.1 200 OK Content-Type: text/plain Transfer-Encoding: chunked Server: Jetty(6.1.26) 2 document(s) deleted in 1.2 ms. Regards, Mahender ----- Original Message ----- From: "Christian Grün" <christian.gruen(a)gmail.com> To: "Mahender Didwania" <mahender(a)didwania.co.uk> Cc: "basex-talk" <basex-talk(a)mailman.uni-konstanz.de> Sent: Wednesday, December 15, 2010 4:26:41 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [basex-talk] Hierarchical collections via REST > I am using 6.3.4, but if I send a post request to /server/collection/subcollection, only the collection gets created (and the document is added to collection, not to subcollection). Could you provide us with an sscce that allow us to reproduce the issue? > In view of the above, could you please throw more light on how the subcollections can be created using REST and how documents can be added to subcollections using REST? The documentation will be updated with the upcoming official release. Best, Christian

1 0

Limit of 32 attributes per element
by Peter Fischer 15 Dec '10

15 Dec '10

Dear all, when testing BaseX with the TPoX benchmark workload (http://tpox.sourceforge.net/) I could not load the input data set since it contains elements with more than 32 attributes. The large number of attributes stems from the FIXML data (http://www.fixprotocol.org/specifications/fix4.4fixml) contained in the workload, so it is not just a stress test by the benchmark designers. Is there any way to lift this limitation? Best Regards, Peter -- Dr. Peter Fischer Systems Group/D-INFK/ETH Zurich peter.fischer(a)inf.ethz.ch Tel: +41/44/632 36 16 http://www.systems.ethz.ch/people/petfisch Universitätstr 6, CAB E75

3 4

Database credentials not enforced over REST?
by Mahender Didwania 15 Dec '10

15 Dec '10

Hi, If I contact a BaseX instance over REST, I can drop databases/collections without passing credentials in basic auth header, using command= query param (is there any other mechanism for auth over REST supported by BaseX?). Tried this on a collection newly created using REST...do we have to 'add' credentials to DB/collection after creating it? If yes, how? Regards, Mahender

2 1

Re: [basex-talk] Installing Basex with Ubuntu
by Alexander Holupirek 14 Dec '10

14 Dec '10

Glad it works! Have fun using BaseX and please report any problems you encounter. On 14.12.2010, at 19:53, Erik Lomas wrote: > Hi Alexander, > > Never mind. I found the workaround from reading a bit more. Because Ubuntu > doesn't recognize your software as a trusted source, I needed to manually > change file permissions after downloading to allow execution. > > -----Original Message----- > From: Alexander Holupirek [mailto:alexander.holupirek@uni-konstanz.de] > Sent: Tuesday, December 14, 2010 9:54 AM > To: elomas(a)wi.rr.com > Cc: BaseX Talk > Subject: Re: [basex-talk] Installing Basex with Ubuntu > > On 14.12.2010, at 16:49, elomas(a)wi.rr.com wrote: > >> I'm having troubles installing basex.jar with Ubuntu 10.04 LTS and OpenJDK > Java 6 Runtime. I'm getting message that "It's not marked as executable" > and not from a trusted source. Can anyone help with this? I'm still fairly > new to Linux. > > Can you please provide some more details? What did you do that led to those > messages?

1 0

Installing Basex with Ubuntu
by elomas＠wi.rr.com 14 Dec '10

14 Dec '10

I'm having troubles installing basex.jar with Ubuntu 10.04 LTS and OpenJDK Java 6 Runtime. I'm getting message that "It's not marked as executable" and not from a trusted source. Can anyone help with this? I'm still fairly new to Linux.

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk December 2010