November 2007 - users-list

[MonetDB-users] Using DataSource class within MonetDB -- connection error -- cause? fix?
by jsolderitsch 16 Nov '07

16 Nov '07

I got lots of good help with my last query. I am trying to access a MonetDB through Sun's Glassfish app server. I am following an example that uses the Java Persistence API and Netbeans 6.0 beta 2 that has some interesting automation to generate code, in particular for configuration file generation that define the jndi context. But my example doesn't work. My code is based on a tutorial I found that uses Derby which is built into Glassfish. I see the errors: TopLink, version: Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007)) Server: unknown RAR5038:Unexpected exception while creating resource RAR5117 : Failed to obtain/create connection from connection pool [ jdbc_monetdb_localhost_demoPool ]. Reason : Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused] Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused Error Code: 0 Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused I looked at the class MonetDataSource in the JDBC jar file and I see that the constructor for MonetDataSource uses 45123 for the field portNumber. But there is no apparent way to set the portNumber to something else. How do I get MonetDB to listen on this port? It seems that the default port is 50000. Is there a conf setting I can make to get this to work? What is the difference between portNumber here and port value as checked for in the Driver class? Any help appreciated. Jim -- View this message in context: http://www.nabble.com/Using-DataSource-class-within-MonetDB----connection-e… Sent from the monetdb-users mailing list archive at Nabble.com.

3 7

[MonetDB-users] how to select a column named "column"?
by m h 15 Nov '07

15 Nov '07

Hi all, I'm trying to reflect tables (to create a sqlalchemy backend for monetdb). I need to reflect the tables to do that and need primary keys. This information is stored in keycolumns, yet I can't seem to get the column out by itself. sql>select * from keycolumns; +------+--------+------+---+ |id |column |trunc |nr | +======+========+======+===+ |4394 |vendnum | 0 | 0 | |4393 |vendnum | 0 | 0 | +------+--------+------+---+ Timer 1.750 msec 2 rows sql>select column from keycolumns; !syntax error, unexpected COLUMN in: "select column" Timer 0.163 msec 0 rows sql>select keycolumns.column from keycolumns; !syntax error, unexpected COLUMN in: "select keycolumns.column" Advice??? thanks matt

4 3

[MonetDB-users] how compile PHP interface on Linux
by Martin Minka 15 Nov '07

15 Nov '07

I am running CentOS 4.5 (RHEL4.5). I compiled PHP 5.2.2 from source. I compiled "MonetDB server v5.2.0, based on kernel v1.20.0" from source with monetdb-install.sh . MonetDB server works for me. I downloaded clients-1.20.0.tar.gz, unpacked in /tmp and runned: ./configure --prefix=/mytest/MonetDB --with-php --with-php-config=/mytest/php/bin --with-php-extensiondir=/mytest/php/lib/php/extensions I see only warning, that Buildtools are not installed and that I will not able to build from CVS, that should be fine, I am not using source code from CVS (right?). I run make and it seams to me, that the process is only building only mapiclient and mapilib. Output of make does not mention any problems but there is also no mentioning of PHP in this output. The output files are here http://www.struix.com/phpmonetdb.zip. I wonder, if somebody could help me out. Sincerely, Martin

2 4

[MonetDB-users] Using JDBC for MonetDB across the network
by jsolderitsch 13 Nov '07

13 Nov '07

I successfully installed Monet on Mac OS X (Tiger) and it works as expected. I can use JDBC from Aqua Data Studio or even Netbeans 6.0 beta 2 to access databases I create but my experiments so far are when these clients and the Monet DB are on the same Mac OS X host. Now I want to install Monet on a linux box on my network and access the DB via JDBC from my Mac. I installed Monet on the linux box (Cent OS). But access via JDBC from the Mac does not seem to be working. I seem to connect from the Mac via Aqua Data Studio, but I do not see the demo database. Instead I see a <DEFAULT> database listed with no schemas. I created a new user and and a schema for that user on Linux using the command line client and that seemed to work. But after disconnecting and re-connecting, I still don't see the database. Could I be doing something wrong? Jim -- View this message in context: http://www.nabble.com/Using-JDBC-for-MonetDB-across-the-network-tf4793137.h… Sent from the monetdb-users mailing list archive at Nabble.com.

3 24

[MonetDB-users] Compilation error in MonetDB4
by Ying Zhang 13 Nov '07

13 Nov '07

Hello, I get the following error when compiling the module MonetDB4: (dev branch, on andorea.ins.cwi.nl => fedora 6, MD Athlon(tm) 64 X2 Dual Core Processor 3800+) gcc -m64 -DHAVE_CONFIG_H -I. -I/ufs/zhang/monet/dev/MonetDB4/src/tools -I../.. -I/ufs/zhang/monet/dev/MonetDB4/src/tools -I../monet -I/ufs/zhang/monet/dev/MonetDB4/src/tools/../monet -I../modules/plain -I/ufs/zhang/monet/dev/MonetDB4/src/tools/../modules/plain -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/common -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/gdk -DLIBEMBEDDEDMIL -Wall -Wextra -std=c99 -g -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wp,-D_FORTIFY_SOURCE=2 -D_REENTRANT -c embeddedclient.c -fPIC -DPIC -o .libs/libembeddedmil_la-embeddedclient.o In file included from /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:69: embeddedclient.h:29:26: error: mapilib/Mapi.h: No such file or directory In file included from /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:69: embeddedclient.h:31: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'embedded_mil' /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:183: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'embedded_mil' make[5]: *** [libembeddedmil_la-embeddedclient.lo] Error 1 make[5]: Leaving directory `/export/scratch1/zhang/mbuild/dev/MonetDB4/build-debug/src/tools' I think I have seen such error earlier, in de mailing-list or bug report, but I can't recall it. I believe both my source code and build env. are up-to-date and clean, but this error still looks as if I have some out-dated stuf. Does anybody have a clue about this? Thanks! Jennie

2 2

[MonetDB-users] R: Re: mclient fails to connect to local database server: "No route to host"
by marco.antonelli82＠fastwebnet.it 12 Nov '07

12 Nov '07

>Can you check the merovingian.log file to see if it actually sees a >client connecting, or maybe give another hint why things go wrong? > These lines appear in /usr/local/var/log/merovingian.log when I try to connect with mclient: MSG merovingian[8124]: database 'demo' already running since 2007-11-12 14:24: 35, up min/avg/max: 2/769/4851, crash average: 0.00 0.00 0.00 (10-9=0) MSG merovingian[8124]: redirecting client for database 'demo' to mapi:monetdb: //hp:50001/ The fact is that my host is reffered as "hp" (my machine name) and as "localhost". On my /etc/hosts file "hp" is an alias for 192.168.1.1 and not for 127.0.0.1, and beacuse of this mclient is blocked by my firewall. I changed my /etc/hosts file and now it works, but how to make MonetDB listen on "localhost" instead of "hp"? There is no option for that in /usr/local/etc/monetdb5.conf I find this error message as well when I start the "demo" db: ERR demo[8181]: #warning: please don't forget to set your vault key! ERR demo[8181]: #(see /usr/local/etc/monetdb5.conf) What is this about? Thanks for help Fabian!

2 1

[MonetDB-users] mclient fails to connect to local database server: "No route to host"
by marco.antonelli82＠fastwebnet.it 12 Nov '07

12 Nov '07

Hello everyone, I successfully managed to install MonetDB components(MonetDB-common, MonetDB clients, MonetDB5-server, MonetDB_SQL) on Linux, but I have some problems in running it. These are the steps that I followed from the online documentation: I started merovingian with: sudo merovingian then I created the "demo" database and started it with: sudo monetdb create demo sudo monetdb start demo I checked the status: sudo monetdb status demo name state uptime crashes demo running 29m 6s 0 (if I run this command without 'sudo' i get: monetdb status demo warning: MonetDB Database Server is not running name state uptime crashes demo stopped 1 2007-11-12 12:33:41 Is that normal?) So everything seems fine, but when I run mclient (both as root and normal user) I got an error: mclient -lsql --database=demo !ERROR mapi_reconnect: connect: No route to host Setup connection failed I even tried to add a kernel route with: sudo route add -host localhost lo but it did not help. Does somebody know what is the problem and how to solve it? Best regards, Marco Antonelli

2 1

[MonetDB-users] XQuery: Schema import, Indexing
by Silvio Kohler 09 Nov '07

09 Nov '07

Hi, we're trying to benchmark different XML-DBs, one of them is MonetDB/Xquery. Two questions came up: 1) How is schema import done in MonetDB/XQuery? Does it affect execution time for queries? We imported it in the XML file and also in the query, but did not have any effect on execution time. Also, a lot of schema items such as <xs:enumeration> or <xs:dateTime> seem not to be supported. 2) Is indexing possible? Regards, Silvio

4 4

[MonetDB-users] Is there a blocking connect to server
by Pranav Vaidya 08 Nov '07

08 Nov '07

Hello, Is there a client API in Monet which implements a blocking connect to the Mserver (possibly with a time out). My understanding of mapi_connect is that it is a non-blocking connect. I would appreciate it if someone could kindly direct me in this regard. My thanks in advance. Pranav. -- View this message in context: http://www.nabble.com/Is-there-a-blocking-connect-to-server-tf4768425.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] XQuery: Schema import, Indexing
by Silvio Kohler 06 Nov '07

06 Nov '07

Hi, we're trying to benchmark different XML-DBs, one of them is MonetDB/Xquery. Two questions came up: 1) How is schema import done in MonetDB/XQuery? Does it affect execution time for queries? We imported it in the XML file and also in the query, but did not have any effect on execution time. Also, a lot of schema items such as <xs:enumeration> or <xs:dateTime> seem not to be supported. 2) Is indexing possible? Regards, Silvio

1 0