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

Re: [basex-talk] BaseXException
by Mark Boon 09 Dec '10

09 Dec '10

Rats, I just found out that the XQuery class is defined as final. :-(( On Thu, Dec 9, 2010 at 8:40 AM, Mark Boon <mboon(a)avatar-reality.com> wrote: > Well, as I said, it was just an off-the-wall idea. And I appreciate > the focus on performance, it's paramount. > > Having said that, the XQuery class is the one that has the query and > generates the exception and is thereby in the unique position to > easily perform certain services, like providing a nicely formatted > error to the exception. Any other solution is going to be a workaround > at best. The best I can think of right now is to sub-class XQuery and > catch the BaseXException and wrap it in a new exception in the > execute() method and add a printErrorDetail() method that does the > formatting as I explained. I see little drawback in terms of either > performance or security, as you'll still be free to use the base-class > in any case. > > So that's what I'll do. Maybe I'm the only one who sees the value of > it, I thought there would be more developers who'd benefit of such an > implementation. > > Mark > > > On Thu, Dec 9, 2010 at 1:08 AM, Christian Grün > <christian.gruen(a)gmail.com> wrote: >>> org.basex.core.BaseXException: Stopped at line 42, column 55: >>> [XPST0003] Expecting ")", found """. >>> >>> However, it doesn't show me the query. Since I generate (sometimes >>> large) queries automatically, this message by itself is not always >>> very helpful (to put it very mildly). >> >> In your case, I'd recommend to wrap query execution with try/catch and >> lookup the relevant snippet by yourself; this is similar to what Jan >> has already proposed. If this should not be possible for reason, feel >> free to comment back on this. >> >> Based on my experiences, a more detailed error feedback would >> represent undesirable overhead. >> >> Christian >> >

1 0

Re: [basex-talk] BaseXException
by Mark Boon 09 Dec '10

09 Dec '10

Well, as I said, it was just an off-the-wall idea. And I appreciate the focus on performance, it's paramount. Having said that, the XQuery class is the one that has the query and generates the exception and is thereby in the unique position to easily perform certain services, like providing a nicely formatted error to the exception. Any other solution is going to be a workaround at best. The best I can think of right now is to sub-class XQuery and catch the BaseXException and wrap it in a new exception in the execute() method and add a printErrorDetail() method that does the formatting as I explained. I see little drawback in terms of either performance or security, as you'll still be free to use the base-class in any case. So that's what I'll do. Maybe I'm the only one who sees the value of it, I thought there would be more developers who'd benefit of such an implementation. Mark On Thu, Dec 9, 2010 at 1:08 AM, Christian Grün <christian.gruen(a)gmail.com> wrote: >> org.basex.core.BaseXException: Stopped at line 42, column 55: >> [XPST0003] Expecting ")", found """. >> >> However, it doesn't show me the query. Since I generate (sometimes >> large) queries automatically, this message by itself is not always >> very helpful (to put it very mildly). > > In your case, I'd recommend to wrap query execution with try/catch and > lookup the relevant snippet by yourself; this is similar to what Jan > has already proposed. If this should not be possible for reason, feel > free to comment back on this. > > Based on my experiences, a more detailed error feedback would > represent undesirable overhead. > > Christian >

1 0

Aufnahme von Java-Bibliotheken in die Datenbank ?
by Burkert, Michael 09 Dec '10

09 Dec '10

Hallo ! Allgemeine Anfrage: Aufnahme von Java-Bibliotheken in die Datenbank Bei uns meint jemand, in der Datenbank eXist bestehe die Möglichkeit, Java-Bibliotheken aufzunehmen. Hintergrund: Es sei gelungen die Validierungsengine auszutauschen und einen OWL-Reasoner direkt zu integrieren. Damit wäre es möglich eine ontologische Prüfung von OWL-basierten XML-Daten unmittelbar aus der Datenbank heraus bei der Speicherung durchzuführen. Ist dies bei BaseX bereits heute möglich ? Bzgl. der Anwendungsvielfalt bei XML sicherlich ein interessanter Ansatz. der in Zukunft womöglich häufiger angefragt wird. Viele Grüße Michael

3 2

Anfrage: Speicher und Datenbankgröße
by Burkert, Michael 09 Dec '10

09 Dec '10

Hallo ! Womöglich habt Ihr das Thema schon häufiger auf dem Tisch gehabt. Aus Euren Erfahrungen: Wie groß darf eine Datenbank sein, damit sie mit den Default Einstellungen für Java noch arbeitet ? Per Defaulteinstellungen Unbegrenzt ? Per Defaulteinstellungen begrenzt auf wie viel MB ? Wie kann man BaseX im Falle einer Begrenzung elegant mehr Speicher spendieren ? Bei mir laufen 170 MB problemlos, selbst mit komplexen XQuery-Abfragen. Bei über 500 MB war bei einem Testlauf in der Vergangenheit erst einmal Schluß. Viele Grüße Michael

2 1

BaseXException
by Mark Boon 09 Dec '10

09 Dec '10

This is a bit an off-the-wall request but I figured it doesn't hurt to throw out here as an idea. When I have an error in my query I typically get a BaseXException saying something like: org.basex.core.BaseXException: Stopped at line 42, column 55: [XPST0003] Expecting ")", found """. However, it doesn't show me the query. Since I generate (sometimes large) queries automatically, this message by itself is not always very helpful (to put it very mildly). Either I print all my queries in their entirety, something that results in a dazzling amount of output. Or I jump through some hoops and try to keep my last query so it can be printed alongside the exception. Both are not very satisfactory solutions. I was thinking though how nice it would be if the exception could print the query for me. And the icing on the cake would be if (in the above example) it would print an extra line just after line 42 with 54 spaces and ^ at column 55, so I get an arrow pointing out where the error is without me having to count to 42 first and then to 55. Whatcha all think? Personally, I think it's such a good idea I was thinking of doing it myself. If the BaseX6.3 source were available, that is. Mark Boon

3 2

BaseX 6.3.3 - problems to list some docs if path specified (in some cases)
by Jan Vlčinský 09 Dec '10

09 Dec '10

Hi I get problems listing some documents Attached is compressed database. Test scenario - listing all docs - OK for $doc in collection() return base-uri($doc) returns file:/D:/opt/BaseX/snapshot file:/D:/opt/BaseX/mydata.xml file:/D:/opt/BaseX/path/to/data/mydata.xml file:/D:/opt/BaseX/mydata2.xml file:/D:/opt/BaseX/path/to/data/mydata2.xml file:/D:/opt/BaseX/DDRTest/ddr/live/JSDI_NDIC_20100111_00000751.xml file:/D:/opt/BaseX/DDRTest/ddr/live/JSDI_NDIC_20100111_00000752.xml This is OK Test scenario - listing path/to/data documents - OK for $doc in collection("DDRTest/path") return base-uri($doc) for $doc in collection("DDRTest/path/to") return base-uri($doc) for $doc in collection("DDRTest/path/to/data") return base-uri($doc) in all cases returns file:/D:/opt/BaseX/path/to/data/mydata.xml file:/D:/opt/BaseX/path/to/data/mydata2.xml This is also OK Test scenario - listing ddr/live docs - ERROR for $doc in collection("DDRTest/ddr") return base-uri($doc) for $doc in collection("DDRTest/ddr/live") return base-uri($doc) does not return anything. This is bad. How was the database created All DDRTest/path/to/data documents were added via command line client. Note, that those documents are very simple like <root/> All DDRTest/ddr/live documents were added using Python API Note, that when adding those documents, XML declaration was present as seen from my log record add as JSDI_NDIC_20100111_00000752.xml to DDRTest/ddr/live *<?xml version="1.0" encoding="utf-8"?>*<DOC version="3.0" id="14662257-ca70-48a1-b2b8-0c34d6f4cef4" country="CZ" DataSet="extended"><INF sender="JSDI_NDIC" receiver="TRAFFICINTELLIGENCE" transmission="HTTP"><DAT><EVTT version="2.01" language="CZ" /><SNET type="GN" version="8.12" country="CZ" /><UIRADR structure="4.2" version="593" /></DAT></INF><MJD count="1"><MSG id="{8ad5a3b7-261d-b1f0-0126-1dd076cd0045}" version="1" type="TI" planned="false"><MTIME format="YYYY-MM-DDThh:mm:ssTZD"><TGEN>2010-01-11T15:39:38+01:00</TGEN><TSTA>2010-01-11T15:33:17+01:00</TSTA><TSTO>2010-01-11T16:33:17+01:00</TSTO></MTIME><MTXT language="CZ">Od 11.1.2010 15:33 do 16:33 v ulici Okružní v obci Klášterec nad Ohří okres Chomutov , délka 176m; Klášterec nad Ohří, ul. Okružní u č.p. 557, okr. Chomutov nehoda; OA srazilo chodce, bez zranění</MTXT><MEVT><TMCE urgencyvalue="N" directionalityvalue="1" timescalevalue="(D)" diversion="false"><EVI eventcode="201" updateclass="3" quantifier="1" eventorder="1"><TXUCL language="CZ">Nehody</TXUCL><TXEVC language="CZ">nehoda</TXEVC></EVI><TXTMCE language="CZ">nehoda </TXTMCE></TMCE></MEVT><MLOC><TXPL>v ulici Okružní v obci Klášterec nad Ohří okres Chomutov , délka 176m</TXPL><SNTL coordsystem="S-JTSK" count="4"><COORD x="-825701" y="-996639" /><STEL el_code="160642" /><STEL el_code="160642" /><STEL el_code="160771" /><STEL el_code="160951" /></SNTL></MLOC><MDST><DEST CountryName="Česká republika" RegionCode="60" RegionName="Ústecký" TownShipCode="3503" TownShip="Chomutov" TownCode="563129" TownName="Klášterec nad Ohří"><STRE StreetCode="147290" StreetName="Okružní" /></DEST></MDST></MSG></MJD></DOC> Attached is also log file from BaseX. Jan On Tue, Oct 26, 2010 at 1:16 PM, Jan Vlčinský <jan.vlcinsky(a)gmail.com>wrote: > Thanks Michael > The option to specify path in collection is good one. > Just for others to see how it behaves: > > I have collection name "Pokus" > add as item01.xml to "dir/subdir" <root1/> > add as item02.xml to "/dir/subdir" <root2/> > creates two documents there (both path versions works the same, with or > without slash) > base-uri reports names starting "file:/D:/opt/BaseX/dir/subdir" > (what might confuse a bit, but not much) > > xquery for $doc in collection("Pokus/dir/subdir") return base-uri($doc) > selects both items properly (of course showing the 'D:/opt/BaseX/' inside > of the base-uri result string). > > xquery for $doc in collection("Pokus/") return base-uri($doc) > selects all items in the collection, not only from the root > > xquery for $doc in collection("") return base-uri($doc) > selects all items in the currently open collection, if one used open > <collection>, otherwise it complains about no default collection. > > I did not find any way how to query relative path in current collection > without naming it. No real need for this now. > > With best regards > > Jan > > On Tue, Oct 26, 2010 at 11:37 AM, Michael Seiferle < > michael.seiferle(a)uni-konstanz.de> wrote: > >> Hi Jan, >> >> I am sorry but at the moment there is - to my knowledge - way of >> specifying a custom prefix to the base-uri(). >> You can as well, starting from 6.3, provide a path to documents inside a >> collection via: >> >> for $doc in collection('test/dir') >> return base-uri($doc) >> >> Anyway, regarding your issue: >> >> for $doc in collection('test/dir') >> return replace(base-uri($doc),'file:/path/foo/bar/','') >> >> might do the trick. >> >> Kind regards >> Michael >> Am 26.10.2010 um 11:16 schrieb Jan Vlčinský: >> >> I tried many ways how to specify target - without and with slash and >> backslash - no change. >> Is there any way to manage that? >> >> Jan Vlčinský >> >> PS: Be sure this is not a problem if it is not possible. it would be only >> a bit nicer. >> >> >> > > > -- > *Jan Vlčinský* > Slunečnicová 338/3, 734 01 Karviná Ráj, Czech Republic > tel: +420-597 602 024; mob: +420-608 979 040 > skype: janvlcinsky; GoogleTalk: jan.vlcinsky(a)gmail.com > > -- *Jan Vlčinský* Slunečnicová 338/3, 734 01 Karviná Ráj, Czech Republic tel: +420-597 602 024; mob: +420-608 979 040 skype: janvlcinsky; GoogleTalk: jan.vlcinsky(a)gmail.com

2 1

Dynamische Elementnamen ?
by Burkert, Michael 08 Dec '10

08 Dec '10

Hallo ! Frage: Ist es möglich Knotennamen dynamisch zu vergeben ? Konkret: <mod:Elementname1> soll dynamisch erzeugt werden. Abstrakt: <{$nodename}> Statische Vergabe von Knotenamen: declare function Model:Fkt ( $classes as xs:string) as node()* { for $class in $classes return <mod:Elementname1 rdf:about="{$class}"> </mod:Elementname1> }; Mit freundlichen Grüßen Michael B

3 3

How to delete selected documents from database
by Jan Vlčinský (CAD) 07 Dec '10

07 Dec '10

Hi So far I was adding documents and querying using Python API (generally sending commands to BaseX). Now I need to delete some documents. What is the most effective method? 1. drop db I would have to recreate it very soon. I am a bit concerned by other clients being connected to the same database 2. loop in Python performing delete command one document by one 3. do some sort of xquery in style "for $doc in collection() return (delete base-uri($doc))" Note, that this does not work, but there might be some way like this similar to insert or update mechanism Any ideas or hints? Thanks for advice Jan -- *Ing. Jan Vlčinský* CAD programy Slunečnicová 338/3, 734 01 Karviná Ráj, Czech Republic tel: +420-597 602 024; mob: +420-608 979 040 skype: janvlcinsky; GoogleTalk: jan.vlcinsky(a)gmail.com http://cz.linkedin.com/in/vlcinsky

2 1

BaseX 6.3.3
by Christian Grün 06 Dec '10

06 Dec '10

Dear all, we've just released another minor version of BaseX, which is also linked now from the download page (http://basex.org/download). Finally, BaseX 6.5 will be published in January '11. Along with the official release, we'll relaunch our homepage, containing some commercial offerings.. stay tuned! Here's the changelog of Version 6.3.3: [ADD] XQuery: "ft" module added to extended XQuery Full Text with useful features; see http://basex.org/xq-ft [ADD] Command: DROP BACKUP added to drop database backups [ADD] GUI: new menu items "Add documents" and "Delete documents" [ADD] GUI: new menu item "Manage" to backup/restore/rename/drop databases [MOD] XQuery: "db" and "file" modules updated: http://basex.org/xquery [MOD] System.getProperty("user.dir") added as optional home directory [MOD] GUI: menu structure updated [FIX] Command: ADD modified to support the addition of larger documents [FIX] GUI: highlighting of search terms in text editors [FIX] GUI: file chooser supports new extensions: *.xql, *.xquery, ... [FIX] Server: StressTest All the best, Christian

1 0

A couple of technical issues
by Mark Boon 04 Dec '10

04 Dec '10

I ran into a few separate issues. Since they concentrate on the same piece of code, I address them simultaneously. In my program I have the following method: private void processEventTriggers() { try { ByteArrayOutputStream stream = new ByteArrayOutputStream(); String inQuery = "collection()/event/@in/string()"; XQuery inputQuery = new XQuery(inQuery); inputQuery.execute(_context,stream); String input = stream.toString(); String processQuery = "collection()/trigger_set/trigger[@name='"+_currentTrigger+"']/matches"; System.out.println("Process Event: "+processQuery); QueryProcessor processor = new QueryProcessor(processQuery, _context); Iter iterator = processor.iter(); Item item; while ((item=iterator.next())!=null) { BXNode node = (BXNode)item.toJava(); String pattern = node.getAttributes().getNamedItem("pattern").getNodeValue(); // Pattern regexp = Pattern.compile(pattern, Pattern.CASE_INSENSITIVE); // Matcher regexpMatcher = regexp.matcher(input); // System.out.print("'"+input+"' matches '"+pattern+"'"); // if (regexpMatcher.matches()) // System.out.println(" = true"); // else // System.out.println(" = false"); String matchQueryString = "matches('"+input+"','"+pattern+"','i')"; System.out.print("Match Query: "+matchQueryString); XQuery matchQuery = new XQuery(matchQueryString); stream.reset(); matchQuery.execute(_context,stream); if (stream.toString().equals("true")) { System.out.println(" = true"); if (executeCommands(node)) break; } else System.out.println(" = false"); } } catch (BaseXException exception) { exception.printStackTrace(); } catch (QueryException exception) { exception.printStackTrace(); } } What this does is it queries the database for an input item and then matches this input to a set of 'matches' nodes. When a node matches it starts executing a series of commands, which are mostly XQuery commands themselves. The first issue I have is that it seemed a bit inefficient to use an XQuery to match a regular expression. The section commented out matches the same regular expression. Unfortunately, I bumped into a few cases where the Java implementation mistakenly returns 'false' whereas the BaseX implementation returns 'true'. I can't complain really about BaseX here. Actually, kudos for providing a proper implementation, because I had assumed it would simply delegate this functionality to the Java regexp API. But I was a bit surprised to find that the Java regular expressions implementation seems to be broken. My question now is, can I call the BaseX 'matches()' function directly? Because I think that would be much more efficient. A more serious issue I have is that the XQueries that are executed in the 'executeCommand()' call occasionally insert and delete nodes into collection()/memory sub-elements. And it also can recursively call processEventTriggers() again. Most of the time this works fine, but occasionally I get the following error: Exception in thread "main" java.lang.RuntimeException: Possible bug? Feedback is welcome: basex-talk(a)mailman.uni-konstanz.de BaseX 6.3.2: Data Access out of bounds [pre:403, indexSize:4, access:4 > 3] at org.basex.util.Util.notexpected(Util.java:46) at org.basex.io.TableDiskAccess.cursor(TableDiskAccess.java:323) at org.basex.io.TableDiskAccess.read1(TableDiskAccess.java:92) at org.basex.data.Data.kind(Data.java:324) at org.basex.query.item.DBNode$4.next(DBNode.java:272) at org.basex.query.path.IterStep$1.next(IterStep.java:45) at org.basex.query.iter.NodeIter.next(NodeIter.java:1) at org.basex.query.path.IterPath$1.next(IterPath.java:66) at org.basex.query.path.IterPath$1.next(IterPath.java:1) at BotCommandProcessor.processEventTriggers(BotCommandProcessor.java:285) at BotCommandProcessor.processEvent(BotCommandProcessor.java:262) at BotCommandProcessor.executeCommands(BotCommandProcessor.java:364) at BotCommandProcessor.processEventTriggers(BotCommandProcessor.java:305) at BotCommandProcessor.processEvent(BotCommandProcessor.java:262) at BotCommandProcessor.main(BotCommandProcessor.java:442) Now I'm not entirely sure, but I suspect that the iterator is affected either by the insert/delete operations or by the nesting of the iterator process. Or a combination of the two. I could somehow understand this if the queries that are being executed would affect the set of triggers it's looping over, but that is not the case. I did find an ugly way around this problem but I'm afraid it could get me into trouble later. So any feed-back about what might be the best way to fix this would be appreciated. Mark Boon

2 1

Introducing PAD Submit Worker
by ShareSoftware24 01 Dec '10

01 Dec '10

This message: Introducing PAD Submit Worker Dear DBIS Group, University of Konstanz, We're ShareSoftware24.com, one of the fastest growing download websites for Windows, Mac, Linux and PDA/Mobile software. You have received this message because we have listed one or more of your products on our website. Let us ask you, do you still submit your product's PAD files manually to software websites and directories? NO MORE!!! Today Introducing... <http://www.sharesoftware24.com/free-downloads/windows/network-internet/ other/info/pad-submit-worker-60264.html> PAD Submit Worker PAD Submit Worker is an advanced application designed to enable you to submit PAD files everywhere automatically. PAD Submit Worker helps shareware authors to easily submit PAD files to all major download sites, directories, and other targeted resources as fast as possible.

1 0

Inserting nodes into xquery result sets
by Charles F. Munat 01 Dec '10

01 Dec '10

I have a database like this: <data> <templates> <template> <id>123</id> <content> <html> <head><title>My Template</title></head> <body><text/></body> </html> </content> </template> </templates> <pages> <page> <id>456</id> <content> <p>This is some text.</p> </content> </page> </pages> </data> I want to write an XQuery that results in this: <html> <head><title>My Template</title></head> <body><p>This is some text.</p></body> </html> So <text/> is replaced by <p>This is some text.</p> Here is the start of an XQuery select: for $x in /data/templates/template[id='123']/content/* for $y in /data/pages/page[id='456']/content/* return $x That gets me the template. How do I insert $y in place of $x/body/text ? I've searched all over with no luck. I can do this in the business logic, but so much better to do it in the query. Also, I'd like to be able to do this recursively. Is that possible? Do I have to write my own function for this? Thanks much for any help! Chas.

2 3

Surprising function behavior
by Mark Boon 30 Nov '10

30 Nov '10

I bumped into some surprising function behavior. I have the following query: declare namespace math = "java:java.lang.Math"; declare function local:choose-phrase ( $phrase as xs:string ) as xs:string { let $prefix := local:choose( ("Absolutely, ", "It's likely that ", "The odds are good that ", "There's a fairly good chance that ", "There's a light chance that ", "It's uncertain that ", "Chances are not good that ", "It's doubtful that ", "It's unlikely that ", "There's no way that ") ) return fn:concat($prefix,$phrase) }; declare function local:choose ( $arg as xs:string* ) as xs:string { let $count := fn:count($arg) let $random := math:floor(math:random() * $count) + 1 return $arg[xs:integer($random)] }; local:choose( ( "Phrase 1", "Phrase 2" ) ) When I execute this (say in the GUI tool) it's supposed print either "Phrase 1" or "Phrase 2". Instead it prints a random choice from the function 'choose-phrase' as if it was called with an empty string as argument, which is very strange. When I remove the 'choose-phrase' function altogether, the query behaves correctly. If I then paste the 'choose-phrase' after the 'choose' function, it also behaves correctly. But declaring 'choose-phrase' before 'choose' gives me an unexpected result. The only thing I can think of is that 'choose-phrase' calls 'choose' which is declared later. I don't know if that's actually allowed. But even so, it should give an error instead of seemingly doing something random.

2 1

Re: [basex-talk] User-defined functions
by Christian Grün 23 Nov '10

23 Nov '10

Hi Mark, (I'm passing this on to the mailing list..) > At the moment my function block is not very long. But I expect this is > likely to change, as I'm using XQuery as a sort of programming > language where 'users' can add functions. Moreover, there will be > cases where they'll be executing thousands of queries and the total > execution time should ideally take no more than a second or two in the > most extreme circumstance. > > At this time I don't experience any performance problems, BaseX is > very snappy. But I'm still in the experimentation phase and I'd like > to avoid spending a lot of time building a framework that later may > turn out to be unworkably slow. Regarding the complexity and size of function blocks, our users haven't reported any bottlenecks yet. Instead, bad performance is mainly due to XQuery expressions that are difficult, or impossible, to optimize. But, no doubt, it might make sense to precompile complex XQuery code that takes hundreds of KB, or even MB. Right now, precompilation of XQuery code isn't supported in BaseX > Another thing I ran into is that updating doesn't seem to be allowed > within functions. So I'm now looking into using XSLT to solve these > issues for me. On the one hand by prefixing the query with the > function declarations that are actually used in the query, and through > templates that would substitute updating function-calls by the > function-body. I'm also new to XSLT so I'm not sure if that will work, > but it seems worth giving it a try. Updating is no problem in XQuery functions: you'll have to add the "updating" specified to a function declaration: declare updating function ... { ... }; A general restriction of XQuery is that an expression cannot both update and output items. As an example, the following query is invalid: delete //node, 1 to 10 Instead, you can perform local updates by applying the transform expression: copy $a := ...nodes to be modified... modify ...update on $a... return ...e.g., $a... > P.S. extracting the xsl-stylesheet from the file-header from an XML > file and then applying it to itself is a bit ugly, does anyone know if > there is a (JAXP) way to get an XML file with its stylesheet already > applied automagically? Maybe this won't be necessary anymore.. Hope this helps, Christian

2 1

basex 6.3.2 and .NET
by Maximilian Gärber 23 Nov '10

23 Nov '10

Hi all, I did some testing with IKVM and basex-6.3.2.jar and it turns out to be as simple as calling ikvmc on the .jar file to get a working basex-6.3.2.dll for .NET I adapted the DB example from http://www.inf.uni-konstanz.de/dbis/basex/code/DatabaseExample an it run without problems. Now I am curious what others have experienced using basex on .NET. And of course: what are chances that this could be supported in the future (like Saxon.net, for example) Best Regards, Maximilian

3 3

User-defined functions
by Mark Boon 23 Nov '10

23 Nov '10

I'm fairly new to XQuery and only started to use it and BaseX last week. So far I've been very impressed with the capabilities of both. I have one question about user-defined functions. From what I can tell so far that I learned about XQuery, user-defined functions are only accessible when they are declared in the prolog of the query. In itself I suppose there's a certain logic to that. My project is most likely very atypical from your average XQuery usage, but it would be much more convenient, and probably also much more efficient if I could somehow (optionally) declare user-defined functions and reuse them for several queries in a row. I don't think importing a module would be a solution because a) that would be even more inefficient and b) I don't think it wouldn't work with dynamically created functions. (I'm executing queries that contain queries that get executed...) So I was wondering if there's a way to accomplish this. And even if this is currently not possible, would it be complicated for an accomplished Java developer to add as a custom extension? Any tips or ideas will be greatly appreciated. Mark

2 1

Test doesn't succeed for Rev. 2715 / 2718
by Thomas 22 Nov '10

22 Nov '10

Hi, I just checked out Rev. 2718. During build, I get the following error: Running org.basex.test.server.ServerCmdTest BaseX 6.3.3 [Server] Server was started. Tests run: 34, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 2.541 sec <<< FAILURE! Server was stopped. When I uncomment the following lines in CmdTest (that have been changed in 2715), the test succeeds. l 350 ok(new Open(NAME)); l 351 no(new Restore(NAME)); l 352 ok(new XQuery(".")); The message says: java.lang.AssertionError: Database 'input' was not found. at org.junit.Assert.fail(Assert.java:91) at org.basex.test.server.CmdTest.ok(CmdTest.java:428) at org.basex.test.server.CmdTest.restore(CmdTest.java:350) The other tests succeed. Any ideas? Greetings, -- Thomas

2 1

Specify a custom document name containing spaces
by Daniël Knippers 18 Nov '10

18 Nov '10

Hi everyone, I have a question regarding the add command -- ADD (AS [name]) (TO [target]) [input]. It seems it is not possible to add a document to the database which you want to give a custom name (for whatever reason) that contains a space like so: add as "test x.xml" "/path/to/test 1.xml" Doing this will result in an error implying I do not use the right syntax. Apparently it is not allowed to use quotes (neither " nor ') around the name you want to give the document. I wonder why this is. Especially because BaseX will actually name the document 'test 1.xml' when the 'as [name]' is omitted; like so: add "/path/to/test 1.xml" I wonder if this is a minor bug in the syntax checking of this command, or that this is intended behavior. In case of the latter, I wonder if there is another way to specify names which contain spaces. While we are at it (the add command): I was expecting the TO [target] part to refer to a database. For example, if I have two databases 'misc' and 'col', I would expect a command such as: add to misc "/path/to/test.xml" to add the document test.xml to the database misc. Instead, I first have to open the database misc, then add the document (without the 'to misc'-part), then close it again. Is this also intended? If so, please enlighten me as to what target exactly refers to (apparently no database/collection). Thanks in advance for any responses. -- Daniël ps. I am on version 6.3.1

4 9

Util.applicationPath based on ProtectionDomain returns unintended context-/app-location
by Thomas 18 Nov '10

18 Nov '10

Hello everyone, I'm new to BaseX. Just evaluating if it fits in my current project. Looks great. My project uses maven, BaseX 6.3.2 is added as a dependency according to your documentation. Here comes the problem: The resolution of the Prop.HOME-Directory (thus the location of the props-file ".basex") doesn't fit the intended behavior (as far as I got the intention), when using (Netbeans and) maven for build and run. And it should not work as intended when placing the basex-jars in a lib-directory as well. AFAIK, it's supposed to be a directory relative to the path in which the application got executed (if props ".basex" are found there, otherwise the users home directory). (If however the current path should be the intended one, then I'd say it's not very intuitive or practical) Using (Netbeans and) maven for build and run, causes the relative path to result in the maven-repository-location of the xbase-jar. (e.g. "{repository-root}/.m2/...") That's definitely no place for a props-file, so it will always result in the user-home-directory. I don't want to pollute the users home directory however (besides we plan to make the app portable), that's why I was wondering if you could detect the relative path in another way. Here's the details of what's currently happening: The creation of the Database: Class<?> c = Class.forName(DRIVER); Database db = (Database) c.newInstance(); causes several initializations to happen. Among others, there's the static initializer of Prop (line 38), which calls Util.applicationPath() to calculate the HOME directory. The method body of applicationPath starts with final String path = Util.class.getProtectionDomain(). getCodeSource().getLocation().getPath(); which returns the location of the jar in the maven repository, which is not the application path (and could result in a completely unintended path when using custom-classloaders). Suggestion: Could you just calculate the working directory like this: final String path = new File(".").getPath(); or final String path = new File(".").getAbsolutePath(); This would IMHO result in a more intuitive location for the working- (or config-)directory. I'd suggest to put that into a new method, say Util.workingPath() (or Util.configPath()), to prevent trouble with code, that actually needs to receive the jar-file-location (if such code exists at all). To stay compatible with the old resolution strategy, you could just add this line of code on top of the old resolution, thus provide a third location for props. I'd contribute this patch by myself, if you'd agree. Future needs for my application are dynamic configuration of port-ranges and stuff, that's why I'd also love to have the opportunity to configure BaseX completely by the use of the API, without having to deal with config-files for "third-party-libs". BaseX looks great and I'd love to use it for my project if it proves to be adequate. Great work! Greetings, -- Thomas

2 4

BaseX 6.3.2
by Christian Grün 17 Nov '10

17 Nov '10

Hi all, we've just uploaded another version of BaseX. The most notable change is the removal of the "basex" XQuery functions and the introduction of two new modules "db" and "util". Details on the new and modified functions are listed at: http://basex.org/xquery We'll add numerous other function libraries in near future. If you have any requests.. Christian Changelog Version 6.3.2: [ADD] Storage: compression of text files (activation: SET COMPRESS 1) [ADD] XQuery: new "db:" and "util:" functions, replacing "basex:" [ADD] XQuery: initial implementation of the EXPath http module [ADD] XQuery Editor: line/column information, support for surrogates [MOD] XQJ: dummy properties added: user, password, serverName, port [FIX] Storage: wildcard index did not find last word [FIX] Dynamic integration of optimal CatalogResolver implementation [FIX] XQuery bugs (count() on open collection, external functions, ..)

2 2

BaseX security report
by DownloadRoute.com 17 Nov '10

17 Nov '10

Hello, We would like to inform you that your program BaseX 6.0 has successfully passed antivirus and antispyware tests and were so impressed that we decided to give you our 100% CLEAN award! We use for scanning now four of the best antivirus engines available on the market. Place the following ready-to-use HTML code on your website to increase the trust for your program and let your visitors know that is Virus Free. You can use text version or image version (with your software name), both linking to your program details: Graphics award: <a href="http://www.downloadroute.com/BaseX-DBIS-Group-University-of-Konstanz.html"><img src="http://www.downloadroute.com/images/av-awards/BaseX-DBIS-Group-University-o…" style="border:none;" width="180" height="120" alt="BaseX - 100% Safe granted by DownloadRoute.com"></a> You must know that we've created the brand new and *absolutely real reports*. Other sites usually offers only fake awards. You may check your security reports on this URL: http://www.downloadroute.com/BaseX-DBIS-Group-University-of-Konstanz/antivi… If you have any questions, don't hesitate to contact us. Best Regards, George Zubor - Senior Editor --------------------------------- e-mail: support(a)downloadroute.com web: http://www.downloadroute.com --------------------------------- Download Route is one of the biggest software archives on the internet with more than 73.500 software titles in archive.

1 0

update on context nodes
by Stefano Santoro 12 Nov '10

12 Nov '10

Hi, when I bind a DOM tree as the context item in XQJ against an XQuery script that performs updates, the passed DOM tree is not modified. Here is a groovy example import groovy.xml.XmlUtil import groovy.xml.DOMBuilder import groovy.xml.dom.DOMCategory import javax.xml.xquery.XQConstants docbuilder = DOMBuilder.newInstance() doc = docbuilder.sample() { renameMe(id:11) { renameInner(isit:"true","yes") } deleteMe(id:12) { alongWithMe("bummer") } insertBeforeMe(id:14) { alongWith(me:"true","Oh Yeah") andMe(too:"yes","Oh Yeah") } insertAfterMe(id:15) { atLevelThree(level:3) { atLevelFour(level:4, "fourth level") atLevelFour(level:4, "fourth level again") } alongWith(me:"true","Oh Yeah") } } // prints the DOM tree before updates XmlUtil.serialize(doc, System.out) ds = Class.forName("org.basex.api.xqj.BXQDataSource").newInstance() cnn = ds.getConnection() stmt = """ let \$r := . return ( rename node \$r/renameMe as 'gotRenamed', delete node \$r/deleteMe[@id='12'], insert node <gotInsertedBefore id='13'> <alongWithMe>Cool</alongWithMe> </gotInsertedBefore> before \$r/insertBeforeMe[@id='14'], insert node <gotInsertedAfter id='16'> <alongWithMe>Cool</alongWithMe> </gotInsertedAfter> after \$r/insertAfterMe[@id='15'] ) """ xe = cnn.prepareExpression(stmt) xe.bindNode(XQConstants.CONTEXT_ITEM, doc, null) xqs = xe.executeQuery() // the DOM tree was not modified XmlUtil.serialize(doc, System.out) xqs.close() xe.close() cnn.close() Should I pass it as an external variable instead? Ciao Stefano

2 1

Re: [basex-talk] Can't build using maven 3
by Michael Seiferle 10 Nov '10

10 Nov '10

Hi Stefano, (this time with cc to the list, as this might be of general interest :-)) sorry again for the inconvenience. We currently have no automatic deployment of the minor Version jars to our repository (we are about to change that soon, hopefully). The recoomended and "clean" solution is installing the latest repository version of BaseX into your local subversion repository via: > $ cd basex > $ svn up > $ mvn -DskipTests=true install This should avoid the errors below. Let me know if this helps and feel free to ask more! Kind regards Michael Am 10.11.2010 um 19:41 schrieb Stefano Santoro: > [WARNING] The POM for org.basex:basex:jar:6.3.2 is missing, no dependency information available > Downloading: http://repository.codehaus.org/org/basex/basex/6.3.2/basex-6.3.2.jar > Downloading: http://www.inf.uni-konstanz.de/dbis/basex/maven/org/basex/basex/6.3.2/basex… > Downloading: http://repo1.maven.org/maven2/org/basex/basex/6.3.2/basex-6.3.2.jar >

1 0

predicate evaluation issue
by Martin Gieseking 10 Nov '10

10 Nov '10

Hello again, :) I think, I've found another bug. This time it's somehow related to implicit type casting. When running the query /a/b[@*=2] on the following XML document, both b nodes are selected, although the first one has no matching attribute. /a/b[@*='2'] returns the correct node. <a> <b a="1" b="3"/> <b a="2" b="2"/> </a> Best regards, Martin

2 3

types & encoding when talking to BaseX server
by Godmar Back 10 Nov '10

10 Nov '10

Hi, I have 2 questions regarding: https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/java/BaseXClient.java a) create() takes an InputStream. Which character encoding is assumed (I'm guessing UTF-8?) b) Query.next() returns a String. Is there a way/need to determine the type of the Query result (e.g., String, boolean, etc.)? (Or is an XQuery's result type statically determinable, in which case this would not be needed?) - Godmar

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk