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

BaseX and Oxygen
by Marc van Grootel 28 Jul '16

28 Jul '16

Hi all, (sorry if this is too much off-topic) I re-read some of the related topics on this list. I have also installed the Argon plugin (very nice). I tried this several times in the past but everytime I went back to the BaseX gui. But I would like to be able to reduce my use of the BaseX gui and do more directly from Oxygen. Even though the gui is very nice I would like to more development to be done from Oxygen. I wanted to post here first as you all may have some ideas on how to fix some shortcomings to the current BaseX/XQuery workflow with Oxygen. When I have a better idea of what is really missing or can't be worked around I will also post some of these things on the Oxygen list. 1) Syntax Although I understand that XQuery 3.1 wasn't official with the release of 17.1 earlier versions were a bit more relaxed about syntax. Instead in 17 and higher whenever XQuery code uses typical 3.1 syntax (such as literal arrays) syntax coloring displays parts of the code in red. Earlier versions, if I remember correctly, I believe did a better job at this. Is there a way to avoid having large parts of the code in red (I tend to use arrays and other 3.1 syntax quite a lot). 2) Validating It seems that, even if I choose the BaseX connection for validation, the code still gets analyzed by Saxon 9.6 which doesn't know about the 3.1-isms and barfs with: E [BaseX - Localhost] Invalid XQuery syntax, syntax does not pass static validation. I guess that's Saxon talking here. That's it really, quite basic. Feels like it's almost, but not quite, there yet. Any tips? I will post to Oxygen mailing list once I am convinced that I have done everything I can to improve the situation. --Marc

2 2

Error message in basex GUI, but not via cmd line
by Rob Vos 28 Jul '16

28 Jul '16

Hi, I keep getting an error message in Basex GUI saying Error: Stopped at D:/XML/xquery/GBF-RekExt-Nr_v22_basex-CSV-withDB-toDisk.xq, 10/2: [XPTY0004] xs:double expected, empty sequence found. I use the following code declare function functx:month-name-nl ( $date as xs:anyAtomicType? ) as xs:string? { ('januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december') [month-from-date(xs:date($date))] This error doesn't appear when I use the cmd line functionality. Thing is however that I want to test some changes and the GUI is very usefull for it. Searching for this specific error hasn't doen me any good. Could one of you please point me in the right direction. Met vriendelijke groet, kind regards, [CALVI] Rob Vos (not working on Monday afternoons) Consultant +31(0)88 16 69 826 r.vos(a)calvi.nl<mailto:r.vos@calvi.nl> | www.calvi.nl<http://www.calvi.nl/> Kasteel Nederhemert Kasteellaan 1 5317 KX Nederhemert-zuid The Netherlands [+31 (0) 88 1669 800]<http://www.calvi.nl/> Disclaimer Dit bericht en eventuele attachments die zijn meegestuurd, bevatten vertrouwelijke informatie en zijn uitsluitend bestemd voor de geadresseerde(n). Indien u als niet-geadresseerde dit bericht ontvangt, wordt u verzocht de Calvi systeembeheerder hierover te informeren en het bericht te vernietigen. Middels deze disclaimer bevestigen wij dat dit e-mail bericht geen virussen bevat. Calvi Business Software B.V. is statutair gevestigd te 's-Hertogenbosch en ingeschreven in het handelsregister onder nr. 17133645. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the Calvi system manager and destroy this message. This footnote also confirms that this email message has been swept for the presence of computer viruses. Calvi Business Software B.V. has its registered offices in 's-Hertogenbosch and is registered with the trade register under no. 17133645.

2 3

db:store question
by Wang, Genneva 28 Jul '16

28 Jul '16

Hi basex guru’s, I’m wondering if there are other mechanisms to add binary resources other than using db:store? We are using java client, hence we are using the store method. We are currently experiencing some performance issue with only this method call, so was wondering if there are other alternatives. Any tips would be greatly appreciated. Thanks. Regards, -Genneva

2 1

JBoss 6.4 and BaseX 8.4
by Bondeson, Carl 27 Jul '16

27 Jul '16

We just upgraded from 7.8 to 8.5. We are using BaseX in a JBoss multi-threaded application. Something has changed with ClientSession. I have log4j at trace level and the server is started but when a call is made to the ClientSession constructor nothing happens. static final int BASEX_SERVER_PORT = 1990; static final String BASEX_USER = "admin"; static final String BASEX_PASSWORD = "admin"; static final String BASEX_HOST = "localhost"; try { // get server status boolean serverstarted = BaseXServer.ping(BASEX_HOST, BASEX_SERVER_PORT); // server started? if (!serverstarted) { instance.basexlog.trace("BaseXDictionary: BaseX: Start BaseX server"); // no-> create a new instance using server and client ports // BaseXServer server = new BaseXServer("-p" + BASEX_SERVER_PORT); } else { // yes-> log the event instance.basexlog.trace("BaseXDictionary: BaseX: BaseX server already started"); } // start initialization process instance.basexlog.debug("BaseXDictionary: BaseX: Server started"); // this call never returns or something strange is going on instance.mapperDBSession = new ClientSession(BaseXDictionary.BASEX_HOST, BaseXDictionary.BASEX_SERVER_PORT, BaseXDictionary.BASEX_USER, BaseXDictionary.BASEX_PASSWORD); This next log4j output is never seen in the log file instance.basexlog.trace("BaseXDictionary: BaseX: Client Session created "); Any JBoss users? Thanks Carl R Bondeson IT Analyst 3 Information Technology Connecticut Department of Public Health 410 Capitol Ave Hartford, CT 06134 Phone: 860-509-7434 carl.bondeson(a)ct.gov<mailto:carl.bondeson@ct.gov> [logosmall]

2 6

Issue with last night's snapshot
by France Baril 27 Jul '16

27 Jul '16

I can't seem to validate content (It says the .xsd file does not exist). Here is some test code: let $xsd := <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xs:element name="root"> <xs:complexType mixed="false"> <xs:choice minOccurs="1" maxOccurs="unbounded"> <xs:element name="leaf"><xs:complexType><xs:attribute name="value" type="xs:string"></xs:attribute></xs:complexType></xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> let $xml := <root><leaf value="test"></leaf></root> let $xsd-path := 'xsd-test.xsd' let $xsd-file := file:write($xsd-path, $xsd) return validate:xsd-info($xml, $xsd-path) -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

Value out of range on xs:integer?
by Jorge Williams 27 Jul '16

27 Jul '16

Hello all, Performing this query... xquery version "1.0"; declare namespace tst="http://test.racspace.com"; declare function tst:factorial ($input as xs:integer) as xs:integer { let $result := tst:multiply(1 to $input) return $result }; declare function tst:multiply ($inputs as xs:integer*) as xs:integer { let $mid := count($inputs) div 2 return if (count($inputs) eq 1) then $inputs[1] else tst:multiply($inputs[position() <= $mid]) * tst:multiply($inputs[position() > $mid]) }; let $inputs := tokenize(normalize-space(/factorials),' ') let $outputs := for $i in $inputs return xs:string(tst:factorial(xs:integer($i))) return string-join($outputs, '
') on this input: <factorials> 10 20 30 40 50 60 600 1000 </factorials> Both Saxon and XQilla return the answer below, but BaseX says: Stopped at /Users/jorgew/factorial/factorials.xq, 14/74: [FOAR0002] Value out of range: 859541760 * 235989936000. when I run via the cli like this : basex -X -i factorial.xml factorials.xq Thoughts? Thanks, -jOrGe W. Response from Saxon, XQilla : 3628800 2432902008176640000 265252859812191058636308480000000 815915283247897734345611269596115894272000000000 30414093201713378043612608166064768844377641568960512000000000000 8320987112741390144276341183223364380754172606361245952449277696409600000000000000 12655723162254307425418678245150829297671403862274660768187828858528140823147351237817802795619571074765208532598060224803240903782164769430795025578054271906283387643826088448124626488332623608376164081221171179439885840257818732919037889603719186743943363062139593784473922231852782547619771723889252476871186000174697934549112845662596182308280390615184691924446215552586523740084932807259056238962104689731522587564412231618018774350801526839567367444928206231310973619440354723718012867753019556135721376207959558860559933052856914157120622980057169891912595926540427596853441276985006724869558201930657900240943007657817473684008944448183219124163017666607770667585082169598239230274035517738648065600492702095732843492708856036920219883363111527988109277392696562776813446645651238419301586157342867860646666350050113314787911320639668510871569846664873595017518995670958477806411667505346462590471136862647349666243426242677175204732314281064417939041868653741187423064985189556742640111598580035644021835576715752869397465453828584471291269955890393294448315746500268702149708808053100406398480942695623586049403348084970064668900206251516968479727515576425962392136269169089884609794271331061018895634421094082310408889752954265842691732460538911784960000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 402387260077093773543702433923003985719374864210714632543799910429938512398629020592044208486969404800479988610197196058631666872994808558901323829669944590997424504087073759918823627727188732519779505950995276120874975462497043601418278094646496291056393887437886487337119181045825783647849977012476632889835955735432513185323958463075557409114262417474349347553428646576611667797396668820291207379143853719588249808126867838374559731746136085379534524221586593201928090878297308431392844403281231558611036976801357304216168747609675871348312025478589320767169132448426236131412508780208000261683151027341827977704784635868170164365024153691398281264810213092761244896359928705114964975419909342221566832572080821333186116811553615836546984046708975602900950537616475847728421889679646244945160765353408198901385442487984959953319101723355556602139450399736280750137837615307127761926849034352625200015888535147331611702103968175921510907788019393178114194545257223865541461062892187960223838971476088506276862967146674697562911234082439208160153780889893964518263243671616762179168909779911903754031274622289988005195444414282012187361745992642956581746628302955570299024324153181617210465832036786906117260158783520751516284225540265170483304226143974286933061690897968482590125458327168226458066526769958652682272807075781391858178889652208164348344825993266043367660176999612831860788386150279465955131156552036093988180612138558600301435694527224206344631797460594682573103790084024432438465657245014402821885252470935190620929023136493273497565513958720559654228749774011413346962715422845862377387538230483865688976461927383814900140767310446640259899490222221765904339901886018566526485061799702356193897017860040811889729918311021171229845901641921068884387121855646124960798722908519296819372388642614839657382291123125024186649353143970137428531926649875337218940694281434118520158014123344828015051399694290153483077644569099073152433278288269864602789864321139083506217095002597389863554277196742822248757586765752344220207573630569498825087968928162753848863396909959826280956121450994871701244516461260379029309120889086942028510640182154399457156805941872748998094254742173582401063677404595741785160829230135358081840096996372524230560855903700624271243416909004153690105933983835777939410970027753472000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2 3

Changes to wildcards in 8.5.2?
by France Baril 26 Jul '16

26 Jul '16

Hi, This query works with 8.5.1 when the value of $wild-words is *.*, but not in 8.5.2. It works in 8.5.2 for real text values, so the issue seems to be with the *.* expression: *let* *$search-result* := *if* (*$operator* = 'and') *then **$search-subset*[(descendant::*title*[1] *contains* *text* ({ *$wild-words*} *all* *using* *wildcards* *weight* {2})) or (. *contains* *text* ({*$wild-words*} *all* *using* *wildcards* *weight* {0.5}))] *else **$search-subset*[(descendant::*title*[1] *contains* *text* ({ *$wild-words*} *any* *using* *wildcards* *weight* {2})) or (. *contains* *text* ({*$wild-words*} *any* *using* *wildcards* *weight* {0.5}))] Not seeing info about changes at http://docs.basex.org/wiki/Full-Text . -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 8

discard-document equivalent
by George Sofianos 23 Jul '16

23 Jul '16

Hi again, I wonder if there is an equivalent command to discard-document which is available in Saxon PE? I have a list of XML documents available in a remote repository, and I make the same checks in every XML in a for loop. Example: let $list := ("http://url1", "http://url2", "http://url3", "http://url4") for $file in $list return local:runChecks(doc($file)) If the documents are large, they will keep filling the memory. I just run a script that uses 42 files about 50mb each, and that consumed over 2GB of memory. The checks are quite complex so I don't think that the fetch module would work here, if my understanding is correct about what it does. For more information about how discard-document works, see my question/answer on SO: http://stackoverflow.com/questions/34514859/using-discard-document-with-sax… Thanks!

2 1

Behaviour of db:open('mydb') update {} in updating functions
by Maximilian Gärber 22 Jul '16

22 Jul '16

Hi, I just noticed that when I use a db that is opened this way, I cannot do updates anymore. Example: declare variable $_:PUB := db:open('PUB') update {}; Then, inside updating function: let $sec := $_:PUB//Section[@Guid = $id] return replace node trace($sec) with <Section>changed</Section> There is no error whatsoever, the update simply doesnt happen. (BaseX 8.4.4) Bug? Regards, Max

2 1

Schema validation
by George Sofianos 22 Jul '16

22 Jul '16

Hi, I wonder what is the status of schema validation in BaseX? I have a Java web service that is used to validate some schemas, which is using xerces2 to validate XML files. I want to transfer some of this work to my XQuery scripts in BaseX, so I can minimize the bandwidth on large files (the XML files are being retrieved from a remote repository). I did try to put xercesImpl.java on the lib directory, the validation does run, but I'm not sure about these two things 1) Is the new version of xerces being used, or is the Java default one being used? Maybe it's possible to add a function to return the library being used? 2) My Java service (which is using xerces2) is running the validation in about 5 seconds, the same validation takes 32 seconds in BaseX 8.5.1 Any ideas, tips etc are welcome Thanks, George.

3 6