July 2017 - BaseX-Talk - mailman.uni-konstanz.de

JSON to map
by Florian Wagner 19 Jul '17

19 Jul '17

Hey there, I'm probably missing something but please bear with my as I'm new to XML databases and XQuery. So what I've done is put JSON documents into BaseX using the REST interface and PUT requests. Now I want to use them in a RESTXQ handler. Loading the document using "db:open" will return me a document-node() but I'd like a map instead for simpler use and automatic types (I'll be outputing JSON again). The only thing I could come up with and that works is using "Content-Type: application/json;format=basic" when uploading and then: parse-json(xml-to-json(db:open(...))) But that seems very complicated and wasteful. Is there no other way? Regards Florian Wagner --- Universitaetsbibliothek Tuebingen Wilhelmstr. 32, 72074 Tuebingen IT-Abteilung, Raum B109 +49(0)7071/29-77860 http://www.ub.uni-tuebingen.de

2 1

Local permissions / REST / write permission needed
by Florian Wagner 19 Jul '17

19 Jul '17

Hi everyone! Trying out BaseX I'm having problems getting a very simple setup to work correctly. > list Name Resources Size Input Path ------------------------------------- test 2 33470 ~webdav 1 6004 2 database(s). > show users Username Permission -------------------- admin admin test none 2 user(s). > show users on test Username Permission -------------------- test write 1 user(s). $ curl -u test -i -X PUT -T file.xml http://host:8080/basex/rest/test/file.xml Enter host password for user 'test': HTTP/1.1 100 Continue HTTP/1.1 400 Bad Request Content-Type: text/plain;charset=utf-8 Content-Length: 24 Server: Jetty(9.3.9.v20160517) write permission needed. Using the "admin" user instead, works! Giving the test user global writer permissions makes it also work... So what am I doing wrong here? Regards Florian Wagner --- Universitaetsbibliothek Tuebingen Wilhelmstr. 32, 72074 Tuebingen IT-Abteilung, Raum B109 +49(0)7071/29-77860 http://www.ub.uni-tuebingen.de

2 4

Embedded BaseX
by George Sofianos 14 Jul '17

14 Jul '17

Hello, I'm building a web service that along with some other things (XML Validation, Saxon XQuery, etc) includes a BaseX processor for running XQuery scripts. I'm wondering what is the best way to use an embedded BaseX processor. Can some objects be shared (e.g Context, QueryProcessor), or are they very lightweight and there is no need to share / reuse ? Can I get the number of the jobs running and the job status like in the client / server mode? My intention is to make sure I can limit the amount of the jobs running in parallel, and have more control over the execution (maybe cancel jobs if necessary) Thanks, George

3 4

Re: [basex-talk] How could I get the current database name in xquery?
by Christian Grün 14 Jul '17

14 Jul '17

Hi Donald, Did you try db:name()? See our documentation for more information [1]. Christian [1] http://docs.basex.org/wiki/Database_Module Am 14.07.2017 8:12 vorm. schrieb "donaldjohn" <donaldjohn(a)qq.com>: > Hi, > How could I get the current database name in xquery? I need extract the > database input path and then concate it with the relative XML path, I want > to get the current opened database name rather than specify it. How could I > archive this? >

1 0

How could I get the current database name in xquery?
by donaldjohn 14 Jul '17

14 Jul '17

Hi, How could I get the current database name in xquery? I need extract the database input path and then concate it with the relative XML path, I want to get the current opened database name rather than specify it. How could I archive this?

1 0

quick and dirty guide to increasing memory capacity?
by C. M. Sperberg-McQueen 12 Jul '17

12 Jul '17

I’m working on some XQuery code for language corpora and testing a function that reads a corpus and gathers information about its contents. The function works fine on the one-million word Brown Corpus, but it’s failing with an out-of-memory error on the five-million-word Hamburg Dependency Treebank (the XML for which is somewhat more verbose than Brown’s). Before I spend a lot of time trying to rewrite the code to reduce memory usage: Is there a quick way to give the BaseX GUI interface more memory? Once the code is more complete, it will make sense to try to improve its speed and lower its resource consumption (and at that point I’ll surely have lots of questions for the list), but for the moment I would prefer to postpone such considerations, and focus on writing code I understand. Thanks! ******************************************** C. M. Sperberg-McQueen Black Mesa Technologies LLC cmsmcq(a)blackmesatech.com http://www.blackmesatech.com ********************************************

3 2

Data Access out of bounds error when running XQuery on a databse
by Jason Ricles 11 Jul '17

11 Jul '17

I am running BaseX 7.9 (yes I know its old but for reasons beyond the scope of this we can't just update BaseX) on RHEL 6.9. The BaseX is not running any instance as a server but as a standalone application with its libraries being used with my java application. I am able to add new files to the database, but when I run an XQuery I get the following output: *error running xquery: declare namespace tr = '[query]org.basex.core.BaseXException: Improper use? Potential bug? Your feedback is welcome:* *Contact: basex-talk(a)mailman.uni-konstanz.de <basex-talk(a)mailman.uni-konstanz.de>* *Version: BaseX 7.9* *Java: Oracle Corporation, 1.8.0_131* *OS: Windows 7, amd64* *Stack Trace: * *java.lang.RuntimeException: Data Access out of bounds:* *- pre value: 5813546* *- #used blocks: 22710* *- #total locks: 22710* *- access: 22709 (22710 > 22709]* *at org.basex.util.Util.notExpected(Util.java:53)* *at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:508)* *at org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:194)* *at org.basex.data.Data.kind(Data.java:284)* *at org.basex.query.value.node.DBNode$5.next(DBNode.java:353)* *at org.basex.query.value.node.DBNode$5.next(DBNode.java:345)* *at org.basex.query.path.IterStep$1.next(IterStep.java:39)* *at org.basex.query.path.IterStep$1.next(IterStep.java:31)* *at org.basex.query.path.MixedPath.iter(MixedPath.java:99)* *at org.basex.query.gflwor.GFLWOR$2.next(GFLWOR.java:78)* *at org.basex.query.MainModule$1.next(MainModule.java:98)* *at org.basex.core.cmd.AQuery.query(AQuery.java:96)* *at org.basex.core.cmd.XQuery.run(XQuery.java:22)* *at org.basex.core.Command.run(Command.java:329)* *at org.basex.core.Command.execute(Command.java:94)* *at org.basex.core.Command.execute(Command.java:117)* *at basex_debug.Corrupt_DB_Test.queryTestResultsUUID(Corrupt_DB_Test.java:114)* *at basex_debug.Corrupt_DB_Test.checkIfAlreadyAdded(Corrupt_DB_Test.java:48)* *at basex_debug.Corrupt_DB_Test.addToDatabase(Corrupt_DB_Test.java:64)* * at basex_debug.Corrupt_DB_Test.main(Corrupt_DB_Test.java:23)* The query was running fine before so I know there is not a problem with the query, I have only read about the database getting corrupt with BaseX when ran in Server and Client mode. What may be causing this problem and what are some possible solutions?

2 3

BASEX: REST: PUT to change a XML file in DB
by Roland Krause 10 Jul '17

10 Jul '17

Hi all, I installed basex for keeping and updating XML files. I can load a XML into a browser with javascript ... var xhr = new XMLHttpRequest(); xhr.open( "GET", "http://localhost:8984/rest/XMLfiles/cmuInput.xml", true); xhr.send(); var xml = xhr.responseXML; ... but if I try to PUT something, it will not work. ... var xhr = new XMLHttpRequest(); xhr.open( "PUT", "http://localhost:8984/rest/XMLfiles/test.xml", true); xhr.setRequestHeader("Authorization", "Basic " + btoa("admin:admin")); xhr.send("<ALLES>hat ein Ende, nur die Wurst hat zwei</ALLES>"); ... *[HTTP/1.1 400 Bad Request 6ms]* BUT it works with *curl* echo "<ALLES>hat ein Ende, nur die Wurst hat zwei</ALLES>" | *curl* -u admin:admin -i -X PUT -T - "http:// localhost :8984/rest/XMLfiles/ test .xml" HTTP/1.1 201 Created Content-Type: text/plain;charset=UTF-8 Content-Length: 36 Server: Jetty(8.1.18.v20150929) 1 resource(s) replaced in 32.91 ms. I need help here! -- Kind regards, *Roland*

3 2

Some timeDate arithmetic fail
by Jan Dölle 09 Jul '17

09 Jul '17

Hi, please try this: xs:dateTime("2017-07-07T18:30:00.1") - xs:dayTimeDuration("PT1S") = 2017-07-07T18:30:59.1 ????? or that: xs:dateTime("2017-07-07T18:00:59.1") - xs:dayTimeDuration("PT1M") = 2017-07-07T18:00:59.1 ????? I think, there is a bug :( Best Regards Jan -- Jan Dölle E-Mail: basex-list(a)id1.de Telefon +49-69-244502-0 Home: www.id1.de Information Design One AG, Baseler Straße 10, 60329 Frankfurt am Main Registereintrag: Amtsgericht Frankfurt am Main, HRB 52596 Vorstand: Robert Peters, Aufsichtsrat: Christian Hecht (Vorsitz)

2 1

CG 40
by Imsieke, Gerrit, le-tex 09 Jul '17

09 Jul '17

“You’ll become smart at the age of forty,” a Swabian saying goes („Mit 40 wird man g’scheid.“, see also [1]). If this is true, and if the (excellent) current system is the product of Christian’s pre-40 dabbling, how much more sophisticated will BaseX become from now on? Happy birthday, Christian! Enjoy your holidays. —Gerrit [1] https://de.wikipedia.org/wiki/Schwabenalter

3 2