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

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

Running commands on BaseX on Tomcat
by Kristian Kankainen 06 May '15

06 May '15

Hello! I have BaseX 8.11 running on Tomcat and need to execute some commands or XQuery for deploying xml files from elsewhere. I allready have a XQuery function for this and can do it on my local setup using for example the basexclient. My problem is that the Tomcat is available only through HTTP and I wouldn't like to open up the function for the outside world using RESTXQ. Is there a way to "talk" with the BaseX in the Tomcat? I have full access to the machine via SSH. Another way I thought of would be to just upload the data folder from my local setup, but it doesn't feel the right way to do it. Best regards Kristian K

2 10

Base-X basics :-}
by Niels Grundtvig Nielsen 06 May '15

06 May '15

I've used ColdFusion and (reluctantly) php with MySQL, so I have some idea about combining database query with html tags to get formatted output … but I'd welcome a pointer to a tutorial about doing the same thing with Base-X Also, what would you recommend as an introduction to xQuery? w3schools … I seem to remember this was a bit brief, and this afternoon I can't get it to load anyway; wikiBooks on xQuery already incudes exist-DB specific code in the second of its "Beginning examples". Thanks in advance!

2 1

Re: [basex-talk] Pulling files from multiple zips into one DB
by Fabrice Etanchaud 04 May '15

04 May '15

Dear Constantine, In my experience, commands are always faster than db:* calls. Maybe someone @basex could confirm that, and that commands do not use the Pending Update List ? Are you sure you disabled ADDRAW ? If there are many raw files along the xml files, you may have better results extracting and rearchiving only xml before. I have the same problem with patent archives, where each xml file may come with many pdf and gif. Best regards, Fabrice De : Hondros, Constantine (ELS-AMS) [mailto:C.Hondros@elsevier.com] Envoyé : lundi 4 mai 2015 14:01 À : Fabrice Etanchaud Objet : RE: Pulling files from multiple zips into one DB Is that going to be any faster do you think? I tried it and it took a looooong time to read through the zips, so I am hoping there might be a faster more direct way of doing it. From: Fabrice Etanchaud [mailto:fetanchaud@questel.com] Sent: 04 May 2015 13:56 To: Hondros, Constantine (ELS-AMS) Subject: RE: Pulling files from multiple zips into one DB Hello Constantine, Why don't you simply create a new collection with ADDARCHIVES=true ? Best regards, Fabrice De : basex-talk-bounces(a)mailman.uni-konstanz.de<mailto:basex-talk-bounces@mailman.uni-konstanz.de> [mailto:basex-talk-bounces@mailman.uni-konstanz.de] De la part de Hondros, Constantine (ELS-AMS) Envoyé : lundi 4 mai 2015 13:50 À : basex-talk(a)mailman.uni-konstanz.de<mailto:basex-talk@mailman.uni-konstanz.de> Objet : [basex-talk] Pulling files from multiple zips into one DB Hello all, I need to merge any XML files located in 500 GB of zips into a single DB for further analysis. Is there any faster or more efficient way to do it in BaseX than this? TIA. for $zip in file:list($src, false(), '*.zip') let $arch := file:read-binary(concat($src, '\', $zip)) for $a in archive:entries($arch)[ends-with(., 'xml')] return db:add('my_db', archive:extract-text($arch, $a), $a) TIA, Constantine ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands. ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 3

Pulling files from multiple zips into one DB
by Hondros, Constantine (ELS-AMS) 04 May '15

04 May '15

Hello all, I need to merge any XML files located in 500 GB of zips into a single DB for further analysis. Is there any faster or more efficient way to do it in BaseX than this? TIA. for $zip in file:list($src, false(), '*.zip') let $arch := file:read-binary(concat($src, '\', $zip)) for $a in archive:entries($arch)[ends-with(., 'xml')] return db:add('my_db', archive:extract-text($arch, $a), $a) TIA, Constantine ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

1 0