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

Re: [basex-talk] baseX vs ExistDB
by Julio Croce 23 Apr '18

23 Apr '18

Welcome! I have not used exist, but I can share my history. I used sedna for many years. When development stopped I looked for alternatives. I have read many comparisons in WWW andI have found basex. A detailed benchmark of basex and others: https://bbddxml.wordpress.com/2014/01/08/un-benchmark-para-nuestras-bases-d…. If you know xmark, it is most important and most cited benchmark for xml. I have run these tests also (for Sedna and basex), and published results are close. In basex I notice that writing xml result to files is very fast. Also query and indexes optimisation is very clever (pues, more clever than me), sometimes only few miliseconds for gigabytes of xml. And basex has excelent support for official w3C standards (Fulltext, Update, all of Xquery 3.1. see https://en.wikipedia.org/wiki/XML_database). And very stable. I have used berkeley in early times, it was very slow. One question to the team: Can you include replication feature? Best regards Julio

2 1

RFC2, Client for R
by Ben Engbers 22 Apr '18

22 Apr '18

Hi, I have changed the code for RbaseXClient.R in such a way that it complies more to the server protocol and to the R-style of coding. - 'execute' has been renamed to 'command' - All the functions in the Command Protocol section return a list with the complete server response. This makes it much easier to handle errors (see lines 8-14 in TestRBaseXClient.R). In the Query Command Protocol section, the functions 'more()' (as being called by results) and 'full()' now return the results, prefixed with a byte that represents the Type ID. Cheers, Ben Engbers

1 0

baseX vs ExistDB
by Feargal Hogan 20 Apr '18

20 Apr '18

Hi Is anyone aware of any comparisons between baseX and Exist? I have some familiarity with Exist and I’d like o understand what are the benefits of each. Thanks Feargal

8 14

Re: [basex-talk] BaseX-Talk Digest, Vol 100, Issue 34
by Feargal Hogan 20 Apr '18

20 Apr '18

> > On Thu, 2018-04-19 at 16:26 +0100, Feargal Hogan wrote: >>> >> From the comparison chart that Ben referenced earlier I noticed that >> baseX doesn?t seem to actually load xml files into an xml database, >> is that right? > No. Yes. Maybe. > > baseX does load the documents into a database. It stores them in an > internal data structure, not as textual XML. I think the comparison page perhaps misrepresents that point slightly. > > >> Does baseX need to be 'told' that it has been updated, in order to >> add the new data to its indeices? >> Or does it know there has been an update and automatically reindex? > > This isn't a meaningful quesiton. You are correct. In the context of my misunderstanding the comparison document, the question is pointless and meaningless. Thanks

1 0

ExecuteCommand with a multiple Command objects?
by buko 20 Apr '18

20 Apr '18

Hello all, I’m currently in the process of evaluating BaseX for an embedded use case and I ran into an issue. I figured out that each Command is a transaction (though I think this should be made more prominent in the javadocs at http://docs.basex.org/javadoc/org/basex/core/Command.html) and I found the Execute command that lets multiple Commands be grouped together and executed as one… but the Execute command takes a string. What happens if I have a series of Command objects that I would like to execute together in a single transaction?

2 3

Streaming results
by Bram Vanroy 20 Apr '18

20 Apr '18

Dear list I am curious to find out whether it is possible to stream results of a query, i.e. where a submitted query behaves as a generator. Especially for web interfaces this is useful: a user is presented with a result as soon as it is found, and doesn't have to wait for all results to be gathered. Especially useful with large databases of course. Preferably a way that works with the nodejs, PHP client but I am open to other suggestions. Thanks in advance Bram

3 4

Dagger et al. being replaced by char refs in returned XML
by Chuck Bearden 19 Apr '18

19 Apr '18

Hi all, I have loaded a large XML document (a dictionary of New Testament Greek) into its own database in BaseX 9.0. I'm using OpenJDK 1.8.0_162 under Ubuntu 16.04.4. I used the default Java parser, and I enabled the token & full text indices, but otherwise the database settings were the defaults. When I execute a particular query, I'm getting a sequence of the character reference for the carriage return ('') instead of some characters like the single & double daggers. Here is some typical output:  <entry n="ἄγε|G33"> <note type="occurrencesNT">2</note> <form> <orth>ἄγε</orth>,</form> <seg type="derivation">prop. imperat. of<ref> <foreign xml:lang="grc">ἄγω</foreign> </ref>,</seg> <sense> <gloss>come!</gloss>used as<gramGrp> <pos>adv.</pos> </gramGrp>and addressed, like<ref> <foreign xml:lang="grc">φέρε</foreign> </ref>, to one or more persons:<ref osisRef="Jas.4.13">Ja 4:13</ref>,<ref osisRef="Jas.5.1">5:1</ref> </sense> </entry> The sequence of '' char refs replace a dagger '†' (U+2020). I wonder if I'm doing something wrong, or if I've happened on a bug. Here is my XQuery: declare namespace tei = "http://www.crosswire.org/2013/TEIOSIS/namespace"; declare namespace xsi = "http://www.w3.org/2001/XMLSchema-instance"; let $coll := collection('abbott-smith.tei'), $elems := $coll//tei:seg[parent::tei:entry] return <div xmlns="http://www.crosswire.org/2013/TEIOSIS/namespace" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">{ for $elem in $elems let $entry := $elem/parent::tei:entry, $entry_lemma := $entry/@n/data(), $page_num := $elem/preceding::tei:pb[1]/@n/data(), $comment_text := concat('Page: ', $page_num, ' ; Entry: ', $entry_lemma, ' ') return ( comment {$comment_text}, $entry ) }</div> The source XML document is here: https://github.com/translatable-exegetical-tools/Abbott-Smith/blob/master/a… Thanks in advance for your guidance. All the best, Charles Bearden

3 4

Validation Module: validate:xsd-report( ) improvement
by Yitzhak Khabinsky 19 Apr '18

19 Apr '18

Hello, I am successfully using BaseX Validation Module. Along the following lines: let $xml := 'd:\Temp\CDW\HOME\id4879_BO201801_HomeSubscriberMovementFact.xml' let $xsd := 'd:\Temp\CDW\HOME\HomeSubscriberMovementFact.xsd' return validate:xsd-report($xml, $xsd, '1.1') My XML files have multi-megabyte size and lots of validation errors. In tens or hundreds of thousands of errors. Behind the scenes, Saxon validator 9.8.0.11 is running. Unfortunately, the output structure contains a repeating url attribute. The BaseX output pane cannot present all the errors. It says: "(Chopped) Results". <report> <status>invalid</status> <message level="Error" line="10" column="26" url="file:///D:/Temp/CDW/HOME/id4879_BO201801_HomeSubscriberMovementFact.xml">The content "N/A" of element <CommercialServiceCode> does not match the required simple type. Value "N/A" contravenes the enumeration facet "R60080-X00162, R60080-X00163, ..." of the type Q{http://www.millicom.com}CommercialServiceCodeType</message> <message level="Error" line="19" column="23" url="file:///D:/Temp/CDW/HOME/id4879_BO201801_HomeSubscriberMovementFact.xml">The content "TBD" of element <MovementTechnology> does not match the required simple type. Value "TBD" contravenes the enumeration facet "N/A, HFC, GPON, MMDS, FIBER, C..." of the type Q{http://www.millicom.com}MovementTechnologyType</message> <message level="Error" line="24" column="18" url="file:///D:/Temp/CDW/HOME/id4879_BO201801_HomeSubscriberMovementFact.xml">The content "-1.0000" of element <DownloadSpeed> does not match the required simple type. Value "-1" contravenes the minExclusive facet "0" of the type Q{http://www.millicom.com}DownloadSpeedType</message> <message level="Error" line="26" column="6" url="file:///D:/Temp/CDW/HOME/id4879_BO201801_HomeSubscriberMovementFact.xml">The 7th field in constraint {PK} has no value</message> ... </report> My proposal is to eliminate the repeated url attribute from the each message and elevate it to its own element just once under the root report tag. Along the following output structure: <report> <status>invalid</status> <url>file:///D:/Temp/CDW/HOME/id4879_BO201801_HomeSubscriberMovementFact.xml</url> <message level="Error" line="10" column="26">The content "N/A" of element <CommercialServiceCode> does not match the required simple type. Value "N/A" contravenes the enumeration facet "R60080-X00162, R60080-X00163, ..." of the type Q{http://www.millicom.com}CommercialServiceCodeType</message> <message level="Error" line="19" column="23">The content "TBD" of element <MovementTechnology> does not match the required simple type. Value "TBD" contravenes the enumeration facet "N/A, HFC, GPON, MMDS, FIBER, C..." of the type Q{http://www.millicom.com}MovementTechnologyType</message> <message level="Error" line="24" column="18">The content "-1.0000" of element <DownloadSpeed> does not match the required simple type. Value "-1" contravenes the minExclusive facet "0" of the type Q{http://www.millicom.com}DownloadSpeedType</message> <message level="Error" line="26" column="6">The 7th field in constraint {PK} has no value</message> ... </report> This way the output of the validation is much more readable and hopefully will fit in its entirety to the output pane. Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…>

3 3

Re: [basex-talk] Validation Module: validate:xsd-report( ) improvement
by Yitzhak Khabinsky 19 Apr '18

19 Apr '18

Hi Marco, The proposed solution is way too slow. let $xml := 'd:\Temp\CDW\HOME\id4879_BO201801_HomeSubscriberMovementFact.xml' let $xsd := 'd:\Temp\CDW\HOME\HomeSubscriberMovementFact.xsd' let $validate := validate:xsd-report($xml, $xsd, '1.1') return file:write("output.xml", copy $newvalidate := $validate modify (delete node $newvalidate//@url) return $newvalidate ) I guess delete node... is too heavy. It runs for 143 seconds. Without it just 11 seconds. The input XML file size is about 40MB. The output.xml file has about the same size. That's why I was proposing to change the default output format of the validation. Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…> From: Yitzhak Khabinsky Sent: Thursday, April 19, 2018 2:51 PM To: m.lettere(a)gmail.com Subject: Re: [basex-talk] Validation Module: validate:xsd-report( ) improvement Hi Marco, Thanks for the proposed solution. It works. But I was referring to the default behavior. The url attribute is redundant for every message element. Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…>

1 0

Increase/Decrease font size not possible with MacOS
by Kirsten, Dirk 19 Apr '18

19 Apr '18

Hi Christian, Minor issue, but using the latest snapshot I am unable to increase/decrease the editor font size in MacOS (using Command +/-), whereas it works flawlessly using Windows (with Ctrl +/-). Cheers Dirk Dirk Kirsten ______________________________ Senacor Technologies AG D?sseldorfer Stra?e 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

Unicode problem with database
by Giuseppe Celano 18 Apr '18

18 Apr '18

Hi, I tried to create a database containing the attached file and I get some Unicode character converted into "carriage return" characters. Any hint? Thanks! Ciao, Giuseppe Universität Leipzig Institute of Computer Science Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

2 2

RFC, Client for R
by Ben Engbers 18 Apr '18

18 Apr '18

Hi, Last month I have been working on a R client. Results from my work are attached. The 'add, replace and store'-commands should be working but haven't been tested yet since I don't have any good example-commands at hand. I'm looking forward for comments! Ben Engbers

2 1

Collection function
by Giuseppe Celano 18 Apr '18

18 Apr '18

Hi, It seems there is an error with the collection function. Something like this: collection("directory")[5] does not return anything in 9.0 but it does in 8.6.7 Best, Giuseppe Universität Leipzig Institute of Computer Science, Digital Humanities Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

2 1

GUI
by Giuseppe Celano 16 Apr '18

16 Apr '18

I see that in the 9.0 version the "+ button" to add a new tab is missing. I think it was very useful: can it be re-introduced in the following releases? Best, Giuseppe Universität Leipzig Institute of Computer Science Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

2 2

Multipart and charset
by Marco Lettere 16 Apr '18

16 Apr '18

Hi everyone, when parsing a multipart response we are getting from a server we need to integrate with basex raises the exception [1]. By forcing the mediatype (with override-media-type attribute) to text/plain we've been able to see that parts look something like [2]. Our suspect was that the multipart parser does not tolerate the quotes around UTF-8 but exploring the jungles of RFC they seem to be allowed as per an example of https://tools.ietf.org/html/rfc2045 that states: Note that the value of a quoted string parameter does not include the quotes. That is, the quotation marks in a quoted-string are not a part of the value of the parameter, but are merely used to delimit that parameter value. In addition, comments are allowed in accordance with RFC 822 rules for structured header fields. Thus the following two forms Content-type: text/plain; charset=us-ascii (Plain text) Content-type: text/plain; charset="us-ascii" are completely equivalent. Could we kindly have some feedback on this in order to avoid having to parse the whole multipart on our own? Thank you very much. Marco. [1] Unsupported encoding: java.nio.charset.IllegalCharsetNameException: "UTF-8" at org.basex.core.Command.execute(Command.java:94) at org.basex.gui.GUI.exec(GUI.java:427) at org.basex.gui.GUI.lambda$4(GUI.java:370) at org.basex.gui.GUI$$Lambda$80/502071500.run(Unknown Source) at java.lang.Thread.run(Thread.java:745) Caused by: org.basex.query.QueryException: Unsupported encoding: java.nio.charset.IllegalCharsetNameException: "UTF-8" at org.basex.query.QueryError.get(QueryError.java:1392) [...] [2] ----boundary44723329.705882352941176-- Content-Type: application/xop+xml; type="application/soap+xml"; charset="UTF-8" Content-Transfer-Encoding: 8bit Content-Id: <0.1808ACE4.38B8.11E8.8E46.50569966F200>

2 2

Replace command long execution time
by Andrey Fedosenko 14 Apr '18

14 Apr '18

Hello, The size of my database is about 23GB and about 650,000 records. The execution of the REPLACE command can take about 10 minutes. What could be the reason?

2 5

FW: Java 9 and BaseX 9
by Bram Vanroy 13 Apr '18

13 Apr '18

From: Bram Vanroy Sent: vrijdag 13 april 2018 11:03 To: 'basex-talk(a)mailman.uni-konstanz.de' <basex-talk(a)mailman.uni-konstanz.de> Subject: Java 9 and BaseX 9 Hello list I just downloaded and installed the most recent version of Java and tried to install the latest version (from the download web page) of Basex. However, upon launching the installer I get the message "Must install Java before running the installer". When looking through the mailing list, I already found this issue but it was marked as solved. [1] The problem still occurs, though. Perhaps the issue is that the {url}/releases/latest isn't the same download as you get from using the {url}//download page. If they are different, than perhaps these should be put in sync so that you always get the latest version when downloading. Kind regards Bram Vanroy [1] https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/msg10417.ht…

2 3

Problems compiling BaseX in Eclipse Oxygen
by Ben Engbers 13 Apr '18

13 Apr '18

Hi, I want to compile and run the basex-examples in Eclipse (Oxygen) but even after adding Maven-support, I can't manage to compile the sources (were downloaded with git). When I look at the properties for the basex-examples project, I would expect to find the Java-classes in the target/classes directory but this directory does not contain any java classes. How can I compile the sources? Thanks, Ben

2 8

Re: [basex-talk] XSLT Module: feature request - XSLT 3.0 support
by Yitzhak Khabinsky 11 Apr '18

11 Apr '18

Just some minor touches for the XSLT Module for improvement. 1. If Saxon is present in the classpath set CP=%MAIN%\BaseX.jar;%MAIN%\lib\*;%MAIN%\lib\custom\*;d:\Kit\Saxonica\9.8.0.11\JavaEE\* return xslt:processor(), xslt:version() shall return Saxon EE 3.0 instead of Saxon EE 2.0 1. Documentation improvement http://docs.basex.org/wiki/Xslt_Module It currently says "...XSLT 2.0 is used instead if Version 9.x of the Saxon XSLT Processor<http://www.saxonica.com/> (saxon9he.jar, saxon9pe.jar, saxon9ee.jar) is found in the classpath...." Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…>

2 2

Multiparts ... this time a proposal ...
by Marco Lettere 11 Apr '18

11 Apr '18

Dear Christian and BaseX community, working with multipart requests and RestXQ lately, we have the feeling that there could be a way to intercept the structure of the request with annotations in order to perform a more fine grained access to the single parts. At the moment the docs state the following example where, due to the consumes annotation reporting multipart/mixed, the data is returned as a sequence of items: |declare| |||%rest:path||(||"/multipart"||)| |||%rest:POST||(||"{$data}"||)| |||%rest:consumes||(||"multipart/mixed"||) ||(: optional :)| |function||page:multipart(||$data||as||item||()*) {| |||"Number of items: "|||| ||count||(||$data||)| |};| Do you think that an approach where the content negotiation is refined to single parts could be implementable? What we have in mind is something like the following snippet. Besides the usual sequence based representation of the body, parts are extracted as variables (part named “partname1” with $part1 and type validated/coerced to the function signature and so on). > |declare| > |||%rest:path||(||"/multipart"||)| > |||%rest:POST||(||"{$data}”||) (: |{$data} Could be removed at all or > is out of standard? :) > |||%rest:consumes||(||"multipart/mixed"||) ||(: optional :)| > |%input:part||(|||"{$part1}", |"partname1"||) ||(: partname could be > inferred from Content-Disposition and C|ontent-Type for type coercion > applied as usually with single-part requests :) |%input:part||(|||"{$part2}", |"partname2"||)| || |function||p||:multipart(||$data||as||item||()*, $part1 ||*as*||xs:binary, $part2 ||*as*||node()) {| | p||:do-something-with($part1)||||||||||| | };| || |Maybe even the serialization method could be declared... | |declare| |||%rest:path||(||"/multipart"||)| |||%rest:POST||(||"{$data}"||)| |||%rest:consumes||(||"multipart/mixed"||) ||(: optional :) ||%input:part||(|||"{$part1}", |"partname"||, "csv;separator=','") ||(: Just as an example ...:)||| |function||p||:multipart(||$data||as||item||()*, $part1 as node()) {| |||p||:do-something-with($part1)||||||||||| |}; ||Finally a check on the part count could be enforced in order to disallow requests that do not match *declare* %rest:path("/multipart") %rest:POST("{$data}") %rest:consumes("multipart/mixed") (: optional :) %input:part("{$part1}", "partname", "csv,separator=','")| ||%input:part-count(2)| *function* p:multipart($data as item()*, $part1 as node()) { |||p||:do-something-with($part1)| }; | This makes for a nice, declarative way of extracting parts or ensuring that the structure of the requests respects a given REST service contract. We understand that RestXQ is a shared formalization effort in the XML community but maybe there could be some opportunity to experiment and propose an addition to the specification? As usual thanks a lot for your attention. Best regards Marco.

2 1

Error-code when reading from a socket (RbaseClient)
by Ben Engbers 11 Apr '18

11 Apr '18

Hi, Since a few weeks I am working on a client for the R language. I use BaseXClient.java as example. And in R I use the R6 package for object orientation. And at this moment I can login and issue COMMANDs. I guess that at this moment and for this question, these parts of the code are the most essential: - socket-definition: private$sock <- socketConnection(host = "localhost", port = 1984L, open = "w+b", server = FALSE, blocking = TRUE, encoding = "utf-8") - execute a command: execute = function(command) { flush(private$sock) private$send(command) private$info <- private$receive() private$testSock() result <- private$show_receive() return(result) } - get the server-response: receive = function(input, output) { private$info <- NULL if (missing(input) || missing(output)) { output <- raw(0) output <- private$receive(private$sock, output) return(rawToChar(output)) } else { while((rd <- readBin(input, what = "raw", n =1)) >0) { if (rd == 0xff) next output <- append(output, rd) } return(output) } - test the result (Exceptionhandling): testSock = function() { tryCatch({ test <- readBin(private$sock, what = "raw", n =1) }, error = function(e) { print("ERROR") print(e) return(FALSE) }) return(test == 0x00) } I create a session and issue some commands from in a script: Session <- BasexClient$new("localhost", 1984, "admin", "admin") print(Session$execute("xquery 1 to 5")) print(Session$execute("xquery 6 to 10")) print(Session$execute("list")) When testsock is used in the first call, the readBin in the third line returns 00! Perfect! Result is [[1]] [1] "1" "2" "3" "4" "5" When testsock is used for the second call returns 0a ;-( and output is [[1]] character(0) When I comment out the first two calls, result is: [[1]] [1] "Name Resources Size Input Path " [2] "---------------------------------------------------------------------------------------------------------------" [3] "EUR 164 12288704 /home/bengbers/Programs/basex/ " [4] "EUR_Debat 1492 44857696 /home/bengbers/DataScience/TextMining-Web-Analytics/Text-mining case/xml_files/ " [5] "test1 0 4568 " [6] "" [7] "3 database(s)." My question for this moment is, if the response '0a' in testSock is truly the response from the basexserver or is this an error that is returned by the socket? Is the a list that explains the errorcodes returnde by the basex-server? Ben

2 1

OPTIMIZE command error
by Andrey Fedosenko 10 Apr '18

10 Apr '18

Hello, I have the following error while executing the "OPTIMIZE ALL" command: mproper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.6.7 Java: Oracle Corporation, 1.7.0_151 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException: 3 at org.basex.util.Compress.unpack(Compress.java:120) at org.basex.data.DiskData.txt(DiskData.java:284) at org.basex.data.DiskData.text(DiskData.java:251) at org.basex.io.serial.Serializer.node(Serializer.java:415) at org.basex.io.serial.Serializer.node(Serializer.java:158) at org.basex.io.serial.Serializer.node(Serializer.java:345) at org.basex.io.serial.Serializer.node(Serializer.java:158) at org.basex.io.serial.Serializer.serialize(Serializer.java:109) at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) at org.basex.build.Builder.parse(Builder.java:77) at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) at org.basex.core.cmd.ACreate.update(ACreate.java:90) at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) at org.basex.core.Command.run(Command.java:257) at org.basex.core.Command.execute(Command.java:93) at org.basex.server.ClientListener.run(ClientListener.java:139)

2 5

Re: [basex-talk] XSLT Module: feature request - XSLT 3.0 support
by Yitzhak Khabinsky 09 Apr '18

09 Apr '18

Hello, Good news on my end. I was running the following 3 lines in the BaseX Editor: let $doc := 'd:\Temp\CDW\IFRS\InforSunSystems\id0001_TZ20180200_IFRS15_SunSystems_3TZ002.xml' let $stylesheet := 'd:\Temp\CDW\IFRS\InforSunSystems\IFRS15_SunSystemsOut.xslt' return xslt:transform($doc, $stylesheet) And getting the following error message: "" (Line 1): Content is not allowed in prolog. My XSLT stylesheet starts as follows: <?xml version="1.0"?> <xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xpath-default-namespace="http://www.millicom.com" xmlns:functx="http://www.functx.com" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xsl:output method="text" encoding="UTF-8"/> <xsl:strip-space elements="*"/> Based on Martin's input, I changed the last line to: return xslt:transform-text($doc, $stylesheet) And everything is working. Thanks a lot! Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…>

1 0

XSLT Module: feature request - XSLT 3.0 support
by Yitzhak Khabinsky 09 Apr '18

09 Apr '18

Hello, We have Saxon EE edition v.9.8.* licenses and are using XSLT stylesheets compliant with the XSLT 3.0 standard. Unfortunately, BaseX XSLT module currently supports up to XSLT 2.0 standard only. return xslt:processor(), xslt:version() yields the following: Saxon EE 2.0 Though Saxon XSLT processor supports XSLT 3.0 standard. XSLT 3.0 features are available in all Saxon editions. http://saxonica.com/documentation/index.html#!using-xsl/xslt30 And Michael Kay chairs the w3c XSLT group. Are there any plans to add the XSLT 3.0 standard support to the BaseX XSLT module? [cid:image001.png@01D3D004.BB4AE290] Regards, Yitzhak Khabinsky Technical Services Lead Millicom International Services LLC 396 Alhambra Circle, Suite 1100 Coral Gables, FL 33134 Skype4B: +1 (305) 445-4172 Tel: (954) 684-8673 yitzhak.khabinsky(a)millicom.com<mailto:.khabinsky@millicom.com> www.millicom.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.millico…>

2 1

query is not using attribute index with function
by andre weber 09 Apr '18

09 Apr '18

Hi, with the new Version 9 I have encountered a strange performance issue: - Running a simple xpath-query is fast, as it is using the attribute-index. Execution time: 59.19 ms - Putting the same simple xpath-query into a function results in a very poor performance. No use of the attribute-index here. Execution time: 12578.55 ms There where no issues with that in the previous Versions 8.x Here’s the setup… xquery version "3.1"; declare function local:slow_query_here() as node()* { prof:time( db:open("mars","data“)/sec[ @isin = "FR0000125338" ] ) (: 12578.55 ms :) }; let $fast_query_here := prof:time( db:open("mars","data“)/sec[ @isin = "FR0000125338" ] ) (: 59.19 ms :) return local:slow_query_here() Here’s the query plan… <QueryPlan compiled="true" updating="false"> <GFLWOR type="element()*"> <Let type="element()*"> <Var name="$fast_query_here" id="0" type="element()*"/> <ProfTime name="time(value[,label])" type="element()*"> <CachedPath type="element()*"> <ValueAccess index="attribute" type="attribute()*"> <IndexStaticDb name="mars" database="mars"/> <Str type="xs:string">FR0000125338</Str> </ValueAccess> <IterStep axis="self" test="*:base_isin" type="attribute()*"/> <CachedStep axis="parent" test="*:option" type="element()*"> <CachedPath> <IterStep axis="parent" test="*:option_list" type="element()*"/> <IterStep axis="parent" test="*:finance" type="element()*"/> <IterStep axis="parent" test="document-node()" type="document-node()*"/> </CachedPath> </CachedStep> </CachedPath> </ProfTime> </Let> <ProfTime name="time(value[,label])" type="element()*"> <CachedPath type="element()*" database="mars"> <DBNode database="mars" pre="0" type="document-node()"/> <IterStep axis="descendant" test="*:option_list" type="element()*"/> <IterStep axis="child" test="*:option" type="element()*"> <CmpSimpleG op="=" type="xs:boolean" size="1"> <CachedPath type="attribute()?"> <IterStep axis="attribute" test="*:base_isin" type="attribute()?"/> </CachedPath> <Str type="xs:string">FR0000125338</Str> </CmpSimpleG> </IterStep> </CachedPath> </ProfTime> </GFLWOR> </QueryPlan> Any idea what’s causing the performance drop? Thank you for your thoughts! Andre

2 2

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk