BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Re: [basex-talk] Sub : Adding Special Characters to the Collection Database
by Christian Grün 09 Nov '15

09 Nov '15

Hi Madhan, > I am facing the problem of adding special characters to the collection > Database in below cases, What do you mean by "problem", and what are "special characters"? Christian > Case-1: if the xml file size is huge(in GBs),at the time the collection > Database creation tacking more time, > Case-2: if the more no.of xml files are adding to the particular collection > Database continuously > > Example: > > in Xml file <MyTag myAttribute="10" ...</MyTag> > > The values are adding like the following > in collection <MyTag myAttribute="A" ...</MyTag> > > Sample Collection adding code : > -------------------------------------------- > /* > This method takes the xml files list as input and process the list > Create the xml collection DB, adds xml to the collection if already exists > replace it > */ > > public static void createCollection(ArrayList<String> listFiles){ > ClientSession clientSession = null; > String strIndexedFile=""; > try { > clientSession = new ClientSession("<<IP_ADDRESS>>", 1984, > "<<USER>>", "<<PWD>>"); > String strDbName = "Sample_Collection"; > String strKeysFileLocation = > "D:\\TEMP\\7GB_Collection_TestingTeam\\Files"; > > String res = clientSession.execute("XQUERY db:exists('" + > strDbName + "')"); > //DB existence checking > if (!res.equalsIgnoreCase("true")) { > clientSession.execute("CREATE DB " + strDbName); > } else { > clientSession.execute("OPEN " + strDbName); > } > > for (int i = 0; i < listFiles.size(); i++) { > strIndexedFile = listFiles.get(i); > String tempFlag=clientSession.execute("XQUERY db:exists('" + > strDbName + "','" + strIndexedFile + "')"); > clientSession.execute("ADD " + strKeysFileLocation + > File.separator + strIndexedFile); > } > System.out.println("InFormation:: > "+clientSession.execute("INFO")); > //optimizing the current opend DB using OPTIMIZE ALL command > clientSession.execute("OPTIMIZE ALL"); > System.out.println("InFormation:: > "+clientSession.execute("INFO")); > > } catch (Exception e) { > System.out.println("Exception files DB Updating: " + > e.getMessage()); > e.printStackTrace(); > } finally { > if (clientSession != null) { > try { > clientSession.close(); > } catch (IOException ex) { > ex.printStackTrace(); > } > } > } > } > > Hardware Specifications of Basex Sever : > ---------------------------------------------------------- > Operating System : Red Hat Enterprise Linux 64bit > OS Version : Linux 2.6.32 > Hard Disk : 500 GB > Memory Capacity : 16 GB Ram > Processor Family : Intel (R) Xeon(R) CPU E5 -2680 V2 > Processor Speed : 2.80 GHz > Physical Processors : 8 > Virtual Processors/cores : 4 > Server Version : basex 7.9 > -- > Thanks & Regards > Madhangopal.P

1 0

basic JSON problem
by Florent Gallaire 09 Nov '15

09 Nov '15

I would like to use the new "basic" JSON via REST. With basex 8.3.1 and 8.3.2beta, my_request&method=json&json=format=jsonml works fine, but my_request&method=json&json=format=basic returns : [FOJS0006] Element 'article' has invalid namespace: ''. What's the problem ? Best regards Florent -- FLOSS Engineer & Lawyer

2 1

Keeping a database optimized
by Paul Swennenhuis 05 Nov '15

05 Nov '15

What is the best way to keep the indexes of a database up-to-date? I have created a database with the option UPDINDEX set to ON (and db-info tells me that it is indeed switched on) and I have also created text and attribute indexes. Even so, after several insertions (using XQUERY insert node) I see that the UPTODATE flag is no longer checked and I have to run OPTIMIZE ALL to get back my performance. a) Is there a way to keep UPTODATE checked under all circumstances? And if not b) Is is advisable to run OPTIMIZE ALL after every insertion? (I guess not)

2 4

PHP client update
by Paul Swennenhuis 04 Nov '15

04 Nov '15

Hi all, I wrote an update for the BaseX PHP client, to handle the Digest authentication method as introduced in BaseX 8.0 See attachment. Regards, Paul

1 0

request concerning unittest in the GUI
by Rob Stapper 02 Nov '15

02 Nov '15

Hi Christian, For debugging my xquery-code I using the test-facilities from the unit-module in combination with trace and prof:dump command in the code for code-tracing. The problem is that when a unit-test fails it overwrites the trace-output in the Query-info window. So the code-tracing-info is gone just when I need it. It would make debugging a lot easier if the trace-output is appended after the unit-test-output in the Info-window of the GUI. Best, Rob --- Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware. https://www.avast.com/antivirus

2 5

Best way to batch up a set of DB creates, updates and queries?
by Hondros, Constantine (ELS-AMS) 01 Nov '15

01 Nov '15

I'm looking for the best way to batch up a series of updating operations into a single pipeline that can be run at once. To give you an idea, we have to create multiple databases, perform a number of updating post-processes on each, before finally pulling certain fields out. I've got a lot of parameters that need to externalised somehow - database creation options, location of DTDs, XSDs, Catalogs, and unless I am trying this the wrong way I am finding it quite difficult. I can't write it all XQuery - I have a mixture of updating and non-updating functions. I can't get much traction out of the BXS scripting syntax - for example, I can't seem to create and use variables using this. What do other people out there use to glue these sorts of operations together? TIA, Constantine ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 5

WebDav issues and auth clarification
by Régis Robineau 30 Oct '15

30 Oct '15

Hi all, I'm a beginner in BaseX and I'd need some clarification about the setup and configuration, especially about authentication process. The context is: - Debian 8 Jessie, with Basex 8.3 manually installed (i.e. not from APT). I'm using Apache in front of Tomcat to access web apps (through mod_proxy and mod_proxy_ajp): ProxyPass /BaseX83 ajp://localhost:8009/BaseX83 ProxyPassReverse /BaseX83 ajp://localhost:8009/BaseX83 - Webapp (WEBPATH): "/var/lib/tomcat7/webapps/BaseX83" - Data (DBPATH) : "/var/data/basex" (owned by tomcat7 user) - Client/server binaries (BaseX83): "/opt/basex/bin/" - conf file: "/opt/basex/.basex" Here are the main variables in my ".basex" file: DBPATH = /var/data/basex REPOPATH = /var/lib/tomcat7/webapps/BaseX83/repo HOST = localhost PORT = 1984 SERVERPORT = 1984 PROXYPORT = 80 WEBPATH = /var/lib/tomcat7/webapps/BaseX83 HTTPLOCAL = false STOPPORT = 8985 AUTHMETHOD = Basic And in my "WEB-INF/web.xml" I've set: - the value of "org.basex.dbpath" to reflect my local path (i.e. "/var/data/basex") - a new "org.basex.password" for the "org.basex.user" (admin) I have access to dba and REST service but I encounter various issues regarding authentication and WebDAV: 1/ I can't connect to WebDav service using the Finder (on Mac OS X 10.8.5) when "org.basex.authmethod" is set to "Digest". WebDav only works with the "Basic" auth method 2/ When the WebDav folder is mounted in the Finder, I can't copy files into it (permissions issues?). I've both tested as admin and as a test user with read/write permissions to the database... An empty file is created (zero byte, no content). But on the other hand, I'm able to access the REST interface with the same users (admin and test). I've created the test user like so: $ ./basexserver // in a second tab: $ ./basexclient -w > CREATE DB testdb > CREATE USER test password > GRANT READ ON testdb TO test > GRANT WRITE ON testdb TO test > SHOW USERS ON testdb 3/ The "org.basex.password" in WEB-INF/web.xml has no effect. The only way to define a password for admin is to use the console (ALTER PASSWORD admin password). Moreover the "service-specific credentials" for WebDav has no effect either. It just don't work. You can only connect to WebDav with the user credentials you defined in basex console (hence listed in users.xml). So what is the purpose of the "org.basex." settings? Does anybody ever faced the same issues with WebDav? Should I downgrade to 7.9 ? Thanks for your help. Regis

2 2

Creating Tim, ADate, Dtn, Map programatically
by James Wright 30 Oct '15

30 Oct '15

I have some Java methods which return time elements and or Maps and I was trying to convert these into XQuery atomic values with no luck. Is there a utility for these? Array has ``fromValues`` and all other types like ``Str`` have ``get`` but Map, Tim, Dtn, ADate do not appear to be construct-able. Any help would be appreciated. - James

2 1

BasexGui
by meumapple 28 Oct '15

28 Oct '15

Hi All, I love using the gui but I have a hard time dealing with autocomplete: is there a way to disable it in the txt editor? I think that it would also be very useful to allow view of whitespaces and tabs and have a function to prettify the code itself (do you know any for xquery?) Thank you very much for your work! Joseph

6 27

repo install issue
by Andy Bunce 28 Oct '15

28 Oct '15

Hi, The following installs in the repository, and can be used: " https://raw.githubusercontent.com/james-jw/xq-mustache/master/src/xq-mustac… " !repo:install(.) But it does not appear the repo:list() or the UI repository list.. I suspect the issue is the form of the namespace module namespace mustache = 'http://xq-mustache'; Regards /Andy

2 4

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk