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:
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>
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.
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?
Try loading the xml file in your web browser. If that doesn't succeed either, it's a connection problem.
3. 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.
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.
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. -- Sjoerd Mullender