BaseX-Talk

basex-talk@mailman.uni-konstanz.de

6 participants
5250 discussions

Increasing memory allocated to BaseX
by Steve Baskauf 12 May '15

12 May '15

I am running BaseX 8.1 on a Win7 machine with 8GB memory. I have a query that loads data from several CSV files, then generates a RDF/XML dump into a single, very large file (1370000 lines). When I run the query using the BaseX GUI, I get an "Out of Main Memory" error. I am able to get the query to complete via the command line, which is fine for the moment, but if the database gets larger, I'm anticipating that I won't be able to use it. An obvious solution would be to generate several smaller files, but the real problem is that BaseX doesn't seem to be utilizing all of the available memory. When I monitored memory utilization, it was only utilizing a small fraction of the available memory. I tried increasing the allocated memory by changing the BASEX_JVM=-Xmx512m to BASEX_JVM=-Xmx1024m line in the basex.bat and basexgui.bat files, but that didn't seem to have any effect - I still run out of memory and there is plenty of unused memory in the system. I must be missing something. Is there a simple change that I can make to make more memory available to BaseX? For reference purposes, the query I'm running is at https://github.com/baskaufs/test/blob/master/image-all-hack.xq Steve Baskauf

2 1

Basex Standalone : [bxerr:BXSQ0007] Could not initialize supplied driver: 'com.mysql.jdbc.Driver'
by jean-marc Mercier 12 May '15

12 May '15

Hi, I am struggling to use Basex sql module together with Basex Standalone. I am getting the error : [bxerr:BXSQ0007] Could not initialize supplied driver: 'com.mysql.jdbc.Driver' The sql connection works finely while using the Basex server. I guess that it might be due to the fact that I don't know how to include multiple jar while using with eclipse. I tried to go to Windows/Preferences/XQUERY/Interpreters and set -classpath {BaseXDirectory}\lib\*, but it does not work. Maybe somebody already met this small issue before ? Thanks for your answer, cheers

2 10

EXPath package format
by Andy Bunce 12 May '15

12 May '15

Hi, It appears the EXPath package format has changed. The current version of the spec reads: the root of the ZIP file contains a directory named *content*, containing the components and any other file the package needs. http://expath.org/spec/pkg#descriptor A previous version http://expath.org/spec/pkg/20100107#d2e112 reads Alongside this descriptor, the root of the ZIP file contains a directory *named after the module name* (see below) which contains the components and any other file the package needs. BaseX appears only to support this earlier version. If a package using a *content* folder is installed the following error is reported: [bxerr:BXRE0004] Package descriptor: Invalid attribute 'name' /Andy

3 7

Trigger to apply statements on technical events ?
by cmarchand＠oxiane.com 12 May '15

12 May '15

Hello ! I've had this problem : I've forgotten a db:optimize(...) after a delete nodes operation. The following xquery has been 60 times slower than before. Is there a way to detect an update operation, and a way to know on which database the update occurs, to run automatically a db:optimize(...) each time a update xquery is run ? Christophe

2 2

java.io.StreamClosed ignorable ?
by cmarchand＠oxiane.com 11 May '15

11 May '15

Hello ! I have some java.io.IOException - Stream closed while performing updating XQueries. Thez are logged in basexgui java console, but in GUI, xquery is not interrupted, no error happens. Are these exceptions ignorables ? i.e. if process in GUI is not interrupted, is a fallback run and the log only informative ? Here is a partial stack-trace... BaseX 7.9 is used Best regards, Christophe java.io.IOException: Stream Closed at java.io.RandomAccessFile.seek(Native Method) at org.basex.io.random.TableDiskAccess.readBlock(TableDiskAccess.java:570) at org.basex.io.random.TableDiskAccess.readPage(TableDiskAccess.java:535) at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:514) at org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:194) at org.basex.data.Data.kind(Data.java:284) at org.basex.query.value.node.DBNode.<init>(DBNode.java:53) at org.basex.query.value.seq.DBNodeSeq.itemAt(DBNodeSeq.java:65) at org.basex.query.value.seq.DBNodeSeq.itemAt(DBNodeSeq.java:19) at org.basex.query.value.seq.Seq.toString(Seq.java:145) at org.basex.query.value.seq.Seq.toString(Seq.java:133) at org.basex.util.TokenBuilder.addExt(TokenBuilder.java:348) at org.basex.util.TokenBuilder.addSep(TokenBuilder.java:311) at org.basex.query.expr.Arr.toString(Arr.java:120) at org.basex.query.func.StaticFuncCall.toString(StaticFuncCall.java:140) at java.lang.String.valueOf(String.java:2847) at java.lang.StringBuilder.append(StringBuilder.java:128) at org.basex.query.gflwor.For.toString(For.java:126) at java.lang.String.valueOf(String.java:2847) at java.lang.StringBuilder.append(StringBuilder.java:128) at org.basex.query.gflwor.GFLWOR.toString(GFLWOR.java:669) at org.basex.util.TokenBuilder.addExt(TokenBuilder.java:348) at org.basex.util.TokenBuilder.addSep(TokenBuilder.java:311) at org.basex.query.expr.Arr.toString(Arr.java:120) at org.basex.query.expr.List.toString(List.java:150) at java.lang.String.valueOf(String.java:2847) at java.lang.StringBuilder.append(StringBuilder.java:128) at org.basex.query.gflwor.GFLWOR.toString(GFLWOR.java:670) at org.basex.util.TokenBuilder.addExt(TokenBuilder.java:348) at org.basex.util.TokenBuilder.addSep(TokenBuilder.java:311) at org.basex.query.expr.Arr.toString(Arr.java:120) at org.basex.query.expr.List.toString(List.java:150) at org.basex.query.MainModule.toString(MainModule.java:122) at java.lang.String.valueOf(String.java:2847) at java.lang.StringBuilder.append(StringBuilder.java:128) at org.basex.query.QueryInfo.usedDecls(QueryInfo.java:186) at org.basex.query.QueryInfo.toString(QueryInfo.java:137) at org.basex.query.QueryInfo.toString(QueryInfo.java:97) at org.basex.core.cmd.AQuery.query(AQuery.java:111) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:329) at org.basex.core.Command.execute(Command.java:94) at org.basex.gui.GUI.exec(GUI.java:417) at org.basex.gui.GUI.access$500(GUI.java:41) at org.basex.gui.GUI$8.run(GUI.java:361)

2 1

Database opened by another process, for non-updating queries
by Amanda Galtman 08 May '15

08 May '15

Hi, I saw a case today where a Linux cron job was running non-updating queries while a GUI user on Windows 7 was running non-updating queries on the same database. The GUI operation succeeded, but the Linux cron job reported this error: Database 'DocLibrary' is currently opened by another process. Both processes were using BaseX 8.1. I think it would be difficult for me to provide a short, self-contained example that reproduces this phenomenon reliably. However, I wanted to report it as a data point, if that helps at all. If it is expected behavior due to the mix of platforms and operation modes, that would be useful for me to know. Thanks, Amanda > > -----Original Message----- > > From: Christian Grün [mailto:christian.gruen@gmail.com] > > Sent: Friday, March 13, 2015 7:03 AM > > To: Amanda Galtman > > Cc: basex-talk(a)mailman.uni-konstanz.de > > Subject: Re: [basex-talk] Can you prevent database modification via GUI? > > > > Hi Amanda, > > [snip] > > > > > A related question is whether it is problematic for one user of the > > > GUI to have a database open (or to be actively running a query) > > > while another > > user > > > of the GUI is trying to run a query on the same database. > > > > As long as all queries are read-only, you will be absolutely fine. > > > > Hope this helps, > > Christian

2 2

A very short question about BaseX
by Fabrizio Venerandi 08 May '15

08 May '15

Hi, I’m testing BaseX and I have a very short question about XQuery Update Facility. If I try in other XQuery processor like Saxon a simple query that add a ‘id’ in XML, like this: xquery version "1.0"; declare default element namespace "http://www.w3.org/1999/xhtml"; let $sourcedoc := fn:doc("MOST.xhtml") return for $ancora at $gatto in $sourcedoc//*[@class="testo"] return if (not($ancora/@id)) then insert node attribute id {concat("testo",$gatto)} into $ancora else() Saxon run the Query and change the original file, “MOST.xhtml”. If I try the same query in XBase on Ubuntu, I see in the log XBase find the tag to add the id, but the original file is not changed. What I’m missing? Thank you Fabrizio

2 1

Performance issue related with Casting.
by ankit kumar 08 May '15

08 May '15

Hi, I am invoking a java method inside My XQuery script, My java methods returns a string array which contains the Id of elements. Now I am taking that list in a xquery variable. It looks like this. let $ids := javacontext:getIds(); // Java Method return /sample_xml/category/product[@id = $ids] Now the problem is that, It is working fine with this, but when I declare variable $ids as xs:string* sequence. It performance is decreased by almost 100%. It looks like this. let $ids as xs:string* := javacontext:getIds(); // Java Method return /sample_xml/category/product[@id = $ids] But, for bigger no of products, and ids . when the variable $ids declared as xs:string*, it is working good, but when I removed xs:string*. it performance decreased drammatically. I have no idea, why it is working in such a way. Any kind of help is appreciated. Thanks, Ankit

2 1

xquery of attributes
by Florent Gallaire 07 May '15

07 May '15

In the RESTXQ documentation there is this example which works fine : declare %rest:path("cities") %output:method("json") %output:json("format=jsonml") function page:cities() { element cities { db:open('factbook')//city/name } }; If I have the same factbook db but with name as attribute and not as element, with the only change in the code the xquery request db:open('factbook')//city/@name I will have the error message: [XQDY0025] Duplicate attribute 'name'. That's ok, but what is the right way in xquery to easily use multiple attributes as return value of request. Is the right way to prefer elements to attributes ? Cheers Florent -- FLOSS Engineer & Lawyer

2 3

debugging
by Rob Stapper 06 May '15

06 May '15

Hi, For those who, like myself, loose themselves often in their code, hereby a little debug-facility. Nothing much but it helps me keep track of my code. To get an idea of the debug-output, have a look at the attached output-file. Unfortunately the code isn't integrated in the BaseX-core, but it's just an xquery-module. So you, unfortunately, do have to write a few debug-calls in your, probably already buggy, code. On the other hand it's pretty straight forward; see attachment "debug_demo.xq" for usage. Hopes this can be of use for somebody. Rob Stapper. Ps. Improvements are very welcome. --- Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware. http://www.avast.com

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk