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

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

tail recursion not happening?
by Graydon Saunders 27 Sep '21

27 Sep '21

Hello -- Using BaseX 9.6.1 on Linux. So I'm trying to convert a compact-ish element pattern string, delimited with braces, back into something that looks like XML vocabulary for readability. (The pattern strings are being used to detect similar structure in the content set.) The test query (below) works fine. Stick the functions in a module namespace, and run the real content, and I get the "Stack Overflow: Try tail recursion?" error. (Query plan for this case attached.) Nothing in the real data should be all that large. I suspect I'm being too clever for my own good somehow, but if anyone can tell me specifically where I'd appreciate it. Thanks! Graydon ====== declare namespace fn = "http://www.w3.org/2005/xpath-functions"; declare variable $NMToken as xs:string := '[\p{L}\p{Nd}._\-:]+'; declare function local:tag($names as xs:string*,$active as xs:string*,$event as xs:string*) { let $do as xs:string := substring($event,1,1) return if (not(normalize-space($do))) then () else if ($do eq '{') then (concat('<',head($names),'>'), local:tag(tail($names),(head($names),$active),substring($event,2))) else (concat('</',head($active),'>'), local:tag($names,tail($active),substring($event,2))) }; declare function local:emitPattern($in as xs:string) as xs:string { let $chunked as element(fn:analyze-string-result) := analyze-string($in,$NMToken) let $names as xs:string+ := $chunked/fn:match/string() let $openClose as xs:string+ := $chunked/fn:non-match => string-join() return string-join(local:tag($names,(),$openClose)) }; let $pattern as xs:string := "{subblock{sublabel}{p}}" let $yikes as xs:string := "{primaryblock{shortdesc}{table{title}{tgroup{colspec}{colspec}{colspec}{thead{row{entry{p}}{entry{p}}{entry{p}}}}{tbody{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p{xref}{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}{xref}{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}{xref}{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}{xref}}}{entry{p}}}{row{entry{p}}{entry{p}}{entry{p}}}{row{entry{p}}{entry{p}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p{xref}{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}{row{entry{p}}{entry{p{xref}}}{entry{p}}}{row{entry{p}}{entry{p{em}}}{entry{p}}}}}}{note{p}}}" return ($pattern,$yikes) ! local:emitPattern(.)

3 6

Passing a map to an external variable
by Graydon Saunders 23 Sep '21

23 Sep '21

Hello -- I suspect I am being a cabbage somehow, but I'm not figuring this out. If I have a query in the GUI (9.6.1) which declares an external variable: declare variable $targetMap external; and set the value via the GUI $x button to: map {'structure' : '/some/path/name'} It doesn't work. Typing the variable as map(*) doesn't work. declare variable $targets external; declare variable $targetMap as map(*) := xquery:eval($targets); does work, but makes me think I must be doing something wrong. How does one go about binding a literal map to an external variable? (I am going to want to do this in a script later; the GUI version is strictly for testing.) Thanks! Graydon

3 4

Problems installing EXPath
by Jonathan Robie 03 Sep '21

03 Sep '21

I tried installing EXPath, but without success. > REPO INSTALL http://files.basex.org/modules/expath/functx-1.0.xar Stopped at , 1/66: [repo:parse] functx-1.0.xar: Resource "expath-pkg.xml" not found.. If I download the .xar and unzip it, it looks like this: [image: image.png] Here is the content of expath-pkg.xml: <package xmlns="http://expath.org/ns/pkg" name="http://www.functx.com" abbrev="functx" version="1.0" spec="1.0"> <title>FunctX library</title> <xslt> <import-uri>http://www.functx.com/functx.xsl</import-uri> <file>functx.xsl</file> </xslt> <xquery> <namespace>http://www.functx.com</namespace> <file>functx.xq</file> </xquery> </package> Any thoughts? Jonathan

2 3

Custom map combinator
by Marco Lettere 02 Sep '21

02 Sep '21

Dear all, just thinking out loudly ... Whether it could be interesting to specify a function with proper signature as a custom combinator for map:merge. Currently "duplicates" : "combine" results in the entry value being a sequence of the originating values. This could cause loss of information in the case that one of the merged maps does not contain the key. It could be useful to use defaults or placeholders instead ... Maybe even combine the values as strings or numbers .... Too exotic? M.

1 0

probably a bug
by Rob Stapper 02 Sep '21

02 Sep '21

Hi Cristian, Consider snippets [1] and [2], both result in false(). That can’t be right to me. [1] () = 4 [2] () != 4 Rob. Sent from Mail for Windows -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 2

ignore previous mail, please!
by Rob Stapper 02 Sep '21

02 Sep '21

I need a holyday. Sorry about the previous mail. Need to use not()-function offcourse. Rob. Sent from Mail for Windows -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

1 0

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