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

Re: [basex-talk] [EXTERNAL] - Re: Re. Encoding support for the BaseX server
by Christian Grün 05 Sep '20

05 Sep '20

> > Please find the attached zip, which contains the sample program for > replicating the encoding issue with the provided datafiles. > Could you please review the provided sample and help me in resolving > this issue. > After having created "testenvSSL1" database, and after having fixed your local paths, I ran your example, and it didn’t trigger any errors. Please give me more information on what you believe goes wrong.

1 0

WebDAV username and password
by Nicholas Saunders 04 Sep '20

04 Sep '20

How to authenticate with WebDAV? nicholas $ nicholas $ lynx http://localhost:8984/webdav/ --dump HTTP: Access authorization required. Use the -auth=id:pw parameter. Looking up localhost:8984 Making HTTP connection to localhost:8984 Sending HTTP request. HTTP request sent; waiting for response. Alert!: Access without authorization denied -- retrying lynx: Can't access startfile http://localhost:8984/webdav/ nicholas $ Create a user on the docker container? Change the password for the basex user itself? Or, is this from within the basex console for the container?

1 1

Re: [basex-talk] [EXTERNAL] - Re: Re. Encoding support for the BaseX server
by Christian Grün 03 Sep '20

03 Sep '20

Hi Sharath, I would appreciate if you could spend some more time on preparing code (e.g. a Java class) that we can run out of the box. This way, we can ensure that the problem is really caused by BaseX, and not the framework you might be using. Thanks, Christian On Thu, Sep 3, 2020 at 4:43 PM Sharath Babu Pulumati <spulumat(a)opentext.com> wrote: > Hi Christian, > > The detailed steps are below, > > 1. Installed the BaseX and started the BaseX server, with default > configuration. > 2. Using the xqj client, for communicating with the basex sever. > 3. Using db::replace(), I have tried pushing and pulling of the > document in basex. > > > Can we have a quick call at any time, to discuss on this issue. > > Thanks & Regards, > Sharath. > ------------------------------ > *From:* Christian Grün <christian.gruen(a)gmail.com> > *Sent:* Thursday, September 3, 2020 5:29 PM > *To:* Sharath Babu Pulumati <spulumat(a)opentext.com> > *Cc:* James Ball <basex-talk(a)jamesball.co.uk>; BaseX < > basex-talk(a)mailman.uni-konstanz.de> > *Subject:* [EXTERNAL] - Re: Re. Encoding support for the BaseX server > > Hi Sharath, > > It's difficult to tell what might go wrong in your setup. Could you please > provide us with a step-by-step procedure that allows us to reproduce the > problem? > > Thanks in advance, > Christian > > > > Sharath Babu Pulumati <spulumat(a)opentext.com> schrieb am Do., 3. Sep. > 2020, 13:55: > > Hi, > > I'm facing an issue with the basex when trying to import documents, > > 1. With specified and un-specified encoding values. > 2. Importing the document which are exported from basex server. > > Getting the below error when trying to import the exported document from > basex server with below content: > > *Imported Document Content to BaseX: * > <?xml version="1.0" encoding="ISO-8859-1"?> >  > <root> > <name>mahesh</name> > </root> > > *Received Document Content from BaseX:* >  > <root> > <name>mahesh</name> > </root> > > > *NOTE: Data loss of encoding is occurred. * > > > *Error:* Invalid byte 1 of 1-byte UTF-8 sequence. > *Stack trace:* > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) 16:33:35,895 DEBUG > [default task-3] com.xmlstore.service.BaseXXmlStoreService - id: > 0601e16280001ada slot: 0101e162800009130 > > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) [16:33:35.911] > TRACE: XQConnection-1.createExpression() invoked. > > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) [16:33:35.911] > TRACE: XQConnection.getStaticContext() invoked. > > 2020-09-03 16:33:35,926 INFO [stdout] (default task-3) [16:33:35.926] > TRACE: XQExpression-6.executeQuery(), raw XQuery resolved to: > db:replace('testenvSSL1', '6301e16280000114/0601e16280001ada.xml', > 'C:\Program Files (x86)\BaseX\data\0601e16280001ada.xml') > > 2020-09-03 16:33:35,989 INFO [stdout] (default task-3) [16:33:35.989] > DEBUG: XQExpression-6.close() invoked. > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) > javax.xml.xquery.XQException: > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) *BXCE001 - > Stopped at ., 1/11*: > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) [FOUP0002] > "C:/Program Files (x86)/BaseX/data/0601e16280001ada.xml" *(Line 1): > Invalid byte 1 of 1-byte UTF-8 sequence.* > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) at > deployment.XMLStoreService.ear.XMLStoreService.war//com.xmlstore.repository.BaseXQueryProcessorClient.storeDocument(BaseXQueryProcessorClient.java:354) > > Could you please help me in resolving this issue, as we are near to our > release. > > Thanks & Regards, > Sharath. > >

1 0

Re: [basex-talk] Re. Encoding support for the BaseX server
by Christian Grün 03 Sep '20

03 Sep '20

Hi Sharath, It's difficult to tell what might go wrong in your setup. Could you please provide us with a step-by-step procedure that allows us to reproduce the problem? Thanks in advance, Christian Sharath Babu Pulumati <spulumat(a)opentext.com> schrieb am Do., 3. Sep. 2020, 13:55: > Hi, > > I'm facing an issue with the basex when trying to import documents, > > 1. With specified and un-specified encoding values. > 2. Importing the document which are exported from basex server. > > Getting the below error when trying to import the exported document from > basex server with below content: > > *Imported Document Content to BaseX: * > <?xml version="1.0" encoding="ISO-8859-1"?> >  > <root> > <name>mahesh</name> > </root> > > *Received Document Content from BaseX:* >  > <root> > <name>mahesh</name> > </root> > > > *NOTE: Data loss of encoding is occurred. * > > > *Error:* Invalid byte 1 of 1-byte UTF-8 sequence. > *Stack trace:* > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) 16:33:35,895 DEBUG > [default task-3] com.xmlstore.service.BaseXXmlStoreService - id: > 0601e16280001ada slot: 0101e162800009130 > > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) [16:33:35.911] > TRACE: XQConnection-1.createExpression() invoked. > > 2020-09-03 16:33:35,911 INFO [stdout] (default task-3) [16:33:35.911] > TRACE: XQConnection.getStaticContext() invoked. > > 2020-09-03 16:33:35,926 INFO [stdout] (default task-3) [16:33:35.926] > TRACE: XQExpression-6.executeQuery(), raw XQuery resolved to: > db:replace('testenvSSL1', '6301e16280000114/0601e16280001ada.xml', > 'C:\Program Files (x86)\BaseX\data\0601e16280001ada.xml') > > 2020-09-03 16:33:35,989 INFO [stdout] (default task-3) [16:33:35.989] > DEBUG: XQExpression-6.close() invoked. > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) > javax.xml.xquery.XQException: > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) *BXCE001 - > Stopped at ., 1/11*: > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) [FOUP0002] > "C:/Program Files (x86)/BaseX/data/0601e16280001ada.xml" *(Line 1): > Invalid byte 1 of 1-byte UTF-8 sequence.* > > 2020-09-03 16:33:35,989 ERROR [stderr] (default task-3) at > deployment.XMLStoreService.ear.XMLStoreService.war//com.xmlstore.repository.BaseXQueryProcessorClient.storeDocument(BaseXQueryProcessorClient.java:354) > > Could you please help me in resolving this issue, as we are near to our > release. > > Thanks & Regards, > Sharath. > >

1 0

Question about map:merge
by Markus Schmid 03 Sep '20

03 Sep '20

Hi, I have a small code sample ScriptOrig.xqy (https://gitlab.com/ms452206/stackoverflow63684864). I am not sure what is wrong. While I expected this output: <database name="DS0002" autosar="AutosarFoo02.arxml" fibex="FibexFoo02.xml"/> <database name="DS0003" autosar="AutosarFoo03.arxml" fibex="FibexFoo03.xml“/> I got this: <database name="DS0002" autosar="AutosarFoo02.arxml" fibex=""/> <database name="DS0003" autosar="AutosarFoo03.arxml" fibex="“/> The modified version ScriptModified.xqy works as required. You can reproduce this using BaseX 9.4.2. I have more weird function using map:entry. Thank you for exploring this. Markus

2 3

ancestor axis i.c.w. fetched XML issue
by RobStapper 31 Aug '20

31 Aug '20

Hi Christian, I encountered some inconsistency when using an fetched XML-node in combination with xpath’s ancestor-axis. I attached a small snippet. I expect an ancestor here. It works alright if the XML-node is not fetched from a document or in case of the parent-axis. Best Regards, Rob Stapper Sent from Mail for Windows 10 -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 8

json:doc-available()
by Hans-Juergen Rennau 30 Aug '20

30 Aug '20

Dear BaseX team, it's really great that now we have functions json:doc(), csv:doc() and html:doc(). In my opinion it becomes increasingly obvious that BaseX is a powerful data integration platform. Perhaps you will also add the corresponding xxx:doc-available() functions? Kind regards,Hans-Jürgen

2 1

superfluous shape="area' when using html:parse()
by Jos van den Oever 30 Aug '20

30 Aug '20

Hi all, When loading a document with html:parse(), an extra attribute is added to every <a/> element. <a href="abc"></a> becomes <a shape="rect" href="abc"></a> This error is even shown in the example on the wiki: https://docs.basex.org/wiki/HTML_Module It turns out this behaviour can be avoided by using the 'nodefaults" option of TagSoup: html:doc($uri, map { 'nodefaults': true() }) That's a lot faster than removing these attributes from loaded document. ⤳Jos

2 1

Re: [basex-talk] [EXTERNAL] - Re: XQExpression-8.executeQuery() API throws java.lang.NullPointerException exception while executing XQuery(retrieving the 171 MB xml document) like db:open('testenvSSL1', '6300000180000114/0600000180002931.xml')
by Christian Grün 28 Aug '20

28 Aug '20

Exactly; it’s called Client API in the documentation: https://docs.basex.org/wiki/Java_Examples Srikumar Choudhury <schoudhu(a)opentext.com> schrieb am Fr., 28. Aug. 2020, 07:33: > Hi Christian, > Are you talking about BasexClient as mentioned in > below link? is this BaseX API? > > > https://github.com/BaseXdb/basex/blob/master/basex-examples/src/main/java/o… > Thanks, > Srikumar > ------------------------------ > *From:* Christian Grün <christian.gruen(a)gmail.com> > *Sent:* Thursday, August 27, 2020 7:57 PM > *To:* Srikumar Choudhury <schoudhu(a)opentext.com> > *Cc:* BaseX <basex-talk(a)mailman.uni-konstanz.de>; Rajiv Pandya < > rpandya(a)opentext.com>; Sharath Babu Pulumati <spulumat(a)opentext.com> > *Subject:* Re: [EXTERNAL] - Re: XQExpression-8.executeQuery() API throws > java.lang.NullPointerException exception while executing XQuery(retrieving > the 171 MB xml document) like db:open('testenvSSL1', > '6300000180000114/0600000180002931.xml') > > …and our own API will definitely consume less memory. Did you try it as > well? > > > > On Thu, Aug 27, 2020 at 2:55 PM Christian Grün > <christian.gruen(a)gmail.com> wrote: > > > > > do I need to increase -Xmx4096m to higher? > > > > +1 >

1 0

Re: [basex-talk] [EXTERNAL] - Re: XQExpression-8.executeQuery() API throws java.lang.NullPointerException exception while executing XQuery(retrieving the 171 MB xml document) like db:open('testenvSSL1', '6300000180000114/0600000180002931.xml')
by Christian Grün 27 Aug '20

27 Aug '20

> do I need to increase -Xmx4096m to higher? +1

1 1

Unpredictable function return types seems to default to item()? instead of item()*. Applies to 9.4.2
by Wiemer, Sebastian 27 Aug '20

27 Aug '20

Hi, Thank you Christian for the new 9.4.2. release! The function "f()" below will yield to the error: "Cannot promote item()? to xs:integer?: $result_4" This works in BaseX 9.1 ------ declare function local:f() as xs:integer()*{ let $id := client:connect("localhost", 1984, "admin", "admin") let $result := client:query($id, "1,2") let $close := client:close($id) return $result }; local:f() ----- I guess, that unpredictable return types at compile time default to item()? instead of item()* and thus cannot be used in a function returning anything else but item()? Has someone an idea for a solution/workaround for this? Best regards, Sebastian Eine Studie. Über 1300 Befragte. Ein Thema: Künstliche Intelligenz. https://ki.adesso.de/de/erste-schritte/index.html?pk_campaign=KI%20Report&p… ------------------------------------------------------- >>> business. people. technology. <<< ------------------------------------------------------- adesso SE mit Sitz in Dortmund Vorstand: Michael Kenfenheuer (Vors.), Dirk Pothen, Andreas Prenneis, Stefan Riedel, Jörg Schroeder Vorsitzender des Aufsichtsrates: Prof. Dr. Volker Gruhn Amtsgericht Dortmund HRB 20663

2 2

Xquery performence
by chandra sekhar n 27 Aug '20

27 Aug '20

Dear Basex team, We are facing an xquery performance issue. Please find the query in below and please suggest any clue to optimize query let $subbrk := (collection("867509_Voice_DECEMBER-19_Billed_1")/SUBCUSTBRK) let $detailUsageTxn := $subbrk/DETAIL/TRANSACTION[@Usage = 'usage'] let $DistCallTypesAll := ($detailUsageTxn/SUB_SECTION/@Type) let $DistCallTypes := ( for $r in $DistCallTypesAll group by $ct := $r return $ct) *//Here taking nearly 3 minutes* let $allmonths := distinct-values($subbrk/Month) let $rowcnt := count($detailUsageTxn/SUB_SECTION) let $months := $allmonths[position() le 10000] let $opttype := 'NumVal' let $durop := 'hh:mm:ss' return ( if($DistCallTypes!='' ) then( for $month in $months return <R> <GRPBY>{ $month }</GRPBY>{ if($opttype = 'NumVal') then for $ct in $DistCallTypes let $ctCnt := sum($detailUsageTxn/SUB_SECTION[data(@Type) = data($ct) and data(../../../Month) = $month]/@Calls) *//Here taking 4 to 5 minutes* return element { replace(concat('_',data($ct)),'(\.|\[|\]|\\|\||\-|\^|\$|\?|\*|\+|\{|\}|$|$| |')', '_') } {xs:decimal($ctCnt)} else () } </R>) else() ) Regards, Chandrasekhar

2 2

Re: [basex-talk] BaseX - CORS
by Andy Bunce 27 Aug '20

27 Aug '20

Hi Elina, (cc: basex-talk) Happy to help. That email correspondence is a bit old, and the code referenced is ancient. I suspect your problems creating the headers in XQuery restxq are due to default namespace prefix changes, rest vs restxq, way back when. You are correct that enabling the supplied CORS filter in web.xml works for GET and POST but not PUT. The reason is that PUT is not in the default AllowedMethods [1] As an exercise I have created a little sample that uses only RESTXQ facilities. [2] It assumes the web.xml CORS filter is not enabled. As supplied it has: A cors.html file, to be opened directly in the browser, i.e. using the file protocol. A cors.xqm intended to be put in the webapp folder of a local basexhttp running on 8984 Only the PUT request is allowed as I have commented out the Xquery generation of the CORS headers for GET and POST. Note PUT is a non-simple CORS request and will result in the browser sending an additional request using the OPTIONS method [3] This can be seen in the screenshot and is handled in the cors.xqm code. Hope this helps /Andy [1] https://www.eclipse.org/jetty/documentation/current/cross-origin-filter.html [2] https://gist.github.com/apb2006/ea6a901a570b04f94e0e0e21098a5402 [3] https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS#Preflighted_requests [image: image.png] On Fri, 7 Aug 2020 at 13:53, Elina Koskentalo <ekoskent(a)gmail.com> wrote: > Hello Andy, > > I hope you don't mind me contacting you, I found this email corresponding > between you and another person about BaseX and adding > the Access-Control-Allow-Origin header to the response. > https://mailman.uni-konstanz.de/pipermail/basex-talk/2017-February/011782.h… > > I have a very similar issue than what you are talking about there. I don't > manage to define a rule in the restxq file that would simply add > Access-Control-Allow-Origin header to or requests. I already manipulated > the filters in the web.xml file which now works for GET but for PUT I still > get the CORS issue back. > > Would you have any tips for me? Thank you very much in advance! > > Best regards, > Elina Koskentalo > ekoskent(a)gmail.com >

3 4

Stack Overflow on 9.4.2
by AirQuick 25 Aug '20

25 Aug '20

This `test.xq` file works on BaseX 9.4.1: ``` xquery version "3.1"; import module "urn:x-xspec:common:deep-equal" at "https://github.com/xspec/xspec/raw/c629869560ab2bce3a6199569917de70ede4bbc3…"; let $r := Q{urn:x-xspec:common:deep-equal}deep-equal((), (), '') return element test { $r } ``` $ BaseX941/basex/bin/basex test.xq /tmp/BaseX941/basex/.basex: writing new configuration file. <test>true</test> But it fails on 9.4.2: $ BaseX942/basex/bin/basex test.xq /tmp/BaseX942/basex/.basex: writing new configuration file. [basex:overflow] Stack Overflow: Try tail recursion? Is it possibly a regression in 9.4.2? -- AirQuick

2 2

XQDoc Parser requires leading colons in doc-comment for @token documentation
by Andreas Mixich 25 Aug '20

25 Aug '20

Hello, when using `inspect:xqdoc#1` on a module, where the lines of doc comments do not start with a leading colon, as shown by the following example: (:~ Description @comment-token :) the output will be missing the element for the @comment-tokens (i.e.:`xqdoc:function/xqdoc:comment/xqdoc:param`). They only get provided, if the leading colons are set, as in: (:~ : Description : : @comment-token :) Since I dislike to add the leading colons I opened up an issue at [1], but according to Loren Cahlander the parser does not seem to require them. Therefore I assume, that this could be implementation dependent. The spec does not require the leading ':', but it seems, that BaseX does. Could the lack of leading colons be tolerated? That would be nice! Thank you. [1]: https://github.com/xqdoc/xqdoc/issues/4 -- Goody Bye, Minden jót, Mit freundlichen Grüßen, Andreas Mixich

2 2

BaseX GUI: XPath suggestions / completion
by andre.aepli＠gmx.ch 25 Aug '20

25 Aug '20

2 2

improving query performance
by Bill Osmond 23 Aug '20

23 Aug '20

Hi all, I'm attempting to query a fairly large database, with 136,938 resources and a size of 12,257,686,099. The basex server itself is an AWS EC2 instance with 4 cores & 16 gigs of ram, using -Xmx12g. The database contains audio DDEX information which (to me at least) is fairly complicated XML. The query I'm running against the database works and gives me the result I want, but takes upwards of 15 minutes to execute. I've taken a look at the wiki documentation regarding indexes, but it's not clear to me that any of the non-default indexes would help for the query I'm running. That query is: declare namespace ernm="http://ddex.net/xml/ern/411"; for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity> Am I wrong, and would an additional value index help here? Or is my query just bad? Thanks, Bill p.s. The BaseX GUI client is awesome - especially the treemap view. Really helps with wrangling these XML files!

4 16

Re: [basex-talk] documentation flaw
by Christian Grün 22 Aug '20

22 Aug '20

Hi Rob, you are right. I have replaced "or" with "and". Thanks for the hint. – Best, Christian On Sat, Aug 22, 2020 at 12:57 PM RobStapper <r.stapper(a)lijbrandt.nl> wrote: > Hi, > > > > I have my doubts about the expressions used at the “tertium non > datur”-principle in the documentation [1]. > > Or the expression should be “$a or not($a)” or the rewritten expression > should be “false()” . > > > > [1]: https://docs.basex.org/wiki/XQuery_Optimizations#Pure_Logic > > > > Best regards, > > > > Rob Stapper > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> > <#m_-2765550508791472733_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> >

1 0

documentation flaw
by RobStapper 22 Aug '20

22 Aug '20

Hi, I have my doubts about the expressions used at the “tertium non datur”-principle in the documentation [1]. Or the expression should be “$a or not($a)” or the rewritten expression should be “false()” . [1]: https://docs.basex.org/wiki/XQuery_Optimizations#Pure_Logic Best regards, Rob Stapper Sent from Mail for Windows 10 -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

Error: Stopped at ., 1/20: [FODC0002] Resource 'C:/Srikumar/Software/BaseX/BaseX941/basex/bin/6301904f80000114/0601904f80007547.xml' does not exist.
by Srikumar Choudhury 21 Aug '20

21 Aug '20

Hi Christian, Why I am getting below error message, even though 0601904f80007547.xml file exist in database. if we will open the corresponding database using basexgui.bat(i.e., open "JunitDocbaseDB" database in GUI), then xqPreparedExpr.executeQuery() java api is returning proper 0601904f80007547.xml data(see below log), otherwise throwing same below error message. How I can resolve this issue or it is bug? BXCE001 - Stopped at ., 1/20: [FODC0002] Resource 'C:/Srikumar/Software/BaseX/BaseX941/basex/bin/6301904f80000114/0601904f80007547.xml' does not exist. Open basex.bat: ================= > XQUERY db:open('JunitDocbaseDB', '6301904f80000114/0601904f80007547.xml')  <testSuiteConfig version="2.0"> <testSuiteEnv> <paths> <path type="input" value="../data"/> </paths> </testSuiteEnv> <package name="com.documentum.test.xhive_integration.uc_1.uc_1_1"> <test name="TC_1_1_1" className="TC_1_1_1"/> </package> </testSuiteConfig> Query executed in 12.59 ms. > XQUERY for $article in doc('6301904f80000114/0601904f80007547.xml') return $article Stopped at ., 1/20: [FODC0002] Resource 'C:/Srikumar/Software/BaseX/BaseX941/basex/bin/6301904f80000114/0601904f80007547.xml' does not exist. Run same xquery from java program: ================================== XQPreparedExpression xqPreparedExpr = null; XQResultSequence resultSeq = null; String xQuery = "for $article in doc('6301904f80000114/0601904f80007547.xml') return $article"; xqPreparedExpr = m_conn.prepareExpression(xQuery); resultSeq = xqPreparedExpr.executeQuery(); Log: ==== [13:17:10.034] TRACE: XQConnection-1.prepareExpression(String) invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:17:10.034] TRACE: XQConnection-1.prepareExpression(String, XQStaticContext) invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:17:10.035] TRACE: XQPreparedExpression-1.executeQuery() invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:17:10.036] TRACE: XQPreparedExpression-1.executeQuery(), raw XQuery resolved to: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article javax.xml.xquery.XQException: BXCE001 - Stopped at ., 1/20: [FODC0002] Resource 'C:/Srikumar/Software/BaseX/BaseX941/basex/bin/6301904f80000114/0601904f80007547.xml' does not exist. Run same xquery using above same java program:(after opening basexgui.bat and open "JunitDocbaseDB" database in GUI) ============================================== log: ==== [13:22:49.313] TRACE: XQConnection-2.prepareExpression(String) invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:22:49.313] TRACE: XQConnection-2.prepareExpression(String, XQStaticContext) invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:22:49.315] TRACE: XQPreparedExpression-1.executeQuery() invoked, with the raw XQuery of: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:22:49.315] TRACE: XQPreparedExpression-1.executeQuery(), raw XQuery resolved to: for $article in doc('6301904f80000114/0601904f80007547.xml') return $article [13:22:49.318] DEBUG: XQPreparedExpression-1.close() invoked. Finished executing xquery with query Start iterating through the xquery results for query 0 Result :  <testSuiteConfig version="2.0"> <testSuiteEnv> <paths> <path type="input" value="../data"/> </paths> </testSuiteEnv> <package name="com.documentum.test.xhive_integration.uc_1.uc_1_1"> <test name="TC_1_1_1" className="TC_1_1_1"/> </package> </testSuiteConfig> Thanks, Srikumar

2 16

multi-line queries in the command line client
by Bill Osmond 20 Aug '20

20 Aug '20

Hi all, First, thanks for making BaseX! I'm in the process of learning it (and XQuery) after an ill-fated attempt to coerce complicated XML data into a relational database, and I'm optimistic about the prospects of success. But there is one thorn in my side: it seems like xquery commands have to all be on a single line when run from the command line client. Multiple lines/indentation goes a long way towards helping me mentally structure the queries I'm (trying to) run, but it seems I have to join them together on a single line in order to actually run them. I've tried the standard \ character with no luck, and I couldn't find anything in the documentation about it. Is there any solution, or is that just the way it is? Thanks, Bill

2 2

problems using Archive module with certain zip files
by Lizzi, Vincent 20 Aug '20

20 Aug '20

Hello, I'm using BaseX in several file conversion projects that involve unpacking a zip file using the Archive module, modifying the files that are found inside with the File module and XSLT module, and creating new zip file(s) using the Archive module again. BaseX is very useful for these kinds of transformations and makes it quick to develop a transformation complete with unit tests. I'm running in to 2 kinds of problems with certain zip files and getting the following error messages from the Archive module. 1. When attempting to extract certain zip files archive:extract-to() or archive:entries() produce this error message "Operation failed: only DEFLATED entries can have EXT descriptor." The zip files that produce this error can be extracted using another program such as 7zip, which might be better at handling variations in the structure of some zip files. 2. When attempting to create a zip file larger than about 2 Gb. After extracting a zip file larger than about 2 Gb using archive:extract-to (which works), when trying to create a new zip file file:write-binary($newZip, archive:create-from($tempDir)) produces a stack trace that begins with: java.lang.ArrayIndexOutOfBoundsException: Maximum array size reached. at org.basex.util.Array.checkCapacity(Array.java:322) at org.basex.util.Array.newCapacity(Array.java:313) at org.basex.util.Array.newCapacity(Array.java:301) at org.basex.io.out.ArrayOutput.write(ArrayOutput.java:32) at java.base/java.io.OutputStream.write(OutputStream.java:157) at java.base/java.util.zip.DeflaterOutputStream.deflate(DeflaterOutputStream.java:253) at java.base/java.util.zip.DeflaterOutputStream.write(DeflaterOutputStream.java:211) at java.base/java.util.zip.ZipOutputStream.write(ZipOutputStream.java:332) at java.base/java.io.FilterOutputStream.write(FilterOutputStream.java:108) at org.basex.query.func.archive.ZIPOut.write(ZIPOut.java:44) at org.basex.query.func.archive.ArchiveCreate.add(ArchiveCreate.java:138) I'm currently using BaseX version 9.4.1 and Java 64-bit openjdk version "11.0.7" 2020-04-14. This might be a bug in BaseX handling of zip files. Is there any solution or workaround? Thanks, Vincent ______________________________________________ Vincent M. Lizzi Head of Information Standards | Taylor & Francis Group 530 Walnut St., Suite 850, Philadelphia, PA 19106 E-Mail: vincent.lizzi(a)taylorandfrancis.com Phone: 215-606-4221 Web: www.tandfonline.com Taylor & Francis is a trading name of Informa UK Limited, registered in England under no. 1072954 "Everything should be made as simple as possible, but not simpler." Information Classification: General

2 1

Re: [basex-talk] Starten Unit Test Module in XQuery
by Markus Schmid 20 Aug '20

20 Aug '20

Hi Christian thank you for the response. The solution is good (far better than code generating .bat files ..). I slightly modified the solution in order to run the same testsuites with different testdata in one script: declare function test:runtests() { for-each( map:keys($test:dbset), function($k) { test:runtest($test:dbset($k)) } ) }; declare function test:runtest($databases) { let $testdata := $databases/@data let $name := $databases/@name let $dummy := trace(concat('runtest for testdata : ‘,$name)) let $args := ('-cp','C:\Arbeit\Tools\BaseX932\basex\BaseX.jar','org.basex.BaseX','-b',concat('{mytests}data=',$testdata),'-o',concat('C:\Arbeit\Tasks\UnitTests\TestResult',$name,'.xml'),'-t','C:\Arbeit\Tasks\UnitTests\TestModules\') return ( try {proc:system('java',$args)} catch * { } ) }; let $result := test:runtests() return() Using the try / catch block is important here else the script stops when the first test failure occurs. Markus > Am 20.08.2020 um 09:10 schrieb Christian Grün <christian.gruen(a)gmail.com>: > > Hi Markus, > >> Ist es möglich, ein Unit Test Module (https://docs.basex.org/wiki/Unit_Module#Query) über ein XQuery Script zu starten und die Testausgabe in ein File umzuleiten? > > As you’ve already noted, unit tests must always be started outside an > XQuery expression. The reason is that sequentially executed unit tests > may have come with all kinds of side effects which go beyond the scope > of a single query. > > The following solution doesn’t necessarily distinguish itself through > elegance, but you could launch a second BaseX instance with the > Process Module [1] and convert the string output to an XML document > via fn:parse-xml: > > let $args := ('-cp', '/path/to/basex.jar', 'org.basex.BaseX', '-t', > '/path/to/tests') > let $result := proc:system('java', $args) > return parse-xml($result) > > This way, your tests will be run in an independent BaseX context. If > you invoke the function from the directory in which your BaseX > instance and the tests reside, you can omit the absolute paths > (/path/to/). > > Hoppe this helps, > Christian > > [1] https://docs.basex.org/wiki/Process_Module#proc:system

1 0

Starten Unit Test Module in XQuery
by Markus Schmid 20 Aug '20

20 Aug '20

Hi Ist es möglich, ein Unit Test Module (https://docs.basex.org/wiki/Unit_Module#Query) über ein XQuery Script zu starten und die Testausgabe in ein File umzuleiten? (Ich kenne nur die Möglichkeiten, das Module über das TEST Kommando und die Command line unter Angabe der -t Option zu starten). Danke für die Antwort. Markus Schmid

2 1

Can't serialize entities to XML
by Andreas Mixich 18 Aug '20

18 Aug '20

Hi, a REST API returns data in JSON, which I have requested via the http-client's `http:send-request#1` function with the following code: 1. let $data := local:get-article($token, concat($local:ahost, $link))/json 2. let $response := json:serialize($data, map{'format':'xquery'}) 3. => json:parse(map{'format':'xquery'}) 4. let $child := $response(2)?data?children(1)?data 5. return $child?body_html BaseX returns the JSON XML-encoded (see line 1), so I serialize once into JSON (line 2), then to XQuery Map (line 3). In line 4 I return data, that can look like this: <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p> In the further process I would like this to become proper XHTML. I tried all the different `fn:serialize#2` parameters. Either the data stays the same or it gets re-entitized. I also tried `html:parse#1` but get the error: [html:parse] Line 1: No text allowed before root element. I also tried casting to `xs:normalizedString` or using `fn:normalize-space#1` to no avail, before the `html:parse#1` As last I tried document { $child?body_html } which did not change anything in the output. If I do this, however: let $data := ' <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p>' return $data I get this: <div class="md"><p>Welcome everyone from <a href="/r/all">r/all</a>! Please remember:</p> So my question is: How can I serialize this into XHTML (de-entitze it)? Thanks. -- Goody Bye, Minden jót, Mit freundlichen Grüßen, Andreas Mixich

2 4

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk