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

Re: [basex-talk] BaseX: Support for JSON
by Abishek N 22 Jan '13

22 Jan '13

Hello I am using twitter4j streaming api to capture tweets and feeding them into a basex database, converting them into xml using json api. While using the json:parse api, i get BXJS0001 error often. I assume it is because of encoding. Is there an option available in the json: api that would allow me to specify the enoding technique? Also if i store the documents as a json, instead would it facilitate json query? Thanks, Abishek

3 5

Fwd: dynamic web application, XQJ, BaseX
by marco fregonese 22 Jan '13

22 Jan '13

---------- Forwarded message ---------- From: marco fregonese <marcofregonese(a)gmail.com> Date: 2013/1/21 Subject: Re: [basex-talk] dynamic web application, XQJ, BaseX To: Christian Grün <christian.gruen(a)gmail.com> There is a class in my Java web application that has a method that, after connecting to my BaseX database, execute a query on it. This query (associated to the "xquerystring" variable), after importing a library module and pointing the processor to the file containing the library module("library_module.xq"), uses the function "lib:getparts()". Now, after executing this method, I noticed that: with BaseX 7.3 the Xquery processor (o whatever it is, I don't know) looks for "library_module.xq" in the filesystem $HOME/basex/bin, while with BaseX 7.5 the processor looks for "library_module.xq" in $HOME. My question basically is: what is that makes the processor (or whatever it is) look for the file "library_module.xq" in $HOME/basex/bin (with BaseX 7.3) and in $HOME (with BaseX 7.5)? Hope I've been clear. Thanks PS: in BaseX GUI everything works fine: the XQuery processor looks for the file containing the library module in the same folder where the main module is. Example of main module: import module namespace lib="http://www.example.com/my_library_module" at "library_module.xq"; lib:getparts() The following is the code of the class I've talked about: package xqu; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.PrintStream; import javax.xml.namespace.QName; import javax.xml.xquery.XQConnection; import javax.xml.xquery.XQException; import javax.xml.xquery.XQExpression; import javax.xml.xquery.XQResultSequence; import con.Connection; public class Query { public static void getAllParts(String a, String sc) throws XQException, FileNotFoundException { File file = new File(sc); FileOutputStream fos = new FileOutputStream(file); PrintStream ps = new PrintStream(fos); System.setOut(ps); XQConnection con = Connection.getConnection(); XQExpression xqe = con.createExpression(); xqe.bindString(new QName("b"), a, null); String xqueryString = // using backslash for escaping " "import module namespace lib=\" http://www.example.com/library_module\"" + "at \"library_module.xq\";" + "declare variable $b external; " + "lib:getparts($b)"; XQResultSequence rs = xqe.executeQuery(xqueryString); String b = rs.getSequenceAsString(null); con.close(); System.out.println(b); } } 2013/1/20 Christian Grün <christian.gruen(a)gmail.com> > Hi Marco, > > sorry for the late feedback. Can you reproduce the issues in the BaseX > GUI or on command line? > > Best, > Christian > ___________________________________ > >

2 2

Hi all, and URL Rewriting/Request handling question
by Jay Straw 22 Jan '13

22 Jan '13

Hi all, I've been developing in eXist since 2008, and I'm now trying out your BaseX. I'm impressed so far, but how can I perform URL rewriting? I've tried using Jetty's Rewrite Handler via the example code at http://wiki.eclipse.org/Jetty/Feature/Rewrite_Handler but then the server fails to start, it simply dumps with: $ sh bin/basexhttp org.eclipse.jetty.rewrite.handler.RewriteHandler So I figure I need to compile it in (I grabbed from github and built with maven, but didn't know how to build the http server and downloaded the 5meg zip). Not sure how to do that. I'm not a Java guy at the moment, so any pointers would be very helpful. Thanks everybody! Jay

2 1

Use of BaseX
by Ankur Kasliwal 21 Jan '13

21 Jan '13

Hi, I am new to BaseX and documentation is also not very helpful for me. I am trying to deal with a collection of XML files present on the server. I am able to access those files using REST . What I want to do is read those XML files from a collection present in a certain folder and using Xpath/Xquery get certain nodes from these files and populate a RDBMS corresponding to them. For example: &gt bookstore &lt &gt book &lt abc &gt/ book &lt &gt price &lt 123 &gt /title &lt &gt title &lt xyz &gt /title &lt &gt /book &lt I have 10 of these files in my collection. So my question is how can I query all these Xml files at ones and get specific results like "Books with price value greater than 100". Once I get these results I want to store the result in a RDBMS so that at later point I can query that RDBMS to generate certain reports. NOTE: I am a graduate student and just doing this for learning and academic purpose. Hope to hear from someone soon. -- Ankur ankur.kasliwal.26(a)gmail.com 001-(916)673-7559

3 3

dynamic web application, XQJ, BaseX
by marco fregonese 20 Jan '13

20 Jan '13

Hi there, I'm developing a Java dynamic web application in Eclipse Juno using XQJ and BaseX (OS Ubuntu 12.04). I'm using an XQuery main module importing a library module in my Java-XQJ code to query BaseX, something like this: .... String xqueryString = // import library module and point the processor to the file containing the library module "import module namespace lib=\" http://www.example.com/mylibrary_module\" at \"mylibrary_module.xq\";" + "lib:myfunction()"; XQResultSequence rs = xqe.executeQuery(xqueryString); ... Two questions: 1. Why does the processor looks for "mylibrary_module.xq" in ~/basex/bin? 2. Is there any way to change this path? Thanks.

2 2

Fwd: basex_7.5-1_amd64.changes ACCEPTED into unstable
by Alexander Holupirek 17 Jan '13

17 Jan '13

To all the Debian users. BaseX 7.5 has been accepted in unstable. Sorry for letting you wait so long. Begin forwarded message: > From: Debian FTP Masters <ftpmaster(a)ftp-master.debian.org> > Subject: basex_7.5-1_amd64.changes ACCEPTED into unstable > Date: 18. Januar 2013 00:17:33 MEZ > To: Alexander Holupirek <alex(a)holupirek.de>, <tmancill(a)debian.org> > > Accepted: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Format: 1.8 > Date: Tue, 15 Jan 2013 10:00:12 +0100 > Source: basex > Binary: basex > Architecture: source all > Version: 7.5-1 > Distribution: unstable > Urgency: low > Maintainer: Alexander Holupirek <alex(a)holupirek.de> > Changed-By: Alexander Holupirek <alex(a)holupirek.de> > Description: > basex - XML database and XPath/XQuery processor > Closes: 696796 696804 697037 > Changes: > basex (7.5-1) unstable; urgency=low > . > * New upstream release (December 21, 2012) (closes: #697037) > XQUERY UPDATE > - bulk updates are now much faster than before > - insert and replace operations take much less memory > - databases can now be created via XQuery and db:create() > . > GUI TEXT EDITOR > - a fast and flexible search/replace panel has been added > - error highlighting has been extended to XML files > - the editor was improved for editing arbitrary text files > . > XQUERY 3.0 > - the code has been aligned with latest changes in the specs > - HTML5 support has been updated > . > WEB APPLICATIONS > - new modules have been added: Request, Session, Sessions > - logging has been revised and extended to HTTP requests > - SSL support added, switched to Jetty 8 > - all operation modes have been unified and simplified > - RESTXQ elements added to simplify forwarding and redirects > . > CORE FEATURES > - improved stability of concurrent read/write operations > - the INSPECT command performs database sanity checks > - EXECUTE triggers the execution of command scripts > . > * Packaging: > - Added example provided by jidanni(a)jidanni.org to basex.1 > Thanks! (closes: #696804) > - Added note for missing -q option to basex.1 (closes: #696796) > Reported issue upstream: > https://github.com/BaseXdb/basex/issues/620 > Checksums-Sha1: > f2557eb167c7833402ce771a1fb8b1bd7499a0a8 1856 basex_7.5-1.dsc > 9dd929c365333bc6bcc2681b782c4fcaaad3a94a 1315007 basex_7.5.orig.tar.gz > e8b7ff70d349bf4b69b588b74aa69f2b82dbb016 98461 basex_7.5-1.debian.tar.gz > 2e9f5a817befb3a680822cb58ad808f42e98c461 2489490 basex_7.5-1_all.deb > Checksums-Sha256: > 017ecab180dda4499b557f537f7f30813a7b615af47dc8d8bae827d02f47fe3d 1856 basex_7.5-1.dsc > 3fbc7b2fe2aa7427ad312cbe0aded3fcc86d029e6f6cd38476c5fc5d59ef7c30 1315007 basex_7.5.orig.tar.gz > 851bd420ecc0e9ac706a80251b7dd7ffbc9adec7cd83ecc99173a00705f26494 98461 basex_7.5-1.debian.tar.gz > 211f97595d0004e71ae2cd9d3822e13e54eb111b37a5ec25362d8ec9d0dfc315 2489490 basex_7.5-1_all.deb > Files: > 0a815272fac2cf303c9fce8350faace9 1856 database optional basex_7.5-1.dsc > 7028a0e81cecf02b73ba6d30cdc261fd 1315007 database optional basex_7.5.orig.tar.gz > a6b8dc8d172e8cfa93af05c18644b390 98461 database optional basex_7.5-1.debian.tar.gz > 3b3571e5b6d078867e40329bfc06ffb3 2489490 database optional basex_7.5-1_all.deb > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.12 (GNU/Linux) > > iQIcBAEBAgAGBQJQ+IDGAAoJECHSBYmXSz6WT4IP/1tKOwPKJlzDQGHrDZM015vD > OFo300qJK32pSD9HDHfKBpp8m6+DqpgEzzE7xeCbo2/o/1r6y8JZHGbgNxIw+AhB > Vio2fcq7EYelj2/NEGaohAhMsCVqpwxGdAcO+WURjJZJUBphO7dZxv8uFDY2d/yD > 9NRLm4Ta63c9Whg5ozMaWh3KNJR/fc6AksPH1rMgKqWETJvnm5VgLuEYV2pd/+x4 > fH6QeDxeko1GGQZUaXQjf+bqWff+QRaCevy6rQOkF6Io/PYOfniuhBGIMEm4fs/d > +SGc8dGuXOgaJ2ALeb6yG0ZnMdeEVQ9vRO5LcJJv+YkMmIG75LewojXMpwwFGA/J > Af4o6WS4zFjHH+dLAbsKntrDhiLd1h3T8Urt9CA3T3cEP4xTUWDjNRAEwV5ebqRG > veD7qPzLXZErVKcrLKXaYXEg5sYS0DIjB0Q6sUYYPDfUmhYTIFTyRf3vaDuoc0Er > xW24/we8aVAnSAOcg63dPKajUz+slnxZPn6iNgqJUe+r1R1Qn/aMntPZfgeARmmx > YZKN5GXcABzCPx7N+LGyXTOPg4fkda+vFK8x70vm2Sf0Tet0Z4PBPvxKDMQzu9BF > H/7tHLAqM8aCWZNfHz8e12xbQctyaZiz6i24i9F1a+Dh94Vjjpvyd7HBZ7ZcHWnb > jo6iobCXljlk20aa/JlO > =/S7U > -----END PGP SIGNATURE----- > > > Thank you for your contribution to Debian.

1 0

Changing content through Data Source/Oxygen
by France Baril 17 Jan '13

17 Jan '13

Hi, Our .xqm uses a configuration file that is stored in a DB called AppResources. When we use the GUI to create/upload the content for AppResources, we can access our restxq pages and the result is based on our config. If we access the config file in Oxygen and change anything, even a space, it's like the .xqm cannot access the information anymore. We tried: - Updating/optimize the index/paths. - Stopping/starting the server. The file is saved properly. If we save it on disk from Oxygen and reload AppResources with the config file, we are able to access the information in the file again. So the issue is really the fact that the change occurs through webdav. What are we missing here? Regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 11

fastest way to add/replace/delete xml
by Fabrice Etanchaud 17 Jan '13

17 Jan '13

Dear all, I have to store and replace xml pieces, and am wondering what can be the fastest way to achieve that task. - Add provided files containing several xml pieces, and then use xquery update to replace nodes ? - Or split files to add a document per xml piece, and then use db:replace ? These databases have size near the physical limit. Regards, Fabrice Etanchaud Questel-Orbit

2 1

[XQuery] Sharing a value between expressions?
by Johannes Krampf 16 Jan '13

16 Jan '13

Hello, I would like to assign a sequence to a variable and then share this variable between two expressions. Particularly I want to create a list of documents to delete from the db and then return the number of deleted documents. Code sketch of what I am trying: let $nodes := [...] let $base-uris := for $node in $nodes return base-uri($node) let $distinct-base-uris := distinct-values($base-uris) for $base-uri in $distinct-base-uris return db:delete("db", $base-uri), return count($distinct-base-uris) --- The problem with this approach is that $distinct-base-uris is local to the first expressions and not in scope for the count call. I tried to just duplicate all code, but then I get an error message that "no updating expression [is] allowed". Is there any way to achieve what I want and put my value in a scope accessible by both expressions? Regards, Johannes

2 2

DB freezes on updating restxq - a simpler example
by France Baril 15 Jan '13

15 Jan '13

Hi, I have sent a request for this issue last month, but my example was too complex. Here is the simplest example I could get that reproduces the issue. This seems to be a problem with updating restqx functions, so I'm unsure how to reproduce it with a .bsx. If you use the attached db with the attached query on localhost:8984. The browser should freeze on BaseXMas when accessing debug/debug-freeze. - The xslt works. If you make the function none updating and return $result. You'll see the video.png in the browser. - The updating function works. If you replace the node $result with <hey/> and comment out the xslt:transform line. The document will be replace in the db. - The two don't work together. Specific characteristic if this xsl: - It uses a rest access to extract the path for the video. Without the doc('http://...rest…') line, this would work. Note that this used to work with prior versions of BaseX. Thanks, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1