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

Big Surprise from outputs in version 7.3.1 and 8.6.7 ?
by Bang Pham Huu 02 Feb '18

02 Feb '18

Hello, I've been using BaseX to query an XML file in version 7.3.1 and it worked well. However, because of this problem https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/msg10241.ht… and I was suggested to use version 8.6.7 then I changed to use this version in a Java Web application which queries the old BaseX files from version 7.3.1. However, I didn't know that this version changes created a very surprise result between version 7.3.1 and 8.6.7 (i.e: data is missing in version 8.6.7 from output result !!!). Could someone tell me why it happens and how to use BaseX version 8.6.7 on BaseX database from version 7.3.1. Here is the difference between 2 outputs on same old BaseX database version 7.3.1 (left: 8.6.7, right: 7.3.1) with same XQuery: https://www.diffchecker.com/iCgLhRUx The XQuery is: declare namespace gml = "http://www.opengis.net/gml/3.2"; declare function local:get-children() { let $x := collection('userdb')//gml:identifier/text() return if (exists($x)) then for $i in $x return $i else <empty/> }; let $x := distinct-values(local:get-children()) for $i in $x return $i Thanks,

4 13

SqlExecutePrepared, Oracle and getParameterCount again
by Jan Dölle 01 Feb '18

01 Feb '18

Hi, I found any other issue on using Oracle SQL in BaseX by SqlExecutePrepared. It caused by stmt.getParameterMetaData().getParameterCount(). The current workaround ignores the thrown Exception and will continue the statement execution. But produce may open cursors on in the Database. So finally it will run into ora-1000 "Maximum open cursors exceeded." By totally avoiding the call of getParameterCount this issue will avoid. So I will provide an other fix. What do you prefer: a) check for "Oracle" in stmt.getConnection().getMetaData().getDatabaseProductName() and skip the parameter test at all or b) add an other option "checkParameters" (default true) like "timeout" and skip getParameterCount if it is set to false. I personal prefer a). Cheers, Jan -- Jan Dölle E-Mail: basex-list(a)id1.de Telefon +49-69-244502-0 Home: www.id1.de Information Design One AG, Baseler Straße 10, 60329 Frankfurt am Main Registereintrag: Amtsgericht Frankfurt am Main, HRB 52596 Vorstand: Robert Peters, Aufsichtsrat: Christian Hecht (Vorsitz)

2 3

BaseX 9.0 (still to come): Improved text compression
by Christian Grün 01 Feb '18

01 Feb '18

Hi all, with version 9.0 of BaseX, texts will be better compressed than before. Short strings and whitespace text nodes will be inlined in our main storage, instead of being stored in an extra heap file as before. This will particularly be helpful when perfoming mass updates on short strings (replace 'yes' to 'no', etc.), and your future BaseX database will get even smaller [1]. Obviously, BaseX 9.0 databases cannot opened anymore with older versions. However, BaseX will be 100% backward compatible, so there will be no need to export and recreate your existing database instances. Instead, all future updates you perform will use the new compression feature; and if you run a complete optimize, all existing texts will be reduced as well. All the best, Christian [1] https://github.com/BaseXdb/basex/issues/1536

2 4

xml element beginning and end space loss
by Stefania Axo 01 Feb '18

01 Feb '18

Hi all! is there a way to preserve the beginning and ending spaces in the Database xml elements? In other words If I execute this xQuery db:replace("MyDB", "doc.xml", "<a> stefy </a>") the resulted document will be <a>stefy</a> As you can see I lost my beginner and ending spaces. thanks Stefania

3 4

Stateless server without sessions
by Christoph Gaukel 01 Feb '18

01 Feb '18

Hi Team, i designed a service that uses web tokens to identify the users and i try to run this service really stateless, that says without creating any sessions. The service runs as basexhttp and uses Jetty. Is there a parameter, that prevents it from creating sessions at all? Currently curl writes: < HTTP/1.1 406 Not Acceptable < *Set-Cookie: JSESSIONID=1tgnabd2l6y3p1jpg8qv3hb53d;Path=/* < Expires: Thu, 01 Jan 1970 00:00:00 GMT < Content-Type: text/plain;charset=UTF-8 < Content-Length: 19 < Server: Jetty(8.1.18.v20150929) and the service adds a new session per call: sessions: "1gnn17n91gsmuc9grvk417ne 1xim2bo4bmtvr11e4a8tap8cl8 kiy3rq9j5lyq1hf6gf8vy4td2 s5luvfkvdpjv19ikpzqeev9k2 mn50c33fxflz17jv24oc68baw 1tgnabd2l6y3p1jpg8qv3hb53d" Best regards, Christoph

2 3

INFO and dp:system() show different values
by Lars Johnsen 29 Jan '18

29 Jan '18

Hi all when restarting a http-server, the script for accessing no longer finds the databases using db:open(). The path to the database using INFO in command line basex says one thing, while output from db:system() is different db:system() .../basex-webapp/webapp/WEB-INF/data INFO: .../basex-webapp/data The folder /webapp is where the scripts are. There is only one file .basex which contain the same as shown with INFO, which resides under folder /basex-webapp. Any thoughts? Best Lars

2 1

Special Character Search - @, $,#
by Navin Rawat 24 Jan '18

24 Jan '18

Hi Team, Could I search @, $, # by full text API of bases? I am using following query but unable to get any success: let $query := '@' let $options := map { "mode": "any", "fuzzy": "off", "wildcards": true(), "ordered": "false" } return ft:search("database", $query, $options) Please suggest. Regards, Navin

2 1

BaseX File Module : access network folder on windows server
by Dieter Zanzinger 22 Jan '18

22 Jan '18

I am working with den BaseX-File-Module for a while and can access a local folder, for example: file:list('C:/'). Now I want the same in a Windows network. If I create a folder on the Desktop of the local machine = localhost and give it a "Freigabe" with "Freigabename" netzlaufwerktestF, it is possible to list it´s contents with: file:list('//WIN7PROPARPC/netzlaufwerktestF/'). Now I try the same with a folder on a server, which I can access by windows explorer. I expected the following to work: file:list('//SERVERNAME_or_IP/Freigabename/') But I get only errors. Does anybody know the right way to access a network folder with the file module of BaseX under windows? (I didn´t find anything in the wiki or by google). Thanks in advance Dieter Zanzinger

3 2

BaseX 9.0 sql:prepare not working
by Jan Dölle 22 Jan '18

22 Jan '18

Hi, the function sql:prepare it not longer working Best Regards Jan ( sql:init("org.sqlite.JDBC"), let $conn := sql:connect("jdbc:sqlite:database.db") let $prep := sql:prepare($conn, "select 'Nothing'") let $result := sql:execute-prepared($prep) return ( $result, sql:close($prep), sql:close($conn) ) ) -> Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 9.0 beta Java: Oracle Corporation, 1.8.0_151 OS: Linux, amd64 Stack Trace: java.lang.NullPointerException at org.basex.util.Token.string(Token.java:87) at org.basex.query.func.sql.JDBCConnections.add(JDBCConnections.java:42) at org.basex.query.func.sql.SqlPrepare.item(SqlPrepare.java:27) at org.basex.query.func.sql.SqlPrepare.item(SqlPrepare.java:1) at org.basex.query.expr.ParseExpr.value(ParseExpr.java:71) at org.basex.query.expr.gflwor.Let$LetEval.next(Let.java:177) at org.basex.query.expr.gflwor.GFLWOR$1.next(GFLWOR.java:87) at org.basex.query.QueryContext.next(QueryContext.java:398) at org.basex.query.expr.List$1.next(List.java:119) at org.basex.query.QueryContext.next(QueryContext.java:398) at org.basex.query.scope.MainModule$1.next(MainModule.java:122) at org.basex.query.QueryContext.next(QueryContext.java:398) at org.basex.query.QueryContext.cache(QueryContext.java:620) at org.basex.query.QueryProcessor.cache(QueryProcessor.java:112) at org.basex.core.cmd.AQuery.query(AQuery.java:86) at org.basex.core.cmd.XQuery.run(XQuery.java:22) at org.basex.core.Command.run(Command.java:257) at org.basex.core.Command.execute(Command.java:93) at org.basex.gui.GUI.exec(GUI.java:430) at org.basex.gui.GUI.lambda$4(GUI.java:373) at java.lang.Thread.run(Thread.java:748) -- Jan Dölle E-Mail: basex-list(a)id1.de Telefon +49-69-244502-0 Home: www.id1.de Information Design One AG, Baseler Straße 10, 60329 Frankfurt am Main Registereintrag: Amtsgericht Frankfurt am Main, HRB 52596 Vorstand: Robert Peters, Aufsichtsrat: Christian Hecht (Vorsitz)

2 1

Licensing issue
by Benoit Maisonny 19 Jan '18

19 Jan '18

Hello, I just realised that the basex-api Maven artifact depends on milton-api 1.8, which is released under GPLv3 (this is declared in its parent pom). That means that basex-api, and any software that is distributed with it, must be released under GPLv3 as well... Are BaseX developers aware of that? Note that the current milton library v2 is released under Apache license. Is there any intention to upgrade to milton v2 (is it even possible)? Thanks, Benoit

3 3