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

Parameter to xquery
by Lars Johnsen 30 Jan '14

30 Jan '14

Is it possible to pass parameters to xquery modules using BaseX scripting language? I tried something similar to to http-specification but had no luck. For example, if the code below is stored as add.xq, could $x and $y be supplied in a RUN add.xq command? declare variable $x external; declare variable $y external; let $res := $x + $y return $res All the best Lars G Johnsen National Library of Norway

2 1

How do you update Basex to 7.7.2 version?
by DAIANE ROBERTA CANDIDA 30 Jan '14

30 Jan '14

Hello, I have the Basex installed on the Ubunto Server and by the command apt-get install basex I can not update it because it is past of date, then I downloaded the basex_7.7.2-1.debian.tar.gz but I don't know how to execute the installation. Could you give me a tutorial to do the installation for updating of the basex? Regards, Daiane

5 6

Load lots xml but Unknown option 'ADDCACHE'
by DAIANE ROBERTA CANDIDA 29 Jan '14

29 Jan '14

Hello, I am trying to load a big xml dataset into the Basex but I am in trouble because it is taking so much time and then the message below is returned: Out of Main Memory. The following hints might help you: - increase Java's heap size with the flag -Xmx<size> - choose the internal XML parser in the GUI or via 'set intparse on' - deactivate the text and attribute indexes So I read the help topic in the web site http://comments.gmane.org/gmane.text.xml.basex.talk/2540 I realized that I didn't have set ADDCACHE ON. After that I wrote the following command lines on the linux OS: BaseX 7.0.2 [Client] Try "help" to get more information. > CREATE DB bd_inex2009 Database 'bd_inex2009' created in 66.81 ms. > SET AUTOFLUSH false AUTOFLUSH: OFF > SET ADDCACHE true Unknown option 'ADDCACHE'. > SET INTPARSE true INTPARSE: ON > SET DTD false DTD: OFF > ADD /home/arwen/daiane_oracle/loading_inex2009/new_page_xml2 Out of Main Memory. The problema persist yet. Finaly I downloaded the latest Basex release for Ubunto by the link https://launchpad.net/ubuntu/+source/basex/7.7.2-1 I don't know how to install the basex_7.7.2-1.debian.tar.gz on the server. Could you give me some help? I really need to load this database with those xml to complete a academic task. Regards Daiane

2 1

How to get file name + line number in query results
by Moshe Zuisman 29 Jan '14

29 Jan '14

Hi. I am using base-X as kind of repository for my XML files, to perform queries over all files I use. Number and size of files are not a problem - it is some 100+ files , each one few hundreds lines. To be more specific - those are xml files of IzPack installation. I have loaded all my files into database and perform different kinds of queries there. It works great. Problem is - that after I have found desired data, I have to look at which file at which place it really is located. What I am doing now is - just copy into clipboard piece of resulting data and performing "search in files" at all my XML files directory. Finally - it works, but I am sure - there have to be better way to do it... Can I somehow modify my query to cause base-X to "say" me - where calculated result is located at original file system?

2 2

Pearl pigments
by tony.zhao＠vip.188.com 29 Jan '14

29 Jan '14

1 0

os x app broken
by Charles Dietrich 28 Jan '14

28 Jan '14

When I attempt to open the unzipped BaseX.app (version 7.7.2), OS X reports that it is damaged. -- Charles

4 4

duplicate xmlns in wadl o/p
by Andy Bunce 27 Jan '14

27 Jan '14

given a function commented like: (:~ : return search results : <hit> : <entity>country</entity> : <name>name</name> : <url>...</url> : </hit> :) declare %rest:GET %rest:path("where4/api/search") %restxq:query-param("q", "{$q}") %output:method("json") function search($q){ The wadl function [1] produces: <wadl:resource path="/where4/api/search/"> <wadl:method name="GET"> <wadl:doc xmlns="http://www.w3.org/1999/xhtml">return search results <hit xmlns="" xmlns="http://www.w3.org/1999/xhtml"> <entity xmlns="">country</entity> <name xmlns="">name</name> <url xmlns="">...</url> </hit> </wadl:doc> <wadl:request> <wadl:param name="q" style="query"/> </wadl:request> <wadl:response> <wadl:representation mediaType="application/json"/> </wadl:response> </wadl:method> </wadl:resource> Regards /Andy [1] http://docs.basex.org/wiki/RESTXQ_Module#rest:wadl

2 2

BaseX as a Windows Service
by Sam Eklund 23 Jan '14

23 Jan '14

Is there a possibility to install BaseX server as a service under Windows? The -S switch to start BaseX in the background is nice, however a proper windows service would be even better! Anyone that has accomplished this? Best regards, Sam

4 6

XMLPrague, BaseX User Meeting
by Christian Grün 20 Jan '14

20 Jan '14

Dear all, we are pleased to give you the agenda for our BaseX User Meeting! As a little surprise, we can announce Michael Sperberg McQueen as additional speaker! This is the current list of speakers and talks: _ SESSION 1 _______ • 14:30 Christian Grün: BaseX: 12 Months, 12 Updates • 15:00 Michael Sperberg McQueen: Using BaseX for Off-the-cuff Queries • 15:30 Lars Johnsen: BaseX as a Corpus Tool _ SESSION 2 _______ • 16:30 Gerrit Imsieke: Using BaseX with RESTXQ as the Storage Back-end for a Web-based XML Editor • 16:55 Jean-Marc Mercier: Data Heterogeneity with XQUERY++ and BaseX • 17:20 Yoann Maingon: BaseX for Rapid Minimum Viable Product Prototyping • 17:45 Open Discussion The list may be subject to updates; the latest version will be found here: http://www.xmlprague.cz/preconf2014 http://lanyrd.com/2014/basex Conference tickets are still available. Spread the word! We are looking forward to meeting you in Prague, Christian

1 0

Paging takes time.
by Geet Gangwar 20 Jan '14

20 Jan '14

Hi, I have huge XML document containing around 70000000 child nodes. I want to implement paging on this, so that I can fetch a chunk of nodes at time, but as the start position value increases from 10000000 the execution time takes more than a second to execute, is there a any optimized way I can follow. I have written following code: public class XQJ { public static void main(String[] args) throws XQException { XQDataSource xqs = new BaseXXQDataSource(); xqs.setProperty("serverName", "localhost"); xqs.setProperty("port", "1984"); // Change USERNAME and PASSWORD values XQConnection conn = xqs.getConnection("admin", "admin"); XQPreparedExpression xqpe = conn.prepareExpression("declare namespace xbrli=' http://www.xbrl.org/2003/instance';" + " declare variable $doc as xs:string external;" + " declare variable $start as xs:integer external;" + " declare variable $pageSize as xs:integer external;" + " let $allMatches := doc($doc)/xbrli:xbrl/*" + " return subsequence($allMatches,$start,$pageSize)"); // " return $matches"); xqpe.bindString(new QName("doc"), "1389962424906/1389962424906/facts.xml", null); int totalRecords = 70000000; int pageSize = 10000; int noOfPages = totalRecords/pageSize; long startTime = 0; int start = 0; for(int i=0; i<noOfPages; i++){ startTime = System.currentTimeMillis(); start = i*pageSize; xqpe.bindInt(new QName("start"), start, null); xqpe.bindInt(new QName("pageSize"), pageSize, null); XQResultSequence rs = xqpe.executeQuery(); // while(rs.next()){} // System.out.println(rs.getItemAsString(null)); // System.out.println(start + " : " + (System.currentTimeMillis()-startTime)); } System.out.println(start + " : " + (System.currentTimeMillis()-startTime)); conn.close(); }

2 1