BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5251 discussions

slow DB when updating
by radim-havlicek＠post.cz 30 Oct '18

30 Oct '18

Hello, when one client is uploading file to a database (let's say Database1), upd. basex file is created and exists until the file is uploaded to the database Database1. Problem is that meanwhile the upload is running, all other clients reading data from the Database1 read the data very, very slowly. Also clients trying to read data from Database2 or Database3 reads the data very, very slowly while the upload to Database1 is running. Also the client trying to upload data to Database2 is not successful until the upload to Database1 is done. Database1, Database2 and Database3 are databases in the same BaseX database. Can I speed up the loading data from various databases at the same time or the parallel uploading? I've read about the PARALLEL option in .basex option file, but are there any best practices what the value should be regarding to the database size or the number of databases? And are there similar best practices to CACHETIMEOUT, TIMEOUT and KEEPALIVE options? Are there more information than what is at http://docs.basex.org/wiki/Options ? Thanks for your reply in advance. Best regards, Radim Havlicek

2 1

How to pass an XPath expression as parameter?
by Andreas Mixich 29 Oct '18

29 Oct '18

Is there a way to do something like this? declare function local:insert( $doc as node(), $at-location as xpath(), (: I know, there is no 'xpath' type, this is just for demo :) $what as node()* ) as node() { copy $c := $doc modify insert node $what into $at-location return $c }; let $xml := <xml><body><p>This is a paragraph.</p></body></xml> let $nd := <this><is><a>Test</a></is></this> return local:insert($xml, xpath("/body"), $nd) As I see it, it would need a dynamic xs:string => XPath expression conversion or a defer XPath expression, which both do not exist, for $at-location. I managed to do this, however: declare function local:insert($doc, $at-location, $what) { let $update := ``[ declare variable $doc external; declare variable $what external; declare variable $at-location external; copy $c := $doc modify insert node $what into `{$at-location}` return $c ]`` return xquery:eval($update, map{ 'doc':$doc, 'at-location':$at-location, '$what':$what }) }; let $xml := <xml><body><p>This is a paragraph.</p></body></xml> let $node := <this><is><a>Test</a></is></this> return local:insert($xml, "$c/body", $node) Ideally (for me), there would be a 'defer' XPath expression, that starts its life as a string (when passed) and then unfolds upon call. Or a type (or function) fn:xpath(), that behaves that way. Or am I just blind and don't see the obvious, and there *is* a simpler solution? -- Minden jót, all the best, Alles Gute, Andreas Mixich

2 2

BaseX-standard-installation-with-embedded-jetty-- how to deploy other webapp
by Dieter Zanzinger 27 Oct '18

27 Oct '18

Dear BaseX-fellows, the websocket-feature in 9.1 is great. Now- to use ist, I need the BaseX-Version with embedded Jetty. My problem is, that I need another web app, too. Up to now, I used Tomcat as container for BaseX and the other webapp. Is it possible, to deploy another app in the embedded Jetty ? Any hints, how to do that? In Tomcat and - as far as I know in a standard Jetty installation - I just copy the .war into the webapps-Folder. That doesn´t work in the embedded Jetty. I would be glad for hints. Sincerely Dieter Zanzinger

2 1

fn:format-number() for german style numbers
by Wiemer, Sebastian 27 Oct '18

27 Oct '18

2 1

Database Updates
by Dave Kopecek 25 Oct '18

25 Oct '18

Hi All, Given a database created from catalog.xml below. What's the best way to update & add records received daily as in file daily-update.xml ? Coming from relational DBs & new to this. I ultimately need to script/automate this. Hoping there's some magic command I'm missing & looking for best way to approach the problem. Thanks, -Dave catalog.xml <?xml version="1.0" encoding="UTF-8"?> <CATALOG> <ENTRIES> <ENTRY> <SKU>1</SKU> <TITLE>Empire Burlesque</TITLE> <ARTIST>Dylan</ARTIST> <PRICE>10.90</PRICE> </ENTRY> <ENTRY> <SKU>2</SKU> <TITLE>Hide your heart</TITLE> <ARTIST>Bonnie Tyler</ARTIST> <PRICE>9.90</PRICE> </ENTRY> </ENTRIES> </CATALOG> daily-update.xml <?xml version="1.0" encoding="UTF-8"?> <CATALOG> <ENTRIES> <ENTRY> <SKU>1</SKU> <PRICE>19.90</PRICE> <NEWTHING>I wasn't here before the update</NEWTHING> </ENTRY> <ENTRY> <SKU>1971</SKU> <TITLE>Tupelo Honey</TITLE> <ARTIST>Van Morrison</ARTIST> <PRICE>8.20</PRICE> </ENTRY> </ENTRIES> </CATALOG>

3 5

Websocket chat and session
by Maximilian Gärber 24 Oct '18

24 Oct '18

Hi, we've chat working with the 9.1 snapshot. Also private message works but only if the BaseXHTTP class is used (embedded jetty). If we start the webapp with mvn jetty:run the session info seems to get lost (also in the DBA). Br, Max

2 2

Sir, when basex 9.1, please ;-)
by Maximilian Gärber 24 Oct '18

24 Oct '18

3 5

determine index use in xquery:eval
by Johannes Echterhoff 24 Oct '18

24 Oct '18

Hello, Is there a way to determine if the query that is executed by xquery:eval(...) makes use of index information? Can we somehow obtain the optimized plan for that query? Best regards, Johannes

2 2

Re: [basex-talk] Importing XML (DITA) validated with Relax NG schemas?
by Christian Grün 24 Oct '18

24 Oct '18

Hi Jason (cc to the list), > I set the CP variable like so: > CP=$MAIN/BaseX.jar:$MAIN/lib/custom/dita-ng.jar:$MAIN/lib/*:$MAIN/lib/custom/*:$CLASSPATH > > This appears to be slightly different than the example you linked Christian. I’m using BaseX 9.0.2. Does this make a difference? The start scripts in the official distributions are created from the GitHub examples I linked, so they are slightly different. > I added an echo $CLASSPATH line under the CP variable. When I run the script, the echo statement is blank. In the script, no value will be bound to the $CLASSPATH variable. Instead, you can assign values to this variable by yourself, which will then be appended to the $CP variable. If you didn’t do so, and if your Linux environment does not have any other values assigned to this variable (which is the default), the output will necessarily be empty. > Is there a way to see how the classpath is set when running this script? To answer the "how": It will be set via the line that you will find some lines below in the script, and the -cp Java argument: exec java -cp "$CP" $BASEX_JVM org.basex.BaseX "$@" If you want to know which value is bound to $CP, try "echo $CP". In Java, the full user class path at runtime will be bound to the "java.class.path" system property. It can e.g. be retrieved via proc:property('java.class.path') [1]. Christian [1] http://docs.basex.org/wiki/Process_Module#proc:property

3 5

REQUEST REPLACE error
by radim-havlicek＠post.cz 23 Oct '18

23 Oct '18

Hello, we have currently 9 databases in our BaseX database. The biggest ones have about 9 GB, all together they have nearly 26 GB. Everything had worked fine until Friday. Since Friday, every time we sent REQUEST REPLACE command to any of those databases, it generated following error: 00:00:17.672 0.0.0.1:64492 admin REQUEST REPLACE Report\8f6a4b73-5be2-4246-b 0ad-3baaec0fbd54 [...] 4.16 ms 00:00:18.282 0.0.0.1:64492 admin ERROR Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 8.6.3 Java: Oracle Corporation, 1.8.0_171 OS: Windows Server 2012 R2, amd64 Stack Trace: java.lang.ArrayIndexOutOfBoundsException at org.basex.io. random.TableDiskAccess.insert(TableDiskAccess.java:347) at org.basex.data. Data.insert(Data.java:912) at org.basex.data.Data.insert(Data.java:739) at org.basex.query.up.atomic.Insert.apply(Insert.java:44) at org.basex.query. up.atomic.AtomicUpdateCache.applyUpdates(AtomicUpdateCache.java:297) at org. basex.query.up.atomic.AtomicUpdateCache.execute(AtomicUpdateCache.java:281) at org.basex.core.cmd.Replace.replace(Replace.java:104) at org.basex.core. cmd.Replace.access$0(Replace.java:69) at org.basex.core.cmd.Replace$1.run (Replace.java:57) at org.basex.core.cmd.ACreate.update(ACreate.java:90) at org.basex.core.cmd.Replace.run(Replace.java:54) at org.basex.core.Command. run(Command.java:257) at org.basex.core.Command.execute(Command.ja... 612.41 ms (It is from the log file.) We currently use BaseX version 8.6.3 Any idea why the error is generated and what could be the source of the problem? (Too big database? Too big databases all together? Some database lock?) Thank you in advance for your answer. Best Regards, Radim Havlicek

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk