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

xsl - using doc() to read in an xml stored within BaseX
by Oliver.Zmorek＠degruyter.com 01 Dec '17

01 Dec '17

Dear all, currently I'm facing following problem: 1) Saxon9he.jar stored in "lib" folder (to ensure XSLT 2.0) of a local BaseX instance (Windows) 2) Xquery calls a transformation xslt:transform($doc, $xsl) 3) Within this stylesheet I try to address another resource stored in the same database Background: XML contains product information and refers to certain other XML resources like authors, serials etc. I guess I have to options: 1) Refer to document directly (database path) Here I used doc() and referred to the additional documents, e.g. doc('/serials/serial-123.xml'). Unfortunately, the transformation says that the file or directory does not exist. I played a while around with doc() and collection() but could not find a way to make it work. Maybe the reason is that saxon runs outside the database and does not know about the database context. 2) Use rest service Afterwards I tried to use the rest interface. Given the example before I used http://admin:admin@localhost:8984/rest/serials/serial-123.xml (user and pw are admin). Checked that simple with a browser - worked. The transformation instead didn't work - it returned a 401 unauthorized http response. So, my question is how to read in database documents in an XSL stylesheet? And why does my http request does not work? Best, Oliver

3 4

Serialization options
by George Sofianos 30 Nov '17

30 Nov '17

Hi, What I'm trying to do is serialize a CSV with CRLF newlines in Linux using BaseX. It's not really important since my CSV parser supports both newlines, but maybe this discussion can help me understand how BaseX serialization works, or create an improvement for BaseX. I'm running BaseX GUI (latest snapshot). I have a sequence of strings that are CSV. I'm using fn:serialize with an item-separator of xml entity 
 I'm then returning this output as a result of the script. This gives me about 200 lines of CSV. Copy pasting these lines into an editor, or using the Save button from the GUI, saves these values with an LF newline character. The RFC [2] for CSV files recommends a CRLF character for CSV, so it would be nice if I can serialize this from BaseX directly. I tried some options from the wiki [1] but had no luck. File module also uses a system specific newline character. [3] Maybe this is something that could be a part of CSV serialization issue [4] , or maybe it is already possible to achieve this somehow. Thanks, George [1|http://docs.basex.org/wiki/Serialization] [2|https://tools.ietf.org/html/rfc4180#section-2] [3|http://docs.basex.org/wiki/File_Module#file:write-text-lines] [4|https://github.com/BaseXdb/basex/issues/1518]

3 7

FTP client
by Kirsten, Dirk 29 Nov '17

29 Nov '17

Hi list, I would like to access a file lopcated on a remote FTP server. But to my surprise I couldn't find anything or anyone trying to do this before. Basically I would like something similar to fetch:text(), but using ftp instead of HTTP. Is there any simple way to do this using XQuery or some library around? I can't really imagine I am the first one to try this...? Of course I am aware I can write my own library based on Apache commons fairly easy, but I thought I would ask first. Cheers Dirk Dirk Kirsten ______________________________ Senacor Technologies AG D?sseldorfer Str. 13 65760 Eschborn M +49 (151) 4435 1967 Dirk.Kirsten(a)senacor.com www.senacor.com Senacor Technologies Aktiengesellschaft - Sitz: Eschborn - Amtsgericht Frankfurt am Main - Reg.-Nr.: HRB 105546 Vorstand: Matthias Tomann, Marcus Purzer - Aufsichtsratsvorsitzender: Daniel Gr?zinger Diese E-Mail inklusive Anlagen enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten, informieren Sie bitte den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail including any attachments may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the materials in this e-mail is strictly forbidden.

2 3

Locking up BaseX RESTXQ using jobs
by Omar Siam 29 Nov '17

29 Nov '17

Hi! I just observed the following: If I start more RESTXQ requests than the PARALLEL settings allows jobs, which start slave jobs and wait for them, the RESTXQ jobs never finish, hang. The RESTXQ jobs don't lock anything but start a slave job each which does lock some DB for reading. It seems to me that the RESTXQ requests are started regardless of the number of parallel jobs already running but the slave jobs never start because they are over the limit of parallel running jobs. Is this a known situation? Is there some way to stop accepting RESTXQ requests or not starting slave jobs until the parallel limit permits it? Best regards Omar Siam

2 7

An illegal reflective access operation has occurred
by Massimo Franceschet 29 Nov '17

29 Nov '17

Hi. I am trying BaseX version 8.6.7 with java version “9.0.1” on a macOS Sierra, planning to show it in classroom. When running the GUI I am getting the following error: WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.basex.gui.GUIMacOSX (file:/Applications/basex/basex/BaseX.jar) to method com.apple.eawt.Application.getApplication() WARNING: Please consider reporting this to the maintainers of org.basex.gui.GUIMacOSX WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release Failed to initialize native Mac OS X interface Thanks for help. Massimo

3 4

BaseX scripting
by Kristian Kankainen 28 Nov '17

28 Nov '17

A simple question - did I correctly understand, that when running a script, then each separate command will be an isolated transaction? And that it is not the case that the whole script is treated as a single transaction? So that, let's say I have script with three updating commands (or XQueries) A, B and C. While running it, A and B executes successfully but C creates an error. After running the script, whatever was updated by A and B is still reflected in the database? Br, Kristian

2 2

id generation and updates
by E. Wray Johnson 27 Nov '17

27 Nov '17

How can I white a single XQUERY statement that assigns an auto-generated id to a node (using either generate-id(), or random:uuid() ) then inserts the node into a database and then returns the auto-generated id. I can do the id assignment and insert operation just fine using { }, I just don't know how to return the id afterward

3 7

Issue preserving namespaces with json:parse
by E. Wray Johnson 24 Nov '17

24 Nov '17

What is wrong with this code? import module namespace geo = 'http://expath.org/ns/geo'; declare namespace gml='http://www.opengis.net/gml'; let $opt := map { "lax": true() } let $y := json:parse('{ "coords":{ "gml:Point":{ "gml:coordinates":"0,0" } } }', $opt ) let $x := json:parse('{ "coords":{ "gml:Point":{ "gml:coordinates":"-123.45,45.343" } } }', $opt ) return geo:distance($x/json/coords/*, $y/json/coords/*)

2 3

Unknown function: lazy:cache
by Bridger Dyson-Smith 21 Nov '17

21 Nov '17

Hi Christian, et al, In the process of reading the wiki and trying examples, I've stumbled across a problem while attempting the lazy:cache example[1] let $f := 'lazy.txt' let $t := lazy:cache(file:read-text($f)) return(file:delete($f), $t) throws an error "No namespace for 'lazy:cache'." If I prepend a `declare namespace lazy = "http://basex.org/modules/lazy";` to the beginning of my test file, I get an updated error: "Unknown function: Q{ http://basex.org/modules/lazy}cache". I get that same result in BaseX-latest (9.0 beta b5f1824) and v8.6.7. Is this a bug or is this A Case of The Missing Import Module Statement? Thanks in advance for your help. Cheers, Bridger [1] http://docs.basex.org/wiki/Lazy_Module#lazy:cache

2 1

Loading data
by E. Wray Johnson 20 Nov '17

20 Nov '17

I have a JSON file https://gist.githubusercontent.com/Miserlou/c5cd8364bf9b2420bb29/raw/2bf258… I want to load it into a database in a different XML format where I can use gml:Point in place of longitude and latitude as separate elements. However my for loop does not emit individual XML elements for each json object in the loaded array.

3 7

geo package - Great Circle Distances
by E. Wray Johnson 20 Nov '17

20 Nov '17

Can anyone recommend how in BaseX to calculate great circle distances (e.g. between two geo:Points) (e.g. in meters or kilometers).

1 0

Documentation typo
by Marco Lettere 20 Nov '17

20 Nov '17

Hi all, I think there is a typo in the documentation on the map:merge function [1]. The Summary states the possibility to use "use-combine" as a value for duplicates option but it should be 'combine' only. Regards, M. [1] http://docs.basex.org/wiki/Map_Module#map:merge

2 1

Re: [basex-talk] Spatial Reference not working
by Christian Grün 18 Nov '17

18 Nov '17

The Geo Module is basically a light-weight wrapper for the JTS Topology Suite: geo:srid calls getSRID() (see [1]). Maybe you could ask on the jts mailing list and give us some feedback? [1] https://github.com/BaseXdb/basex/blob/master/basex-api/src/main/java/org/ex… Am 14.11.2017 12:23 vorm. schrieb "E. Wray Johnson" <wray.johnson(a)gmail.com >: I am sorry, I did not make myself clear. It always returns 0. There is a way to set the spatial reference. Typically with the srsName attribute on the geometry. In this example that would be the gml:Polygon element. However, none of the valid values is recognized by JTS. It is as if the srsName attribute is not getting to JTS. On Mon, Nov 13, 2017 at 5:41 PM, Christian Grün <christian.gruen(a)gmail.com> wrote: > > I can’t get the geo:srid() to work. I have tried many combinations of > @srsName values. Can anyone provide examples? > > Try e.g. this: > > import module namespace geo='http://expath.org/ns/geo'; > declare namespace gml='http://www.opengis.net/gml'; > geo:srid( > <gml:Polygon> > <outerboundaryIs> > <gml:LinearRing> > <coordinates>-150,50 -150,60 -125,60 -125,50 > -150,50</coordinates> > </gml:LinearRing> > </outerboundaryIs> > </gml:Polygon> > ) >

2 4

Re: [basex-talk] XPath generator
by Kristian Kankainen 17 Nov '17

17 Nov '17

I don't know if it is the optimal solution in BaseX, but what functionality concerns, you can look at this functx function: http://www.xqueryfunctions.com/xq/functx_path-to-node-with-pos.html For BaseX specifics, maybe this page can help you (sorry but I am not sure): http://docs.basex.org/wiki/Index Best, Kristian K17. nov 2017 4:06 PM kirjutas kuupäeval Giuseppe Celano <celano(a)informatik.uni-leipzig.de>: > > Hi All, > > I would like to ask what the best way is in BaseX to create XPath expressions once I identify a certain span in an XML file. More concretely, I usually tokenize a text contained in an XML document, and I would like to specify for each token its position in the original document. Thanks. > > Best, > Giuseppe > >

1 0

Some string peculiarities
by Kristian Kankainen 17 Nov '17

17 Nov '17

Hello I encountered some strange things when tokenizing text. Sample runnable code is added below. Here is my list of problems: 1) the regular expression "(\.){3}" doesn't match the same as "(\.\.\.)". Shouldn't they be equal? 2) a very annoying whitespace is placed text to the newline of out:nl(). It is placed before out:nl() if it is called in the beginning of an element, or it is placed after the newline if out:nl() is called in the end of an element. E.g the serialized output is either "<s> this" or ". </s>". Sample runnable code: for $text in ("this one... is the first.", "this one is second.") return <s>{ out:nl(), string-join( analyze-string($text, '(\.){3}|[\W]')//text()[not(.=" ")], out:nl() ), out:nl() }</s> , "--------- VERSUS --------- " , for $text in ("this one... is the first.", "this one is second.") return <s>{ out:nl(), string-join( analyze-string($text, '(\.\.\.)|[\W]')//text()[not(.=" ")], out:nl() ), out:nl() }</s>

2 1

XPath generator
by Giuseppe Celano 17 Nov '17

17 Nov '17

Hi All, I would like to ask what the best way is in BaseX to create XPath expressions once I identify a certain span in an XML file. More concretely, I usually tokenize a text contained in an XML document, and I would like to specify for each token its position in the original document. Thanks. Best, Giuseppe

2 1

Hypertext Application Language: Do we need a library that implements this?
by Omar Siam 17 Nov '17

17 Nov '17

Hi list! I implemented a REST API using apigility some time ago and by doing that I stumbled upon http://stateless.co/hal_specification.html I kind of like it so I thought maybe there is a customizable XQuery implementation? If not: Is someone else interested in creating a customizable BaseX XQuery implementation? Best regards Omar Siam

1 0

basex-node binding objects
by E. Wray Johnson 15 Nov '17

15 Nov '17

Andy, 1. I am pelase that JSON result objects are mapped to JavaScript objects. Are undefined values handled (e.g. XQuery () vs JavaScript undefined)? 2. I am using basex-node and having trouble binding objects in a query. I would like to have the object result in an XQUERY map. It would be nice if undefined values as defined above are handled as well. For now I have to do something like this'$x := map ' +JSON.stringify(obj).replace('undefined', '()'). I hope this make sense.

2 1

Update/Delete JSON
by E. Wray Johnson 15 Nov '17

15 Nov '17

What is the best way to update JSON objects (only some object values) by unique id? What is the best way to delete JSON objects by unique id? Wray Johnson (m) 704-293-9008

5 8

BaseX gui, windows 10 and java
by Arto Viitanen 15 Nov '17

15 Nov '17

I have BaseX 8.6.7 on 32 bit Windows 10. When I tried to load an XML file yesterday to editor, the program crashed. I tried several times, and then reinstalled BaseX from net. This did not help. The program crashes on file dialog. If I open the file with double click, the file opens. Then I reinstalled java, but this did not help either.When I used cmd window, and run "java -cp BaseX.jar org.basex.BasexGUI", it worked. So it seems problem is on Java version embedded. Windows is 10.0.16299.19, and Java that works is 1.8.0_144-b01 Arto Viitanen Microteam Oy Haarlankatu 4B 33230 Tampere

2 4

updating inside map:for-each
by E. Wray Johnson 14 Nov '17

14 Nov '17

How can database updating be done inside map:for-each ?

3 2

DB locking
by Navin Rawat 14 Nov '17

14 Nov '17

Hi There, I have created an script which will setup a job by job:eval() function of BaseX to perform multiple actions on the inputs before ingesting them into the database. I have to create a report on each and every success/failure steps on each job. For this I have created per job XML file within the database under '/job/' directory, it is an update function. Everything is working fine, except user is unable to perform any other action within the database at the time of job execution. It seems, our running job is blocking whole database. Our job may take 20 minute to 2 hour to finish. Is this the correct behavior of BaseX to block whole database (even for reading)? or I am doing something wrong? Please suggest. Regards, Navin

3 6

Spatial Reference not working
by E. Wray Johnson 13 Nov '17

13 Nov '17

I can’t get the geo:srid() to work. I have tried many combinations of @srsName values. Can anyone provide examples? E. Wray Johnson

2 2

Update operations on JSON objects are not working
by E. Wray Johnson 13 Nov '17

13 Nov '17

I have tried many ways of updating JSON objects and none seem to work. Using the BaseX GUI, the Result window seems to show the correct outcom, but the database is not modified. What am I missing? Do I need to explicitly start/stop a transaction? XQUERY: db:open('db','country')/json[countryId = 1] update { replace value of node countryName with 'Aldorria', insert node <population type="number">1000</population> into . } Result: <json type="object"> <countryId type="number">1</countryId > <countryName>Aldorria</countryName> <population type="number">1234</population> <planetName>Zeldon</planetName> </json>

2 2

XSD 1.1 support? Unknown function: xs:dateTimeStamp
by Bridger Dyson-Smith 13 Nov '17

13 Nov '17

Hi Christian, et al, I was wondering if I'm seeing a bug or an oversight on my part. I was trying to type a $date as xs:dateTimeStamp but getting an error using the BaseX GUI, v8.6.7. let $date := '2017-12-15T23:45:00-5:00' return xs:dateTimeStamp($date) I've read in Walmsley's that XSD v1.1 data type support is required for xs:dateTimeStamp. Is this a bug or maybe user/operator error? Many thanks. Best, Bridger

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk