February 2008 - users-list

[MonetDB-users] Loading user-defined mal function on server start
by Michael 19 Feb '08

19 Feb '08

Hi, I'd like to place some MAL functions on the server and make them available asap the server starts. Placing a user.mal in the lib dir did not help. Placing in an existing file tells me that the appropriate module is not loaded and the datatypes I am using in are not available yet. Does that mean, that I have to place the functions when my app starts and opens the connection? Is there a desired way at all like the above? Thx, Mike -- <NO> OOXML - Say NO To Microsoft Office broken standard http://www.noooxml.org

2 1

[MonetDB-users] Trouble loading DLLs when called from scripting environment
by Yuvaraj Athur Raghuvir 19 Feb '08

19 Feb '08

Hello, I am using a language called J (www.jsoftware.com). What I have done so far is as follows: 1) Got the Mbedded example running in a C++ project 2) Moving the DLL interactions to J-MonetDB interactions by wrapping the main calls in my own dll called mdbdll.dll Everything is fine until I get to the call embedded_sql (set, setlen) in mdbdll.dll. What I see is that when the lib_sql.dll is loaded I get an access violation error and the program crashes. Is there any assumption on the location at which lib_sql.dll is loaded? Any other clues will be appreciated. Thanks, Yuva

1 0

[MonetDB-users] Windows 64-bit DBGEN
by Jos van Dongen 17 Feb '08

17 Feb '08

Hello, I want to run some TPC-H test on a Windows 64bit server. Does anyone have an executable version of the DBGEN tool which runs on Windows 64bit and will generate large (SF100 or more) files? Thanks in advance. Met vriendelijke groet/kind regards, Jos van Dongen Tholis Consulting T: 06-51169606 F: 0842-231136 M: jvdongen(a)tholis.com www.tholis.com No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1283 - Release Date: 16-2-2008 14:16

1 0

[MonetDB-users] Embedded Use: Persisting and Metadata
by Yuvaraj Athur Raghuvir 13 Feb '08

13 Feb '08

Finally, I have managed to get the Mbeddded example working in VC++ 2005 Express Edition on Windows XP ! Thanks to the folks in the mailing list. Use Case: MonetDB5 , Embedded Mode , SQL To move towards the application I intend to experiment on, I need some more information: 1) How to make data durable? In the simple example, I tried the following: a) First Run: Create table and insert rows. Select to check if everything is ok. b) Second Run: Only perform selection >> I get an error in the second run. 2) How to get meta data of the database? a) I want to know the size of the tables and meta tables in the data base. In particular I am interested in seeing the growth of the database on addition of content. b) Typically, there is a master table in the database that records information of the schema persisted. What is the name of the Master Table and its schema in MonetDB? c) SQLite has an independent analyzer tool which dumps the state of the storage from which I can extract most of the data I need. Does MonetDB have a similar mechanism? ~Yuva >>>> code snippet >>>>> dbh = embedded_sql (set, setlen); if (dbh == NULL || mapi_error(dbh)) die(dbh, hdl); /* switch off autocommit */ if (mapi_setAutocommit(dbh, 0) != MOK || mapi_error(dbh)) die(dbh,NULL); if ((hdl = mapi_query(dbh, "create table emp" " (name varchar(20),age int)")) == NULL || mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); for(i=0; i< 1000; i++) { char query[100]; _snprintf(query, 100,"insert into emp values(\'user%d\', %d)", i, (i % 82)); if ((hdl = mapi_query(dbh, query)) == NULL || mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); } if ((hdl = mapi_query(dbh, "select * from emp")) == NULL || mapi_error(dbh)) die(dbh, hdl); i=0; while (mapi_fetch_row(hdl)) { char *age = mapi_fetch_field(hdl, 1); i= i+ atoi(age); } if (mapi_error(dbh)) die(dbh, hdl); close_handle(dbh,hdl); printf("The sum is %d \n",i); mapi_disconnect(dbh); return 0;

4 8

[MonetDB-users] How to convert time from seconds to Year Month Day...
by Iftikharn 11 Feb '08

11 Feb '08

Thanks to people out there for providing excellent answers. I have time values in the form of seconds since 1970/01/01 00:00:00.000 GMT e.g. "1087488000". How could I convert them into Year, Month, Day, Hour, Minute, and Second. Iftikhar -- View this message in context: http://www.nabble.com/How-to-convert-time-from-seconds-to-Year-Month-Day...… Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] monetdb x100
by Cam Bazz 08 Feb '08

08 Feb '08

hello, I could not find a download for monetdb x100. is that a part of monetdb? Best.

2 1

[MonetDB-users] How to import tables along with data from MS Access into MonetDB
by Iftikharn 07 Feb '08

07 Feb '08

Hi Could any one kindly tell me how to import tables and data from MS Access into MonetDB. Regards, Iftikharn -- View this message in context: http://www.nabble.com/How-to-import-tables-along-with-data-from-MS-Access-i… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] MonetDB database server (Merovingian) is not running
by Iftikharn 06 Feb '08

06 Feb '08

Hi In MonetDB I want to create my own database "test" In one console I turned the mserver5 on by $mserver5 --dbinit="include sql;" # MonetDB server v5.2.0, based on kernel v1.20.0 # Serving database 'demo' # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.20.0 loaded > In another concole, I issued the following command $monetdb create test The following message appears: Warning: MonetDB database server is not running successfully created database 'test' $monetdb status test monetdb status test name state uptime crashes test stopped 0 And $monetdb start test start: cannot perform: MonetDB Server (merovingian) is not running mserver5 is already running, how to run merovingian? I tried at the prompt $merovingian $ nothing happens Could any one help me to create my own database rather than the default one 'demo'. Regards, Iftikhar -- View this message in context: http://www.nabble.com/MonetDB-database-server-%28Merovingian%29-is-not-runn… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Accessing MonetDB with MAL through JBDC
by Michael 06 Feb '08

06 Feb '08

Hi folks, I just installed MonetDB. I tried to run the simplest examples and failed. :-( The MAL Reference does not semm really helpful though to me. My questions is, is it possible to use the DB as an embedded server with a Java application? The exampled displayed a C example only. Is it possible to communicate to the server with MAL? I want to write a backend for the Apache Directory Server. I want MonetDB to be it. I want to transform LDAP requests to MAL and get results back form the server. Is this possible at all with this DB? FYI: I am a C illiterate Mike -- <NO> OOXML - Say NO To Microsoft Office broken standard http://www.noooxml.org

5 10

Re: [MonetDB-users] (MonetWeb) monetweb/Docs manual.texi, Stable_2008-02-03, 1.37.2.3, 1.37.2.4
by Martin Kersten 04 Feb '08

04 Feb '08

This is not good and a remnant of Peter's attempt to get the Xquery stuff in. I did not have the time to correct it in a way that all intended results are available. Stefan Manegold wrote: > Update of /ufs/monet/repository/monetweb/Docs > In directory corona.ins.cwi.nl:/tmp/cvs-serv22830/Docs > > Modified Files: > Tag: Stable_2008-02-03 > manual.texi > Log Message: > > since I do not know, whether all these .texi files are supposed to exist, > or whether the reference to them are just legacy, > I (try to) comment them out, > to hope fully get (at least) a tiny step further with building the web site ... > > XQuery/Apache.texi > XQuery/POSIX.texi > XQuery/Windows.texi > XQuery/intro.texi > XQuery/Overview.texi > XQuery/DocMgmt.texi > XQuery/ListDoc.texi > XQuery/AddDoc.texi > XQuery/DelDoc.texi > XQuery/DocOther.texi > XQuery/Xquery.texi > XQuery/Functions.texi > XQuery/xrpc.texi > XQuery/FAQ.texi > > > Index: manual.texi > =================================================================== > RCS file: /ufs/monet/repository/monetweb/Docs/manual.texi,v > retrieving revision 1.37.2.3 > retrieving revision 1.37.2.4 > diff -u -d -r1.37.2.3 -r1.37.2.4 > --- manual.texi 4 Feb 2008 17:58:15 -0000 1.37.2.3 > +++ manual.texi 4 Feb 2008 18:21:05 -0000 1.37.2.4 > @@ -258,14 +258,15 @@ > @include MonetDB/iSQL-Viewer.texi > > @node Apache Configuration, CGI Interface, iSQL-Viewer, Client Interfaces > +@c @include XQuery/Apache.texi > @include XQuery/Security.texi > > @node CGI Interface, POSIX Interface, Apache Configuration, Client Interfaces > @include XQuery/CGI.texi > @node POSIX Interface, Windows Interface, CGI Interface, Client Interfaces > -@include XQuery/POSIX.texi > +@c @include XQuery/POSIX.texi > @node Windows Interface , SQL Reference, POSIX Interface, Client Interfaces > -@include XQuery/Windows.texi > +@c @include XQuery/Windows.texi > > @c ---------------------- SQL PART > @node SQL Reference, SQL Core, Windows Interface , Top > @@ -286,13 +287,13 @@ > > @node XQuery Reference, XQuery Overview, External Functions , Top > @chapter XQuery > -@include XQuery/intro.texi > +@c @include XQuery/intro.texi > > @node XQuery Overview, Database Scaleability, XQuery Reference , XQuery Reference > -@include XQuery/Overview.texi > +@c @include XQuery/Overview.texi > > @node Document Management, Document Collection, Pathfinder Project,XQuery Reference > -@include XQuery/DocMgmt.texi > +@c @include XQuery/DocMgmt.texi > @menu > * Document Collection:: > * Add Document:: > @@ -302,20 +303,20 @@ > @end menu > > @node Document Collection , Add Document, Document Management, Document Management > -@include XQuery/ListDoc.texi > +@c @include XQuery/ListDoc.texi > @node Add Document, Remove Document, Document Collection, Document Management > -@include XQuery/AddDoc.texi > +@c @include XQuery/AddDoc.texi > @node Remove Document, Cache Policy, Add Document, Document Management > -@include XQuery/DelDoc.texi > +@c @include XQuery/DelDoc.texi > @node Cache Policy, Miscellaneous, Remove Document, Document Management > @include XQuery/Cache.texi > @node Miscellaneous, Supported Functions, Cache Policy, Document Management > -@include XQuery/DocOther.texi > +@c @include XQuery/DocOther.texi > > @node Supported Functions, Prepared Queries , Miscellaneous , XQuery Reference > @section Supported Functions > -@include XQuery/Xquery.texi > -@include XQuery/Functions.texi > +@c @include XQuery/Xquery.texi > +@c @include XQuery/Functions.texi > > @node Prepared Queries, StandOff Extensions , Supported Functions ,XQuery Reference > @include XQuery/PreparedQueries.texi > @@ -325,10 +326,10 @@ > @include XQuery/Standoff.texi > > @node XRPC Extention, XQuery FAQ, Why StandOff Extensions?, XQuery Reference > -@include XQuery/xrpc.texi > +@c @include XQuery/xrpc.texi > > @node XQuery FAQ, Design Overview, SOAP Protocol, Top > -@include XQuery/FAQ.texi > +@c @include XQuery/FAQ.texi > > @c ---------------------- MAL Design PART > > >

1 0