BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

How to update db online without closing application ?
by Pratik Kharwade 18 Mar '13

18 Mar '13

Hi, Our application will be a desktop application with data in XML fomrat. The data is nothing but articles stored as XML and will be displayed in HTML format with the help of XSLT. For this we are using BaseX as desktop DB. Just changed to 7.6. The front-end will have a ListBox displaying the names of the articles, when selected by user, will display the transformed (HTML) document. Along with this functionality, we have given a search tool, which have some common XQuery features like; Exact Phrase, Proximity Search, Word1 OR Word, Word1 NOT Word2... This is what we have done successfully. Now we are stucked at one point. We have to give an online update facility through which the user DB will get updated, if not, as soon as he goes online. This part is also done but... While updating, the our application doesnt response till the updates are done. The user can't interact with the application. What we have planned is updating should be done as a background process and the user can interact with the application while updating. Also after updating the DB should get optimize and the updates should get reflected at the front-end. I hope I have cleared our needs and now waiting for your answer/suggestions. Have a nice day Pratik

3 2

problem with parse-xml function
by Bartosz Marciniak 18 Mar '13

18 Mar '13

Hi, Let me show you a simple example that shows strange behaviour of parse-xml() function: ----------------------------------------------- declare function local:transform($nodes as node()*) as item()* { for $node in $nodes return typeswitch($node) case text() return parse-xml-fragment($node) case element(b) return element b {local:transform($node/node())} default return local:transform($node/node()) }; let $textdoc := <doc><a>content 1</a> <a>content 2</a> </doc> let $doc := <doc>{ for $node in $textdoc/node() return local:transform($node) }</doc> let $doc2 := <doc>{ for $node in $doc/node() return $node }</doc> return $doc ---------------------------------------------------- After running it on baseX 7.6 the result is: $doc = <doc> <a>content 1</a> <a>content 2</a> </doc> but it differs from doc2: $doc2 = <doc> <a>content 2</a> <a>content 1</a> </doc> Why does using parse-xml() function change the order of the elements? I ran this simple code on zorba and eXist (using util:parse() function) and $doc2 was the same as $doc. Regards Bartosz Marciniak

2 1

Home, DBPATH etc. when basexserver is started in service mode
by Subash Kalbarga 18 Mar '13

18 Mar '13

Hi a) I am a new user, so far love basex and I am on Win7. I use the zip file (rather than the setup program) and extract b) I specifically set -Dorg.basex.path=c:\blah" in basexserver.bat and basexclient.bat c) If I now start basexserver.bat from a command prompt and then from another command prompt start basexclient.bat and do an "info" I see DB_PATH, REPO_PATH etc. set correctly to "c:\blah" as it should be. d) However if I run basexserver.bat -S (start as service) and then connect via basexclient.bat ,and do a info, the DB_PATH_REPO_PATH etc. are completely confused and basexclient thinks they are in its current directory. Moreover, if I actually create a database and add a file to it and close and then check where the data is stored, it is stored in the place basexclient thinks the DBPATH is rather than where it should be as per the server e) I am sort of sure that the server is looking at the correct paths even when started in -S mode because I see .basexhistory and .logs being created in C:\blah Thanks in advance

2 1

Wie man gutes Einkommen mit dieser Methode wird
by Emily Parker 16 Mar '13

16 Mar '13

Hello Basex Talk Ich habe 12 Jahre lang in Casinos gearbeitet. Ich habe tausende Menschen gesehen, die versucht haben, an den Roulette-Tischen Geld zu verdienen. Wenn sie nur gewusst hätten, dass der richtige Ort, um beim Roulette Geld zu verdienen, nicht das Casino, sondern das Internet ist! Online Casinos basieren auf Computerprogrammen und wenn Sie die Funktionsweise des Systems verstehen, können Sie diese schlagen. „Ein seltsamer Trick“ machte mich und hunderte andere Menschen reich! Finden Sie heraus, wie SIE GLEICH JETZT dasselbe tun können! Klicken Sie auf den unten stehenden Link, um das Roulette-System kennenzulernen, mit dem ich mein Haus, meine Urlaube und die Ausbildung meiner Kinder finanziert habe! http://awhub.com/b/click/270/47403792/2c1a3.html mit beste Grüße, Emily Parker P.S. Diese Methode ist so einfach, dass sie sogar Kinder verstehen! Ich weiß das, da mein Tochter Julia SELBST Geld damit verdient! Um aus unserer Mailingliste austragen http://awhub.com/b/unsub/189/47403792/2c1a3.html

1 0

seeking for a document in a collection with a million documents is very slow
by Fabrice Etanchaud 15 Mar '13

15 Mar '13

Dear all, Does the document index rely on text or attribute index ? One can experiment very slow response time when looking for a specific document name in an optimized collection of a million documents (in dynamic execution, without optimizations, for example within a loop with a name being the concatenation of string values). Is there a way to speed things up ? Best regards, Fabrice Etanchaud Questel-orbit

1 0

re-sort database
by Cerstin Elisabeth Mahlow 14 Mar '13

14 Mar '13

Hi, after a lot of data has been gathered, I realized that my update-function has a bug. It's not a big deal fixing it, however, I don't know how to resort the existing data. Essentially, I wanted to create this kind of data: <collection> <entry> <node>123</node> <query>xyz</query> <secondquery>abc_1</secondquery> <secondquery>abc_2</secondquery> </entry> <entry> <node>456</node> <query>xyz</query> <secondquery>abc_1</secondquery> <secondquery>abc_3</secondquery> <secondquery>abc_4</secondquery> </entry> </collection> However, the data looks like this: <collection> <entry> <node>123</node> <query>xyz</query> </entry> <secondquery>abc_1</secondquery> <secondquery>abc_2</secondquery> <entry> <node>456</node> <query>xyz</query> </entry> <secondquery>abc_1</secondquery> <secondquery>abc_3</secondquery> <secondquery>abc_4</secondquery> </collection> So, the secondqueries are stored just after the entry they belong to. How would I be able to move these data from "right after a particular node" to "just inside this particular node" using XQuery Update? Thanks in advance and best regards Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Departement Sprach- und Literaturwissenschaften Fachbereich Deutsche Sprach- und Literaturwissenschaft Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow(a)unibas.ch Web: http://www.oldphras.net

4 8

Error in 7.6 !! but not in 7.5
by John Best 14 Mar '13

14 Mar '13

Hi there, for $x in (db:fulltext('work', 'string theory')/ancestor::*:Doc except db:fulltext('work', 'elastic')/ancestor::*:Doc) return substring(data($x/Publish/PubDate/@d), 7) I am storing Dates in YYYYMMDD Format as <PubDate d="20040608"> tag. The above query will return the Date of the Document published for the searched criteria. Using the BaseX 7.5, I was able to run the query correctly. But with 7.6, I am getting error *"Single item expected, ("20040608", "20040609") found"* -- Have a nice day JBest

2 1

Re: [basex-talk] Bugreport: org.basex.server.ClientQuery.cache(ClientQuery.java:81)
by Bodo Hüsemann 13 Mar '13

13 Mar '13

Hi all, I apologize for the german post on this english mailinglist...So here we go in english: I have recently migrated my BaseX application from version 7.2 to 7.6 (and 7.6.1 Beta). The BaseX lib throws exceptions while running concurrent XQuery queries and updates (based on a threadpool), see the exceptions attached below (the specific numeric error-code changes slightly but the error occurs every time on the same line of code). The error itself seems to happen unter heavy concurrency (sequential queries have no problem) and not every time query executes. The application code is as follows (class de.infabswissarmy.control.XMLDBManagerBaseX.query): public ArrayList<String> query(String inQuery, String[][] inArgs){ ClientSession mySession = null; ClientQuery myQuery = null; ArrayList<String> tmpString = new ArrayList<String>(); try { mySession = getClientSession(); myQuery = mySession.query(inQuery); // bind variable if (inArgs != null){ for (int i=0; i < inArgs.length; i++){ myQuery.bind("$" + inArgs[i][0], inArgs[i][1]); } } while (myQuery.more()){ // **exception is in this line ** tmpString.add(myQuery.next()); } } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { if (myQuery != null){ try { myQuery.close(); } catch (BaseXException e) { // ignore } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return tmpString; } To be complete this is the used helper function: private static ClientSession getClientSession() throws IOException { ClientSession mySession = new ClientSession("localhost", 1984, "admin", "admin"); return mySession; } Version 7.2 is running without problems. In version 7.6 I have seen some rare Java heap space errors at the same location, and once I even saw a massive growth of the DB > 1GB (normal size would be 1MB), but this may be another error and I cannot reproduce it. I will try to deliver a selfcontained min-example, but this could be quite an effort to do (it will take some time to produce it). So I hope that you might find the problem with the delivered information. Many thanks once again for this great XML-DB and thanks in advance for your help! Bodo -- attached error stack with version 7.6.1 (in 7.6 the error occurs in row 79 instead of 81) org.basex.core.BaseXException: -146032 at org.basex.server.ClientQuery.cache(ClientQuery.java:81) at org.basex.server.Query.more(Query.java:74) at de.infabswissarmy.control.XMLDBManagerBaseX.query(XMLDBManagerBaseX.java:86) at de.infabswissarmy.control.XMLDBManagerBaseX.queryDoc(XMLDBManagerBaseX.java: 121) at de.infabswissarmy.control.QueryTask.httpQuery(QueryTask.java:180) at de.infabswissarmy.control.QueryTask.run(QueryTask.java:271) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.basex.core.BaseXException: 0 at org.basex.server.ClientQuery.cache(ClientQuery.java:81) at org.basex.server.Query.more(Query.java:74) at de.infabswissarmy.control.XMLDBManagerBaseX.query(XMLDBManagerBaseX.java:86) at de.infabswissarmy.control.XMLDBManagerBaseX.queryDoc(XMLDBManagerBaseX.java: 121) at de.infabswissarmy.control.QueryTask.httpQuery(QueryTask.java:180) at de.infabswissarmy.control.QueryTask.run(QueryTask.java:271) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.basex.core.BaseXException: java.lang.ArrayIndexOutOfBoundsException at org.basex.server.ClientQuery.cache(ClientQuery.java:81) at org.basex.server.Query.more(Query.java:74) at de.infabswissarmy.control.XMLDBManagerBaseX.query(XMLDBManagerBaseX.java:86) at de.infabswissarmy.control.XMLDBManagerBaseX.queryDoc(XMLDBManagerBaseX.java: 121) at de.infabswissarmy.control.QueryTask.httpQuery(QueryTask.java:180) at de.infabswissarmy.control.QueryTask.run(QueryTask.java:271) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

2 4

index usage while processing large xml file(s)
by EV Narasimham 13 Mar '13

13 Mar '13

Hi, I'm currently processing a 3GB xml file. Below is the Query that is being executed and the corresponding output count(db:open("ASEPXML", "A_SEPXML")/descendant::*:PmtInf[15]/*:CdtTrfTxInf/*:CdtrAgt/*:FinInstnId/*:BIC/text()) Output: 100000 The total time taken to evaluate the query is 210 secs. Below is the query plan. Compiling: - pre-evaluating db:open("ASEPXML", "A_SEPXML") Optimized Query: fn:count(document-node { "A_SEPXML" }/descendant::*:PmtInf[15]/*:CdtTrfTxInf/*:CdtrAgt/*:FinInstnId/*:BIC/text()) Result: - Hit(s): 1 Item - Updated: 0 Items - Printed: 6 Bytes - Locking: local [ASEPXML] Timing: - Parsing: 0.0 ms - Compiling: 0.28 ms - Evaluating: 210818.96 ms - Printing: 0.08 ms - Total Time: 210819.34 ms Query plan: <QueryPlan> <FNAggr name="count(item)"> <CachedPath> <DBNode name="ASEPXML" pre="0"/> <IterPosStep axis="descendant" test="*:PmtInf"> <Pos min="15" max="15"/> </IterPosStep> <IterStep axis="child" test="*:CdtTrfTxInf"/> <IterStep axis="child" test="*:CdtrAgt"/> <IterStep axis="child" test="*:FinInstnId"/> <IterStep axis="child" test="*:BIC"/> <IterStep axis="child" test="text()"/> </CachedPath> </FNAggr> </QueryPlan> The database ASEPXML has text index created. The structure of the xml is as follows: <root> <PmtInf> <CdtTrfTxInf> <CdtrAgt> <FinInstnId> <BIC>XXXXXX1A</BIC> </FinInstnId> </CdtrAgt> </CdtTrfTxInf> <CdtTrfTxInf> <CdtrAgt> <FinInstnId> <BIC>XXXXXX2A</BIC> </FinInstnId> </CdtrAgt> </CdtTrfTxInf> <CdtTrfTxInf> <CdtrAgt> <FinInstnId> <BIC>XXXXXX3A</BIC> </FinInstnId> </CdtrAgt> </CdtTrfTxInf> <CdtTrfTxInf> ... repeating node (100000) </PmtInf> <PmtInf> </PmtInf> ... repeating node (40) </root> Are there possibilities of reducing the response times and how do I detect if an index is being used or not ? Regards Nesh

3 2

Make-Up Brushes
by sales32＠injoybeauty.NET 12 Mar '13

12 Mar '13

Dear Madam/Sir, My company MANUFACTURE different kinds of MAKEUP BRUSHES. Please see the products in the attached IMAGE. Simply REPLY if any questions or requests. B.R Mr. Woo

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk