BaseX-Talk

basex-talk@mailman.uni-konstanz.de

13 participants
5244 discussions

sum() is returning inaccurate sums
by Jay Straw 17 Jun '20

17 Jun '20

Hi all, I'm building a budgeting system for home use, using XSLTForms and -- ready for it? -- BaseX! sum() has been behaving weird. I'm adding USD, which means only 2 decimals of precision. But depending on the combination of elements I add, I'll get a long double that's inaccurate. Sometimes it returns what I expect, sometimes it doesn't, but either case is repeatable. Take these 3 receipts: 1 -- <receipt uuid="694bf777-2d40-42ad-9809-97dfe6b04f40"> <metadata> <date>2020-06-08</date> <store> <name>Frigid North</name> <location/> </store> <purchaser>Jay</purchaser> <account>Debit</account> <category>shop-general</category> <net-total-computed>6.50</net-total-computed> <tip>0.00</tip> <gross>6.50</gross> </metadata> <item> <name>Start Capacitor (for old rockwell saw/jointer motor)</name> <cost>6.50</cost> <qty>1</qty> <total>6.50</total> <category>shop-general</category> </item> </receipt> 2 -- <receipt uuid="2eb74e82-3db5-4bd9-a591-8621c79f3fd6"> <metadata> <date>2020-06-09</date> <store> <name>Home Depot</name> <location>Tudor</location> </store> <purchaser>Jay</purchaser> <account>Cash</account> <category>jay-misc</category> <net-total-computed>9.87</net-total-computed> <tip>0</tip> <gross>9.87</gross> </metadata> <item> <name>Stainless Protractor</name> <cost>9.87</cost> <qty>1</qty> <total>9.87</total> <category>jay-misc</category> </item> </receipt> 3 -- <receipt uuid="1f1462e6-b37f-4daa-b293-29b9ec353627"> <metadata> <date>2018-09-16</date> <store> <name>Title Wave</name> <location>Midtown</location> </store> <purchaser>Franny</purchaser> <account>Debit</account> <category>books</category> <net-total-computed>20.85</net-total-computed> <tip/> <gross>20.85</gross> </metadata> <item> <name>Music of the Spheres</name> <category>books</category> <cost>6.95</cost> <qty>1</qty> <total>6.95</total> </item> <item> <name>Magic Mirror of M. C. Escher</name> <cost>8.95</cost> <qty>1</qty> <total>8.95</total> <category>books</category> </item> <item> <name>Daumier 120 Great Lithographs</name> <cost>4.95</cost> <qty>1</qty> <total>4.95</total> <category>books</category> </item> </receipt> When I sum the <gross/> elements: sum 1 & 2 = 16.369999999999997 sum 1 & 3 = 27.35 sum 2 & 3 = 30.72 What makes certain combinations return such crazy numbers? I did find one other thread in the mailing list about this, it got an answer but didn't really explain much. I have a schema for prices in the XForm, should I be loading that somehow? The only workaround I have now is like, "let $grosses:= for $gross in $receipts//gross return xs:decimal($gross)" but I'm hoping there's a more straightforward way. Not sure if this is implementation specific or if it's not defined or what. If I should ask elsewhere, please let me know :-) Be well, Jay

2 2

Writing 
by Giuseppe G. A. Celano 11 Jun '20

11 Jun '20

Hi, I would like to print a comment containing only a dash (i.e., ) , but this is not allowed. I tried to use "-" instead of - in comment { "-” }, but such a string is converted to ‘-', so the error is still there. How can I print  ? Should I simply use <----->? In any case, I see that data() does not convert - into -: how can I get the conversion? Thanks. Best, Giuseppe

2 1

RestXQ and Docker
by Hinkelmanns Peter 11 Jun '20

11 Jun '20

Dear list, I'm using BaseX in a Docker container and I am able to add XML-Files to Databases. But I am not allowed to edit 'restxq.xqm' or to add something to the '/webapp' directory. Changing permissions with 'chown -R 1984 ~/webapp/' via bash doesn't work. What do I need to do, to be able to use my own restxq-module within the docker container of basex? Thanks in advance Peter <https://twitter.com/MHD_BDB>

2 1

S1000D XML Database
by Roger Jerrell 08 Jun '20

08 Jun '20

I am completely new to basex so forgive me please for asking something that has been asked before. Can anyone share any knowledge about the use of basex to manage S1000D XML content? Specifically, I'm interested in it's use as an offline xml database manager for a large collection of S1000D data modules: 100k or more perhaps 5GB of data uncompressed. Any comments or thoughts or tips are greatly welcomed and appreciated. Roger Technical Publications Engineer Renton, WA, USA

2 1

GUI Stack Trace
by Ben Pracht 08 Jun '20

08 Jun '20

Hi Folks, I got this error trying to specify a directory location when creating a database using the GUI by dialog. Creating the database via command works. I feel like this is somehow not the fault of BaseX because I don't see this on my other Linux machine. Nonetheless, I'd like recommendations on how the Linux side of the basex community works. My setup: cat /etc/*release edora release 30 (Thirty) NAME=Fedora VERSION="30 (Workstation Edition)" ID=fedora VERSION_ID=30 VERSION_CODENAME="" PLATFORM_ID="platform:f30" PRETTY_NAME="Fedora 30 (Workstation Edition)" ANSI_COLOR="0;34" LOGO=fedora-logo-icon CPE_NAME="cpe:/o:fedoraproject:fedora:30" HOME_URL="https://fedoraproject.org/" DOCUMENTATION_URL=" https://docs.fedoraproject.org/en-US/fedora/f30/system-administrators-guide/ " SUPPORT_URL="https://fedoraproject.org/wiki/Communicating_and_getting_help" BUG_REPORT_URL="https://bugzilla.redhat.com/" REDHAT_BUGZILLA_PRODUCT="Fedora" REDHAT_BUGZILLA_PRODUCT_VERSION=30 REDHAT_SUPPORT_PRODUCT="Fedora" REDHAT_SUPPORT_PRODUCT_VERSION=30 PRIVACY_POLICY_URL="https://fedoraproject.org/wiki/Legal:PrivacyPolicy" VARIANT="Workstation Edition" VARIANT_ID=workstation Fedora release 30 (Thirty) Fedora release 30 (Thirty) export |grep DESKTOP declare -x DESKTOP_SESSION="/usr/share/xsessions/cinnamon2d" declare -x GNOME_DESKTOP_SESSION_ID="this-is-deprecated" declare -x IMSETTINGS_INTEGRATE_DESKTOP="yes" declare -x XDG_CURRENT_DESKTOP="X-Cinnamon" declare -x XDG_SESSION_DESKTOP="" bpracht2@pracht-office-closet basex-rent-world]$ java -cp /home/bpracht/rent-world/basex-rent-world/BaseX.jar:/home/bpracht/rent-world/basex-rent-world/lib/custom/*:/home/bpracht/rent-world/basex-rent-world/lib/*: -Xms2g -Xmx4g org.basex.BaseXGUI Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException at javax.swing.JLabel.setIcon(JLabel.java:406) at org.basex.gui.view.project.ProjectCellRenderer.getTreeCellRendererComponent(ProjectCellRenderer.java:29) at javax.swing.plaf.basic.BasicTreeUI$NodeDimensionsHandler.getNodeDimensions(BasicTreeUI.java:2807) at javax.swing.tree.AbstractLayoutCache.getNodeDimensions(AbstractLayoutCache.java:492) at javax.swing.tree.FixedHeightLayoutCache.getBounds(FixedHeightLayoutCache.java:553) at javax.swing.tree.FixedHeightLayoutCache.getBounds(FixedHeightLayoutCache.java:199) at javax.swing.tree.AbstractLayoutCache.getPreferredHeight(AbstractLayoutCache.java:190) at javax.swing.plaf.basic.BasicTreeUI.updateCachedPreferredSize(BasicTreeUI.java:1902) at javax.swing.plaf.basic.BasicTreeUI.getPreferredSize(BasicTreeUI.java:2003) at javax.swing.plaf.basic.BasicTreeUI.getPreferredSize(BasicTreeUI.java:1991) at javax.swing.JComponent.getPreferredSize(JComponent.java:1662) at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:791) at java.awt.Container.layout(Container.java:1513) at java.awt.Container.doLayout(Container.java:1502) at java.awt.Container.validateTree(Container.java:1698) at java.awt.Container.validate(Container.java:1633) at javax.swing.RepaintManager$3.run(RepaintManager.java:711) at javax.swing.RepaintManager$3.run(RepaintManager.java:709) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at javax.swing.RepaintManager.validateInvalidComponents(RepaintManager.java:708) at javax.swing.RepaintManager$ProcessingRunnable.run(RepaintManager.java:1731) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) Best Regards, Ben Pracht ben.pracht(a)gmail.com

3 5

Serializing with xml-stylesheet prolog
by Jay Straw 07 Jun '20

07 Jun '20

Hi, Been a while since I've posted. Been a while since I programmed! I need to run a client-side stylesheet (XSLTForms, I tried it server side, didn't work), but getting my assembled XHTML document to output with <?xml-stylesheet ...?> has been hard. After searching https://docs.basex.org/wiki/Serialization, http://www.w3.org/TR/xslt-xquery-serialization-31/#serparams-in-xdm-instance, searching this list, lots of googling with prolog/declaration/other words, I came up empty. So I tried other things. But those other things worked poorly, and when things did come out in the right order, with the right namespaces etc, the single page app that worked as a standalone document, doesn't work. If I copy and paste raw output from basex that my browser receives, put it in a new file in the same directory, and open that in my browser it works fine. So there's gotta be some issue with my workaround. So I'm hoping you can tell me what I've missed in my searches, so that I don't need a workaround :-) I haven't built anything in a few years, but I've been subscribed to this list for many many years and you're all such a patient, wonderful lot. Thank you all so much. Be well, Jay Straw

2 1

java.lang.ArrayIndexOutOfBoundsException on REST GETrequest
by Geoff Alexander 06 Jun '20

06 Jun '20

We have a BaseX application that uses the BaseX REST API. A number of GET requests are failing with an HTTP 400 Bad Request response. Looking at the BaseX logs, I find that BaseX is internally throwing java.lang.ArrayIndexOutOfBoundsException for these HTTP 400 Bad Request failures: <entry time="05:13:57.193" address="***.***.***.***:*****" user="admin" type="400" ms="3.93">[GET] https://********.*******.ibm.com:10443/BaseX/rest/****/*******.xml; Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.6.7 Java: IBM Corporation, 1.8.0_241 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException 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:370) at org.basex.io.serial.Serializer.node(Serializer.java:158) at org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:105) 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.StandardSerializer.node(StandardSerializer.java:105) at org.basex.io.serial.AdaptiveSerializer.node (AdaptiveSerializer.java:75) at org.basex.io.serial.Serializer.serialize (Serializer.java:109) at org.basex.io.serial.AdaptiveSerializer.serialize (AdaptiveSerializer.java:66) at org....</entry> I realize that BaseX 8.6.7 is somewhat old. I can look at upgrading to a more recent version if necessary. But before I do that, I'd like to know if the java.lang.ArrayIndexOutOfBoundsException is a known problem and more importantly if there is anything we can do short of upgrading BaseX to fix the problem. Thanks, Geoff Alexander, Ph.D. Software Engineer, Corporate Tools Development IBM Corporation Charlotte, NC

2 1

[FULLTEXT] How to search for underscore seperated words ?
by ETANCHAUD Fabrice 05 Jun '20

05 Jun '20

Hi all BaseX users, When I search for 'YET_ANOTHER_SILLY_KEYWORD', ft:search gives me all text nodes containing any of the YET ANOTHER SILLY KEYWORD words. I tried the different search modes, but could not find a way to get ft:search return only the text nodes containing the concatenation. Does anybody have a solution ? Best regards, [MAIF] Fabrice ETANCHAUD Unité Etudes Informatiques - MAIF VIE 50 avenue Salvador Allende 79029 Niort Cedex 9 fabrice.etanchaud(a)maif.fr MAIF.FR<http://www.maif.fr/> | Retrouvez-nous aussi sur [Facebook] <https://www.facebook.com/MAIFassureur> [Twitter] <https://twitter.com/MAIF> [Youtube] <https://www.youtube.com/user/maif>

3 3

HashMap insertion bug - node ID is different on get than on put
by Buddy Kresge 05 Jun '20

05 Jun '20

This can be reproduced in 9.2.4 and 9.3.3 (only tried those 2 versions) We are using java:HashMap, and we are seeing that when we insert a node into the HashMap from a file and do a subsequent hash:get, the generate-id() for the hash:get is different than the original generate-id value from the hash:put. Note: when we read the XML from a file, that is when we see the issue, if we declare the XML in Basex GUI, we do NOT see this behavior. Here are the examples: Scenario #1: XML is a variable in the BaseX GUI session --- no bug ---------------------------------------------------------------------------------------- declare namespace hash = "java:java.util.HashMap"; let $data := <A> <B> <C> <Message>Hi there</Message> <Message>How are you</Message> <D> <E>1</E> </D> </C> </B> </A> let $node := $data//*:C let $kb := hash:new() let $nullOp := hash:put($kb, generate-id($node), $node) let $getNode := hash:get($kb, generate-id($node)) return (generate-id($node), generate-id($getNode)) Result: id6312150 id6312150 Scenario #2: XML is read in from a file --- bug appears ---------------------------------------------------------------------------------------- Move the data into a file and then read in from the file, that is when we see the issue. declare namespace hash = "java:java.util.HashMap"; let $file := doc('SampleData.xml') let $node := $file//*:C[1] let $kb := hash:new() let $null := hash:put($kb, generate-id($node), $node) let $getNode := hash:get($kb, generate-id($node)) return (generate-id($node), generate-id($getNode)) Result: id30601d5 id30602d0 Thanks in advance for your assistance Buddy

2 1

Random Numbers from Random.org
by Leo Studer 03 Jun '20

03 Jun '20

Hello I try to use random numbers from random.org. Here my xpath let $urand := function(){doc("https://www.random.org/integers/?num=1&min=0&max=1000000000&col…")//*:pre/number() div 1000000000} return for $i in 1 to 10 return $urand() Which brings 10 time the same value, however, every run time a different one. What is wrong with this code? Thanks in advance for your valuable input Yours Leo

3 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk