[Monetdb-developers] Get xquery timing, Error when running examples, etc
Hi,
I just started to use MonetDB. My PC is Windows XP. I installed the MonetDB-XQuery-0.10.2.msi and few weeks later after the newer version come out, I uninstalled from Control Panel & install 0.12.0.
I have several questions:
1. How to run the query from the command prompt and get the timing? Currently, everytime I want to run the query, I have to start XQuery Server (start - all programs - monetdb xquery - XQuery Server). After that I save the xquery into .xq file, then run it by right click - open with MPFClient. I've tried the following in XQuery Server but it gives me error:
MonetDB>MapiClient -T -lx test.xq; !ERROR: "MapiClient -T -lx test.xq;" ! ^ ! can't help you here, sorry. MonetDB>
2. I tried to run the example in the website, books1.xq and books2.xq and slashdot.xq. In the files, the xml file is from internet. But when I run the files, the following error message come out:
ERROR: No such file or directoryI/O warning : failed to load external entity "http://monetdb.cwi.nl/XQuery/files/bib.xml" ERROR: shred:mainSHREDDER: xmlCreateURLParserCtxt(" http://monetdb.cwi.nl/XQuery/files/bib.xml") failed ERROR: CMDshred2bats: operation failed. ERROR: interpret_params: +(param 2): evaluation error.
Is it connection problem? How to modify the connection settings so that I can download data from internet?
3. voc2.xq and voc5.xq give the following error:
type error: [err:XPTY0004] Orderspec requires at most one atomic item (given: string*).
4. Where is the shredded document being stored? Is it in the place where I install the program or in My Documents? Because before I uninstall 0.10.2, I shredded some documents, and after I uninstall then install 0.12.0, the shredded xml documents are still there.
Thanks,
Klarinda
On Thu, Jul 06, 2006 at 05:29:31PM +0800, kla gw wrote:
Hi Klarinda,
thanks for your interest in MonetDB/XQuery. Though I am only used to the Unix version of MonetDB/XQuery, I will try to give my best to answer your request.
- How to run the query from the command prompt and get the timing?
Currently, everytime I want to run the query, I have to start XQuery Server (start - all programs - monetdb xquery - XQuery Server). After that I save the xquery into .xq file, then run it by right click - open with MPFClient. I've tried the following in XQuery Server but it gives me error:
MonetDB>MapiClient -T -lx test.xq; !ERROR: "MapiClient -T -lx test.xq;" ! ^ ! can't help you here, sorry. MonetDB>
Issue this command from the Windows command line, *not* from within the MonetDB server. You may have to call MapiClient with a fully qualified path (`C:\some\long\path\MapiClient').
- I tried to run the example in the website, books1.xq and books2.xq
and slashdot.xq. In the files, the xml file is from internet. But when I run the files, the following error message come out:
ERROR: No such file or directoryI/O warning : failed to load external entity "http://monetdb.cwi.nl/XQuery/files/bib.xml" ERROR: shred:mainSHREDDER: xmlCreateURLParserCtxt(" http://monetdb.cwi.nl/XQuery/files/bib.xml") failed ERROR: CMDshred2bats: operation failed. ERROR: interpret_params: +(param 2): evaluation error.
Is it connection problem? How to modify the connection settings so that I can download data from internet?
(This may be OS dependent, so no guarantees for my answer.)
This looks to me like a connection problem. What you could do is download the respective XML files to your harddisk, then replace the URL strings in the query files with `file:// ...'.
Actually, we're relying here on the HTTP implementation of a third-party library (the libxml2 library, http://www.xmlsoft.org/). Unfortunately, I don't know the details on how this library tries to access the network and what you have to do to get network access running.
- voc2.xq and voc5.xq give the following error:
type error: [err:XPTY0004] Orderspec requires at most one atomic item (given: string*).
Apparently we have an erroneous example on the net, sorry about that. We'll fix that soon. The error message is actually correct, the query is wrong.
- Where is the shredded document being stored? Is it in the place
where I install the program or in My Documents? Because before I uninstall 0.10.2, I shredded some documents, and after I uninstall then install 0.12.0, the shredded xml documents are still there.
(again OS specific)
I think the database is held in the installation directory of MonetDB. Look out for a directory that is called `dbfarm'. The structure below it contains the MonetDB database.
Just let us know if you experience any more problems.
Jens
On 2006-07-06 11:29, kla gw wrote:
Hi,
I just started to use MonetDB. My PC is Windows XP. I installed the MonetDB-XQuery-0.10.2.msi and few weeks later after the newer version come out, I uninstalled from Control Panel & install 0.12.0.
I have several questions:
- How to run the query from the command prompt and get the
timing? Currently, everytime I want to run the query, I have to start XQuery Server (start - all programs - monetdb xquery - XQuery Server). After that I save the xquery into .xq file, then run it by right click - open with MPFClient. I've tried the following in XQuery Server but it gives me error:
MonetDB>MapiClient -T -lx test.xq; !ERROR: "MapiClient -T -lx test.xq;" ! ^ ! can't help you here, sorry. MonetDB>
Take a look at the BAT script MPFclient.bat in the installation folder (normally C:\Program Files\CWI\MonetDB-XQuery). Towards the end there is a call to MapiClient.exe. You can add a -T option there, however that would mess up the XML file that is generated and given to Internet Explorer. So a better solution might be to copy the script (but leave it in the same folder) and modify it to save the output of the MapiClient.exe command into a file which you should not open (the bit starting with the && on the MapiClient line) or throw away like is done in the script.
- I tried to run the example in the website, books1.xq and books2.xq
and slashdot.xq. In the files, the xml file is from internet. But when I run the files, the following error message come out:
ERROR: No such file or directoryI/O warning : failed to load external entity "http://monetdb.cwi.nl/XQuery/files/bib.xml" ERROR: shred:mainSHREDDER: xmlCreateURLParserCtxt(" http://monetdb.cwi.nl/XQuery/files/bib.xml") failed ERROR: CMDshred2bats: operation failed. ERROR: interpret_params: +(param 2): evaluation error.
Is it connection problem? How to modify the connection settings so that I can download data from internet?
Try loading the xml file in your web browser. If that doesn't succeed either, it's a connection problem.
- voc2.xq and voc5.xq give the following error:
type error: [err:XPTY0004] Orderspec requires at most one atomic item (given: string*).
I don't know what the issue is here. Somebody else should comment.
- Where is the shredded document being stored? Is it in the place where
I install the program or in My Documents? Because before I uninstall 0.10.2, I shredded some documents, and after I uninstall then install 0.12.0 , the shredded xml documents are still there.
The database is stored in %APPDATA%\MonetDB (normally C:\Documents and Settings<user name>\Application Data\MonetDB) and is not removed on uninstall. See the Mserver.bat script.
- voc2.xq and voc5.xq give the following error:
type error: [err:XPTY0004] Orderspec requires at most one atomic item (given: string*).
I don't know what the issue is here. Somebody else should comment.
The queries on the web have unfortunately not yet been updated to match the latest typing requirements of MonetDB/XQuery. Sorry for the inconvenience, and thanks for notifying us!
The correct queries are: ======== voc2.xq: for $t in doc("voc.xml")//voyage[leftpage/boatname="ZEELANDIA"] let $l := $t/leftpage order by zero-or-one($l/departure) (: ^^^^^^^^^^^^ ^ :) return { $l/departure/text(), text { ", " }, $l/harbour/text() } ======== voc5.xq: for $t in doc("voc.xml")//voyage let $p := zero-or-one($t/rightpage/particulars/text()) where not($t//destination/arrival) and (contains($p,"wrecked") or contains($p,"sunk")) order by zero-or-one($t/leftpage/boatname/text()) (: ^^^^^^^^^^^^ ^ :) return element { "boat" } { element { "name" } { $t/leftpage/boatname/text() }, text { ": " }, element { "description" } { $t/rightpage/particulars/text() } } ========
We will update the website as soon as possible.
Stefan
Hi, thanks for answering my questions :)
On 7/6/06, Sjoerd Mullender sjoerd@acm.org wrote:
On 2006-07-06 11:29, kla gw wrote:
- How to run the query from the command prompt and get the
timing? Currently, everytime I want to run the query, I have to start XQuery Server (start - all programs - monetdb xquery - XQuery Server). After that I save the xquery into .xq file, then run it by right click - open with MPFClient. I've tried the following in XQuery Server but it gives me error:
MonetDB>MapiClient -T -lx test.xq; !ERROR: "MapiClient -T -lx test.xq;" ! ^ ! can't help you here, sorry. MonetDB>
Take a look at the BAT script MPFclient.bat in the installation folder (normally C:\Program Files\CWI\MonetDB-XQuery). Towards the end there is a call to MapiClient.exe. You can add a -T option there, however that would mess up the XML file that is generated and given to Internet Explorer. So a better solution might be to copy the script (but leave it in the same folder) and modify it to save the output of the MapiClient.exe command into a file which you should not open (the bit starting with the && on the MapiClient line) or throw away like is done in the script.
I have tried to copy the script and add a -T option. Below is a portion of the modified MPFClient.bat:
rem start the real client set XMLFILE=%TEMP%\MonetDB-XQuery-%RANDOM%.xml "%MONETDB%\bin\MapiClient.exe -T" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" -lxquery -sxml %* > "%XMLFILE%" && "%XMLFILE%"
but when I run the .xq file (right click, open with MPFClientModified.bat), there is no result.
My question is: How do you save the output into the file, instead of opening it in IE?
Btw I tried the solution given by Jens (to run from command prompt), and it works :)
- I tried to run the example in the website, books1.xq and books2.xq
and slashdot.xq. In the files, the xml file is from internet. But when I run the files, the following error message come out:
ERROR: No such file or directoryI/O warning : failed to load external entity "http://monetdb.cwi.nl/XQuery/files/bib.xml" ERROR: shred:mainSHREDDER: xmlCreateURLParserCtxt(" http://monetdb.cwi.nl/XQuery/files/bib.xml") failed ERROR: CMDshred2bats: operation failed. ERROR: interpret_params: +(param 2): evaluation error.
Is it connection problem? How to modify the connection settings so that I can download data from internet?
Try loading the xml file in your web browser. If that doesn't succeed either, it's a connection problem.
I still have this problem, so I guess it's connection problem.
- Where is the shredded document being stored? Is it in the place where
I install the program or in My Documents? Because before I uninstall 0.10.2, I shredded some documents, and after I uninstall then install 0.12.0 , the shredded xml documents are still there.
The database is stored in %APPDATA%\MonetDB (normally C:\Documents and Settings<user name>\Application Data\MonetDB) and is not removed on uninstall. See the Mserver.bat script.
How does the xml being shredded? I see there are lots of .buns, .desc, .theap files. Is there any documentation on the shredding detail?
And I'm also interested to create a GUI / interface for XQuery and connect it to MonetDB/XQuery. Please give me some idea of where/how to start. Is it possible to use Java for the GUI?
Regards,
Klarinda
On 2006-07-17 16:49, kla gw wrote:
Hi, thanks for answering my questions :)
On 7/6/06, Sjoerd Mullender sjoerd@acm.org wrote:
On 2006-07-06 11:29, kla gw wrote:
- How to run the query from the command prompt and get the
timing? Currently, everytime I want to run the query, I have to start XQuery Server (start - all programs - monetdb xquery - XQuery Server). After that I save the xquery into .xq file, then run it by right click - open with MPFClient. I've tried the following in XQuery Server but it gives me error:
MonetDB>MapiClient -T -lx test.xq; !ERROR: "MapiClient -T -lx test.xq;" ! ^ ! can't help you here, sorry. MonetDB>
Take a look at the BAT script MPFclient.bat in the installation folder (normally C:\Program Files\CWI\MonetDB-XQuery). Towards the end there is a call to MapiClient.exe. You can add a -T option there, however that would mess up the XML file that is generated and given to Internet Explorer. So a better solution might be to copy the script (but leave it in the same folder) and modify it to save the output of the MapiClient.exe command into a file which you should not open (the bit starting with the && on the MapiClient line) or throw away like is done in the script.
I have tried to copy the script and add a -T option. Below is a portion of the modified MPFClient.bat:
rem start the real client set XMLFILE=%TEMP%\MonetDB-XQuery-%RANDOM%.xml "%MONETDB%\bin\MapiClient.exe -T" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" -lxquery -sxml %* > "%XMLFILE%" && "%XMLFILE%"
That should be: "%MONETDB%\bin\MapiClient.exe" -T Notice the placement of the quotes.
but when I run the .xq file (right click, open with MPFClientModified.bat), there is no result.
My question is: How do you save the output into the file, instead of opening it in IE?
Btw I tried the solution given by Jens (to run from command prompt), and it works :)
- I tried to run the example in the website, books1.xq and books2.xq
and slashdot.xq. In the files, the xml file is from internet. But when I run the files, the following error message come out:
ERROR: No such file or directoryI/O warning : failed to load external entity "http://monetdb.cwi.nl/XQuery/files/bib.xml" ERROR: shred:mainSHREDDER: xmlCreateURLParserCtxt(" http://monetdb.cwi.nl/XQuery/files/bib.xml") failed ERROR: CMDshred2bats: operation failed. ERROR: interpret_params: +(param 2): evaluation error.
Is it connection problem? How to modify the connection settings so that I can download data from internet?
Try loading the xml file in your web browser. If that doesn't succeed either, it's a connection problem.
I still have this problem, so I guess it's connection problem.
- Where is the shredded document being stored? Is it in the place where
I install the program or in My Documents? Because before I uninstall 0.10.2, I shredded some documents, and after I uninstall then install 0.12.0 , the shredded xml documents are still there.
The database is stored in %APPDATA%\MonetDB (normally C:\Documents and Settings<user name>\Application Data\MonetDB) and is not removed on uninstall. See the Mserver.bat script.
How does the xml being shredded? I see there are lots of .buns, .desc, .theap files. Is there any documentation on the shredding detail?
And I'm also interested to create a GUI / interface for XQuery and connect it to MonetDB/XQuery. Please give me some idea of where/how to start. Is it possible to use Java for the GUI?
Regards,
Klarinda
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 17-07-2006 22:49:42 +0800, kla gw wrote: [snip parts I cannot answer]
And I'm also interested to create a GUI / interface for XQuery and connect it to MonetDB/XQuery. Please give me some idea of where/how to start. Is it possible to use Java for the GUI?
Yes, via JDBC or XML:DB you can easily query MonetDB/XQuery. For more information on this, see here: http://monetdb.cwi.nl/TechDocs/APIs/JDBC/node8.html or http://monetdb.cwi.nl/TechDocs/APIs/JDBC/node9.html
participants (5)
-
Fabian Groffen -
Jens Teubner -
kla gw -
Sjoerd Mullender -
Stefan Manegold