BaseX-Talk October 2018

basex-talk@mailman.uni-konstanz.de

25 participants
33 discussions

Websocket Vers. 9.1 on Tomcat
by Dieter Zanzinger 22 Oct '18

22 Oct '18

Hi, BaseX-Team, I tested the new websocket-feature. The .zip- installation on Win10 (your embedded jetty) worked (your chat-app). But I had problems with the .war -installation on tomcat. With the standard-installation, the paths in the chat.js had to be preceded with /BaseX - ok so far. I get the login-page and main-page visible - ok. But when the main-page is loading, the network call to http://localhost:8080/BaseX/ws/chat <http://localhost:8080/BaseX/ws/chat> fails with http-code 404. I think, there is a problem with paths as well? It would be great, if you could add documentation for Tomcat as well. Thanks for this great tool! Dieter Zanzinger

2 1

Bug/question: large collection
by Marko Niinimaki 22 Oct '18

22 Oct '18

Hi, it looks like "nodes" exceeds some integer range if I add 2 million documents (below). Another, unrelated question: our server has 24 cores. What would be the best way to utilize that kind of parallel power in queries? > info db Database Properties NAME: tmp SIZE: 47 GB NODES: -2147476286 DOCUMENTS: 705708 BINARIES: 0 TIMESTAMP: 2018-08-29T02:27:58.000Z UPTODATE: false Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 9.0.2 Java: Oracle Corporation, 1.8.0_66 OS: Linux, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException

2 4

Missing two things but great tool!
by Jennifer Kracht 22 Oct '18

22 Oct '18

Hi, thank you for this handy and comprehensive tool! I have tested other „non-open source“ but they are not working so smart like this. When I started working with XML files I had problems to find the relevant information. But this tool helped me a lot to figure out the general structure. There are just two things that I‘m missing and wanted to ask if this is planned for future: 1. I really like the map visualisation possibility. I use lot of XML with coordinates and I was impressed that the tool could figure out them automatically. But it would be much more cooler to see it with a real map in background. 2. I tried to export the XML to CSV but this seems not working. The exported file is not usable. In past I just used Excel and it’s source task pane to bring it into a table format (filtering and sorting) so an export to Excel woud be cool! I understand that it’s an open source application but maybe you have possibilities to do something for it. Best Regards Jennifer

2 1

Tomcat & services
by Marco Lettere 16 Oct '18

16 Oct '18

Dear all, has anyone experience with exploiting the persistent jobs (services) feature under Tomcat? We have installed services with the proper jobs.xml file. When running jobs:services() in the DBA after startup, we get the services listed. Nevertheless none of the XQuery scripts inside the jobs is executed at startup of the Tomcat. When running standalone with Jetty, the scripts are executed even if, in this case, we are getting empty results when running jobs:services() in the DBA after startup. Any clue on what we should double-check? Thanks, Marco.

3 9

Change the default user and its Password
by DK Singh 11 Oct '18

11 Oct '18

Hi All, I have to change the default user credential of BaseX where should i made the changes, when i access the url "http://localhost:8984/dba" now it opens with the default credentials which is "admin" now i have to change it, i have made the changes in the web.xml <context-param> <param-name>org.basex.user</param-name> <param-value>dharmendra</param-value> </context-param> but it is not working still it is taking the default credentials. Regards Dharmendra Kumar Singh

1 0

Output `out:format` function question
by Bridger Dyson-Smith 08 Oct '18

08 Oct '18

Hi all - I'm confused about some notation in the `out:format`[1] signature. In the wiki, I see out:format($format as xs:string, $item1 as item(), ...) as xs:string and in v9.0.2 (and the latest v9.1 beta) GUI, I see the following info: out:format(format,item1[,...]) But I'm confused by the `[,...]`. What does this mean? I've tried the following: out:format("%06d", 256) -> 000256 (: stolen from the wiki :) out:format("%06d", 256, 367) -> 000256 (: the second item() is ignored :) let $n := <t><i>256</i></t> out:format("%06d", $n) -> IllegalFormatConversionException: java.util.IllegalFormatConversionException: d != java.lang.String. I'm weak on my data model types for sure, but how should the signature here be interpreted? Thanks for your help! Best, Bridger [1] http://docs.basex.org/wiki/Output_Module#out:format

2 2

Dynamic value for collation in FLWOR?
by Andreas Mixich 05 Oct '18

05 Oct '18

Hi, this: for $i in $item let $lang := concat("?lang=", $item/@xml:lang/string()) order by $i collation $lang return $i does not work: "[XPST0003] Expecting quote, found '$'." Any way to do this dynamically? Wouldn't order by $i collation $item/@xml:lang/string() make sense? -- Goody Bye, Minden jót, Mit freundlichen Grüßen, Andreas Mixich

2 1

BaseX DBA via Docker
by Michael Wapp 02 Oct '18

02 Oct '18

Hi! I'm not able to access the DBA when the HTTP server is started using docker. The ports are correctly exposed. When accessing localhost:8984/dba, I get the response: /No function found that matches the request./ The docker command I use is the following: /docker run -d \// // --name basexhttp \// // --publish 1984:1984 \// // --publish 8984:8984 \// // --volume "$HOME/basex/data":/srv/basex/data \// // basex/basexhttp:latest/ Does anybody have an idea what I'm doing wrong? (If this is not the right way to ask questions about BaseX and docker - where else could I find some help?) Kind Regards Michael Wapp

2 1

Re: [basex-talk] JAVA xquery: accessing documents
by Christian Grün 02 Oct '18

02 Oct '18

Hi Jan (cc to the list), > why is doc("users.xml") not working although the database has been > opened before? It says "resource 'home/jan/..../users.xml not found'.. > > doc("main/users.xml") is working. See the following lines in our documentation: If the argument of fn:doc or fn:collection does not start with a valid database name, or if the addressed database does not exist, the string is interpreted as URI reference, and the documents found at this location will be returned. If the DEFAULTDB option is turned on, the path argument of the fn:doc or fn:collection function will first be resolved against the globally opened database. Hope this helps, Christian

1 0

problem with namespace
by radim-havlicek＠post.cz 02 Oct '18

02 Oct '18

Hello, I have problem with namespace 'www.ni.com/TestStand/ATMLTestResults/3.0'. It works for "return" statement, but when I use a value from this namespace in "where" or "order by" statement, the query returns just an empty string, like no results would have been found, although they exist. In more detail, I have following query: ----------------------------------------------- declare namespace nTestResultsCollection='urn:IEEE-1636.1:2013: TestResultsCollection'; declare namespace nTestResults='urn:IEEE-1636.1:2013:TestResults'; declare namespace nCommon='urn:IEEE-1671:2010:Common'; declare namespace nNi='www.ni.com/TestStand/ATMLTestResults/3.0'; let $DocumentNames := ('Report/89500019-0000-4020-a039-9f53a80d7058', 'Report/89400019-0052-4020-a0f0-e1851b8bbec2', 'Report/00000000-0000-4020-a 093-6c29d4c65c32', 'Report/00000000-0000-4020-a09c-ac632bfa5a7d', 'Report/ 00000000-0000-4020-a09c-ac635023a45c', 'Report/00000000-0000-4020-a09c-ac63e 9c5b490', 'Report/89500019-0051-4020-a170-409bbe8e4f89', 'Report/89500019- 0051-4020-a170-409b334e86c8') for $DocumentName in $DocumentNames let $Document := db:open('ATML',$DocumentName) let $TestSystemItem0 := $Document/nTestResultsCollection: TestResultsCollection/nTestResultsCollection:TestResults/nTestResults: TestStation/nCommon:Definition/nCommon:Identification/nCommon:ModelName/text () let $TestSystemItem1 := $Document/nTestResultsCollection: TestResultsCollection/nTestResultsCollection:TestResults/nTestResults: TestStation/nCommon:Definition/nCommon:Extension/nNi:Items/nNi:Item/Content/ text() let $StartDate := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/nTestResults:ResultSet/substring-before (data(@startDateTime), 'T') let $StartTime := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/nTestResults:ResultSet/substring-after (data(@startDateTime), 'T') let $UUID := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/data(@uuid) let $Serial_Number := $Document/nTestResultsCollection: TestResultsCollection/nTestResultsCollection:TestResults/nTestResults:UUT/ nCommon:SerialNumber/text() let $Part_Number := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/nTestResults:UUT/nCommon:Definition/data( @name) let $Slot_ID := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/nTestResults:TestStation/nCommon: Definition/nCommon:Extension/nNi:Items/nNi:Item/Content/text() where (($TestSystemItem1 = 'dx5484')) order by $StartDate, $StartTime return <Result> <DocumentName>{ $DocumentName }</DocumentName> <TestSystemItem0>{ $TestSystemItem0 }</TestSystemItem0> <TestSystemItem1>{ $TestSystemItem1 }</TestSystemItem1> <StartDate>{ $StartDate }</StartDate> <StartTime>{ $StartTime }</StartTime> <Serial_Number>{ $Serial_Number }</Serial_Number> <Part_Number>{ $Part_Number }</Part_Number> <Slot_ID>{ $Slot_ID }</Slot_ID> <Additional_Info></Additional_Info> <ChildResults> { let $Childs := $Document/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/nTestResults:ResultSet//nTestResults: TestGroup/nTestResults:Test for $Test in $Childs let $TestData := $Test/nTestResults:TestResult/nTestResults:TestData let $Limits := $Test/nTestResults:TestResult/nTestResults:TestLimits/ nTestResults:Limits let $TestId := $Test/data(@ID) let $TestName := $Test/data(@name) let $TestGroup := $Test/../substring-after(data(@name), '#') let $TestOutcome := $Test/nTestResults:Outcome/data(@value) let $Root := $Test/root() let $RootUuid := $Root/nTestResultsCollection:TestResultsCollection/ nTestResultsCollection:TestResults/data(@uuid) where (($TestName = 'Course Datum MON (7V)' and $TestGroup = 'Course Datum Input Test' and $RootUuid = $UUID)) return <Test> <TestData>{ $TestData }</TestData> <Limits>{ $Limits }</Limits> <TestId>{ $TestId }</TestId> <TestName>{ $TestName }</TestName> <TestGroup>{ $TestGroup }</TestGroup> <TestOutcome>{ $TestOutcome }</TestOutcome> <Temperature></Temperature> </Test> } </ChildResults> </Result> ----------------------------------------------- If I remove the where (($TestSystemItem1 = 'dx5484')) statement ($ TestSystemItem1 is from nNi namespace), it works fine and TestSystemItem1 values are returned properly in the result in the <TestSystemItem1>{ $ TestSystemItem1 }</TestSystemItem1>. However, if I put the $TestSystemItem1 to the where statement (like in the example above), or to the order by statement, it returns empty result. Is there a way how to fix it? Or is it fixable in the BaseX itself (maybe in the new version)? We cannot change the value of 'www.ni.com/TestStand/ ATMLTestResults/3.0' because the xml files are generated by the 3rd party. Thank you for your help in advance. Best regards, Radim Havlicek

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk October 2018