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

basex csv import cmd
by Kittelmann, Maike 04 Jul '18

04 Jul '18

Dear BaseX users, I often make use of importing files to BaseX via command line. For XML this works fine. Currently, I work with CSV-files that I import to BaseX via GUI. I would like to automatize this process as I do with XML-Import files. Unfortunately, I didn't find any instructions so far how I can apply these same GUI CSV import settings to the import via command line. Is this possible? Best regards, Maike Kittelmann -- Maike Kittelmann Metadaten und Datenkonversion Georg-August-Universität Göttingen Niedersächsische Staats- und Universitätsbibliothek Göttingen D-37070 Göttingen Papendiek 14 (Historisches Gebäude, Raum 1.617) +49 551 39-10249 kittelmann(a)sub.uni-goettingen.de http://www.sub.uni-goettingen.de<https://email.gwdg.de/owa/redir.aspx?C=TxY71q4kfUCSjLXiZog64-dZmmdWU9EIVyC3…>

2 1

Passing sequence of strings to the java class
by Alexander Shpack 03 Jul '18

03 Jul '18

Hey, team! Just simple question. How to pass sequence of string to the java class? let $values := for $i in (1 to 3) return $i cast to xs:string return j:exec($values) In case when local function returns one item all is good. Otherwise j:exec takes array of item()+, but not the array of stings. If you just call j:exec(("1","2")) than all works as expected. Any thoughts? Is it bug or feature? ;) BaseX 9.0 Thanks! -- s0rr0w

2 7

XPST0003 for decimal formats without any properties
by Reece Dunn 02 Jul '18

02 Jul '18

Hi All, Given the query: declare decimal-format test; () BaseX 9.0 reports: Error: Stopped at basex-9.0/file, 1/28: [XPST0003] Decimal-format property '' is invalid. This is a valid XQuery 3.1 file, as https://www.w3.org/TR/xquery-31/#doc-xquery31-DecimalFormatDecl denotes the property production as "*", not "+". Kind regards, Reece

2 1

Host 'files.basex.org' not reachable
by Kristian Kankainen 02 Jul '18

02 Jul '18

Hi I wanted to download a newer version of BaseX, but wasn't able to do so because the host is unreachable: > $ wget http://files.basex.org/releases/9.0.2/BaseX902.zip > [...] Name or service not known And my old versions of BaseX (zip-edition of 8.67 and 9.0) doesn't want to start anymore: > $ ./basexgui > java.util.concurrent.ExecutionException: java.io.IOException: Unknown > host 'files.basex.org'. > [...] Is some of your servers down? Best regards, Kristian K

2 3

Unexpected removal of BaseX Database
by Arjan Loeffen 02 Jul '18

02 Jul '18

Dear BaseX people, We create a backup of a BaseX 8.6.4 database using a windows scheduled process: call basexclient -V -Uadmin -Padmin -c "CREATE BACKUP imvertor-*" We have a server process that interacts with the databases, all called Imvertor-*. In accessing the database at certain moments the backup process seems to conflict with the update process. This is visible in the log: [...] 11:59:12.012 127.0.0.1:60319 admin REQUEST [GET] http://localhost:8984/rest/ imvertor-jobs 11:59:12.106 127.0.0.1:60319 admin 200 95.65 ms 11:59:12.121 127.0.0.1:60319 admin REQUEST [DELETE] http://localhost:8984/rest/imvertor-jobs/2018-06-14-11-58-17-450.xml 11:59:12.137 127.0.0.1:60319 admin 200 5.08 ms 11:59:12.137 127.0.0.1:60322 admin REQUEST [POST] http://localhost:8984/rest/imvertor-jobs 11:59:12.200 127.0.0.1:60322 admin 200 73.59 ms 11:59:12.215 127.0.0.1:60322 admin REQUEST [POST] http://localhost:8984/rest/imvertor-jobs 11:59:21.075 127.0.0.1:60323 admin REQUEST SET QUERYINFO 0.13 ms 11:59:21.075 127.0.0.1:60323 admin OK QUERYINFO: true 0.1 ms *11:59:21.184 127.0.0.1:60323 <http://127.0.0.1:60323/> admin REQUEST CREATE BACKUP imvertor-* 0.21 ms* *11:59:22.372 127.0.0.1:60322 <http://127.0.0.1:60322/> admin 400 Database 'imvertor-jobs_665091421' could not be renamed. 10166.92 ms* *11:59:22.372 127.0.0.1:60322 <http://127.0.0.1:60322/> admin REQUEST [POST] http://localhost:8984/rest/imvertor-jobs <http://localhost:8984/rest/imvertor-jobs>* *11:59:27.309 127.0.0.1:60323 <http://127.0.0.1:60323/> admin ERROR Database 'imvertor-jobs' is being updated, or update was not completed. Backup for 'imvertor-jobs-regression' was created in 53.29 ms. Backup for 'imvertor-jobs_665091421' was created in 1262.1 ms. Backup for 'imvertor-models' was created in 4760.92 ms. Backup for 'imvertor-models-regression' was created in 51.58 ms. 6128.15 ms* *11:59:27.309 127.0.0.1:60322 <http://127.0.0.1:60322/> admin 404 Database 'imvertor-jobs' was not found. 4932.96 ms* 12:01:03.465 127.0.0.1:60325 admin REQUEST [GET] http://localhost:8984/rest/?command=list 12:01:03.481 127.0.0.1:60325 admin 200 3.24 ms 12:01:03.543 127.0.0.1:60325 admin REQUEST [GET] http://localhost:8984/rest/ imvertor-jobs 12:01:03.543 127.0.0.1:60325 admin 404 Database 'imvertor-jobs' was not found. 0.36 ms 12:01:03.543 127.0.0.1:60325 admin REQUEST [PUT] http://localhost:8984/rest/ imvertor-jobs 12:01:03.575 127.0.0.1:60325 admin 201 Database 'imvertor-jobs' created in 13.47 ms. 22.83 ms [...] This is rather a serious problem; the whole database is lost. Our software is set up such that the database is created when it is not found. Hence the last log... Do you recognize the problem, and can you specify how to avoid it? Hope this gives you enough info. Thanks in advance! -- Arjan Loeffen, Armatiek BV 06-12918997

2 2

GUI
by Giuseppe Celano 29 Jun '18

29 Jun '18

Hi, I have updated Java (10 from 8) and I cannot apparently customize the GUI anymore on my Mac (if I click on BaseXGUI > aboutBaseXGUI, I cannot access the relevant tabs). Is this a known issue? Moreover, if I start the GUI from the command line, I keep getting the warning message "Illegal reflective access by org.basex.gui.GUIMacOSX". Is there a way to avoid that? Thanks. Ciao, Giuseppe Universität Leipzig Institute of Computer Science, NLP Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

3 6

Tracing query execution
by Iwan Briquemont 29 Jun '18

29 Jun '18

Hello, I use BaseX mostly for boolean queries, I have a hardware database and I check if specific hardware support features I need. It works great but when something is not as expected, it's hard to find out the reason. E.g. given an expression like: $some-value = $some-list and (custom:predicate() or $x > $y) I would like to know why it's true or false. For now I add trace() manually on the subexpressions, rerun, add trace to more specific parts, etc. Ideally I would want to break down the query execution so it shows the values of subparts of the query to pinpoint why it is false, e.g. have an output like: $some-value = $some-list and (custom:predicate() or $x > $y) -> false()$some-value = $some-list -> true()$some-value -> 1$some-list -> (1, 2, ..., 10)custom:predicate() or $x > $y -> false()custom:predicate() -> false()... # It should also go inside the function$x > $y -> false()$x -> 10$y -> 11 Any ideas how it could be achieved? Looking at the code, maybe a debug() (like iter() or item()) method could be added to Expr objects which would trace the expression query, file, line and the result of the expression (or probably the first x characters of the result to avoid huge output)? With an xquery function which would trigger it. I also thought of modifying the query programmatically to add trace() calls but that seems overly complicated. Best regards, Iwan

3 2

Distributing service as EAR
by Mauro Mugnaini 29 Jun '18

29 Jun '18

Hi All, We are used to implement and deploy services into containers (Tomcat, JBoss, Wildfly, ...) as single WAR and for this kind of work we always implement starting from the BaseX WAR distribution. Now, looking in depth into the structure of the WAR, we noted that all the third party JARs, BaseX common classes JAR and XQJ bridge JAR are located into WEB-INF/lib folder whereas HTTP related classes (filters, servlet, listener and so on) are located inside the WEB-INF/classes. Moreover a possibly useless (?) WEB-INF folder with another web.xml and another jetty.xml in the same WEB-INF/classes. My question is: is there any reason why files in WEB-INF/classes are not “jarred” into a single archive and placed into WEB-INF/lib folder? Are there any cons doing that way according to your experience? The objective is to optimize the EAR content, where several WARs of services are packaged into a single EAR file, by factoring out all the JARs into the /lib folder of the EAR. Thank you and regards, Mauro

2 1

Cancelling long running query
by Shaun Flynn 29 Jun '18

29 Jun '18

Hello there, I have had a look in the documentation and was wondering, is it possible to cancel a query once it has been submitted using ClientQuery/ClientSession? Would calling close() on ClientQuery do that? Shaun

3 2

Copy Path in GUI seems to recently not give correct path for target
by Alex Everitt 28 Jun '18

28 Jun '18

Hi, I'm fairly certain there is a bug in the GUI now. I often right click in the GUI and choose Copy Path (from tree and map etc.) and until recently that worked every time. Now I'm getting paths that are just obviously not correct from the second level of the tree down. The first level of the tree is ok. db:open("bigale_order_list_since_2017-03-31", "bigale_orders_1")/ListOrdersResponse Then the second level of the tree and levels not ok. db:open("bigale_order_list_since_2017-03-31", "bigale_orders_1")/ListOrdersResult/ListOrdersResult *Should be: db:open("bigale_order_list_since_2017-03-31", "bigale_orders_1")/ListOrdersResponse/ ListOrdersResult And so on. db:open("bigale_order_list_since_2017-03-31", "bigale_orders_1")/Orders/Orders/Orders *Should be: db:open("bigale_order_list_since_2017-03-31", "bigale_orders_1")/ListOrdersResponse/ ListOrdersResult/Orders This may have started since the 9 release. Thanks, Alex Everitt

2 1