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

BaseX 9.6: The Summer Edition
by Christian Grün 28 Nov '24

28 Nov '24

Dear all, We provide you with a new and fresh version of BaseX, our open source XML framework, database system and XQuery 3.1 processor: https://basex.org/ Apart from our main focus (query rewritings and optimizations), we have added the following enhancements: XQUERY: MODULES, FEATURES - Archive Module, archive:write: stream large archives to file - SQL Module: support for more SQL types - Full-Text Module, ft:thesaurus: perform Thesaurus queries - Fulltext, fuzzy search: specify Levenshtein limit - UNROLLLIMIT option: control limit for unrolling loops XQUERY: JAVA BINDINGS - Java objects of unknown type are wrapped into function items - results of constructor calls are returned as function items - the standard package "java.lang." has become optional - array arguments can be specified with the middle dot notation - conversion can be controlled with the WRAPJAVA option - better support for XQuery arrays and maps WEB APPLICATIONS - RESTXQ: Server-Timing HTTP headers are attached to the response For a more comprehensive list of added and updated features, look into our documentation (docs.basex.org) and check out the GitHub issues (github.com/BaseXdb/basex/issues) Have fun, Your BaseX Team

11 43

recursively used variables
by Rob Stapper 12 Aug '24

12 Aug '24

Hi, The code[1] below and send as attachment generates a error message: “Static variable depends on itself: $Q{http://www.w3.org/2005/xquery-local-functions}test”. I use these variables to refer to my private functions in my modules so I can easyly refer to them in a inheritance situation. It’s not a big problem for me but I was wondering if the error-triggering is justified or that it should work. [1]=========================================== declare variable $local:test := local:test#1 ; declare %private function local:test( $i) { if ( $i > 0) then $local:test( $i - 1) } ; $local:test( 10) =========================================== Kind 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

4 7

Error running dba in Tomcat 9.0 with BaseX v. 9.5 and above
by Kim Galeazzi 04 Oct '21

04 Oct '21

Launching the dba application in BaseX 9.5 and above deployed on Tomcat 9.0 throws an error: Exception javax.servlet.ServletException: Servlet execution threw an exception org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Cause java.lang.NoClassDefFoundError: org/eclipse/jetty/websocket/api/WebSocketAdapter java.lang.ClassLoader.defineClass1(Native Method) java.lang.ClassLoader.defineClass(ClassLoader.java:760) java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2478) org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:870) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1371) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1215) org.basex.query.func.session.SessionFn.session(SessionFn.java:31) org.basex.query.func.session.SessionGet.value(SessionGet.java:17) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) org.basex.query.expr.ParseExpr.ebv(ParseExpr.java:71) org.basex.query.expr.If.expr(If.java:181) org.basex.query.expr.If.iter(If.java:161) org.basex.query.scope.MainModule.iter(MainModule.java:97) org.basex.query.QueryContext.iter(QueryContext.java:326) org.basex.http.restxq.RestXqResponse.serialize(RestXqResponse.java:84) org.basex.http.web.WebResponse.create(WebResponse.java:66) org.basex.http.restxq.RestXqServlet.run(RestXqServlet.java:69) org.basex.http.BaseXServlet.service(BaseXServlet.java:65) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Cause java.lang.ClassNotFoundException: org.eclipse.jetty.websocket.api.WebSocketAdapter org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1407) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1215) java.lang.ClassLoader.defineClass1(Native Method) java.lang.ClassLoader.defineClass(ClassLoader.java:760) java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2478) org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:870) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1371) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1215) org.basex.query.func.session.SessionFn.session(SessionFn.java:31) org.basex.query.func.session.SessionGet.value(SessionGet.java:17) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) org.basex.query.expr.ParseExpr.ebv(ParseExpr.java:71) org.basex.query.expr.If.expr(If.java:181) org.basex.query.expr.If.iter(If.java:161) org.basex.query.scope.MainModule.iter(MainModule.java:97) org.basex.query.QueryContext.iter(QueryContext.java:326) org.basex.http.restxq.RestXqResponse.serialize(RestXqResponse.java:84) org.basex.http.web.WebResponse.create(WebResponse.java:66) org.basex.http.restxq.RestXqServlet.run(RestXqServlet.java:69) org.basex.http.BaseXServlet.service(BaseXServlet.java:65) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) I tried adding the Ecplise websocket API jar to the lib folder without success. Any ideas? We rely on the RESTXQ for our implementations and find the dba web application very convenient for accessing the logs and managing the database. Thank you. [cid:image001.jpg@01D799B4.AF02AC70]<http://www.inspirage.com/> Kim Galeazzi | Manager, Solution Architecture, Oracle/Agile PLM Consulting Office: 408-680-8837<tel:%28408%29%20680-8837> | Mobile: 408-466-2121<tel:%28408%29%20466-2121> | Campbell, CA This email communication is considered business confidential and intended for the original recipient of this email only.

2 3

Error executing an SQL query using «SQL Module»
by Artur Moor 27 Aug '21

27 Aug '21

*Dear all,* *When executing an SQL query with the SQL module:* sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), let $connection := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") return sql:execute($connection, "SELECT * FROM TABLE") *I get the following error message:* Error: Stopped at /Users/sa/staging/file, 3/19: [sql:error] An SQL exception occurred: Das Resultset wurde geschlossen. Compiling: - inline let $connection_0 := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") - simplify FLWOR expression: sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") ! sql:execute(., "SELECT * FROM TABLE") Optimized Query: (sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") ! sql:execute(., "SELECT * FROM TABLE")) Query: sql:init("com.microsoft.sqlserver.jdbc.SQLServerDriver"), let $connection := sql:connect("jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME", "username", "pa$$w0rd") return sql:execute($connection, "SELECT * FROM TABLE") Query Plan: <QueryPlan compiled="true" updating="false"> <List type="item()*"> <SqlInit name="sql:init" type="empty-sequence()" size="0"> <Str type="xs:string" size="1">com.microsoft.sqlserver.jdbc.SQLServerDriver</Str> </SqlInit> <IterMap type="item()*"> <SqlConnect name="sql:connect" type="xs:integer" size="1"> <Str type="xs:string" size="1">jdbc:sqlserver://SQLHOST:1433;databaseName=DBNAME</Str> <Str type="xs:string" size="1">username</Str> <Str type="xs:string" size="1">pa$$w0rd</Str> </SqlConnect> <SqlExecute name="sql:execute" type="item()*"> <ContextValue type="xs:integer" size="1"/> <Str type="xs:string" size="1">SELECT * FROM TABLE</Str> </SqlExecute> </IterMap> </List> </QueryPlan> *Does anyone have an idea what the problem is?* *Any hints are welcome!*

2 9

XQuery output without namespace declaration
by Yann NICOLAS (ABES) 25 Aug '21

25 Aug '21

Hi all, I am looking for the equivalent instruction of XSLT attribute @omit-xml-declaration in XQuery. My input is : > <marc> > <marc:record *xmlns:marc="http://www.loc.gov/MARC21/slim" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"*> > <marc:leader>01321nam a22002772a 4500</marc:leader> > <c level="item"> > <did> > <unitid type="division">1808001595</unitid> > </did> > </c> > </marc:record> > <marc> My query is : > declare namespace marc="http://www.loc.gov/MARC21/slim"; > > for $record in db:open('marcxml_full')/marc/marc:record > return > insert node $record/c into db:open('uk_parlement_ead')/dsc The ouput is : > <c *xmlns:marc="http://www.loc.gov/MARC21/slim" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" *level="item"> > <did> > <unitid type="division">1808001595</unitid> > </did> > </c> As you can see, there are no marc: elements in this output, hence no need for the marc: namespace. How to get rid of @xmlns:marc and xmlns:xsi ? Thanks a lot for your help ! Regards Yann

3 8

EMail module and javax.activation.DataSource
by dudzikp＠yahoo.com 25 Aug '21

25 Aug '21

Dear all, I am trying to use a basex Email module http://files.basex.org/modules/org/basex/modules/email/EMail.jar. I downloaded a new basex instance (9.6 version) and added this jar to lib directory. Based on the xquery/email.xq file I created the following file: import module namespace email = 'http://basex.org/modules/email/EMail'; let $mail := <email> <from>myuser@machine-office</from> <to>myuser@machine-office</to> <host>localhost</host> <subject>Hello!</subject> <message>Enjoy</message> </email> return email:send($mail) While running the file I obtain: Stopped at /home/myuser/Downloads/basex/file, 12/13: [XPTY0004] javax.activation.DataSource. Caused by: org.basex.modules.email.EMail:send(element()). What's the problem? Shouldn't I use this module? BR

2 1

BaseX 9.6 - BaseX96.zip - missing? Image not found: /img/c_go.png and Image not found: /img/c_editopen.png
by Patrick Durusau 20 Aug '21

20 Aug '21

Great to see the new version! Running ./basexgui 2 image not found messages (omitting the at messages) Image not found: /img/c_go.png and Image not found: /img/c_editopen.png On Debian (Buster I think). Thanks for all the hard work! Patrick -- Patrick Durusau patrick(a)durusau.net Technical Advisory Board, OASIS (TAB) Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300 Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps) Another Word For It (blog): http://tm.durusau.net Homepage: http://www.durusau.net Twitter: patrickDurusau

3 4

org.basex.core.BaseXException with no error message
by Matthew Dziuban 17 Aug '21

17 Aug '21

Hi all, I'm using the java ClientSession class defined in the basex-api module and I'm seeing intermittent org.basex.core.BaseXException errors with an empty error message when executing long-running read queries or CREATE DB commands. The stack trace of the most recent error points to ClientSession.receive ( https://github.com/BaseXdb/basex/blob/9.5.2/basex-core/src/main/java/org/ba… ) org.basex.core.BaseXException: org.basex.api.client.ClientSession.receive(ClientSession.java:190) org.basex.api.client.ClientSession.send(ClientSession.java:178) org.basex.api.client.ClientSession.send(ClientSession.java:215) org.basex.api.client.ClientSession.create(ClientSession.java:128) ... Unfortunately since the message is empty it's difficult to debug what's going wrong. I've checked the log files in basex/data/.logs but haven't found any information about the failure. Is there another place I can look? Or do you have any other recommendations for debugging the errors? Thanks in advance, Matt

2 3

Polling break for loop
by Adam Law 15 Aug '21

15 Aug '21

If polling a url n times and breaking if response is 'completed', is the best to approach to use try catch and error() to get around immutability? I need the full response on complete so I redo the last http get. It is not a biggie requesting twice. Adam On Fri., 13 Aug. 2021, 6:00 pm , <basex-talk-request(a)mailman.uni-konstanz.de> wrote: > Send BaseX-Talk mailing list submissions to > basex-talk(a)mailman.uni-konstanz.de > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > or, via email, send a message with subject or body 'help' to > basex-talk-request(a)mailman.uni-konstanz.de > > You can reach the person managing the list at > basex-talk-owner(a)mailman.uni-konstanz.de > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of BaseX-Talk digest..." > > > Today's Topics: > > 1. XProc? (Jonathan Robie) > 2. Re: XProc? (Martin Honnen) > 3. Pretty-print the -V optimized query? See what indexes are > used? (Jonathan Robie) > 4. Re: XProc? (Imsieke, Gerrit, le-tex) > 5. org.basex.core.BaseXException with no error message > (Matthew Dziuban) > 6. Re: org.basex.core.BaseXException with no error message > (Christian Gr?n) > 7. Re: Pretty-print the -V optimized query? See what indexes are > used? (Christian Gr?n) > 8. Can XQuery return unique values present across multiple > databases? (Tamara Marnell) > 9. Re: Can XQuery return unique values present across multiple > databases? (Martin Honnen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 12 Aug 2021 07:58:04 -0400 > From: Jonathan Robie <jonathan.robie(a)gmail.com> > To: BaseX <basex-talk(a)mailman.uni-konstanz.de> > Subject: [basex-talk] XProc? > Message-ID: > < > CAOkFc+vMLcdXFUZBUvZZVLF8Wc3nKSLASpPKFWV_WPh7hRnEFw(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > What hooks does BaseX provide for XProc? Where can I find examples of > BaseX use in an XProc pipeline? > > Jonathan >

2 3

for-each issue on child-elements
by Rob Stapper 14 Aug '21

14 Aug '21

Hi Christian, I encountered this erroneous behavior while using the for-each-function on a set with child-elements. The evident work-around [2] workd fine. I’m using BaseX 9.6 RC2. I attached the code as attachment. Hope this helps. [1] let $context := <A><B1><C11></C11><C12></C12></B1><B2><C21></C21></B2></A> let $context.processor := function( $context as element( ) , $context.processor as function(*) ) as map(*) { map { $context => name() : $context/child::* => for-each( $context.processor( ? , $context.processor ) ) } } return $context => $context.processor( $context.processor ) [2] let $context := <A><B1><C11></C11><C12></C12></B1><B2><C21></C21></B2></A> let $context.processor := function( $context as element( ) , $context.processor as function(*) ) as map(*) { map { $context => name() : $context/child::* => for-each( function( $child as element( ) ) { $child => $context.processor( $context.processor ) } ) } } return $context => $context.processor( $context.processor ) Rob Sent from Mail for Windows -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

2 1