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

GUI feature request "Add as import"
by Andy Bunce 03 Jan '16

03 Jan '16

Hi, I often find myself adding module imports in the GUI and I wonder if the following suggestion might speed up that process. Add a new menu item to the filelist right click context menu "Add as import" when the file selection is a XQuery module. The action would be to add a line to the current edit window source with import module namespace {$prefix} = '{$namespace}' at {$path}; Where $prefix and $namespace} are read from the source of the selected file, and $path is calculated from the relative path from the edit file source to the selected filelist source. The line would be inserted at a suitable place in the prologue or at the current location if that is too tricky. /Andy

2 4

Position of matched tokens in a full-text query
by Javier Couto 22 May '15

22 May '15

Hi, Sorry if this is too basic, but I’m trying to get the positions of the matched tokens in a full-text query, and I can’t find the way to do it. I imagine something like: for $sentence in //sentence where $sentence[text() contains text { ‘DNA', ‘oxidation' }] return <positions>ft:SOME-FUNCTION-FOR-TOKENS-POSITIONS($sentence[text() contains text { ‘DNA', ‘oxidation' }])</positions> Is this possible? Thank you in advance, Javier

3 10

BaseX for dummies part 2
by Paul Swennenhuis 06 Feb '15

06 Feb '15

Hi all, I am happy to announce that part 2 of my BaseX for dummies is ready. It deals with deploying and configuring BaseX on a virtual Amazon Web Services server. See http://docs.basex.org/wiki/Getting_Started, or go directly to http://www.swennenhuis.nl/basexfordummies/BaseX_for_dummies_part_2.pdf Best regards, and happy days! Paul

2 2

BaseX 8 and oXygen via XQJ
by Lizzi, Vincent 23 Jan '15

23 Jan '15

After upgrading to BaseX 8.0 I'm no longer able to run queries on BaseX from oXygen. Connecting to BaseX from oXygen using WebDav still works, but trying to run a transformation in BaseX using the XQJ driver fails with a message "Access denied". It appears that the XQJ driver needs to be updated for the new authentication mechanism. Will an updated version of the BaseX XQJ driver be available soon? Thank you, Vincent

2 2

data protection at rest
by Mansi Sheth 08 Jan '15

08 Jan '15

Hello, I am thinking about my options of protecting BaseXDB's data at rest. We are storing sensitive client data which we need to protect. We would be migrating BaseXDB on an amazon instance, so protection at rest would be a primary concern. What I wish to do is, while inserting data into the database, it should be encrypted and while using XQUERY, we should have a mechanism to decrypt the data and retrieve the information needed. I am aware of the performance hit here. Would evaluate if its acceptable after I could collect some statistics. I looked at the docs: http://docs.basex.org/wiki/Cryptographic_Module#Encryption_.26_Decryption But, I didn't completely understand a use case for this example. Or if it would solve my purpose. I am currently using some Java code to insert files into the database. Has anyone done something on this line ? Please share some use cases. - Mansi

2 1

BaseX 8.0 snapshot on OpenShift
by Andy Bunce 08 Jan '15

08 Jan '15

Hi, I am having difficulty getting this to work. I had something working with 7.9 (see https://github.com/Quodatum/openshift-basex-quick-start/tree/releases/0.2 ) Using a recent snapshot. I am running ${OPENSHIFT_DATA_DIR}/basex/bin/basexhttp -n ${OPENSHIFT_DIY_IP} -h ${OPENSHIFT_DIY_PORT} -p ${PORT_DATABASE} -e ${PORT_EVENT} -s ${PORT_STOP} -U ${BASEX_USER} -P ${BASEX_PASSWORD} The debug o/p is STOPPORT: 15007 PASSWORD: admin USER: admin EVENTPORT: 15006 DEBUG: true PORT: 15005 SERVERPORT: 15005 HOST: 127.13.28.129 STOPPORT: 15007 PASSWORD: admin USER: admin EVENTPORT: 15006 DEBUG: true PORT: 15005 SERVERPORT: 15005 HOST: 127.13.28.129 WEBPATH: /var/lib/openshift/549d9d794382ec39b8000105/app-root/data/basex/webapp HTTP Server was started (port: 8080) java.net.BindException: Permission denied at java.net.PlainSocketImpl.socketBind(Native Method) at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:376) at java.net.ServerSocket.bind(ServerSocket.java:376) at java.net.ServerSocket.bind(ServerSocket.java:330) at org.basex.BaseXHTTP$StopServer.<init>(BaseXHTTP.java:403) at org.basex.BaseXHTTP.<init>(BaseXHTTP.java:139) at org.basex.BaseXHTTP.main(BaseXHTTP.java:50) Server is running or permission was denied. https://github.com/BaseXdb/basex/blob/0af4ead914d3d1946e5a8ce9672811a34f933… I wonder if SERVERHOST should be set here? As with SERVER PORT.. https://github.com/BaseXdb/basex/blob/0af4ead914d3d1946e5a8ce9672811a34f933… /Andy

2 2

Xquery update question
by Erol Akarsu 06 Jan '15

06 Jan '15

Hi, I have several xml document index keeping products features and have one master index file of products.. Currently, we have about 25 million products that have size about 25G xquery index size. My xquery application is reading features data from auxiliary xml document and enhancing master document. In order to do it, I am inserting data into master document with a generic insert command: insert node <FEATURES_NODE> into <PRODUCT_NODE> But xquery update is executing update process after all insert requests collected. But with huge size of my index, the memory of machine (35G) is exhausted easily and can NOT finish process. Is there way to execute individual xquery update requests one by one so that process can finish? Erol Akarsu

2 2

Fetching a binary document from BaseX with C# using the server API
by Boxstart, Bjorn 06 Jan '15

06 Jan '15

Hello, I'm currently working on the integration of BaseX in part of our .Net based software. One part of the functionality will be to store and retrieve binary files. I haven't been able to retrieve the raw files from the server yet using C#. I based my solution on the example of the C# client in the source code repository of BaseX. With my current solution I receive only the first few (3 to 7) bytes of the file (at least I think they are...). The code I have at the moment is: /// <summary> /// Retrieves a RAW document from the database. The database must be opened before executing this command. /// </summary> /// <param name="path">The path to the binary data to be retrieved</param> /// <returns>A byte array with the binary data</returns> public byte[] Retrieve(string path) { //stream.WriteByte((byte)BaseXCommand.QUERY); Send("RETRIEVE " + path); //Send(path); using (MemoryStream ms = new MemoryStream()) { Receive(ms); info = Receive(); if (!Ok()) { throw new IOException(info); } return ms.ToArray(); } } Can anybody please tell me what the problem with this solution can be or give me a hint for a correct way to retrieve the raw bytes? I know I can use the files on disk directly, but would rather not go that way. Thanks in advance for your reaction! Kind regards, Björn Boxstart

2 2

copy-namespaces declaration
by Alex R. Loayza 06 Jan '15

06 Jan '15

Hello, I've found this same issue on version 7.9: https://mailman.uni-konstanz.de/pipermail/basex-talk/2012-May/003294.html Is there now some fix I'm not aware of? Thank you. Alex

2 1

Out Of Memory
by Mansi Sheth 06 Jan '15

06 Jan '15

Hello, I have a use case, where I have to extract lots in information from each XML in each DB. Something like, attribute values of most of the nodes in an XML. For such, queries based goes Out Of Memory with below exception. I am giving it ~12GB of RAM on i7 processor. Well I can't complain here since I am most definitely asking for loads of data, but is there any way I can get these kinds of data successfully ? mansi-veracode:BigData mansiadmin$ ~/Downloads/basex/bin/basexhttp BaseX 8.0 beta b45c1e2 [Server] Server was started (port: 1984) HTTP Server was started (port: 8984) Exception in thread "qtp2068921630-18" java.lang.OutOfMemoryError: Java heap space at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.addConditionWaiter(AbstractQueuedSynchronizer.java:1857) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2073) at org.eclipse.jetty.util.BlockingArrayQueue.poll(BlockingArrayQueue.java:342) at org.eclipse.jetty.util.thread.QueuedThreadPool.idleJobPoll(QueuedThreadPool.java:526) at org.eclipse.jetty.util.thread.QueuedThreadPool.access$600(QueuedThreadPool.java:44) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Thread.java:744) -- - Mansi

5 17