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

Addendum to last post
by NewIntellectual 24 Jul '10

24 Jul '10

The code I posted accidentally omitted a critical step - add a 'return result;' as the last statement in the doQuery method.

1 0

working with XML databases (BaseX) in Java
by Godmar Back 23 Jul '10

23 Jul '10

Hi, I'd like to follow up for the benefit of the list on this comment by Christian: > As mentioned, our DOM interfaces haven't been tested very much, but > your focus on DOM and XQJ might inspire other users to play around > with this interface as well, and give us more feedback. Could people share their approaches to working with XML in Java? My (apparently outdated) knowledge is that only two approaches are in wide use: those that use an in-memory representation of an XML document (or fragment) - e.g., either XOM, org.w3c.'s DOM, JDOM, etc. or approaches that use a stream-based approach (SAX). Naively, I would have expected that XML databases such as BaseX would provide excellent support for at least one of the widely used DOM interfaces. (In fact, Christian made an earlier comment that BaseX uses an "optimized" (albeit incomplete) implementation of org.w3c.'s DOM classes.) Are there other existing approaches besides DOM that would allow me to retrieve and update XML documents, and represent portions of them in memory? - Godmar

1 0

Re: [basex-talk] How to start BaseX server windows from the command line?
by Andreas Weiler 16 Jul '10

16 Jul '10

Hi Nigel, > 2. Is there a way I can close the command prompt window but leave BaseX > server running as a process in the background? there is no option in windows like the nohup option in linux which puts the commands in background. So you have to create a service with the basex startup on your machine and start this. Another way is to start it like this: start /B java -cp basex.jar org.basex.BaseXServer this will let you get back to the command line (with enter). But when you close the console the server is closed too. Another way is to install cygwin (http://www.cygwin.com/) and run it like on a linux machine: nohup java -cp basex.jar org.basex.BaseXServer & Kind regards, Andreas Nigel Alderton schrieb: > Thanks very much. That worked. > > But unfortunately it doesn't return to the command line prompt, and if I > manually close the command window, the BaseX server stops. > > 1. Is this behaviour intentional? > 2. Is there a way I can close the command prompt window but leave BaseX > server running as a process in the background? > > Thanks again. Sorry to bother you with such newbie questions! > > Nigel > > -----Original Message----- > From: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de] > Sent: 16 July 2010 11:48 > To: Nigel Alderton > Cc: basex-talk > Subject: Re: [basex-talk] How to start BaseX server windows from the command > line? > > Dear Nigel, > > yes you need to download the basex.jar file. > Then you have to execute: java -cp BaseX61.jar org.basex.BaseXServer > > See for more information: http://www.inf.uni-konstanz.de/dbis/basex/server > > I hope this helps. > > Kind regards, > Andreas > > Nigel Alderton schrieb: > >> Thanks Andreas, I tried that but an error appeared: >> >> C:\Program Files\BaseX>java -cp basex.jar org.basex.BaseXServer >> Exception in thread "main" java.lang.NoClassDefFoundError: >> org/basex/BaseXServer >> Caused by: java.lang.ClassNotFoundException: org.basex.BaseXServer >> at java.net.URLClassLoader$1.run(Unknown Source) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(Unknown Source) >> at java.lang.ClassLoader.loadClass(Unknown Source) >> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) >> at java.lang.ClassLoader.loadClass(Unknown Source) >> Could not find the main class: org.basex.BaseXServer. Program will exit. >> >> I only have one file: BaseX.exe in c:\program files\BaseX. Do I need to >> download basex.jar to get the standalone server version of BaseX? >> >> Is there any online documentation regarding configuring an running BaseX >> > on > >> windows? >> >> Nigel >> >> -----Original Message----- >> From: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de] >> Sent: 16 July 2010 11:32 >> To: Nigel Alderton >> Cc: basex-talk(a)mailman.uni-konstanz.de >> Subject: Re: [basex-talk] How to start BaseX server windows from the >> > command > >> line? >> >> Dear Nigel, >> >> just start it with: java -cp basex.jar org.basex.BaseXServer >> >> Kind regards, >> Andreas >> >> Nigel Alderton schrieb: >> >> >>> Hi, >>> >>> How can I start the windows version of the BaseX server from the >>> command line ie. **without** using the client user interface File - >>> Server Administration - Start? >>> >>> I want to configure BaseX server to start when my PC starts? Can this >>> be done, if so how? >>> >>> I have BaseX Version 6.1. >>> >>> Thanks, >>> >>> Nigel >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>> >>> >>> >> >> > >

1 0

Re: [basex-talk] How to start BaseX server windows from the command line?
by Andreas Weiler 16 Jul '10

16 Jul '10

Dear Nigel, yes you need to download the basex.jar file. Then you have to execute: java -cp BaseX61.jar org.basex.BaseXServer See for more information: http://www.inf.uni-konstanz.de/dbis/basex/server I hope this helps. Kind regards, Andreas Nigel Alderton schrieb: > Thanks Andreas, I tried that but an error appeared: > > C:\Program Files\BaseX>java -cp basex.jar org.basex.BaseXServer > Exception in thread "main" java.lang.NoClassDefFoundError: > org/basex/BaseXServer > Caused by: java.lang.ClassNotFoundException: org.basex.BaseXServer > at java.net.URLClassLoader$1.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(Unknown Source) > at java.lang.ClassLoader.loadClass(Unknown Source) > at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) > at java.lang.ClassLoader.loadClass(Unknown Source) > Could not find the main class: org.basex.BaseXServer. Program will exit. > > I only have one file: BaseX.exe in c:\program files\BaseX. Do I need to > download basex.jar to get the standalone server version of BaseX? > > Is there any online documentation regarding configuring an running BaseX on > windows? > > Nigel > > -----Original Message----- > From: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de] > Sent: 16 July 2010 11:32 > To: Nigel Alderton > Cc: basex-talk(a)mailman.uni-konstanz.de > Subject: Re: [basex-talk] How to start BaseX server windows from the command > line? > > Dear Nigel, > > just start it with: java -cp basex.jar org.basex.BaseXServer > > Kind regards, > Andreas > > Nigel Alderton schrieb: > >> Hi, >> >> How can I start the windows version of the BaseX server from the >> command line ie. **without** using the client user interface File - >> Server Administration - Start? >> >> I want to configure BaseX server to start when my PC starts? Can this >> be done, if so how? >> >> I have BaseX Version 6.1. >> >> Thanks, >> >> Nigel >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk(a)mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >> >> > >

1 0

Re: [basex-talk] How to start BaseX server windows from the command line?
by Andreas Weiler 16 Jul '10

16 Jul '10

Dear Nigel, just start it with: java -cp basex.jar org.basex.BaseXServer Kind regards, Andreas Nigel Alderton schrieb: > > Hi, > > How can I start the windows version of the BaseX server from the > command line ie. **without** using the client user interface File – > Server Administration – Start? > > I want to configure BaseX server to start when my PC starts? Can this > be done, if so how? > > I have BaseX Version 6.1. > > Thanks, > > Nigel > > ------------------------------------------------------------------------ > > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk(a)mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

1 0

How to start BaseX server windows from the command line?
by Nigel Alderton 16 Jul '10

16 Jul '10

Hi, How can I start the windows version of the BaseX server from the command line ie. *without* using the client user interface File - Server Administration - Start? I want to configure BaseX server to start when my PC starts? Can this be done, if so how? I have BaseX Version 6.1. Thanks, Nigel

1 0

Results scoring/ranking
by Maciej 15 Jul '10

15 Jul '10

Hello, I have a collection of XML documents formated with respected to a pre-defined stable schema (WSDLs---Web service definitions). I need to execute (from PHP) search over XML documents. I wonder whether xBase: (1) scores relevance of whole matching XML documents and ranks them (in any way) ? (2) allows to identify (in matching document) XML elements with matched query terms and than navigate to parental/children nodes in XML structure ? (3) provides a way to give more weight to some XML element types during relevance scoring ? Best regards, Maciej

2 1

Results ranking
by mgawinecki＠gmail.com 15 Jul '10

15 Jul '10

I have a collection of XML documents formated with respected to a pre-defined stable schema (WSDLs---Web service definitions). I need to execute (from PHP) search over XML documents. I wonder whether xBase: (1) scores relevance of whole matching XML documents and ranks them (in any way) ? (2) allows to identify (in matching document) XML elements with matched query terms and than navigating to parental/children nodes in XML structure ? (3) provides a way to give more weight to some XML element types during relevance scoring ? Best regards, Maciej

1 0

Feature Request
by Andy Chambers 14 Jul '10

14 Jul '10

Hi Christian, A while ago, you were soliciting feature requests so here's mine :-) It would be nice if there was some way to perform XSLT transforms on the results of a query. I'd be happy to implement this if you gave me a few pointers about where you think it would fit in the best. My guess would be to make a XSLT filter and attach it to the OutputStream that is passed to Proc.exec. I'm not sure about how to decide when to apply which stylesheets so I'm open to suggestions here. From a user point of view, I think it would be nice to have a "style" parameter on the REST interface that allows one to specify a stylesheet. Cheers, Andy

2 3

Re: [basex-talk] Using "define function ...."
by Christian Grün 13 Jul '10

13 Jul '10

Hi Johanna, it looks as if your quoted example from the »XQuery Kick Start« books is XQuery-only, ignoring other languages such as PHP, so (I guess?) it's quite comparable to the example I proposed below. The only difference is the XQuery syntax, which has changed in the final W3 Recommendation: Old: define function func() { ... }; Final: declare function local:func() { ... }; Regarding the mix of PHP and XQuery, unfortunately, you won't be able to "import" any XQuery functions. Instead, you'll have to decide which world world you prefer – currently, they are just too different to go hand in hand. Does this come closer to your initial question? Christian On Tue, Jul 13, 2010 at 5:24 PM, Johanna Vompras <johanna.vompras(a)uni-bielefeld.de> wrote: > Hi Christian, > > thanks for the quick answer and the example! Yes, Xquery seems to have > many advantages. Although this example do not 100% match what i have in > mind. My intention is first to query the XML Database and transfer the > results to a function (in the above example FUNCTION) > This function should then dynamically be invoked on the results. > > $cmd = 'for $node in doc("factbook")//country return FUNCTION($node)'; > > But where can I define this function withhin my .php file ... > Is there a possibility to say "import FUNCTIONSFILE.xquery" ???? > Maybe I understand something wrong ... > > I have also found this example, it is nearly that what I have in mind > (but I didn't get it to run!) > > http://www.informit.com/articles/article.aspx?p=101764&seqNum=11 > > In principle, I want to apply external functions on my xquery results. > > Hope it does not sount very confusing ... > > Thanks for helping > > Johanna. > > > > Am 13.07.2010 16:59, schrieb Christian Grün: >> Hi Johanna, >> >> your questions are welcome – I'm just forwarding them back to the >> mailing-list, as they might be interesting for others as well. >> >> The most elegant way to use XML is actually to build the larger >> snippets in XQuery (although our php table example points to another >> direction…). In the beginning, this might sound tedious, but it's >> worth the time; XQuery is pretty simple, compared to e.g. XSLT, and, >> yet, very manifold and powerful enough to construct very complex >> XML/HTML snippets. The BaseX GUI Editor might help you to get to know >> the language (you'll immediately see the query results after each key >> click if you choose "Options->Realtime Execution"). >> >> XQuery is often called an »Information Processing Language«, which >> means that it allows much more than other query languages, such as >> SQL. >> >> The following snippet shows you how to construct an HTML table via XQuery: >> >> (: Beginning of Query :) >> <table border='0'> >> <tr> >> <th>Name</th> >> <th>Population</th> >> </tr> >> { >> for $country at $p in //country >> let $color := if($p mod 2) then '#eeeeee' else '#ffffff' >> return >> <tr style="background-color:{ $color };"> >> <td>{ data($country/name) }</td> >> <td>{ data($country/@population) }</td> >> </tr> >> } >> </table> >> (: End of Query :) >> >> Note that your XQuery results will always be well-formed, which isn't >> the case for PHP. Said this, it is even more elegant to construct >> complete HTML documents in XQuery – but this will surely render the >> source files more unreadable for non-XQuery-folks. >> >> Feel free to ask for more, >> Christian >> >> ___________________________ >> >> On Tue, Jul 13, 2010 at 4:34 PM, Johanna Vompras >> <johanna.vompras(a)uni-bielefeld.de> wrote: >>> Hi Christian, >>> >>> Thank you! >>> I have just tried it out (throught the BaseX-Api) and it works. My Question >>> now is, how to link this a functionality into a .php file, e.g. the >>> TableExample.php which can be downloaded from >>> https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/php/ . >>> It looks like: >>> >>> include("BaseXClient.php"); >>> >>> // commands to be performed >>> $cmd = 'for $node in doc("factbook")//country order by >>> xs:int($node/@population) return data($node/@name)'; >>> $cmd2 = 'for $node in doc("factbook")//country order by >>> xs:int($node/@population) return data($node/@population)'; >>> >>> try { >>> // create session >>> $session = new Session("localhost", 1984, "admin", "admin"); >>> >>> echo "<table border='0' cellspacing='2' cellpadding='4' width='20%'> >>> <tbody><tr style='text-align:center;'><tbody><tr >>> style='text-align:center;'>"; >>> echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff >>> 1px solid;font-size:12pt;'></td>"; >>> echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff >>> 1px solid;font-size:12pt;'>Country</td>"; >>> echo "<td style='text-align:center;background-color:#D7D7D7;border:#ffffff >>> 1px solid;font-size:12pt;'>Population</td>"; >>> try { >>> $query = $session->query($cmd); >>> $query2 = $session->query($cmd2); >>> $count = 0; >>> while($query->more()) { >>> >>> ............ etc ... >>> >>> Where schould I define a such user-defined function, so I can allready use >>> it in the xquery statement? In the $cmd variable before the xquery >>> expression? It is not an elegant way .... Is there a possibility to include >>> some XQuery functions from en external file, by saying: "include ...." ??? >>> >>> Sorry for so much questions!! >>> >>> Thanks! >>> >>> Johanna. >>> >>> >>> >>> Am 13.07.2010 16:24, schrieb Christian Grün: >>>> >>>> Johanna, >>>> >>>> specifying nodes as arguments is straight-forward in XQuery; this >>>> expression might do what you want: >>>> >>>> declare function local:createTable($n as node()) as node()* { >>>> for $c in $n/* >>>> return<result/> >>>> }; >>>> for $node in doc("database")//node >>>> return local:createTable($node) >>>> >>>> >>>> Hope this helps, >>>> Christian >>>> >>>> >>>> >>>> On Tue, Jul 13, 2010 at 3:02 PM,<johanna.vompras(a)uni-bielefeld.de> wrote: >>>> >>>>> >>>>> Hi, I am relatively new to baseX and XQuery and just trying the >>>>> funcionalities of BaseX. I have got some questions on the possibility of >>>>> defining user-defined functions, which take a node (or a node set) as >>>>> parameters and process them subsequently (e.g. format the results as an html >>>>> table, or another numerical computations etc.). >>>>> >>>>> This might look like this: >>>>> >>>>> define function createTable($n as node) >>>>> { >>>>> for $c in $n/* return<some html-output>; >>>>> } >>>>> >>>>> and I would like to use the defined function "createTable" in a xquery >>>>> expression. For example : >>>>> >>>>> for $questionscheme in doc("database")//d:QuestionScheme return >>>>> createTable($questionscheme/node()) >>>>> >>>>> That means I need to pass a whole node (not the query results as string), >>>>> in order to process the node with further xquery expressions. Is this >>>>> compatible with BaseX? And where should I define such functions? Defining a >>>>> function through the XQuery-API does not work. The functions in class Query >>>>> in the BaseXClient.php seem to only support a successive query processing >>>>> (one result tuple after another). Or have I overseen something? If not, can >>>>> this class be quickly modified to support this? >>>>> >>>>> Many thanks for your help on this! >>>>> >>>>> >>>>> _______________________________________________ >>>>> BaseX-Talk mailing list >>>>> BaseX-Talk(a)mailman.uni-konstanz.de >>>>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>>>> >>>>> >>> >>> > > -- > Dr. Johanna Vompras > Universität Bielefeld - Universitätsbibliothek > Universitätsstr. 25, Office A2-136 > 33615 Bielefeld > > Fon +49 (0) 521/106-2644 > Fax +49 (0) 521/106-4052 > Skype johanna.vompras >

1 0