FYI, I'm using the DBD::monetdb test suite to test the
MonetDB ODBC Driver:
set DBI_DSN=dbi:ODBC:driver=MonetDB ODBC Driver
dmake test
Here is the test summary:
Failed Test Stat Wstat Total Fail Failed List of Failed
---------------------------------------------------------
t\02cxn.t 5 1280 8 4 50.00% 7-8
t\12bind.t 1 256 6 1 16.67% 3
t\13count.t 16 4096 30 16 53.33% 12-27
t\23null.t 255 65280 14 22 157.14% 4-14
1 test and 2 subtests skipped.
Failed 4/22 test scripts, 81.82% okay. 30/382 subtests failed, 92.15% okay.
In light of all the additional layers, this is an
unexpected good result. (Admittedly, my tests are
not very aggressive.)
And, even better, all is on the mend:
t\02cxn.t
This is a bug in DBD::ODBC:
<http://www.xray.mpe.mpg.de/mailing-lists/dbi/2005-02/msg00061.html>
fixed in svn:
<http://svn.perl.org/viewcvs/modules/dbd-odbc/trunk/dbdimp.c?rev=858&r1=561&…>
t\12bind.t
This is bug #1229018:
<http://sourceforge.net/tracker/index.php?func=detail&aid=1229018&group_id=5…>
t\13count.t
This is a bug in DBD::ODBC.
It looks like DBD::ODBC doesn't expect that an
ODBC driver is able to return the number of rows
of a result set.
t\23null.t
This is bug #1225455:
<http://sourceforge.net/tracker/index.php?func=detail&aid=1225455&group_id=5…>
Steffen
I don"t know whether MonetDB.conf in CWI\MonetDB\etc is used, but it
contains the following lines:
# Where MonetDB is installed
prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT
exec_prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT
Roger
Hi,
I had some problems installing MonetDB-4.8.0 on MS Windows XP:
the Duesseldorf sourceforge mirror still serves the installer that
misses the pqueue stuff. Removing the wrong version via the Add or
Remove Programs left a filled folder CWI in the Program Files folder and
also a filled folder in my home folder's Application Data folder called
MonetDB. Only after removing these and using the installer from the
Paris sourceforge mirror I was freed from a lot of strange messages.
All in all, the installer should have its version number upped, I think.
Hopefully this will lead to up-to-date mirrors. Also, the installer
should notify the user of the old files and folders, giving the choice
of backing those up, or overwrite them, or whatever seems best.
=====================================================================
Choosing MonetDB SQL Server and MonetDB SQL Client from the Start Menu:
# Monet Database Server V4.8.0
# Copyright (c) 1993-2005, CWI. All rights reserved.
# Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked.
# Visit http://monetdb.cwi.nl/ for further information.
MonetDB>
copying from the documentation->Front ends->SQL web page
(http://monetdb.cwi.nl/TechDocs/FrontEnds/SQL/index.html):
CREATE USER "voc" WITH PASSWORD 'voc' NAME 'VOC Explorer' SCHEMA "sys";
results in a dialog window, containing:
Mserver.exe has encountered a problem and needs to close. We are sorry
for the inconvenience.
AppName: mserver.exe AppVer: 0.0.0.0 ModName:
lib_sql_server.dll
ModVer: 0.0.0.0 Offset: 00057cfa
If you need to have more info, I'll be happy to try to get it for you...
=======================================================================
I don't know whether MonetDB.conf in CWI\MonetDB\etc is used, but it
contains the following lines:
# Where MonetDB is installed
prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT
exec_prefix=C:\Documents and Settings\sjoerd\My Documents\src\MonetDB\NT
which is not right on my system, of course.
========================================================================
=
Met vriendelijke groet,
Roger Erens
Euroned Systems
0900-3876633
r.erens(a)eurosys.nl
Ignacio Hernandez-Ros wrote:
> Hello,
>
> I'll try to send a patch.
>
> This is what happens when the query is executed in MapiClient.
>
> [ihr@jo-con-el FRTA2]$ cat > test.xq
> <hello>hola</hello>
> [ihr@jo-con-el FRTA2]$ MapiClient -lxquery test.xq
> <hello>hola</hello>
> [ihr@jo-con-el FRTA2]$
>
> And this is what happens when the query is executed in MapiClient using mil
> language.
>
> [ihr@jo-con-el FRTA2]$ MapiClient -lmil
> # Monet Database Server V4.9.0
> # Copyright (c) 1993-2005, CWI. All rights reserved.
> # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs; dynamically linked.
> # Visit http://monetdb.cwi.nl/ for further information.
> mil>xquery("xml","<hello>hola</hello>");
> <?xml version="1.0" encoding="utf-8"?>
> <XQueryResult>
> <hello>hola</hello>
> </XQueryResult>
> mil>
>
> The result of an xquery is not a table with rows and columns. Is another
> piece of XML that I don't know how to get it back into the PHP code.
As far as I know, this should be represented as one column. Maybe it
isn't. Sjoerd will know the answer. Perhaps it works better for you in
this case if you use the xquery language, instead of mil from your PHP
script. Again, I think Sjoerd knows for sure how the response is given
shape.
>
> What you sent me didn't work. Thank you for your support. Are there more
> alternatives?
>
> Regards,
> IHR
>
> Ignacio Hernandez-Ros
> XBRL International Inc. - Technology Development
> ihr(a)xbrl.org
> Cell: +34 609027754
Ignacio Hernandez-Ros wrote:
> Hello,
>
> I've successfully moved the source to work with PHP5. The only change that I
> made was to replace occurrences of OnUpdateInt to OnUpdateLong (two
> occurrences)
Can you supply a patch easily? Would be great to have it.
>
> Now I'm in the next problem:
>
> I wish to execute an xquery and receive the XML output back in the php.
> This is the example that I'm doing:
>
> <?php
> if (!extension_loaded('monetdb')) {
> $loadedOk = dl('monetdb.so');
> if (!loadedOk) {
> die('Module not loaded');
> }
> }
> $link = monetdb_connect('mil');
> if (!$link) {
> die('Could not connect: ' . monetdb_error());
> }
> $res = monetdb_query('xquery("xml","<hello>hola</hello>");');
> echo $res;
>
> while($row = monetdb_fetch_row($res)) {
> printf("name=%s htype=%s ttype=%s \n",$row[0],$row[1],$row[2]);
> }
I'm not sure here, but you can try:
$cols = monetdb_num_fields($result);
while ($row = @monetdb_fetch_row($res)) {
for ($i = 0; $i < $cols; $i++) {
print htmlspecialchars($row[$i]);
}
print "<br />";
}
have you tried the query you're executing using MapiClient to see if it
results in what you expect? You might need to connect using xquery
otherwise, but I'm not sure on that.
Regards,
Fabian
> monetdb_close();
> ?>
>
> The query is executed but I don't find a way to obtain the xml back to the
> php.
>
> What shall I do?
>
> Ignacio Hernandez-Ros
> XBRL International Inc. - Technology Development
> ihr(a)xbrl.org
> Cell: +34 609027754
>
Ignacio Hernandez-Ros wrote:
> Does the developers list works?
Yes. I just sent a test mail and it arrived promptly.
>> I tried to compile MonetDB with php 5.0.4 and I get compilation errors.
We have only tried compiling agains PHP version 4 so far. Is it
possible for you to use PHP 4?
>> I wish to use MonetDB to execute xquery against XBRL taxonomies. You
>> can see www.xbrl.org <http://www.xbrl.org/> if you wish.
>>
>>
>>
>> In file included from ../../../../common/monet_utils.h:5,
>>
>> from ../../../../common/stream.h:17,
>>
>> from ../../C/Mapi.h:6,
>>
>> from
>> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:52:
>>
>> ../../../../../monetdb_config.h:637:1: warning: "_POSIX_C_SOURCE"
>> redefined
This doesn look quite right, but my guess is that it doesn't matter too
much. For what it's worth, I get this also.
>> In file included from
>> /usr/lib/gcc-lib/i686-pc-linux-gnu/3.2.2/include/stdio.h:37,
>>
>> from /usr/include/php/Zend/zend.h:37,
>>
>> from /usr/include/php/main/php.h:34,
>>
>> from
>> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:44:
>>
>> /usr/include/features.h:131:1: warning: this is the location of the
>> previous definition
>>
>> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:109:
>> warning: missing initializer
>>
>> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:109:
>> warning: (near initialization for `monetdb_functions[22].num_args')
>>
>> ../../../../../../src/mapi/clients/php/Cimpl/php_monetdb.c:178:
>> `OnUpdateInt' undeclared here (not in a function)
This is the real error. In PHP 4, OnUpdateInt is declared in
Zend/zend_ini.h, in the same block which also declares OnUpdateString.
Note that in your output there is no indication that OnUpdateString is
not defined.
zend_ini.h is include by php_ini.h which is included by php_monetdb.c.
--
Sjoerd Mullender
There is a problem with the MonetDB and Pathfinder licenses.
- The new (1.1) license is not yet available on the main web site;
- On the staging web site (stem), the license is available with the
wrong URL: .../Legal/MonetDBLicense-1.1/index.html instead of
.../Legal/MonetDBLicense-1.1.html.
I don't know whether the Development that is also stuck into the stem
URL is a problem (that depends on how the URLs get translated when this
moves to the real web site), but the ending is certainly a problem. The
URL must end with MonetDBLicense-1.1.html and not
MonetDBLicense-1.1/index.html.
And the same for the Pathfinder license.
--
Sjoerd Mullender
I tried to install the binary (.msi) on XP professional.
After installation and trying to start the server I get a message
Monet Database Server V4.8.0
!ERROR: module/Client: module(pqueue) load error
!ERROR: mvc_init: unable to create system tables
!WARNING: BBPincref: range error 178
Any idea.
Met vriendelijke groet
Harry van Lamoen
KORÈN Information Technology
http://www.koren.nl
Hello,
I am PhD student at EPFL, Switzerland, and I am working on database
replication. I just started looking at MonetDB and I have a simple
doubt. Are modules like the SQL module written in MIL or in C/C++?
I downloaded the sources of the SQL front end and I found some files
whose extension is ".mx" and which seem to implement the SQL translator
into MIL. The code looks pretty much like C++.
Moreover, I read somewhere in your web page that two-phase-locking is
implemented outside the database kernel. Where exactly is it implemented
for the SQL front end?
Thank you very much in advance!
Best regards,
Rodrigo Schmidt