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

Re: [basex-talk] unexpected behaviour
by Christian Grün 13 May '15

13 May '15

If I get it right, you would also expect '!' not to be output in the following query, right? declare function local:f($a, $b) { if($a) then $b else () }; local:f((), trace('!')) In this case, you'll have to wrap your trace call in a function: declare function local:f($a, $b) { if($a) then $b() else () }; local:f((), function() { trace('!') }) Best, Christian On Wed, May 13, 2015 at 11:44 AM, Rob Stapper <r.stapper(a)lijbrandt.nl> wrote: > Hi Christian, > > > > This is the best I can do without losing the essence of the issue. Sorry > about the import, forgot to remove that one. > > The clue is in the “Query Info”-window. It shows: > > > > Evaluating: > > f1: 1 > > Compiling: > > ……. > > > > So function “local:f1#1” is unnecessarely evaluated with value 1. > > > > Success, > > Rob > > > > *Van:* Christian Grün [mailto:christian.gruen@gmail.com] > *Verzonden:* woensdag 13 mei 2015 11:13 > *Aan:* Rob Stapper > *CC:* BaseX > *Onderwerp:* Re: [basex-talk] unexpected behaviour > > > > Hi Rob, > > > > It usually takes me some time to understand new code, so could you > possibly simplify the example as much as possible? For example, the import > cannot be resolved, an empty squence is bound to $a, which means that one > branch will never be called, and maybe you can simplify the partial > function application as well.. > > > > Thanks in advance, > > Christian > > > > > > > > On Wed, May 13, 2015 at 9:55 AM, Rob Stapper <r.stapper(a)lijbrandt.nl> > wrote: > > Hi Christian, > > > > Can you have a look at the attached program. > > Both items of the returned sequence of the program should do the same > thing. > > Both do give the same, correct result: an empty sequence, but the first > item unnecessarely triggers function: “local:f1#1” , while the second item > doesn’t. > > This a pity since “local:f1#1” could be a time-consuming function. > > > > Cheers, > > Rob > > > ------------------------------ > > [image: Afbeelding verwijderd door afzender. Avast logo] > <http://www.avast.com/> > > Dit e-mailbericht is gecontroleerd op virussen met Avast > antivirussoftware. > www.avast.com > > > > > > > ------------------------------ > [image: Avast logo] <http://www.avast.com/> > > Dit e-mailbericht is gecontroleerd op virussen met Avast > antivirussoftware. > www.avast.com > >

1 0

Add metadata to a group of documents inside the database
by Menashè Eliezer 13 May '15

13 May '15

Hello, I have two groups of xml to be included in the same database. Usually the same query will be performed on both of them, but I need to able to query only one group. The difference between the groups is known only to add the xml files, e.g. the origin of the files. This information is not found inside the files, and I prefer not modifying their content. I was hoping to be able to define groups, using subfolders and base-uri or multiple collections, but I know it's not possible using Basex. Maybe I can tag them? The group type is both a property and a possible filter in a query, so I need a good performance. Right now I see two alternatives: 1. Using two separate databases. Once I need to query all files, I'll make the same query on multiple databases... 2. One database, but a query to a new xml document, which includes list of node-ids per group type, will be used both for knowing the type and for querying a subset. Any ideas, please? -- With kind regards, Menashè

3 5

Re: [basex-talk] Problem with Variable having Numericvalue node comparison
by ankit kumar 13 May '15

13 May '15

Thanks for your reply. Actually, The comparison expression is coming from other side. So changing the expression is not possible for me. Thanks, Ankit On 13 May 2015 at 13:18, Marco Lettere <marco.lettere(a)dedalus.eu> wrote: > On 13/05/2015 09:40, ankit kumar wrote: > >> let $v3 :=<a>7900000.00</a> >> let $v2:=<a>930000.00</a> >> return $v2 <= $v3 >> > > Hi Ankit, > > is the following: > > let $v3 :=<a>7900000.00</a> > let $v2:=<a>930000.00</a> > return xs:float($v2) <= xs:float($v3) > > too much of a change for your use-case? > M. >

2 1

Problem with Variable having Numericvalue node comparison
by ankit kumar 13 May '15

13 May '15

Hi, I am trying to compare two variable in basex as given, let $v3 :=<a>7900000.00</a> let $v2:=<a>930000.00</a> return $v2 <= $v3 I am expecting that it will give me true, But it is giving false. I think it is because of the comparison is only string comparison. Is it possible to configure basex for numeric comparison without changing the expression $V2 <= $V3 , or I have to explicitly convert variable value to decimal and then compare it. Thanks, Ankit

2 1

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