BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

BACKUP/RESTORE - 32 bits limitation / java 7
by Fabrice Etanchaud 22 Feb '13

22 Feb '13

Dear BaseX users, BACKUPing a big database (leading to a bigger than 2 Go archive) is ok, But RESTOREing it fails because archive is corrupted. It seems to be related to the 32 bit zip library limitation, that may be solved with java 7. Did someone already try BACKUP/RESTORing big databases with BaseX running on a java 7 jre ? Best regards, Fabrice Etanchaud Questel-Orbit

2 1

OPTIMIZE ALL : <DBNAME>_224548755 could not be renamed
by Fabrice Etanchaud 22 Feb '13

22 Feb '13

Dear BaseX Team, It seems to be a problem with the OPTIMIZE ALL command. When applied on a <DBNAME> collection, it ends up with the following message : "<DBNAME>_224548755 could not be renamed" I suppose a new optimized collection is being created aside the current one, and cannot be renamed as <DBNAME> at the end ? Best regards, Fabrice Etanchaud Questel-Orbit

2 1

BaseX xpath querying takes more time than SAX parser takes
by elangovan MuthuSwamy 22 Feb '13

22 Feb '13

Hi All, I am trying to use BaseX Client and server with large XML files(13 MB size). I have created a database for the XML and evaluated an xpath in that. When I executed an xpath it takes around 250 milliseconds to fetch the results. In case of SAX parser I could get the response for the same xpath within 5 seconds. I used following BaseXClient code for this. BaseXClient session = new BaseXClient("localhost", 1984, "admin", "admin"); // code to fetch the large XML file size. Read from the file. String xmlString = ....... InputStream bais = new ByteArrayInputStream(xmlString.getBytes()); session.create("database", bais); String expression = "/configuration/protocol[starts-with(name, 'http')]/name"; *session.query(expression).execute();* // this line takes 250 milliseconds to give the result. Where as same xpath can be executed within 5 milliseconds in SAX parser. Am I basically missing anything or something else. Please advice me. Thanks in advance. -- Regards, Elango.

3 2

Not enough space
by Shannon Scott Shiflett 22 Feb '13

22 Feb '13

Hi, whenever I choose to show the tree visualization, after a very long delay, "Not enough space" is displayed in that space--it's a small database (<100MB) and 8GB RAM. Unless you recommend something else, I'd like to try completely uninstalling and replacing with a fresh BaseX--How to do this on OS X, besides deleting the app and data directory? Thanks. -- Shannon Scott Shiflett Sr. Programmer/Analyst The University of Virginia Press http://rotunda.upress.virginia.edu/

4 8

Whitespace handling on ingest
by Wendell Piez 22 Feb '13

22 Feb '13

Hi, I see the 'CHOP' option, turned on by default, for trimming leading and trailing whitespace and eliminating empty text nodes. What about going further? Is there a good way to normalize whitespace entirely, collapsing any runs of tab-LF-space into single spaces in my data? I think I mentioned earlier the idea of specifying an XSLT transformation to filter data on ingest (for a similar requirement, namely removing all comments and PIs). That might be going too far but any hints you can give me (or pointers to docs) about functionality to address this sort of thing in general would be welcome. Thanks! Wendell -- Wendell Piez | http://www.wendellpiez.com XML | XSLT | electronic publishing Eat Your Vegetables _____oo_________o_o___ooooo____ooooooo_^

2 3

GUI enhancement to show only query results as text in a tree?
by Amanda Galtman 22 Feb '13

22 Feb '13

Hi, The BaseX GUI is very nice for interactively tweaking a query or exploring my data set. However, one thing I wish I could do with the GUI is see query results as text in a tree with expandable/collapsible nodes. An example of what I mean is in the right pane of this Qizx screen capture: http://www.axyana.com/qizxopen/_distrib/docs/manual/qizxstudio.html#d0e4472 The tree in the screen capture makes it easy to distinguish between adjacent result items, and the collapsibility of result items makes it easier to decide when you want to browse the results at a high level or dig into a specific result. By contrast, the BaseX GUI's text view shows all the text of the query results, but they run together. The folder visualization has expandable/collapsible nodes, but because it shows the query-result nodes in the context of the entire database, you might have to expand a lot of nodes to discover where the query-result nodes are. While it can be useful to see the query-result nodes in context, I often want to see only the results themselves; and if I decide I need more context, I tweak my query to return more context. Would it be possible in a future release of BaseX to get a text tree-view of just the query results? Better yet, is it already available but I don't know about it? Thanks, Amanda

2 2

Re: [basex-talk] BaseX xpath querying takes more time than SAX parser takes
by Christian Grün 22 Feb '13

22 Feb '13

…glad to hear it works. ___________________________ > Thanks Christian for your response, > > I have done a mistake in my code. I have executed different xpaths against > both causes the time difference. Now I have executed same xpath against both > and BaseX xpath evaluation is faster than SAX. > > Regards, > Elango. > > > On Fri, Feb 22, 2013 at 3:51 PM, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Hi Elango, >> >> to say anything on this, we probably need more information on how you >> are processing your data via SAX, and how you receive your result via >> session.query(expression).execute(). Do you have some self-contained >> code that allows us to get more insight into how you are testing? >> >> Best, >> Christian >> >> >> On Wed, Feb 20, 2013 at 11:56 AM, elangovan MuthuSwamy >> <elangovan.h(a)gmail.com> wrote: >> > Hi All, >> > >> > I am trying to use BaseX Client and server with large XML files(13 MB >> > size). >> > I have created a database for the XML and evaluated an xpath in that. >> > When I >> > executed an xpath it takes around 250 milliseconds to fetch the results. >> > In >> > case of SAX parser I could get the response for the same xpath within 5 >> > seconds. >> > >> > I used following BaseXClient code for this. >> > >> > BaseXClient session = new BaseXClient("localhost", 1984, "admin", >> > "admin"); >> > >> > // code to fetch the large XML file size. Read from the file. >> > String xmlString = ....... >> > >> > InputStream bais = new ByteArrayInputStream(xmlString.getBytes()); >> > session.create("database", bais); >> > >> > String expression = "/configuration/protocol[starts-with(name, >> > 'http')]/name"; >> > >> > session.query(expression).execute(); // this line takes 250 milliseconds >> > to >> > give the result. Where as same xpath can be executed within 5 >> > milliseconds >> > in SAX parser. >> > >> > Am I basically missing anything or something else. >> > >> > >> > Please advice me. >> > >> > Thanks in advance. >> > >> > -- >> > Regards, >> > Elango. > > > > > -- > Regards, > Elango.

1 0

Additional info on the invoke problem
by Arto Viitanen 22 Feb '13

22 Feb '13

I am not sure if this tells more of the problem (xquery:invoke does not open the collection), but: if the query does something with the collection plus predicates retrieved, the query is evaluated. So, in my example collection('suuryritys_com/suuryritys.com/data/ou')//*[@cat='production'] if I add some extra content that forces the evaluation, like <a>{collection('suuryritys_com/suuryritys.com/data/ou')//*[@cat='production']}</a>/* I.e. add the result to a -element and retrieve it, the xquery:invoke("file-name.xq") evaluates the query, even if the database (suuryritys_com) is closed! -- Arto Viitanen Microteam Oy Finland

2 1

BaseX 7.6, XQJ API 1.2.3 and XQuery 3.0 features - syntax error for simple map operator
by Markus Ackermann 22 Feb '13

22 Feb '13

Hello BaseX-community, first of all, I really have to say that I really enjoy using BaseX and that I am really impressed by its active development and its ongoing improvement. I am still a little unsure about the Query 3.0 support via the BaseX XQJ driver from net.xqj, though. According to the Changelog of the website ([1]), XQuery 3.0 via XQJ is now supported: BaseX 7.3, 18.06.2012 [...] - Charles Foster's latest XQJ Driver supports XQuery 3.0 and the Update and Full Text extensions: http://xqj.net/basex/ The README file of Charles Foster's driver also states that XQuery 3.0 is supported since driver version 1.1.0: Version 1.1.0: * Supports XQuery 3.0 + XQuery Update Facility + XQuery Full Text extensions. * Various bug fixes. However, take this minimal example using the simple map operator (query A): BaseXXQDataSource dataSource = new BaseXXQDataSource(); dataSource.setServerName("localhost"); dataSource.setPort(1984); XQConnection con = dataSource.getConnection("dict_wsa", "lidell"); con.createExpression().executeQuery( "(1 to 3) ! (. * 2))"); //query A con.createExpression().executeQuery( "let $m := map { 'one' := 1, 'two' := 2 }" + "return ($m('one')"); //query B Executing it yield a syntax exception: Exception in thread "main" javax.xml.xquery.XQException: XQJQS001 - Invalid XQuery syntax, syntax does not pass static validation. Root Cause: net.xqj.basex.bin.bn: Lexical error at line 1, column 11. Encountered: " " (32), after : "!" at XQ3Test.main(XQ3Test.java:21) at XQ3Test.main(XQ3Test.java:21) For query B I also receive a syntax exception: Exception in thread "main" javax.xml.xquery.XQException: XQJQS001 - Invalid XQuery syntax, syntax does not pass static validation. Root Cause: net.xqj.basex.bin.bj: Encountered " "{" "{ "" at line 1, column 15. Was expecting one of: "=" ... "order" ... "," ... Is there another option I have to set to circumvent the 'static validation' or did I overlook anything else? Regards and thanks in advance for any information or advice, Markus Ackermann PS: Information on the execution environment: JVM: 1.7.0_13 (Oracle Corporation 23.7-b01) OS: Linux 3.0.0-30-generic amd64 (Ubuntu 11.10) BaseX 7.6

2 1

Re: [basex-talk] BaseX-Talk Digest, Vol 38, Issue 36
by Arto Viitanen 22 Feb '13

22 Feb '13

22.2.2013 11:04, basex-talk-request(a)mailman.uni-konstanz.de wrote: > Message: 3 > Date: Fri, 22 Feb 2013 09:00:09 +0100 > From: Marco Lettere <marco.lettere(a)dedalus.eu> > To: basex-talk(a)mailman.uni-konstanz.de > Subject: Re: [basex-talk] Indirect evaluation with xquery eval or > invoke on closed collection > Message-ID: <51272589.3000600(a)dedalus.eu> > Content-Type: text/plain; charset="iso-8859-1"; Format="flowed" > > This looks like the same stacktrace reported here: > > https://mailman.uni-konstanz.de/pipermail/basex-talk/2013-February/004683.h… > > BTW, I got also a major corruption of the DB. Your DB remains coherent > when this happens? > M. > > No, but then the query was readonly. Another, but similar query by my colleagues also gave some random answer; where as my gave the stack trace. They used C# api, so it might be partially reason for the difference. -- Arto Viitanen

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk