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

new booking 2014-06-18
by 船公司 18 Jun '14

18 Jun '14

Jeter Shipping (Guangzhou) Ltd.广州即达—全广州最大的散货拼柜庄家！即达船务专业拼箱20载，一直与外运仓和多家船公司有良好合作关系，代理遍布全球，直拼港口众多，船期稳船期多。固定有二截五开，四截二开。五截三开等。精品航线众多：东南亚、中东印巴、欧洲地中海、澳洲新西兰、美加。南非和巴拿马、墨西哥等船期非常好。目的港直接代理方便掌控物权和解决目的港清关事宜。（请您花一点点时间看一眼，也许会为您节省不少成本！感谢您的支持！）价格是死的，人是活的，我从来不奢求太多利润，你我都有的赚才是最好的，真诚希望与您实现双赢。用心做人，以诚待人。期待与您合作。请相信我。三大优势 1. 广州拼箱大庄家，操作专业、海运价格低、船期最稳 2. 报关实力强，可接仿牌、液体、粉末、食品等敏感货物 3. 一站式服务，可上门提货，代办各类出口证书、打托、贴唛等 | 目的港(Destination) | 海运费USD/CBM | 黄埔截关 | 黄埔开船 | T/T（天） | Carrier | | 迪拜（DUBAI） | 0 | 周二 | 周五 | 13 | YML/WHL | | 亚历山大(ALEXANDRIA) | 10 | 周二 | 周五 | 25 | CSCL | | 仁川（INCHON） | 0 | 周二 | 周五 | 5 | TSL | | 海防（HAIPHONG） | 1 | 周二 | 周五 | 5 | TSL | | 雅加达（JAKARTA） | 0 | 周二 | 周五 | 5 | WHL | | 鹿特丹（ROTTERDAM） | 0 | 周二 | 周五 | 23 | CSCL | | 安特卫普（ANTWERP） | 0 | 周二 | 周五 | 27 | CSCL | | 利哈佛尔（LE HAVRE） | 0 | 周二 | 周五 | 21 | CSCL | | 热那亚（GENOA） | 0 | 周二 | 周五 | 21 | YML | | 伊斯坦布尔（Istanbul） | 0 | 周一 | 周四 | 17 | YML | | 悉尼/墨尔本（SYD/MEL） | 0 | 周二 | 周五 | 13 | CSCL | | 奥克兰（AUCKLAND） | 5 | 周二 | 周五 | 18 | CSCL | | 多伦多（Toronto） | 55 | 周二 | 周五 | 25 | CSCL | | 温哥华（Vancouver） | 30 | 周二 | 周五 | 18 | CSCL | | 纽约（New York） | 10 | 周二 | 周五 | 25 | CSCL | 《《欢迎咨询全球港口价格》》最后恭祝各位生意兴隆，万事顺意！询价请发邮件到：344690306@qq.com/sales-15@jeter.com.cn 专做国际海运散货，海运价格低、通关实力强、可接仿牌，粉末，液体等敏感物品，附带服务好，提供散货一条龙运输服务。柜货：由于船东方面没有具体很固定的柜货价格，所以主要是看每个时期的不同价格有浮动，但可以肯定的一点，我们作为国际代理，绝对能够拿到市场的最低价格，因此有货的朋友来电咨询保证有惊喜让你们的利润空间完全打开~！各航线对应签约船东：南美线：ZIM 、EMC、 MSK船东非洲线：MSC、MSK、delmas 中东印巴：OOCL 、CSCL、WHL、HJ、APL 东南亚：YML、H-A、APL、玛丽亚、KMTC等多家近洋线船东欧洲线：CSCL YML等船东 --Tks./Best Regards ＾＿＾业务经理：彭家钊HerryPeng 13450363012 （手机） MSN: pjiazhao(a)hotmail.com QQ:344690306 ------------------------------------------------------------------------------ Jeter Shipping (Guangzhou) Ltd. 广州即达船务运输有限公司 (MOC-NY0446) Room 904-909.Glorious Tower,No.850 Dongfeng Road East,Guangzhou 510600 China 广州市东风东路850号锦城大厦904-909室邮编：510600 Mob:13450363012 Tel:020-87348545 Fax:020-87346274/5/6/7 Email：sales-15(a)jeter.com.cn 如不想收到此类邮件/或是重复多收，请来信告知，我将会及时处理，对此给您造成的不便还请谅解！=^_^=

1 0

Re: [basex-talk] How to run several commands in one post
by Christian Grün 18 Jun '14

18 Jun '14

Hi Arjan (cc to the list), >> But then it is also not possible to start-up some existing server side script that way? I've added another idea to the reopened GitHub issue [1]: we could extend the "run" operation [2] to also support command scripts. Christian [1] https://github.com/BaseXdb/basex/issues/559 [2] http://docs.basex.org/wiki/REST#Operations

1 1

Difference in query behavior between BaseX 7.7 beta and BaseX 7.8.2
by Srinivasan Muthu 17 Jun '14

17 Jun '14

We have been using BaseX 7.7 beta for a while and recently we switched to 7.8.2 and found two queries failed with the existing unit tests. After research, we found that the query is now getting compiled into a different optimized query (from 7.7) and results in evaluating a variable, even if that variable will never be used, as it is inside an IF condition for particular input. Here is the query: ------------------------------------------------------------------ declare function local:addPrefix($arg as element()?){ concat("prefix-", $arg) }; let $a := <a> 1 2 3 </a> let $prefixed-data:= <ele>{local:addPrefix($a/b)}</ele> return if (exists($a/c)) then ( $prefixed-data ) else ( 'no input data' ) ------------------------------------------------------------------ In BaseX 7.7beta the output is 'no input data' which is correct. Here $prefixed-data does not get evaluated in BaseX 7.7 beta, as exists($a/c) is FALSE. The optimized query in GUI also shows '$prefixed-data' variable removed. Here is the optimized query in BaseX 7.7 beta: *Compiling:* - rewriting for tail calls: Q{ http://www.w3.org/2005/xquery-local-functions}addPrefix - rewriting fn:exists($a/c) - inlining let $prefixed-data := element ele { (local:addPrefix($a/b)) } - removing variable $prefixed-data *Optimized Query: * declare function local:addPrefix($arg as element()?) { fn:concat("prefix-", $arg) }; let $a := element a { (element b { ("1") }, element b { ("2") }, element b { ("3") }) } return if($a/c) then element ele { (local:addPrefix($a/b)) } else "no input data" ------------------------------------------------------------------ In BaseX 7.8.2 the query throws an error. In 7.8.2, $prefixed-data gets evaluated even though the 'IF" condition is FALSE. See optimized query from GUI here: *Error:* Stopped at C:/source/perforce/PSODepot/health-analyzer/ha-rel504/libs/catalog/src/main/resources/analysis/vsphere/6.5/CO-001/file3, 1/18: [XPTY0004] Cannot treat item() sequence as element()?: (..., ..., ...). Compiling: - inlining Q{http://www.w3.org/2005/xquery-local-functions}addPrefix#1 - inlining let $arg_3 as element()? := $a_1/b - simplifying flwor expression - rewriting fn:exists($a_1/c) *Query:* declare function local:addPrefix($arg as element()?){ concat("prefix-", $arg) }; let $a := <a> 1 2 3 </a> let $prefixed-data:= <ele>{local:addPrefix($a/b)}</ele> return if (exists($a/c)) then ( $prefixed-data ) else ( 'no input data' ) *Optimized Query:* let $a_1 := element a { (element b { ("1") }, element b { ("2") }, element b { ("3") }) } let $prefixed-data_2 := element ele { (fn:concat("prefix-", ((: element()?, true :) $a_1/b))) } return if($a_1/c) then $prefixed-data_2 else "no input data" Query plan: <QueryPlan> <GFLWOR> <Let> <Var name="$a" id="1"/> <CElem> <QNm value="a" type="xs:QName"/> <CElem> <QNm value="b" type="xs:QName"/> <Str value="1" type="xs:string"/> </CElem> <CElem> <QNm value="b" type="xs:QName"/> <Str value="2" type="xs:string"/> </CElem> <CElem> <QNm value="b" type="xs:QName"/> <Str value="3" type="xs:string"/> </CElem> </CElem> </Let> <Let> <Var name="$prefixed-data" id="2"/> <CElem> <QNm value="ele" type="xs:QName"/> <FNStr name="concat(atom1,atom2[,...])"> <Str value="prefix-" type="xs:string"/> <TypeCheck type="element()?" function="true"> <IterPath> <VarRef> <Var name="$a" id="1"/> </VarRef> <IterStep axis="child" test="b"/> </IterPath> </TypeCheck> </FNStr> </CElem> </Let> <If> <IterPath> <VarRef> <Var name="$a" id="1"/> </VarRef> <IterStep axis="child" test="c"/> </IterPath> <VarRef> <Var name="$prefixed-data" id="2"/> </VarRef> <Str value="no input data" type="xs:string"/> </If> </GFLWOR> </QueryPlan> ------------------------------------------------------------------ We wanted to make sure that this is due to the way queries are executed differently now in BaseX 7.8.2 and not a bug in BaseX 7.8.2. Removing the unused variable makes sense for optimization purposes, so it looks like 7.7 was doing the right thing. Can you confirm please? Thanks, Srini

3 5

Die Wahrheit über Diabetes
by Karolin Hertzog 17 Jun '14

17 Jun '14

To stop receiving these emails:http://mail0.diabetesblog.biz/unsubscribe.php?M=75921&C=08a2923af15af1ad713ec0788079def3&L=1&N=2 Hallo, Falls Sie unter Diabetes leide, dann könnte Ihnen dieser Artikel sehr behilflich sein: 3 Geheimnisse zum Fett verbrennen und Blutzucker verbessern: http://www.diabetesblog.biz Diese 3 Tipps sind einfach und Sie können diese „Geheimnisse“ sofort verwenden. Klicken Sie hier um den Artikel zu lesen: http://www.diabetesblog.biz mit freundlichen Grüßen, Karolin Hertzog

1 0

RESTXQ declare base-uri ".";
by Andy Bunce 17 Jun '14

17 Jun '14

Hi, It seems that in restxq mode relative paths for *declare base-uri* are resolved differently [1]. If I have -webapp --folder1 ---mod1.xqm (which has import module namespace xm='test' at 'mod2.xqm';) ---mod2.xqm The import works. If I add declare base-uri "."; to mod1. the import fails, running the same code not via restxq and it works. Is this intended behavior? /Andy [1] http://www.w3.org/TR/2014/REC-xquery-30-20140408/#id-base-uri-decl

2 7

Basex 404
by Lars Johnsen 16 Jun '14

16 Jun '14

I've recently run into a problem with basexserver/basexhttp. The host:8984 responds but seems to have lost contact with the webapp directory. Here is what is happening on 3 out of 5 installations (on linux - installed by unpacking the latest ziparchive), where one used to work as expected: 1) host:8984 do not display the restxq example, but is up and running 2) host:8984/rest shows the list of databases 3) host:8984/rest/run=script-name.xq gives 404 - no function matches request So the server appears to be connected to the database, but won't look at the webapp directory. Where is the best place to look for information? All the best, Lars

2 1

Strategies for "checkout" or explicit file locking
by Alister Pillow 16 Jun '14

16 Jun '14

Hi all, BaseX doesn’t appear to have explicit document-level access control (ownership and permissions). I understand that Write and Read locks are applied during queries - but these are not explicit and only apply during the course of the query. I wonder what strategies other people use to lock a file for “editing”, or “checkout” a file so that only a single user has access (in a multi-user environment). Does anyone manage more than a few users within one instance of BaseX? (e.g. more than 10) Thanks, Alister.

2 1

Multiple basex webapps in same Tomcat
by Marco Lettere 16 Jun '14

16 Jun '14

Hello all, in one of our use cases we have two basex (7.8.1) that run as standalone servers. They act mainly as service wrappers so we mainly use restxq and http client. Only one has a very limited access to the DB functionality. The pattern is that one of the two is called from a tomcat webapp installed on the same machine. It then calls the second which in turn calls another service on a different machine. All of the calls are HTTP. Anyway we have been asked to condense the installation into the same tomcat. I've been trying that but when I install multiple basex webapps I get strange conflicts in the RESTXQ engine. I was able to reproduce the issue just by exploding two wars (named bx1.war and bx2.war) into the tomcat. Then I've altered the "hello/{$world}" annotated example in restxq.xqm to return "hello world 1" and "Hello world 2". At that point whatever context I use in the browser (either bx1 or bx2) I always get "Hello world 2" as a return. I've tried changing the namespace of the module of restxq.xqm and also changing the servlet context for RESTXQ in bx2 but nothing changes. Could you provide me some hints on this? Thanks, Marco.

2 2

Efficiently using BaseX and JAXB
by Zachary DeLuca 10 Jun '14

10 Jun '14

Hello, I have a question about unmarshaling a query result into JAXB object(s). My database collection contains documents that all contain the same type of root element, let's call it Element1. Originally I was doing something like this (I know it's silly but it worked just fine for small data sets): String CLOSING_TAG = "</Element1>"; Context context = ... Unmarshaller um = ... String predicate1 = ... String predicate2 = ... String query = "//Element1[" + predicate1 + " and " + predicate2 + "]"; String result = new XQuery(query).execute(context); if (result != null && !result.isEmpty()) { ArrayList<Element1> elements = new ArrayList<>(); int index = -1; int beginIndex = 0; while ((index = result.indexOf(CLOSING_TAG, beginIndex)) != -1) { int endIndex = index + CLOSING_TAG.length(); String element1 = result.substring(beginIndex, endIndex); beginIndex = endIndex + 1; elements.add(((Element1) um.unmarshal(new ByteArrayInputStream(element1.getBytes())))); } // do something with the elements } But when I got into larger data sets (my DB collection is currently approx. 1GB total size and has just over 20k documents) this started to fail apparently due to trying to convert the entire result to a string at one time (out of memory error, despite setting -Xmx16384m). So I dig through the examples to find a better way and changed my code to this: ByteArrayOutputStream baos = new ByteArrayOutputStream(); Iter iter = null; Serializer ser = null; QueryProcessor proc = new QueryProcessor(query, context); iter = proc.iter(); ser = proc.getSerializer(baos); proc.close(); if (iter != null && ser != null) { ArrayList<Element1> elements = new ArrayList<>(); for(Item item; (item = iter.next()) != null;) { baos.reset(); ser.serialize(item); elements.add(((Element1) um.unmarshal(new ByteArrayInputStream(baos.toByteArray())))); } ser.close(); // do something with the elements } This appears to work fine but I am just wondering if there is a better/faster way to do it? At first glance, serializing to a ByteArrayOutputSream only to then turn around and use a ByteArrayInputStream to unmarshal with JAXB seems wasteful. Thanks for taking the time to read, Zach

2 4

BaseX Design
by Vaibhav Khare 07 Jun '14

07 Jun '14

Hi, I have a requirement to build XML repository where I will store millions of XML documents (size may vary) based on some unique Ids (one level path like - \10). For another operation, I need to compare the incoming XML document with the stored XML document for any changes. 1. Can any of you please let me know on how to implement this in BaseX? Apart from inserting the XMLs and comparing them with the incoming XML, there is no other query required. 2. Performance is the major criteria for this. Do you think BaseX will be able to handle this as the repository size grows? Also, is there a way to do batch processing of the above operations to improve performance? Thanks in advance, ~ VK

2 1