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

util:item - java.lang.NullPointerException
by Sebastian Guerrero 21 May '20

21 May '20

Hi BaseX team! I have a database with a text-index for a node named "*serial-number"* with 2,164,980 occurrences of text '*0000000*'. *[1]* If I execute : *util:item(db:text("US02", "0000000"), 1)* I get '0000000', as expected. But, If I execute: * util:item(db:text("US02", "0000000"), 2) * I get the error message in *[2]* The same happens with *db:text("US02", "0000000")[2]* *subsequence(db:text("US02", "0000000"),2,1)* I recorded everything on this video *[3]* Is this a bug?, I optimized the database before executing the queries. Best regards, Sebastian. *[1] *https://imgur.com/UDgXYPY *[2] *Stack Trace: java.lang.NullPointerException at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) at org.basex.query.scope.MainModule.iter(MainModule.java:97) at org.basex.query.QueryContext.iter(QueryContext.java:333) at org.basex.query.QueryContext.cache(QueryContext.java:630) at org.basex.query.QueryProcessor.cache(QueryProcessor.java:113) at org.basex.core.cmd.AQuery.query(AQuery.java:101) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:257) at org.basex.core.Command.execute(Command.java:93) at org.basex.gui.GUI.exec(GUI.java:416) at org.basex.gui.GUI.lambda$4(GUI.java:359) at java.lang.Thread.run(Unknown Source) *[3]* https://youtu.be/gXYpBNd7iJc

2 2

Help composing an http:request with POST
by Bridger Dyson-Smith 21 May '20

21 May '20

Hi all - I'm trying to use BaseX to POST an image to a digital asset management system (i.e. I'm not using RESTXQ, etc, just using BaseX to compose and send the request). The request: http:send-request( <http:request method='POST' username='{$user}' password='{$pass}' auth-method='Basic' send-authorization='true'> <http:multipart media-type='multipart/form-data'> <http:body media-type='image/tiff'/> </http:multipart> </http:request>, ' http://localhost:8080/fedora/objects/tdh:2/datastreams/OBJ?versionable=true… ', file:read-binary('/path/to/my/image.tif') ) I'm a hapless caveman when it comes to http, and so when the binary content gets POSTed, the mime-type becomes something like 'multipart/form-data;boundary=1BEF0A57BE110FD467A'. I'm clearly missing something in the http:request but... I don't know what. Any suggestions? It seems like I need some training wheels here, but I'm not sure which ones. :) Thank you, in advance, for your time and trouble. Best, Bridger

1 1

txtl.basex
by Ветошкин Владимир 20 May '20

20 May '20

2 2

Runtime load of a module?
by Buddy Kresge 19 May '20

19 May '20

We have a situation where we have certain XQuery modules and we want to know if there is a way to load a module into BaseX at Run-time? As a hypothetical example If (some condition) Load module X into Basex else Load module Y into Basex

3 4

distinct-values and type coercion
by Marco Lettere 19 May '20

19 May '20

Dear all, after installing Basex 9.3.3 one application of ours started failing in a particular functionality. We tracked it down to the following example code: let $in := <json type="object"> <source type="object"> <reference>Object/20383920-5bb1-4397-8b51-b752863acddf</reference> </source> </json> let $s as xs:string* := distinct-values($in/source/reference/string()) return $s This code now returns the following error: [XPTY0004] Cannot treat xs:untypedAtomic* as xs:string*: distinct-values($in_0/element(source)/element(reference)). Whereas before it was automatically casting to xs:string now it seems that the type coercion in the let clause is too restrictive. This happens only with the distinct-values applied by the way. Is it correct now or was it before? For the moment we solved by removing the type enforcement in the let clause. Thank you for the clarification. Regards, Marco.

2 1

Full-text index: searches for common words in another node. Does it take a lot of time?
by Sebastian Guerrero 19 May '20

19 May '20

Hi everybody. I'm here again with my doubts. Thank you for your patience. ^^ I have a database of trademarks with a full-text index for two nodes: **:mark-identification,*:party-name*. [1] Where "*mark-identification*" contains the name of the trademark, and " *party-name*" contains the name of the owner of the trademark. I use the full-text index in order to search trademarks by its name, for example: *for $results in //case-file[case-file-header/mark-identification/text() contains text {'basex'}]* *return $results//mark-identification* returns all trademarks with "*basex*" on its name. It works like a thunderlight: 15ms to get 3 records among 2,134,434,598 nodes. Really a dream. [2] But, for example, if I change the searched text from "*basex*" by a common word in "*party-name*", for example, "*corporation*" ( has 1096187x occurrences on the full-text index as showed in [1], it's a very common word in owners of trademarks ): *for $results in //case-file[case-file-header/mark-identification/text() contains text {'corporation'}]* *return $results//mark-identification* It takes a long time to get 6,715 records: 62,000ms [3] If I search for "*live*" ( a common word for trademarks name, but not for owners names ) I get 5,875 records in 2,773 ms, which has not a relationship with the 62,000ms to get the 6k records for "*corporation*". [4] So... - Is this an expected behaviour? - Is there a way to specify which "section" of the full-text index should be used to perform the search? ( I don't know... maybe something similar to "*using stemming*" but "*using index 'mark-identification'*" ) Please apologize me if I'm asking by something not-logical, Best regards, Sebastian [1] https://imgur.com/uLla1Xt [2] https://imgur.com/Fkcvv2O [3] https://imgur.com/Hk71CNe [4] https://imgur.com/P72k574

2 3

Same query returns different amount of records
by Sebastian Guerrero 18 May '20

18 May '20

Hi everyone! it's me again. Here is my doubt: If I execute this query: * (# db:enforceindex #) { for $db in ('US00','US01','US02') for $tmUS in db:open($db)/trademark-applications-daily/application-information/file-segments/action-keys/case-file where $tmUS/case-file-header/mark-identification/text() contains text { 'apple' } return $tmUS/case-file-header/mark-identification/text() }* I get 4k results in 139ms from three databases of 90GB and 13M of records. It works like a charm. [01] But, if I include that query into a *for* and then into a *switch* ( I tried with *if-then-else* too ), the same query returns only 11 results in 107ms [02]: *declare namespace gb="http://www.ipo.gov.uk/schemas/tm <http://www.ipo.gov.uk/schemas/tm>";* *let $text := "apple"* *let $registries := ('US')* *for $registry in $registries* *return * * switch ($registry)* * case "US"* * return * * (# db:enforceindex #) { * * for $db in ('US00','US01','US02')* * for $tmUS in db:open($db)/trademark-applications-daily/application-information/file-segments/action-keys/case-file* * where $tmUS/case-file-header/mark-identification/text() contains text { $text }* * return $tmUS/case-file-header/mark-identification/text()* * }* * case "GB"* * return* * (# db:enforceindex #) {* * for $tmGB in db:open('GB')/gb:MarkLicenceeExportList/gb:TradeMark* * where $tmGB/gb:WordMarkSpecification/gb:MarkVerbalElementText/text() contains text { $text }* * return $tmGB/gb:WordMarkSpecification/gb:MarkVerbalElementText/text()* * }* * default return "Unknown registry code"* I noticed that removing the case option "GB" ( even if it's not evaluated ), it works fine and returns the 4k records [03]: *declare namespace gb="http://www.ipo.gov.uk/schemas/tm <http://www.ipo.gov.uk/schemas/tm>";* *let $text := "apple"* *let $registries := ('US')* *for $registry in $registries* *return * * switch ($registry)* * case "US"* * return * * (# db:enforceindex #) { * * for $db in ('US00','US01','US02')* * for $tmUS in db:open($db)/trademark-applications-daily/application-information/file-segments/action-keys/case-file* * where $tmUS/case-file-header/mark-identification/text() contains text { $text }* * return $tmUS/case-file-header/mark-identification/text()* * }* * default return "Unknown registry code"* What I'm missing here? is this the right behaviour? Best regards, Sebastian [01] https://imgur.com/o4RUUyO [02] https://imgur.com/533c0rI [03] https://imgur.com/mCb3qEe

2 2

BaseX 9.3.2: Performance Tweaks, Bug Fixes
by Christian Grün 15 May '20

15 May '20

Dear all, We are glad to provide you with a new BaseX 9.3.2 maintenance release: http://basex.org In preparation to version 9.4, we have introduced numerous small query optimizations that speed up path, predicate and simple map operations and will rewrite your queries for index access more often than before. Feel free to check out the full list of added rewritings and enhancements on Github: https://github.com/BaseXdb/basex/issues?q=is%3Aissue+is%3Aclosed Have fun with the new release, Christian BaseX Team

3 5

Storing XML messages
by Ramzi Hammouda 15 May '20

15 May '20

Hello BaseX team, Using Resful API, I'm trying to make POST method update BaseX database, I want to insert an xml node to an existing document calastone.xml in calastone database , but the node contains '<', you replied to a previous email that I should use fn:parse-xml to make this happen without error. I tried using the function fn:parse-xml, I had success with using it in BaseX GUI like this: let $message := fn:parse-xml('<Id>CTN55</Id>') return insert nodes $message as last into doc("calastone/calastone.xml") But when I tried to do the same with POST method from my application with using this xquery: string xquery = "<query><text>let $message:= fn:parse-xml('<Id>CTN58</Id>')" + "return insert nodes $message as last into doc(\"calastone/calastone.xml\")</text>" + "<variable name = 'message' value = fn:parse-xml('<Id>CTN58</Id>'))/></query>"; I get the error: "" (Line 1): Element type "variable" must be followed by either attribute specifications, ">" or "/>" Can you help on how to do this insertion? Thanks. P Respectons ensemble l'environnement. N'imprimez ce message que si n?cessaire. Let's respect the environment together. Only print this message if necessary.

2 1

Directory and files are neither a file or a directory on Basex 9.3.2 when read from Docker volume
by France Baril 14 May '20

14 May '20

Hi, Here is my issue. I create a new container with Basex 9.3.2 I add a volume ContentDBs under my basex directory ContentDBs has 2 directories and 1 files I run this code from an xqm: let $src-dir-items := file:list('ContentDBs') let $debug := file:append('debug-a.xml', 'count: ' || count($src-dir-items) || '
') let $dirs := for $i in $src-dir-items (: Bug items are neither a dir or a file !? Because volume from docker? :) let $debug := file:append('debug-a.xml', 'item: ' || $i || ' is dir: ' || file:is-dir($i) || '
') let $debug := file:append('debug-a.xml', 'item: ' || $i || ' is file: ' || file:is-file($i) || '
') return $i In the debug file, I get. - The count for items is 3 - For all items, is-dir and is-file are false. I get a similar error if I try to db:create from one of the folders, it seems to recognize that I have a folder, but it chokes on subfolders with: Resource 'js/' does not exist. -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2