February 2008 - users-list

[MonetDB-users] protocol violation Unexpected line in data block
by sateesh 19 Feb '08

19 Feb '08

Hi All, When i try to fetch data from a table some times i am getting this error: It seems it has some thing to do with the type of characters that are being inserted. I am wondering why it didn't threw any exception while inserting but throwing the excep when trying to retrieve !! I hope this is not because of the sql client i am using..I tried using Squrriel and QuantumDB plugin of Eclipse. Here is the Stack Trace Error Executing: select * from dpa.collection_info:java.sql.SQLException: protocol violation: unexpected line in data block: . java.sql.SQLException: protocol violation: unexpected line in data block: . at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2048) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1798) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:371) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:340) at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.quantum.util.proxy.ProxyFactory$InvocationHandlerImpl.invoke(ProxyFactory.java:37) at $Proxy4.execute(Unknown Source) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:133) at com.quantum.sql.MultiSQLServer.execute(MultiSQLServer.java:91) at com.quantum.actions.BaseExecuteAction.getSQLResults(BaseExecuteAction.java:202) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:174) at com.quantum.actions.ExecuteAction.execute(ExecuteAction.java:98) at com.quantum.actions.BaseExecuteAction.execute(BaseExecuteAction.java:125) at com.quantum.actions.BaseExecuteAction.run(BaseExecuteAction.java:111) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1101) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3319) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443) at org.eclipse.equinox.launcher.Main.run(Main.java:1169) -- View this message in context: http://www.nabble.com/protocol-violation-Unexpected-line-in-data-block-tp15… Sent from the monetdb-users mailing list archive at Nabble.com.

4 11

[MonetDB-users] Analyze
by Rahul Chopra 19 Feb '08

19 Feb '08

Is there the equivalent of ANALYZE or UPDATE STATISTICS in MonetDB? I tried both, but could not get them to work. Thanks! = embedded system UML 2.0-Based Software Engineering Using Model-Driven Development. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=b006f31a35aad8826624507… -- Powered by Outblaze

2 1

[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