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

Re: [basex-talk] Displaying transformed XML into JEditorPane
by Anand Chiney (AIR) 11 Jul '12

11 Jul '12

Dear Christian, Yes there is SIMPLE GENERAL answer to the question asked by Sandeep. :-) Actually we are storing thousands of resumes in BaseX. These are stored as a single XML document with following format. <Resumes> <Resume>No 1</Resume> <Resume>No 2</Resume> <Resume>No </Resume> <Resume>No 4</Resume> <Resume></Resume> <Resumes> There are various child elements for <Resume>, which I think is not essential for this generalized answer. Till now I had explained about the Data. Now coming to front-end. We are using Swing based application to search and view these resumes. We want to display the resumes one-by-one in JEditorPane. For this we first transformed the XML to HTML using a XSLT. The BaseX editor can do this using XSLT Module. Christian, do you remember that, earlier there were 3 examples on this and we faced trouble using them. You then corrected these and it helped us a lot, But these were to work with BaseX editor. We need to perform this transformation using Java. Yesterday, Sandeep asked the question on this. We did found a good solution in these 2 examples, here https://github.com/BaseXdb/basex/blob/master/src/test/java/org/basex/test/qu ery/func/FNXsltTest.java https://github.com/BaseXdb/basex/blob/master/src/test/java/org/basex/test/qu ery/AdvancedQueryTest.java But this was not exactly what we were looking for. We need to modify this as per our requirement. And we did it :-) I am not going into deep to explain how we did and why due to less time. Rather I would simply paste the method which worked for us. ----------------------------- Method from the above Example (FNXsltTest.java )------------------------------------------------------------ @Test public void xsltTransform() { check(_XSLT_TRANSFORM); final String doc = "<a/>"; String style = wrap("<xsl:template match='/'><X/></xsl:template>"); query(_XSLT_TRANSFORM.args(doc, style), "<X/>"); query(_XSLT_TRANSFORM.args(doc, '"' + style + '"'), "<X/>"); style = wrap("<xsl:param name='t'/><xsl:template match='/'>" + "<X><xsl:value-of select='$t'/></X></xsl:template>"); final String param = "<xslt:parameters><xslt:t>1</xslt:t></xslt:parameters>"; query(_XSLT_TRANSFORM.args(doc, style, param), "<X>1</X>"); } ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------- ----------------------------- Our Method ------------------------------------------------------------ public String xsltTransform() { return query(_XSLT_TRANSFORM.args(getDoc(), getStyleSheet())); } Explanation- getDoc() will send the query which will retrieve the required Resumes based on user search getStyleSheet() for resume.xslt let $in := /Resumes/Resume[WorkExpr/Java > "5"] let $style := doc('resume.xslt') return (xslt:transform($in, $style)) ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------- ----------------------------- Method from the above Example (AdvancedQueryTest.java)------------------------------------------------- protected static String query(final String query) { final QueryProcessor qp = new QueryProcessor(query, CONTEXT); qp.ctx.sc.baseURI("."); try { return qp.execute().toString(); } catch (QueryException ex) { Logger.getLogger(DBTransform.class.getName()).log(Level.SEVERE, null, ex); return ex.getMessage(); } } We used this method as it is rather copy and paste Other methods after certain R&D, we found not useful in our case (!!) ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------- So wrote a class with these 2 methods (for transformation) and other methods which were useful and it did work. But with a little trouble. This piece of code is NOT PRESERVING THE SPACES which we are giving through our stylesheet. Now for this either you can help us or we need to find a way out of it. Thanks for your kind and timely help. And we will trouble you more in future ;) Regards Anand Chiney _____ From: Sandeep Yohans [mailto:sandeepy.air@gmail.com] Sent: Wednesday, July 11, 2012 4:24 PM To: Anand Chiney Subject: Fwd: [basex-talk] Displaying transformed XML into JEditorPane ---------- Forwarded message ---------- From: Christian Grün <christian.gruen(a)gmail.com> Date: Wed, Jul 11, 2012 at 4:09 PM Subject: Re: [basex-talk] Displaying transformed XML into JEditorPane To: Sandeep Yohans <sandeepy.air(a)gmail.com> Cc: basex-talk(a)mailman.uni-konstanz.de Dear Sandeep, there is no simple general answer to your question, so I'd be glad to if you could prepare a little example [1] that demonstrates the problem. It often takes some time to generate a good and minimized example, but it's often helpful for other readers, too. Thanks in advance (and sorry for all the wise instructions ;), Christian [1] http://mindprod.com/jgloss/sscce.html _____________________________ On Tue, Jul 10, 2012 at 6:31 AM, Sandeep Yohans <sandeepy.air(a)gmail.com> wrote: > Hello, > > Below is the code to transform XML file to HTML. When tried with BaseX > working fine. > > > > let $in := /Resumes/Resume[WorkExpr/Java > "5"] > > let $style := doc('resume.xslt') > > return (xslt:transform($in, $style)) > > > > The aobve XSLT file will tramsform the output to HTML. > > Now I want to display this HTML output in JEditorPane. > > > > > -- > Thanks and Regards > > Sandeep Yohans > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > -- Thanks and Regards Sandeep Yohans Software Developer Systems - AIR Infotech Nagpur - India www.airinfotech.in <http://www.airinfotech.in/> Mobile: +91-997-086-5520

2 1

Fwd: Displaying transformed XML into JEditorPane
by Dirk Kirsten 11 Jul '12

11 Jul '12

By mistake I answered privately to Sandeep, so for the sake of documentation here is my answer as well on the mailing list. ---------- Forwarded message ---------- From: Dirk Kirsten <dk(a)basex.org> Date: Wed, Jul 11, 2012 at 8:45 AM Subject: Re: [basex-talk] Displaying transformed XML into JEditorPane To: Sandeep Yohans <sandeepy.air(a)gmail.com> Dear Sandeep, I don't see how your question relates to BaseX? If the transformation is working fine and you have well-formed HTML output, then the rest is up to the application. Seems like you want to do some Swing-programming; displaying HTML in JEditorPane should work out-of-the-box, but please have a look at the Java-API, e.g.: http://docs.oracle.com/javase/7/docs/api/javax/swing/JEditorPane.html Cheers, Dirk On Tue, Jul 10, 2012 at 6:31 AM, Sandeep Yohans <sandeepy.air(a)gmail.com>wrote: > Hello, > > Below is the code to transform XML file to HTML. When tried with BaseX > working fine. > > > > let $in := /Resumes/Resume[WorkExpr/Java > "5"] > > let $style := doc('resume.xslt') > > return (xslt:transform($in, $style)) > > > > *The aobve XSLT file will tramsform the output to HTML.* > > *Now I want to display this HTML output in JEditorPane.* > > * * > ** > -- > Thanks and Regards > > Sandeep Yohans > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > >

1 0

Displaying transformed XML into JEditorPane
by Sandeep Yohans 11 Jul '12

11 Jul '12

Hello, Below is the code to transform XML file to HTML. When tried with BaseX working fine. let $in := /Resumes/Resume[WorkExpr/Java > "5"] let $style := doc('resume.xslt') return (xslt:transform($in, $style)) *The aobve XSLT file will tramsform the output to HTML.* *Now I want to display this HTML output in JEditorPane.* * * ** -- Thanks and Regards Sandeep Yohans

2 1

usability issue in GUI
by Godmar Back 10 Jul '12

10 Jul '12

Hi, is it possible to connect the GUI to an existing server? If not, I think it really should be, rather than requiring than the GUI start the server. - Godmar

2 3

improve BaseX error message
by Godmar Back 10 Jul '12

10 Jul '12

It should be "outdated" or "out-of-date", not "out-of-dated". Looks like moving to 7.3 is a bigger effort than thought... - Godmar java.io.IOException: Protocol for query iteration is out-of-dated. at org.libx.support.basex.BaseXSessionSupport$Query.exec(BaseXSessionSupport.java:324) at org.libx.support.basex.BaseXSessionSupport$Query.more(BaseXSessionSupport.java:270) at org.libx.support.basex.BaseXSession$1.next(BaseXSession.java:104) at org.libx.support.basex.XMLDatabaseClient$1.after(XMLDatabaseClient.java:53) at org.libx.support.basex.BaseXSession.runQuery(BaseXSession.java:100) at org.libx.support.basex.XMLDatabaseClient.runQuery(XMLDatabaseClient.java:40) at org.libx.support.basex.XMLDatabaseClient.runQueryAsString(XMLDatabaseClient.java:95) at org.libx.support.basex.XMLDatabaseOperation$2.run(XMLDatabaseOperation.java:65) at org.libx.support.basex.XMLDatabaseOperation$2.run(XMLDatabaseOperation.java:62) at org.libx.support.basex.XMLDatabaseOperation.execute(XMLDatabaseOperation.java:46) at org.libx.support.basex.XMLDatabaseOperation.runQueryAsString(XMLDatabaseOperation.java:62)

2 2

problem using BaseX GUI
by Godmar Back 10 Jul '12

10 Jul '12

I'm using the most recent BaseX GUI; I'm trying to change the value of an attribute in an XML document. This results in the following exception: java.lang.ArrayIndexOutOfBoundsException: -1 org.basex.util.list.IntList.get(IntList.java:65) org.basex.gui.view.info.InfoView.setInfo(InfoView.java:173) org.basex.gui.GUI.exec(GUI.java:402) org.basex.gui.GUI$6.run(GUI.java:343) (see attached screenshot). I can't provide a reproducible test case; my second attempt to change the attribute value succeeded, see log below, but perhaps this backtrace helps the developers fix this issue. - Godmar // log of successful execution upon second attempt Query: replace value of node db:open-pre("feed_libx_dot_editions_at_gmail_dot_com_core", 827) with "161" Compiling: - pre-evaluating db:open-pre("feed_libx_dot_editions_at_gmail_dot_com_core", 827) Result: replace value of node attribute src { " libx.editions(a)gmail.com/core/161" } with "161" Timing: - Parsing: 0.66 ms - Compiling: 0.22 ms - Evaluating: 3.29 ms - Printing: 0.06 ms - Total Time: 4.25 ms Result: - Hit(s): 0 Items - Updated: 1 Item - Printed: 0 Bytes Query plan: <QueryPlan> <Replace> <DBNode name="feed_libx_dot_editions_at_gmail_dot_com_core" pre="827"/> <Str value="161" type="xs:string"/> </Replace> </QueryPlan>

2 1

Replication with BaseX
by Usama Dar 10 Jul '12

10 Jul '12

Hi Guys, I am new to BaseX and i am going to use it to store 500K XML documents which will be edited, Queried and stuff. I have already built the main application. I have need to be able to run BaseX in a high availability environment. For that i will initially have two servers and i plan to use rsync on baseX data directory to replicate data. My question basically is are there any recommended strategies to do this? is using rsync going to do the job? i can copy files over in the data directory in a running instance? or the other server should be shutdown while i copy files? any tool/ strategy you might know of? Thanks for your help Usama Dar.

1 0

Performance of Add command
by Manuel Bernhardt 09 Jul '12

09 Jul '12

Hi, I'm doing some testing before migration one of our customers to a new version of our platform that uses BaseX in order to store documents. They have approx. 4M documents, and I'm running an import operation on a 1 M document collection on my laptop. The way I'm inserting documents is by firing off one Add command per document, based on a stream of the document, at a different (unique) path for each document, and flushing every at 10K Adds. Since most CPU usage (for one of the cores, the other ones being untouched) is taken by the BaseX server, I fired up YourKit out of curiosity to see where the CPU time was spent. My machine is a 2*4 core MacBook Pro with 8GB of RAM and SSD, so I think hardware-wise it should do pretty fine. YourKit shows that what seems to use up most time is the Namespaces.update method: Thread-12 [RUNNABLE] CPU time: 2h 7m 9s org.basex.data.Namespaces.update(NSNode, int, int, boolean, Set) org.basex.data.Namespaces.update(int, int, boolean, Set) org.basex.data.Data.insert(int, int, Data) org.basex.core.cmd.Add.run() org.basex.core.Command.run(Context, OutputStream) org.basex.core.Command.exec(Context, OutputStream) org.basex.core.Command.execute(Context, OutputStream) org.basex.core.Command.execute(Context) org.basex.server.ClientListener.execute(Command) org.basex.server.ClientListener.add() org.basex.server.ClientListener.run() I'm not really sure what that method does - it's a recursive function and seems to be triggered by Data.insert: // NSNodes have to be checked for pre value shifts after insert nspaces.update(ipre, dsize, true, newNodes); The whole set of records should have no more than 5 different namespaces in total. Thus I'm wondering if there would perhaps be some potential for optimization here? Note that I'm completely ignorant as to what the method does and what its exact purpose is. Thanks, Manuel PS: the import is now finished: Storing 1001712 records into BaseX took 9285008 ms

2 11

Incorrect use of timezone Z instead of implicit timezone
by Gunther Rademacher 09 Jul '12

09 Jul '12

As explained in http://www.w3.org/TR/xquery-operators/#func-subtract-dates the implicit timezone should be used for augmenting an xs:date without a timezone before subtracting it from one with a timezone. BaseX however appears to be using timezone Z in this case. The following xquery demonstrates this: current-date() - xs:date(substring(string(current-date()), 1, 10)) It should return a zero duration, but BaseX returns -PT2H I am in timezone +02:00. Best regards Gunther

2 1

FW: Problem with RunQueries.java example!!
by Anand Chiney (AIR) 09 Jul '12

09 Jul '12

Dear BaseX Team, The below code is working fine and I am getting the required output - for $x in doc('input.xml')//li return $x/text() i.e; ------------------------Output with XML File---------------- Example 1 Example 2 Example 3 ------------------------------------------------------------ But when I try the same with BaseX DB , I am not getting the required output ;-( for $x in doc('input')//li return $x/text() ------------------------Output with DB---------------------- Example 1Example 2Example 3 ------------------------------------------------------------ Now the first output can easily be populated in the Combo box, but what about the second..? The length of the output is not fixed in real application... I have attached the input.xml file. Regards, Anand Chiney -----Original Message----- From: Christian Grün [mailto:christian.gruen@gmail.com] Sent: Saturday, July 07, 2012 5:42 PM To: Anand Chiney (AIR); BaseX Subject: Re: Problem with RunQueries.java example!! Dear Anand, > Thanks for the reply. The serialize() did work. But what I was expecting > Is pure textual output and I am getting XML output. The output which I am > getting is - I strongly recommend you to spend some more time to get into XPath and XQuery, as those issues can all be realized fairly easily with the languages themselves. Some straightforward tutorials are e.g. found at [1,2]. Here are some examples (among many others) how you could rewrite your query to get the desired results: for $x in doc('input.xml')//li return $x/text() doc('input.xml')//li/text() doc('input.xml')//li/string() doc('input.xml')//li/data() You can also compose the whole combobox within XQuery. Your query could then look like <select>{ for $x in doc('input.xml')//li return <option>{ $x/text() }</option> }</select> or element select { doc('input.xml')//li ! element option { text() } } Hope this helps, Christian [1] http://www.w3schools.com/xpath [2] http://www.w3schools.com/xquery > > ----------------------------------------------------------- > * Convert each result to its Java representation: > Iterator > <li>Exercise 1</li> > <li>Exercise 2</li> > ----------------------------------------------------------- > > But I am expecting this is - > > Exercise 1 > Exercise 2 > > Actually I want to populate a JComboBox which is a part of my front-end. > So I thought that this piece of code, where it is said "Java > representation", would gimme the output as I required. > > Can you help me a little more..? > Which method will gimme the plain output, without the XML Tags...? So that > I can populate a JComboBox... !! > > > Regards, > Anand Chiney > > > -----Original Message----- > From: Christian Grün [mailto:christian.gruen@gmail.com] > Sent: Saturday, July 07, 2012 5:02 PM > To: Anand Chiney (AIR); BaseX > Subject: Re: Problem with RunQueries.java example!! > > Here's a second feedback (sorry for being distracted): Your query does > return standard Java DOM elements, the toString() method of which > returns "[li: null]". As you are probably interested in the string > representation of the elements, you'll need to replace "toJava()" with > "serialize()": > > System.out.println(item.serialize()); > > Hope this helps, > Christian > ___________________________ > > On Sat, Jul 7, 2012 at 1:26 PM, Christian Grün > <christian.gruen(a)gmail.com> wrote: >> Your query will yield the expected results if you remove the explicit >> cq.execute(); call. >> >> In the latest snapshot [1], an exception will be returned if the >> result has already been requested. >> >> Hope this helps, >> Christian >> >> [1] http://files.basex.org/releases/latest/ >> ___________________________ >> >>> Dear Christian >>> >>> Please find attached 2 files, MyRunQueries.java and input.xml >>> >>> The .java file is an edited version of RunQueries.java version and the >>> >>> I hope this would be sufficient for you to test. >>> >>> >>> >>> Regards >>> Anand chiney >>> >>> -----Original Message----- >>> From: Christian Grün [mailto:christian.gruen@gmail.com] >>> Sent: Saturday, July 07, 2012 4:34 PM >>> To: Sandeep Yohans >>> Cc: Anand Chiney; basex-talk(a)mailman.uni-konstanz.de >>> Subject: Re: Problem with RunQueries.java example!! >>> >>> One again I'm sorry Please send us a (small !) example that we can >>> try by ourselves. >>> >>> Thank you in advance, >>> Christian >>> ___________________________ >>> >>> On Sat, Jul 7, 2012 at 1:02 PM, Sandeep Yohans <sandeepy.air(a)gmail.com> >>> wrote: >>>> Hello Christian, >>>> >>>> We are extracting names from a very long list of names. The > item.toJava() >>>> method call in iterate(query) is returning null. >>>> example output: >>>> >>>> [li: null] >>>> >>>> Rest of the methods are printing output fine. >>>> >>>> >>>> -- >>>> Thanks and Regards >>>> >>>> Sandeep Yohans >>>> Software Developer >>>> Systems - AIR Infotech >>>> Nagpur - India >>>> www.airinfotech.in >>>> Mobile: +91-997-086-5520 >>>> >

2 1

BaseX with a Booleen Column
by Scott Clayton 09 Jul '12

09 Jul '12

Hey... I know this may be getting out of the native XML database talk but it would be great if we could add a column and mark as true or false when we grab the data from an external source and mark as gotten. Anyways...just a thought. Maybe there is a plugin for this or something to the effect? Best, Scott PS - I sent a similar email to the default contact at BaseX.org site and after I sent it there was a suggestion to send feature inquiries to this email... I could not find that suggextion until after I had already sent the email. :-)

2 1

BaseX client event protocol
by Andy Bunce 08 Jul '12

08 Jul '12

Hi, I am looking at adding WATCH and UNWATCH to my Node.js BaseX interface and I have a couple of questions before I start. 1) The documentation at http://docs.basex.org/wiki/Server_Protocol shows nothing in the Server Response column. This seems not to be the case. It looks like a standard BaseX protocol type response is to be expected? 2) The example at https://github.com/BaseXdb/basex-examples/blob/master/src/main/java/org/bas… session2 watching and then executing. Does the server protocol identify "event pushes" in some way. That is when I receive a message how can I tell if is a event or a command response? /Andy

2 3

Re: [basex-talk] Problem with RunQueries.java example!!
by Christian Grün 07 Jul '12

07 Jul '12

Dear Anand, > Thanks for the reply. The serialize() did work. But what I was expecting > Is pure textual output and I am getting XML output. The output which I am > getting is - I strongly recommend you to spend some more time to get into XPath and XQuery, as those issues can all be realized fairly easily with the languages themselves. Some straightforward tutorials are e.g. found at [1,2]. Here are some examples (among many others) how you could rewrite your query to get the desired results: for $x in doc('input.xml')//li return $x/text() doc('input.xml')//li/text() doc('input.xml')//li/string() doc('input.xml')//li/data() You can also compose the whole combobox within XQuery. Your query could then look like… <select>{ for $x in doc('input.xml')//li return <option>{ $x/text() }</option> }</select> …or… element select { doc('input.xml')//li ! element option { text() } } Hope this helps, Christian [1] http://www.w3schools.com/xpath [2] http://www.w3schools.com/xquery > > ----------------------------------------------------------- > * Convert each result to its Java representation: > Iterator > <li>Exercise 1</li> > <li>Exercise 2</li> > ----------------------------------------------------------- > > But I am expecting this is - > > Exercise 1 > Exercise 2 > > Actually I want to populate a JComboBox which is a part of my front-end. > So I thought that this piece of code, where it is said "Java > representation", would gimme the output as I required. > > Can you help me a little more..? > Which method will gimme the plain output, without the XML Tags...? So that > I can populate a JComboBox... !! > > > Regards, > Anand Chiney > > > -----Original Message----- > From: Christian Grün [mailto:christian.gruen@gmail.com] > Sent: Saturday, July 07, 2012 5:02 PM > To: Anand Chiney (AIR); BaseX > Subject: Re: Problem with RunQueries.java example!! > > Here's a second feedback (sorry for being distracted): Your query does > return standard Java DOM elements, the toString() method of which > returns "[li: null]". As you are probably interested in the string > representation of the elements, you'll need to replace "toJava()" with > "serialize()": > > System.out.println(item.serialize()); > > Hope this helps, > Christian > ___________________________ > > On Sat, Jul 7, 2012 at 1:26 PM, Christian Grün > <christian.gruen(a)gmail.com> wrote: >> Your query will yield the expected results if you remove the explicit >> cq.execute(); call. >> >> In the latest snapshot [1], an exception will be returned if the >> result has already been requested. >> >> Hope this helps, >> Christian >> >> [1] http://files.basex.org/releases/latest/ >> ___________________________ >> >>> Dear Christian >>> >>> Please find attached 2 files, MyRunQueries.java and input.xml >>> >>> The .java file is an edited version of RunQueries.java version and the >>> >>> I hope this would be sufficient for you to test. >>> >>> >>> >>> Regards >>> Anand chiney >>> >>> -----Original Message----- >>> From: Christian Grün [mailto:christian.gruen@gmail.com] >>> Sent: Saturday, July 07, 2012 4:34 PM >>> To: Sandeep Yohans >>> Cc: Anand Chiney; basex-talk(a)mailman.uni-konstanz.de >>> Subject: Re: Problem with RunQueries.java example!! >>> >>> One again I'm sorry… Please send us a (small !) example that we can >>> try by ourselves. >>> >>> Thank you in advance, >>> Christian >>> ___________________________ >>> >>> On Sat, Jul 7, 2012 at 1:02 PM, Sandeep Yohans <sandeepy.air(a)gmail.com> >>> wrote: >>>> Hello Christian, >>>> >>>> We are extracting names from a very long list of names. The > item.toJava() >>>> method call in iterate(query) is returning null. >>>> example output: >>>> >>>> [li: null] >>>> >>>> Rest of the methods are printing output fine. >>>> >>>> >>>> -- >>>> Thanks and Regards >>>> >>>> Sandeep Yohans >>>> Software Developer >>>> Systems - AIR Infotech >>>> Nagpur - India >>>> www.airinfotech.in >>>> Mobile: +91-997-086-5520 >>>> >

1 0

Re: [basex-talk] Problem with RunQueries.java example!!
by Christian Grün 07 Jul '12

07 Jul '12

Your query will yield the expected results if you remove the explicit cq.execute(); call. In the latest snapshot [1], an exception will be returned if the result has already been requested. Hope this helps, Christian [1] http://files.basex.org/releases/latest/ ___________________________ > Dear Christian > > Please find attached 2 files, MyRunQueries.java and input.xml > > The .java file is an edited version of RunQueries.java version and the > > I hope this would be sufficient for you to test. > > > > Regards > Anand chiney > > -----Original Message----- > From: Christian Grün [mailto:christian.gruen@gmail.com] > Sent: Saturday, July 07, 2012 4:34 PM > To: Sandeep Yohans > Cc: Anand Chiney; basex-talk(a)mailman.uni-konstanz.de > Subject: Re: Problem with RunQueries.java example!! > > One again I'm sorry… Please send us a (small !) example that we can > try by ourselves. > > Thank you in advance, > Christian > ___________________________ > > On Sat, Jul 7, 2012 at 1:02 PM, Sandeep Yohans <sandeepy.air(a)gmail.com> > wrote: >> Hello Christian, >> >> We are extracting names from a very long list of names. The item.toJava() >> method call in iterate(query) is returning null. >> example output: >> >> [li: null] >> >> Rest of the methods are printing output fine. >> >> >> -- >> Thanks and Regards >> >> Sandeep Yohans >> Software Developer >> Systems - AIR Infotech >> Nagpur - India >> www.airinfotech.in >> Mobile: +91-997-086-5520 >>

1 1

Re: [basex-talk] Problem with RunQueries.java example!!
by Sandeep Yohans 07 Jul '12

07 Jul '12

Hello Christian, We are extracting names from a very long list of names. The item.toJava() method call in iterate(query) is returning null. example output: [li: null] Rest of the methods are printing output fine. -- Thanks and Regards Sandeep Yohans Software Developer Systems - AIR Infotech Nagpur - India www.airinfotech.in Mobile: +91-997-086-5520

2 1

Problem with RunQueries.java example!!
by Anand Chiney (AIR) 07 Jul '12

07 Jul '12

Dear BaseX Team, The method iterate() which is used to convert the XML result to its Java representation is retuning [null]. I tried this code with the default query and also with 2-3 more XML files. All are giving same, [null] output..!! Have a nice day :) Regards Anand Chiney

2 1

Re: [basex-talk] Empty Initial Document Inconsistencies
by Dave Glick 07 Jul '12

07 Jul '12

Christian, Thanks again for this! I still haven't had a chance to do any rigorous testing, but in my initial use everything looks great (and all my unit tests still pass). I think more importantly, this resolves an undocumented inconsistency for users of the low-level API - with the guarantee that the database will behave the same way regardless of state, a lot of conditional code can now be removed. Proof that good things come to those who wait :). Dave -----Original message----- From: "Christian Grün" <christian.gruen(a)gmail.com> To: Dave Glick <dglick(a)dracorp.com> Cc: BaseX <basex-talk(a)mailman.uni-konstanz.de> Sent: Tue, Jul 3, 2012 00:13:58 GMT+00:00 Subject: Re: [basex-talk] Empty Initial Document Inconsistencies Hi Dave, here's finally some public feedback for your outstanding feature request: I've rewritten our internal database structures, such that an empty database will now really be empty (i.e., contain no dummy document node anymore). As a result, some convenience methods have disappeared from the Data class (Data.isEmpty(), Data.single()), as they were only offered to hide the former inconsistency. The changes have now been merged into the BaseX master branch. While I believe that we have tested the changes quite well, I am always glad for any feedback. Christian ___________________________ On Thu, Dec 29, 2011 at 4:36 PM, Dave Glick <dglick(a)dracorp.com> wrote: > Hello again, > > I've noticed some inconsistencies with regard to the initial document in an empty database. I understand that it is often treated as an indication that the database is "empty". I.e., if the database has only one node and it's a document at the first pre value, then Data.empty() returns true. The problem arises because the database isn't actually empty - it contains one empty document - and some commands/methods view it as an empty database while others treat it as a database with one empty document. Several examples: > > - The method Data.doc(name) will return -1 (indicating the document doesn't exist) while Data.docs() will return an array of size 1 with the first value a 0 (indicating there is one document at pre value 0). This is actually my own problem because the API I'm writing relies on these two methods being internally consistent - I can't have one telling me there is one document called "XYZ" but then have the other refuse to give me a pre value for the "XYZ" document I was just told exists. > - The GUI shows a single doc node in the tree view but issuing the command "list [database name]" shows the database as having no resources. > - I can evaluate the query "insert node 'text' into doc('[initial document name]')" and it executes. I can see the new text node under the initial document in the GUI tree view. Now when I issue the command "list [database name]" I see 1 resource. Having the list command report different numbers of resources before and after a XQuery insertion seems odd. > - If I issue the command "ADD TO newdoc <xyz/>", I can see the new doc("newdoc") node with the child <xyz> element in the GUI but the previously empty document is now gone. This also seems odd - I'm not sure how I feel about an ADD command removing data from the database (even if it was just intended to be a placeholder). > > In the end, I think BaseX should support the notion of a database with one empty document as being valid - there are probably cases where one might want to start their session in that state. I'm not sure what the solution is or should be (or if it's even something that is worth or needs solving). My own preference would be for the internal indication of an empty database to use a different node kind dedicated for that purpose so there is no confusion whether the single node at pre 0 is an empty initial document or an indication of an empty database. > > At the very least, I think the inconsistencies above should be corrected - if a single empty document node is intended to signify an empty database and is not actually intended to be part of the database, then you should not see it in the GUI, not be allowed to insert content to it, etc. > > Dave > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk

4 12

Performance regression from 7.2 to 7.3 ?
by Nicolas Labrot 07 Jul '12

07 Jul '12

Hello, I have upgraded BaseX from 7.2 to 7.3 but I have a severe performance drop on my query. My query is in 2 parts : - The first part extracts values from an xpath and store them in a map (the map contains 40000 entries) - The second part extracts values from an xpath and test if they are contains in the map (xpath return around 30000 entries). On 7.2 a typical query run on 2s and on 7.3 I have no result after 10 minutes Is there modification on BaseX 7.3 which can explain this performance drop ? Thanks for your help, Regards, Nicolas

2 6

Empty Initial Document Inconsistencies
by Dave Glick 05 Jul '12

05 Jul '12

Hello again, I've noticed some inconsistencies with regard to the initial document in an empty database. I understand that it is often treated as an indication that the database is "empty". I.e., if the database has only one node and it's a document at the first pre value, then Data.empty() returns true. The problem arises because the database isn't actually empty - it contains one empty document - and some commands/methods view it as an empty database while others treat it as a database with one empty document. Several examples: - The method Data.doc(name) will return -1 (indicating the document doesn't exist) while Data.docs() will return an array of size 1 with the first value a 0 (indicating there is one document at pre value 0). This is actually my own problem because the API I'm writing relies on these two methods being internally consistent - I can't have one telling me there is one document called "XYZ" but then have the other refuse to give me a pre value for the "XYZ" document I was just told exists. - The GUI shows a single doc node in the tree view but issuing the command "list [database name]" shows the database as having no resources. - I can evaluate the query "insert node 'text' into doc('[initial document name]')" and it executes. I can see the new text node under the initial document in the GUI tree view. Now when I issue the command "list [database name]" I see 1 resource. Having the list command report different numbers of resources before and after a XQuery insertion seems odd. - If I issue the command "ADD TO newdoc <xyz/>", I can see the new doc("newdoc") node with the child <xyz> element in the GUI but the previously empty document is now gone. This also seems odd - I'm not sure how I feel about an ADD command removing data from the database (even if it was just intended to be a placeholder). In the end, I think BaseX should support the notion of a database with one empty document as being valid - there are probably cases where one might want to start their session in that state. I'm not sure what the solution is or should be (or if it's even something that is worth or needs solving). My own preference would be for the internal indication of an empty database to use a different node kind dedicated for that purpose so there is no confusion whether the single node at pre 0 is an empty initial document or an indication of an empty database. At the very least, I think the inconsistencies above should be corrected - if a single empty document node is intended to signify an empty database and is not actually intended to be part of the database, then you should not see it in the GUI, not be allowed to insert content to it, etc. Dave

4 7

XML command syntax and options
by Andy Bunce 05 Jul '12

05 Jul '12

I am looking at the new 7.3 XML format commands and some things that are not clear to me in the documentation. My particular goal is to create a new database ensuring CHOP is off. There is a Rest syntax example that is exactly what I want at http://docs.basex.org/wiki/REST *<command xmlns="http://basex.org/rest">* * <text>create db test http://files.basex.org/xml/xmark.xml</text>* * <option name='chop' value='false'/>* *</command>* except I want to use the client module http://docs.basex.org/wiki/Client_Module. Can client:execute module use the XML syntax? And if so does the XML syntax <create-db name='...'> Have a way to specify options? Or should I use multiple commands starting with <set option='CHOP'>OFF</set> These links http://docs.basex.org/wiki/Commands#XML_Syntax http://docs.basex.org/wiki/Commands#CREATE_DB are not making it completely clear to me. /Andy

2 1

Chic Bridal Party Dresses
by mltailor.com 04 Jul '12

04 Jul '12

1 0

Radiant like a star
by mltailor.com 04 Jul '12

04 Jul '12

1 0

FW: Empty Initial Document Inconsistencies
by Fabrice Etanchaud 03 Jul '12

03 Jul '12

Dear all at BaseX, Dear Christian, Does that mean that current databases will not work anymore with the next releases ? Best regards, Fabrice -----Original Message----- From: Christian Grün [mailto:christian.gruen@gmail.com] Sent: mardi 3 juillet 2012 02:13 To: Dave Glick Cc: BaseX Subject: Re: [basex-talk] Empty Initial Document Inconsistencies Hi Dave, here's finally some public feedback for your outstanding feature request: I've rewritten our internal database structures, such that an empty database will now really be empty (i.e., contain no dummy document node anymore). As a result, some convenience methods have disappeared from the Data class (Data.isEmpty(), Data.single()), as they were only offered to hide the former inconsistency. The changes have now been merged into the BaseX master branch. While I believe that we have tested the changes quite well, I am always glad for any feedback. Christian ___________________________ On Thu, Dec 29, 2011 at 4:36 PM, Dave Glick <dglick(a)dracorp.com> wrote: > Hello again, > > I've noticed some inconsistencies with regard to the initial document in an empty database. I understand that it is often treated as an indication that the database is "empty". I.e., if the database has only one node and it's a document at the first pre value, then Data.empty() returns true. The problem arises because the database isn't actually empty - it contains one empty document - and some commands/methods view it as an empty database while others treat it as a database with one empty document. Several examples: > > - The method Data.doc(name) will return -1 (indicating the document doesn't exist) while Data.docs() will return an array of size 1 with the first value a 0 (indicating there is one document at pre value 0). This is actually my own problem because the API I'm writing relies on these two methods being internally consistent - I can't have one telling me there is one document called "XYZ" but then have the other refuse to give me a pre value for the "XYZ" document I was just told exists. > - The GUI shows a single doc node in the tree view but issuing the command "list [database name]" shows the database as having no resources. > - I can evaluate the query "insert node 'text' into doc('[initial document name]')" and it executes. I can see the new text node under the initial document in the GUI tree view. Now when I issue the command "list [database name]" I see 1 resource. Having the list command report different numbers of resources before and after a XQuery insertion seems odd. > - If I issue the command "ADD TO newdoc <xyz/>", I can see the new doc("newdoc") node with the child <xyz> element in the GUI but the previously empty document is now gone. This also seems odd - I'm not sure how I feel about an ADD command removing data from the database (even if it was just intended to be a placeholder). > > In the end, I think BaseX should support the notion of a database with one empty document as being valid - there are probably cases where one might want to start their session in that state. I'm not sure what the solution is or should be (or if it's even something that is worth or needs solving). My own preference would be for the internal indication of an empty database to use a different node kind dedicated for that purpose so there is no confusion whether the single node at pre 0 is an empty initial document or an indication of an empty database. > > At the very least, I think the inconsistencies above should be corrected - if a single empty document node is intended to signify an empty database and is not actually intended to be part of the database, then you should not see it in the GUI, not be allowed to insert content to it, etc. > > Dave > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk

2 1

REST service problems - 401-Header sent‏
by MyNew EMail 02 Jul '12

02 Jul '12

Hi again, > What do you exactly mean with "long XQuery request"? Could you provide > us with an example that demonstrates the problem (I didn't manage to > track it down locally)?I'm using PHP with cURL to call the REST service (with standard username and password [admin, admin] for testing). Furthermore I'm using the BaseX HTTP Server (basexhttp.bat).Here is some code summary (first example works well): <?php//... $query = 'let $x := <abc> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> </abc> return insert node $x as last into //test'; $fullQuery = '<query xmlns="http://basex.org/rest">'; $fullQuery .= '<text><![CDATA[ '.$query.']]></text>'; $fullQuery .= '</query>';//...//set authorization stuff//set Content-Type header to application/xml and send a POST request to http://localhost:8984/rest/MyDb/test.xml with $fullQuery in body.//This works. Example XML will be inserted.?> But if the XML part (let $x := ...) or the XQuery part is longer I get this response (and I'm authorized the same way as in the first example): HTTP/1.1 401 Unauthorized WWW-Authenticate: BasicContent-Length: 31 Server: Jetty(6.1.26) This example does'nt work:<?php $query = 'let $x := <abc> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <aaa>Test</aaa> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> <bb test="123"><a>test</a></bb> </abc> return insert node $x as last into //test'; $fullQuery = '<query xmlns="http://basex.org/rest">'; $fullQuery .= '<text><![CDATA[ '.$query.']]></text>'; $fullQuery .= '</query>'; //...?> Removing whitespaces makes it possible to send a request which is a bit longer, but not very much. Is there a solution to send requests like this, maybe in a different way? It is important to make bigger updates on my XML data with REST. Greetings @all

2 1

Sending DELETE request through HTTP Module
by Seenivasan Gunabalan 02 Jul '12

02 Jul '12

hi, My objective is to delete the collections/files through the DELETE request using HTTP module. The DELETE operation does fine, when I ran it from BasexGUI. But if i put the same query inside delete.xq and invoke it by http://localhost:8984/rest?run=delete.xq, The request never returns any response and possibly got hanged. I need to restart the database to make the database to function. I am enclosing the xq i used, import module namespace http='http://expath.org/ns/http-client'; declare function local:cleanlist() { ('sample/record1','sample/record2','sample/record3') }; declare function local:cleandb() { try { for $cl in local:cleanlist() return http:send-request(<http:request method="DELETE" href="http://localhost:8984/rest/{$cl}" status-only = "true" username = "admin" password = "admin" send-authorization="true"> </http:request>) } catch err { err:description } }; <cleandb>{ local:cleandb() }</cleandb>

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk