- 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